Your Office Microsoft Excel 2013, Comprehensive 1e Amy S. Kinser et al (Test Bank All Chapters, 100% Original Verified, A+ Grade) Your Office: Microsoft Office 2013, Excel Comprehensive (Kinser et al.) Module 1 Workshop 1 Navigate, Manipulate, and Print Worksheets 1) A ________ application is a computer program has a user interface comprised of a grid of rows and columns. A) database B) spreadsheet C) matrix D) tabular Answer: B Diff: 1 Page Ref: 46 Objective: Understand Spreadsheet Terminology and Components Text: Your Office: Microsoft Excel 2013 Comprehensive 2) The intersection of a row and column is called a ________. A) cell B) container C) chamber D) cubicle Answer: A Diff: 1 Page Ref: 46 Objective: Understand Spreadsheet Terminology and Components Text: Your Office: Microsoft Excel 2013 Comprehensive 3) Formulas and functions begin with a(n) ________ sign. A) = B) # C) @ D) & Answer: A Diff: 1 Page Ref: 46 Objective: Understand Spreadsheet Terminology and Components Text: Your Office: Microsoft Excel 2013 Comprehensive 4) Which of the following is NOT contained in a cell? A) Functions B) Formulas C) Subroutines D) Text Answer: C Diff: 2 Page Ref: 46 Objective: Understand Spreadsheet Terminology and Components Text: Your Office: Microsoft Excel 2013 Comprehensive
1 Copyright © 2014 Pearson Education, Inc.
5) The extension for Microsoft Excel 2013 workbooks is ________. A) .xlx B) .xls C) .xlxs D) .xlsx Answer: D Diff: 2 Page Ref: 47 Objective: Understand Spreadsheet Terminology and Components Text: Your Office: Microsoft Excel 2013 Comprehensive 6) When there are multiple worksheets, you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right. A) Page Down B) Page Up C) Home D) End Answer: A Diff: 3 Page Ref: 50 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive 7) The keyboard shortcut to move one column to the left is ________. A) Tab B) Shift + Tab C) Ctrl + Tab D) Alt + Tab Answer: B Diff: 3 Page Ref: 51 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive 8) The keyboard shortcut to move to cell A1 is ________. A) Home B) Shift + Home C) Ctrl + Home D) Alt + Home Answer: C Diff: 2 Page Ref: 51 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive
2 Copyright © 2014 Pearson Education, Inc.
9) To move right one screen, you would use the keyboard shortcut ________. A) Page Down B) Shift + Page Down C) Ctrl + Page Down D) Alt + Page Down Answer: D Diff: 3 Page Ref: 51 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive 10) Which of the following is NOT an example of worksheet documentation? A) Descriptive drop-down documentation menus B) Descriptive worksheet names C) Descriptive cell labels D) Descriptive column titles Answer: A Diff: 3 Page Ref: 52 Objective: Document Your Work Text: Your Office: Microsoft Excel 2013 Comprehensive 11) A comment is indicated by the presence of a ________ in the upper-right corner of a cell. A) red square B) blue square C) red triangle D) blue triangle Answer: C Diff: 2 Page Ref: 53 Objective: Document Your Work Text: Your Office: Microsoft Excel 2013 Comprehensive 12) To insert a comment into a cell, you click New Comment in the ________. A) Comments group on the REVIEW tab B) Comments group on the INSERT tab C) Documentation group on the REVIEW tab D) Documentation group on the INSERT tab Answer: A Diff: 3 Page Ref: 53 Objective: Document Your Work Text: Your Office: Microsoft Excel 2013 Comprehensive
3 Copyright © 2014 Pearson Education, Inc.
13) Which of the following is typically NOT contained in a separate documentation worksheet? A) Author B) Modification dates C) Charts D) Modification history Answer: C Diff: 3 Page Ref: 54 Objective: Document Your Work Text: Your Office: Microsoft Excel 2013 Comprehensive 14) The base date for date and time data in Excel 2013 is ________. A) January 1, 1000 B) January 1, 1900 C) December 31, 999 D) December 31, 1899 Answer: D Diff: 3 Page Ref: 55 Objective: Enter and Edit Data Text: Your Office: Microsoft Excel 2013 Comprehensive 15) Which of the following data types is NOT automatically right-aligned by Excel? A) Text B) Numeric C) Date D) Time Answer: A Diff: 3 Page Ref: 55 Objective: Enter and Edit Data Text: Your Office: Microsoft Excel 2013 Comprehensive 16) The keyboard shortcut for Undo is ________. A) Ctrl + U B) Ctrl + Z C) Ctrl + Y D) Ctrl + W Answer: B Diff: 2 Page Ref: 56 Objective: Enter and Edit Data Text: Your Office: Microsoft Excel 2013 Comprehensive
4 Copyright © 2014 Pearson Education, Inc.
17) To insert a line break or hard return in a cell, you would press ________. A) Enter B) Ctrl + Enter C) Alt + Enter D) Shift + Enter Answer: C Diff: 3 Page Ref: 58 Objective: Enter and Edit Data Text: Your Office: Microsoft Excel 2013 Comprehensive 18) Which of the following is NOT a cell range? A) A single cell B) Noncontiguous cells C) A table D) Contiguous cells Answer: C Diff: 3 Page Ref: 58 Objective: Manipulate Cells and Cell Ranges Text: Your Office: Microsoft Excel 2013 Comprehensive 19) You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse. A) Alt B) Ctrl C) F5 D) F7 Answer: B Diff: 2 Page Ref: 59 Objective: Manipulate Cells and Cell Ranges Text: Your Office: Microsoft Excel 2013 Comprehensive 20) An example of a range of cells is ________. A) A1&A3 B) A1+A3 C) A1-A3 D) A1:A3 Answer: D Diff: 1 Page Ref: 59 Objective: Manipulate Cells and Cell Ranges Text: Your Office: Microsoft Excel 2013 Comprehensive
5 Copyright © 2014 Pearson Education, Inc.
21) After selecting a row, pressing the shortcut key ________ will insert a new row above the selected row. A) Ctrl + I B) Ctrl + + C) Ctrl + # D) Ctrl + R Answer: B Diff: 3 Page Ref: 62 Objective: Manipulate Cells and Cell Ranges Text: Your Office: Microsoft Excel 2013 Comprehensive 22) The Merge & Center button is located in the ________. A) Alignment group on the HOME tab B) Styles group on the HOME tab C) Alignment group on the PAGE LAYOUT tab D) Styles group on the LAYOUT tab Answer: A Diff: 3 Page Ref: 64 Objective: Manipulate Cells and Cell Ranges Text: Your Office: Microsoft Excel 2013 Comprehensive 23) To select several contiguous columns, you ________. A) click the header of the first column, then double-click the header of the last column B) click the header of the first column, then right-click the header of the last column C) click the header of the first column, press and hold Shift, and click the header of the last column D) click the header of the first column, press and hold Ctrl, and click the header of the last column Answer: C Diff: 2 Page Ref: 66 Objective: Manipulate Columns and Rows Text: Your Office: Microsoft Excel 2013 Comprehensive 24) To select noncontiguous rows, you ________. A) click the header of the first row, then double-click the header of each additional row B) click the header of the first row, then right-click the header of each additional row C) click the header of the first row, press and hold Shift, and click the header of each additional row D) click the header of the first row, press and hold Ctrl, and click the header of each additional row Answer: D Diff: 2 Page Ref: 66 Objective: Manipulate Columns and Rows Text: Your Office: Microsoft Excel 2013 Comprehensive
6 Copyright © 2014 Pearson Education, Inc.