MIS 112 Problem Set 6

In an Excel Form, when finding a row by entering search criteria: Will the question mark symbol "?" find or match any single character?

Yes, the "?" symbol is used to find/match a single character.

To find an asterisk (i.e., the symbol: *) within a cell, you enter which of the following in an Excel form search criteria?

a tilde followed by an asterick

Can you print data in an Excel Form attached to a table?

No, you can not

Please see the attached Excel workbook image. The cells highlighted in yellow contain a Total Row. How can such a Total Row be added to a table?

Once you have a table, you can click the "Table Tools/Design" tab. Then, under "Table Style Options" check the box for "Total Row." 66341

Suppose you have a range of cells with numbers and a few blank entries. If you sort the range in ascending order(smallest or largest), where will the blank cells be located after sorting?

At the end

What option in the Table Tools / Design tab removes a table without losing the data in it?

Convert to Range

For this question, please download the attached Excel workbook. Convert the data on Sheet1 into a table. Next answer the following question: What keys do you need to press to select the newly created table that it can be copied or moved to a different worksheet?

Ctrl+A

When you apply currency formatting to a Table column and then add a new row to the table, what happens to data entered in the new cell?

Excel applies currency formatting to the new value in that column cell.

A formula refers to a value in the Total Row of a table. What will happen to the formula result if the option for "Total Row" (from the Excel ribbon: Table Tools / Design tab) is unchecked?

the formula returns an error.

The __________ command is used to display text on multiple lines in a cell.

wrap text