CompApps Final (Excel A-E, PowerPoint A-D)

Front

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Back

False

Front

You are in Edit mode any time you are entering or changing the contents of a cell.

Back

True

Front

Arguments are Excel’s built-in formulas.

Back

False

Front

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

Back

True

Front

A named range can begin with a letter or number.

Back

False

Front

Printing gridlines makes data easier to read.

Back

True

Front

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

Back

True

Front

When using the Insert Function button or the AutoSum list arrow, is it necessary to type the equal sign?

Back

False

Front

An absolute cell reference changes the cell references when the formula is copied to a new location.

Back

False

Front

Is it acceptable for dates to have a currency format?

Back

False