BIM I Semester Review Spring21

In the formula =A8*$A$1, which of the following describes A8?

• Relative cell reference

• Absolute cell reference

• Function

• Autosum

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

Which of the following inserts a function into a cell?

• mode indicator

• AutoSum button

• argument

• formula prefix

Which of the following lets you search for a function or select one from a category?

• Function Arguments dialog box

• clipboard

• formula bar

• Insert Function dialog box

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

• mode indicator

• Page Break Preview

• scroll bar

• Fill handle

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

To print a worksheet, you begin by going to Backstage view.

• True

• False

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

• True

• False

You can use the DELETE key to clear cell contents.

• True

• False