Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative?

You don’t like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

a. Apply another style to the cell.
b. Use the Undo command.
c. Clear the cell’s content.
d. Apply the Normal style to the cell.

c. Clear the cell’s content.

Which of the following statements about hidden and unhidden worksheets is correct?

a. Unhidden worksheets cannot contain formulas that refer to hidden worksheets.
b. When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones.
c. A hidden worksheet cannot be inadvertently deleted.
d. Excel creates a minimized window for each hidden worksheet.

c. A hidden worksheet cannot be inadvertently deleted.

Which of the following steps is not a method for inserting a worksheet into a workbook?

a. Click the Insert sheet (+) button to the right of the worksheet tabs.
b. On the Home tab, click Insert and then click Insert Sheet.
c. On the Insert tab, click Worksheet.
d. In the Insert dialog box, click Worksheet and then click OK.

b. On the Home tab, click Insert and then click Insert Sheet.

In order for you to freeze the first column of a worksheet into a frozen pane:

a. The entire contents of the column must be visible.
b. The first row of the column must be non-blank.
c. Duplicate worksheets must also be able to have their first columns frozen.
d. You can click Freeze First Column in the Freeze Panes menu.

c. Duplicate worksheets must also be able to have their first columns frozen.

Which of the following procedures is not a way to sort a table by the contents of one column?

a. Click the Sort button in the Sort & Filter group of the Data tab.
b. Click an AutoFilter button in the total row.
c. Click an AutoFilter button in the field names row.
d. Click the Filter button in the Sort & Filter group of the Data tab.

b. Click an AutoFilter button in the total row.

Which of the following is a valid reason for converting a table to a range?

a. To clear the sorting criteria and start over.
b. To prepare for deleting a column.
c. To prepare for importing new data from a non-Excel file.
d. To prepare to change its conditional formatting.

c. To prepare for importing new data from a non-Excel file.

Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?

a. There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.
b. Only an Auto Outlined worksheet may contain total rows.
c. An Auto Outlined worksheet contains only one button for collapsing and expanding.
d. Only a multi-grouped worksheet can cluster rows and columns.

a. There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.

Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?

a. Table[Auction Items(Total Sale)]
b. Auction Items(Total Sale)
c. Auction Items[#Totals]
d. #Totals[Total Sale]

c. Auction Items[#Totals]

Which of the following procedures is not a way to filter a table by the contents of one column?

a. Click the criterion button on the slicer.
b. Right-click the cell whose contents you want for the criterion and click Filter in the menu.
c. Click the Filter button in the Sort & Filter group of the Data tab.
d. Click the AutoFilter button in the total row at the bottom.

d. Click the AutoFilter button in the total row at the bottom.

Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table?

a. There is no difference between an AutoFiltered range of records in a list and a table.
b. A table maintains its sort order after you close and then open it again.
c. A table given a title enables its field names to be used in formulas in place of cell references.
d. A table enables special subtotal functions for total rows.

c. A table given a title enables its field names to be used in formulas in place of cell references.

Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references?

a. You want to preserve the integrity of any cells referenced by formulas in the macro.
b. You want the values of any cells copied to the macro to be accurate.
c. You want the results of any formulas produced by the macro to be accurate.
d. You want the macro to reproduce its results in the same place each time.

d. You want the macro to reproduce its results in the same place each time.

Which of the following cannot be used to turn on track changes?

a. The Track Changes button
b. The Share Workbook button
c. The Protect Sheet button
d. The Protect and Share Workbook button

c. The Protect Sheet button

Which of the following functions allows you to have Excel place a random number between 10000 and 99999 in a cell?

a. RAND()
b. RANDBETWEEN(10000,99999)
c. BYCHANCE(10000,99999)
d. RANDOM(10000,99999)

b. RANDBETWEEN(10000,99999)

Which of the following actions cannot be performed with comments?

a. You can format the text using a different color.
b. You can change the background comment box color.
c. You can prevent the disclosure of the name of the user who made the comment.
d. You can hide the comment.

b. You can change the background comment box color.