Microsoft Excel Quiz - Modules 1-7

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

• argument

• function

• labels

• active cells

Which of the following views shows how a worksheet will appear when printed?

• Page Layout

• Page Break Preview

• Normal

• Reading

If you discover an error immediately after you have confirmed a cell entry, which of the following could you do to reverse the error? Select all the options that apply.

• Click the Undo button on the Quick Access toolbar.

• Click the Cancel button on the Formula bar.

• Press CTRL+Z.

• Press CTRL+Y.

Which of the following keys do you press to copy selected cells while you drag and drop the selected cells to their new location?

• ALT

• SHIFT

• TAB

• CTRL

Which of the following formulas adds 25 and 10, and then multiplies the result by 50?

• =25+10*50

• =25+10x50

• =50x25+10

• =50*(25+10)

Which of the following tabs in the ribbon provides immediate access to worksheet print options such as changing orientation and scaling to fit?

• Preview

• Home

• Page Layout

• View

Which of the following options can you set to make sure the active worksheet will print on one page?

• Zoom percentage

• Scaling

• Print selection

• Gridlines

Which of the following is the temporary storage area that holds selections you copy or cut?

• Clipboard

• Backstage

• Name box

• Worksheet

To create a new, blank workbook, which of the following can you use? Select all the options that apply.

• Click copy in Backstage view

• Press CTRL+N

• Click New in Backstage view

• Press CTRL+W

When you double-click the right border of a column heading, which of the following occurs?

• Excel hides the column to the left of the double-clicked border.

• AutoFit resizes the column to the default width of 8.43 characters.

• Excel adds a column to the right of the double-clicked border.

• AutoFit resizes the column to accommodate the widest cell entry.