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

Function |
A prewritten formula that is built into Excel. |

Margins |
Are those portions of a printed page outside the main body of the printed document and always are blank when printed. |

Bright |
Colors jump out a dark background and are easiest to see. |

Footer |
Is text and graphics that print at the bottom of every page. |

Header |
Is text and graphics that print at the top of each page. |

Best Fit |
Means that the width of a column will be increased or decreased so the widest entry will fit in the column. |

True |
(True or False) Cooler colors tend to pull away from the reader. |

Theme |
A company or department may standardize with a specific ______ so that all of their documents have a similar appearance. |

Circular reference |
A formula in a cell that contains a reference back to itself. |

Indirect |
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. |

False |
(True or False) An asterick (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. |

c. > |
All of the following are valid Excel arithmetic operators except… a. * b. ! c. > d. % |

False |
(True or False) As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations. |

False |
(True or False) Best fit means that the width of the column will be increased or decreased by a percentage you specify. |

Insert Function box in the formula bar |
Clicking the ______ opens the Inserts Function Dialog Box. |

Page Layout View |
view shows the worksheet divided into pages as well as the header/footer information. |

True |
(True or False) Excel has more than 400 functions that preform just about every type of calculation you can imagine. |

8.43 |
If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters. |

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

Warmer |
Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____ colors. |

Formula |
One of reasons Excel is such a valuable tool is that you can assign a ______ to a cell, and Excel will calculate the result. |

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

Division |
The / arithmetic operator indicates ______. |

Accounting number Format |
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. |

Fill handle |
The small black square located in the lower-right corner of the heavy border around the active cell. |

MIN |
Determines the lowest number in a range |

MAX |
Function displays the highest value in a range. |

Average |
Function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range. |

False |
(True or False) The Accounting number format assigns a floating dollar sign. |

Relative |
The adjusted cell references in a copied and pasted formula are called ____ cell references. |

True |
(True or False) The AVERAGE function requires that the argument be included within parenthesis following the function name. |

Normal |
The default view in Excel is called … |

True |
The equal sign (=) precedes a formula. |

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

False |
(True or False) The range automatically selected by Excel is always correct. |

True |
(True or False) To Sum button menu allows you to enter one of five often-used functions easily into a cell. |

ALT+ENTER |
To start a new line in a cell, press the ____ keys. |

26 |
When Excel follows the order of operations, the formula, 8*3+2, equals _____? |

Operations |
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra. |

HOME tab/ Number Group |
Which of the following is the path to the Comma Style button? |

HOME tab/ Styles Group |
Which of the following is the path to the Conditional Formatting button? |

Range Finder |
To check which cells are referenced in the formula assigned to the active cell. |

False |
(True or False) You cannot format an entire column at once. |

# Excel Chapter 2- Review Study Sheet

### Share This

## Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price