Excel Chapter 2 Concepts Review

Because the most common error when entering a formula is to reference the wrong cell in a formula mistakenly, Excel colors the boarders of the cell referenced in the formula.

In the formula =4*6-8, the subtraction (-) operation is completed before the multiplication operation (*).

The order of Operations is from the right to left.

When a error occurs in a formula cell, Excel displays the Trace Error button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.

Using the Sum menu allows you to enter on of the five often-used functions easily in to a cell, without having to memorize its name or the required arguments.

When you tap or click the 'Decreased Font Size' button, Excel assigns the next lowest font size in the Font Size gallery to the selected range.

Knowing how people perceive colors helps you emphasize parts of your worksheet. Cooler colors (blue, green, and violet) tend to reach toward the reader. Warmer colors (red and orange) tend to pull away from the reader.

You cannot format an entire column at once.

Hiding cells is a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see.

Margins are those portions of printed pages outside of the main body of the printed document and always are blank when printed.

A formula in a cell that contains a reference back to itself is called a(n)____ reference.

If the following arithmetic operations are all found in a formula with no parentheses, which one is completed.

When you copy a formula with a relative cell reference down a row,______.

The ____ function is used to determine the lowest number in a given range.

To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a _____ dollar sign.

Which of the following is valid conditional formatting operator fund in the New Formatting Rule dialog.

A dot on the screen that contains a color called a ____.

Excel includes a(n)_____ you can use to check the worksheet for spelling errors.

A(n) _____ is text and graphics that print at the bottom of each page.

The ____ version of a worksheet shows the results of formulas.

A(n)____ is a prewritten formula that is built into Excel.

A(n)____ alerts Excel that you are entering a formula or function not text.

The order in which calculations are performed in a formula is called the ____.

____ allows you to select cells for use in a formula by using the mouse.

Excel included a function called the ____ function that displays the highest value in a range.

The ____ functions sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range.

___ checks which cells are references in the formula assigned to the active cell.

____ means that the width of a column will be increased or decreased so that the widest entry will fit the column.

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

_____ is the process of finding a correcting errors in the worksheet.