# Excel: Spreadsheet and Instructor Explanation

Topics: Spreadsheet, Chart, Microsoft Excel Pages: 32 (7413 words) Published: May 19, 2011
(TCO 1) A spreadsheet can best be thought of as the computerized equivalent of a ____________ .|  | Your Answer:|         | | ledger| |    CORRECT|         | | slide show| |    |
| | filing cabinet| |    |
| | card catalog| |    |
|
| Instructor Explanation:| Chapter 1, page 71|
| Points Received:| 2 of 2 |
2.| Question:| (TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a:|  | Your Answer:|         | | workbook.| |    CORRECT|         | | ledger.| |    |

| | document.| |    |
| | journal.| |    |
|
| Instructor Explanation:| Chapter 1, page 72|
| Points Received:| 2 of 2 |
3.| Question:| (TCO 1) A workbook with 12 worksheets would be saved as __________ file(s).|  | Your Answer:|         | | 1| |    CORRECT|         | | 2| |    |
| | 3| |    |
| | 4| |    |
|
| Instructor Explanation:| Chapter 1, page 72|
| Points Received:| 2 of 2 |
4.| Question:| (TCO 1) The __________ displays the active cell's contents, including the cell references that make up a calculation.|  | Your Answer:|         | | Formula bar| |    CORRECT|         | | Name box| |    |

| | Status bar| |    |
| | Task bar| |    |
|
| Instructor Explanation:| Chapter 1, page 75|
| Points Received:| 2 of 2 |
5.| Question:| (TCO 1) Tabs, groups and commands make up the:|  | Your Answer:|         | | Ribbon.| |    CORRECT|         | | Office Menu.| |    |
| | Task bar.| |    |
| | Reference Page.| |    |
|
| Instructor Explanation:| Chapter 1, page 75|
| Points Received:| 2 of 2 |
6.| Question:| (TCO 1) Worksheet names are displayed on:|  | Your Answer:|         | | sheet tabs.| |    CORRECT|         | | ribbons.| |    |
| | the task bar.| |    |
| | the Title bar.| |    |
|
| Instructor Explanation:| Chapter 1, page 75|
| Points Received:| 2 of 2 |
7.| Question:| (TCO 1) To quickly move from cell A1 to N41, use the F5 key to display the:|  | Your Answer:|         | | GoTo dialog box.| |    CORRECT|         | | Find command.| |    |

| | Retrieve Cell command.| |    |
| | Locator box.| |    |
|
| Instructor Explanation:| Chapter 1, page 79|
| Points Received:| 2 of 2 |
8.| Question:| (TCO 1) Which of the following formulas is in the correct format?|  | Your Answer:|         | | 4G * G1| |    |         | | =55H ~ 3| |    |
| | =A6 + Z35| |    CORRECT|
| | =52 X 43| |    |
|
| Instructor Explanation:| Chapter 1, page 86|
| Points Received:| 2 of 2 |
9.| Question:| (TCO 1) In the worksheet shown below, the red triangle in cell B3 indicates _______________. |  | Your Answer:|         | | there is an error in the formula in the cell| |    |         | | the cell is the active cell| |    |         | | the cell contains a comment| |    CORRECT|         | | a custom format has been applied to the cell| |    |

|
| Instructor Explanation:| Chapter 1, page 114|
| Points Received:| 2 of 2 |
10.| Question:| (TCO 3) Groups of related numeric values in an Excel worksheet are:|  | Your Answer:|         | | data point.| |    |         | | data roles.| |    |
| | categories.| |    |
| | data series.| |    CORRECT|
|
| Instructor Explanation:| Chapter 3, page 189|
| Points Received:| 2 of 2...