Excel Module 2 Quiz 2

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

• True

• False

Moving from left to right, the first calculation in the order of operations is negation (-).

• True

• False

Moving from left to right, the first calculation in the order of operations is negation (-).

• True

• False

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

• True

• False

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

• True

• False

The Insert Options button lists formatting options.

• True

• False

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

• True

• False

Clicking the Create Function box opens the Function Arguments dialog box.

• True

• False

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

• True

• False

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

• True

• False