Excel: Spreadsheet and Instructor Explanation

Only available on StudyMode
  • Download(s) : 897
  • Published : May 19, 2011
Open Document
Text Preview
(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 |
 | Comments:| |
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 |
 | Comments:| |
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 |
 | Comments:| |
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 |
 | Comments:| |
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 |
 | Comments:| |
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 |
 | Comments:| |
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 |
 | Comments:| |
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 |
 | Comments:| |
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 |
 | Comments:| |
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...
tracking img