Question | Answer |
Is/are used to place worksheet, column, and row titles on a worksheet. | Text
|
Is a series of two or more adjacent cells in a column or row or a rectangular group of cells. | Range
| How many chart types does Excel offer? | 10
| The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. | Autofill Options
| The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. | Autocorrect
| The ____ is the small black square located in the lower-right corner of the heavy border around the active cell. | Fill Handle
| The person or persons requesting the worksheet should supply their requirements in a ____ document. | Requirement Document
| Key that toggles between Insert mode and Overtype mode? | Insert
| To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery. | Print Selection
| You can open the Format Cells dialog box by pressing the ____ keys. | Ctrl+1
| You can use the ____ to check which cells are referenced in the formula assigned to the active cell. | Range Finder
| When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics? A. Identification of how to format various elements of the worksheet or B. Avoiding the temptation to use flashy or confusing visual elements within the worksheet | A
| One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result. | Formula
| The function, or ____________________, of a worksheet is to provide a user with direct ways to accomplish tasks. | Purpose
| True or False, As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. | False
| True or False, The arithmetic operator, , directs Excel to perform the division operation. | False
| After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable. | Zoom
| Cell references in a formula are called ____. | Assumptions
| If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell. | Orientation
| The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. | Fill Formatting Only
| When assigned to a cell, the ____ function returns a number that corresponds to the system date and time | NOW
| What is the path to the Insert Cells arrow? | Home tab & cells group
| True or False, When Excel cannot calculate a formula, it displays an error message in a cell. | True |