Excel Module 2

A _________ is a prewritten formula that is built into Excel.

• feature

• calcuation

• function

• task

The ____________ function displays the highest value in a range.

• MAX

• SUM

• AVERAGE

• MIN

A(n) _______ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

• contiguous

• indexed

• indirect

• direct

The __________ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

• Accounting number format

• Comma style format

• Currency style format

• Percent style format

The default view in Excel is called ________ view.

• Basic

• Standard

• Values

• Normal

The ________ function determines the lowest number in a range.

• BASE

• MIN

• LOW

• LEAST

_____________ view allows you to create or modify a worksheet while viewing how it will look in a printed format.

• Normal

• Page Layout

• Full Screen

• Page Break Preview

All of the following are valid Excel arithmetic operation EXCEPT _________.

• $\wedge$

• %

• *

• $>$

You can click the ____________ button to undo an automatic correction.

• Trace Error

• AutoCorrect Options

• Auto Fill Options

• Paste Options

8. When you decrease the row height to ____, the row is hidden.

• 1

• 0

• 3

• 2