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

all of

studybud

Surround your text in `*italics*`

or `**bold**`

, to write a math equation use, for example, `$x^2+2x+1=0$`

or `$$\beta^2-1=0$$`

Stats

Views: 53

Asked: 3 years ago