Excel 2019 Fall Exam Part 2

Live preview is available on a touch screen.

• True

• False

The equal sign (=) precedes a formula.

• True

• False

The most common error when entering a formula is to reference the wrong cell in the formula.

• True

• False

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

• True

• False

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

• True

• False

You cannot format an entire column at once.

• True

• False

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

• True

• False

The underline format underlines the entire cell, not just the characters in the cell.

• True

• False

An Excel ____ allows data to be summarized and charted easily.

• worksheet

• workflow

• document

• presentation

To enter data in a cell, you must first select the ____.

• row

• column

• worksheet

• cell