.png){kind=logo}
1 Copyright © 2017 Pearson Education, Inc.Exploring Microsoft Office Excel 2016 Comprehensive (Poatsy/Grauer) Chapter 1 Introduction to Excel
1) New workbooks typically contain how many worksheets?
- 0
- 1
- 2
- 3
Answer: B
Diff: 1
Objective: 1 Explore the Excel Window
2) What is the small green square in the bottom right of a cell called?
- Sizing handle
- Fill handle
- Copy/Paste handle
- Move Cell handle
Answer: B
Diff: 2
Objective: 1 Explore the Excel Window
3) What is not one of the tabs in Excel?
- Formulas
- Page Layout
- File
- Mailings
Answer: D
Diff: 1
Objective: 1 Explore the Excel Window
4) Which of the following is not considered an Excel element?
- Formula Bar
- Name Box
- Active cell
- Print Preview
Answer: D
Diff: 3
Objective: 1 Explore the Excel Window
5) Which of the following is not a valid keystroke for navigating around a worksheet?
- Ctrl + Home
- Ctrl + End
- Alt + Up arrow
- Page Down
Answer: C
Diff: 2
Objective: 1 Explore the Excel Window
(Exploring Microsoft Office Excel 2016 Comprehensive, 1e Mary Anne Poatsy, Keith Mulbery et al) (Test Bank all Chapters) 1 / 4
2 Copyright © 2017 Pearson Education, Inc.6) Which of the following would not be considered text?
- Phone number (111.111.1111)
- Social Security number (111-11-1111)
- Part number (PT111)
D) =2*2
Answer: D
Diff: 2
Objective: 2 Enter and Edit Cell Data
7) What does pressing the Enter key while in a cell, do?
- The value is set, and the active cell remains the active cell
- The value is set, and the cell to the right becomes the active cell
- The value is set, and the cell below becomes the active cell
- The value is set, and the action is the same as pressing the Tab key
Answer: C
Diff: 2
Objective: 2 Enter and Edit Cell Data
8) Which keyboard shortcut puts the user in cell edit mode?
- F2
- Shift F2
- F3
- Shift F3
Answer: A
Diff: 2
Objective: 2 Enter and Edit Cell Data
9) Which of the following is not one of the recommendations when first designing a spreadsheet?
- Decide what your purpose is
- Decide what inputs you will need
- Estimate the amount of time required to complete the spreadsheet
- Decide what outputs you will need
Answer: C
Diff: 2
Objective: 2 Enter and Edit Cell Data
10) How is text aligned by default?
- Left
- Center
- Right
- Decimal
Answer: A
Diff: 1
Objective: 2 Enter and Edit Cell Data 2 / 4
3 Copyright © 2017 Pearson Education, Inc.11) Which of the following is not a valid formula?
A) =D3
B) =2*2
- =sum(1,2,3,4,5)
D) =#12/31/2014#-#12/31/2015#
Answer: D
Diff: 3
Objective: 3 Create Formulas
12) What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?
- How to do date calculations
- Order of operations
- Naming convention for cell ranges
- The various printing options available in Excel
Answer: B
Diff: 3
Objective: 3 Create Formulas
13) In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
A) 5/6
- 1+
C) (2-3)
D) 6^2
Answer: C
Diff: 3
Objective: 3 Create Formulas
14) In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second?
A) 5/6
- 1+
C) (2-3)
D) 6^2
Answer: D
Diff: 3
Objective: 3 Create Formulas
15) Where is the Show Formulas command found?
- Formula Auditing group on the Formulas tab
- Formula Auditing group on the Data tab
- Formula Auditing group on the Review tab
- Formula Auditing group on the Developer tab
Answer: A
Diff: 1
Objective: 4 Display Cell Formulas 3 / 4
4 Copyright © 2017 Pearson Education, Inc.16) What should you do if there are columns you need, but do not want to display?
- Delete the columns you do not want to display then undo your action when finished.
- Move the columns you want to see so that they are together then move them back to their
- Cut and paste the columns you do not want to display to another area of the worksheet.
- Hide the columns you do not want to display, then unhide them when finished.
original locations with finished.
Answer: D
Diff: 2
Objective: 5 Manage Columns and Rows
17) What does it mean when you see ####### in a cell?
- Your formula is incorrect.
- At least one of the cell references in your formula is pointing to an empty cell.
- Your column is not wide enough.
- Your row is not tall enough.
Answer: C
Diff: 2
Objective: 5 Manage Columns and Rows
18) One point is how big?
- 1/72 of an inch
- 1/36 of an inch
- The same as a pixel
- The same as one character
Answer: A
Diff: 3
Objective: 5 Manage Columns and Rows
19) Which of the following is not a way to widen a column?
- Drag the line between the column headings to the desired size
- In the Page Layout tab, Scale to Fit group, select Automatic in the Width drop-down box
- Double-click the line between the column headings
- Right-click a column heading and select Column Width
Answer: B
Diff: 3
Objective: 5 Manage Columns and Rows
20) A range is specified by its ________.
- top and bottom row and left and right column
- top row and leftmost column
- top right and bottom left cells
- top left and bottom right cells
Answer: D
Diff: 2
Objective: 6 Select, Move, Copy, and Paste Data
- / 4
.png)