Microsoft Excel and PowerPoint Quiz

You can use the DELETE key to clear cell contents.

• True

• False

To print worksheet contents across the length of a page, you can use portrait orientation.

• True

• False

When you enter a numerical value in a worksheet cell, it is automatically left-aligned.

• True

• False

You can edit cell contents in the Formula bar or in the cell itself.

• True

• False

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

• True

• False

To find the largest value in a cell range, use the MIN function.

• True

• False

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

• True

• False

You've selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

• mode indicator

• scroll bar

• Page Break Preview

• Fill handle

To have Excel enter the lowest price from a range of prices, which of the following would you use?

• MAX function

• COUNT function

• MIN function

• COUNTA function

To combine multiple cells into one combined cell, which of the following do you use?

• Column Width command

• Center button

• Merge and Center button

• Increase Indent button