(Illustrated Microsoft® Office 365 & Excel 2016, Comprehensive, 1e Elizabeth Eisner Reding, Lynn Wermers)
(Test Bank all Chapters)
Excel 2016 - Module 1: Getting Started with Excel 2016
1. In an electronic spreadsheet, you need to manually recalculate when you change the entries.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Excel 2
Understand Spreadsheet Software
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.001 - Describe the uses of Excel
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
2. An Excel 2016 workbook has the file extension .xml.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Excel 2
Understand Spreadsheet Software
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.001 - Describe the uses of Excel
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 4/2/2016 3:29 PM
3. The Visual Analysis tool allows you to easily create charts and other elements that help you visualized how data is
distributed.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Excel 2
Understand Spreadsheet Software
QUESTION TYPE: True / False
HAS VARIABLES: False
DATE CREATED: 4/3/2016 8:10 PM
DATE MODIFIED: 4/3/2016 8:12 PM
4. Charts are updated automatically in Excel whenever data changes.
a. True
b. False
ANSWER: True
Copyright Cengage Learning. Powered by Cognero. Page 1
,Name: Class: Date:
Excel 2016 - Module 1: Getting Started with Excel 2016
POINTS: 1
REFERENCES: Excel 2
Understand Spreadsheet Software
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.001 - Describe the uses of Excel
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
5. To open an Excel file, click Open Other Workbooks on the navigation bar, click This PC, and then click Browse to
open the Open dialog box.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Excel 4
Identify Excel 2016 Window Components
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.002 - Open and save an Excel file
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 4/3/2016 8:36 AM
6. You are in Edit mode any time you are entering or changing the contents of a cell.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Excel 8
Enter Labels and Values and Use the AutoSum Button
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.003 - Build formulas with the AutoSum button
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
7. Arguments are Excel’s built-in formulas.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Excel 8
Enter Labels and Values and Use the AutoSum Button
Copyright Cengage Learning. Powered by Cognero. Page 2
,Name: Class: Date:
Excel 2016 - Module 1: Getting Started with Excel 2016
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.003 - Build formulas with the AutoSum button
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
8. You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Enter and Edit a Simple Formula
Excel 12
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.004 - Enter a formula
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
9. To print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula
Auditing group.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Choose Print Options
Excel 16
QUESTION TYPE: True / False
HAS VARIABLES: False
DATE CREATED: 4/3/2016 8:58 PM
DATE MODIFIED: 4/3/2016 9:08 PM
10. A named range can begin with a letter or number.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Enter and Edit a Simple Formula
Excel 12
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.005 - Use cell references to create a formula
DATE CREATED: 2/26/2016 8:02 PM
Copyright Cengage Learning. Powered by Cognero. Page 3
, Name: Class: Date:
Excel 2016 - Module 1: Getting Started with Excel 2016
DATE MODIFIED: 2/26/2016 8:02 PM
11. You can use a named range instead of a cell address in a formula.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Enter and Edit a Simple Formula
Excel 12
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.005 - Use cell references to create a formula
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
12. You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header
or footer is active.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Excel 14
Switch Worksheet Views
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.006 - Create a header/footer
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
13. Printing gridlines makes data easier to read.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Choose Print Options
Excel 16
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHE.REDI.16.007 - Hide/view gridlines when printing
DATE CREATED: 2/26/2016 8:02 PM
DATE MODIFIED: 2/26/2016 8:02 PM
14. Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet.
____________________
Copyright Cengage Learning. Powered by Cognero. Page 4
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller tutorsection. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
