1

1. You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.
2. True
3. False

6.66 points

Question 2

1. You can use predesigned, formatted files called ____ to create new worksheets quickly.
2. a.formatsheets
3. b.layouts
4. c.templates
5. d.screens

6.66 points

Question 3

1. 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.
2. True
3. False

6.66 points

Question 4

1. All Excel formulas begin with the ____.
2. a.plus sign (+)
3. b.asterisk (*)
4. c.equal sign (=)
5. d.slash (/)

6.76 points

Question 5

1. ____ operators perform mathematical calculations such as adding and subtracting.
2. a.Comparison
3. b.Text concatenation
4. c.Reference
5. d.Arithmetic

6.66 points

Question 6

1. In Excel, the electronic spreadsheet you work in is called a ____.
2. a.tablet
3. b.databook
4. c.numericsheet
5. d.worksheet

6.66 points

Question 7

1. In Excel, a worksheet is contained in a file called a ____.
2. a.workpad
3. b.notebook
4. c.datapad
5. d.workbook

6.66 points

Question 8

1. You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.
2. True
3. False

6.66 points

Question 9

1. Possible paper orientations for printing a worksheet are landscape and ____.
2. a.page break
3. b.portrait
4. c.preview
5. d.normal

6.66 points

Question 10

1. An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.
2. a.project
3. b.dataform
4. c.database
5. d.spreadsheet

6.66 points

Question 11

1. An Excel 2016 workbook has the file extension .xml.
2. True
3. False

6.66 points

Question 12

1. In an electronic spreadsheet, you need to manually recalculate when you change the entries.
2. True
3. False

6.66 points

Question 13

1. You can use a named range instead of a cell address in a formula.
2. True
3. False

6.66 points

Question 14

1. When the paper orientation is portrait, the contents will print across the length of the page instead of across the width. _______________________
2. True
3. False

6.66 points

Question 15

1. The Excel operator for division is ____.
2. a./
3. b.%
4. c.^
5. d.\