Deck 6: Excel 1: Getting Started With Excel 2016

Question 1

Arguments are Excel's built-in formulas.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

You can use a named range instead of a cell address in a formula.

Answer 3

True

Question 4

Office Lite includes simplified version of the apps found in the Office 2016 suite.​ ____________________

Question 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.

Question 6

Dragging the fill handle across a range of cells copies the contents of the first cell into the other cells in the range. ____________________

Question 7

When the paper orientation is portrait , the contents will print across the length of the page instead of across the width. _______________________

Question 8

A named range can begin with a letter or number.

Question 9

Printing gridlines makes data easier to read.

Question 10

To print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.​

Question 11

The Visual Analysis tool allows you to easily create charts and other elements that help you visualized how data is distributed.​

Question 12

Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet. ____________________

Question 13

Labels are numbers, formulas, and functions that can be used in calculations. _____________________

Question 14

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Question 15

Charts are updated automatically in Excel whenever data changes.

Question 16

One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon . ______________________

Question 17

Reference operators compare values for the purpose of true/false results. _____________________

Question 18

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

Question 19

An Excel 2016 workbook has the file extension .xml.

Question 20

You are in Edit mode any time you are entering or changing the contents of a cell.

Question 21

You can use predesigned, formatted files called ____ to create new worksheets quickly.

A) formatsheets
B) layouts
C) templates
D) screens

Question 22

In Excel, the electronic spreadsheet you work in is called a ____.

A) tablet
B) databook
C) numericsheet
D) worksheet

Question 23

The Excel operator for exponent is ____.

A) /
B) \
C) %
D) ^

Question 24

The entry in cell B15 is =SUM(B5:B 14) which is a ____.

A) label
B) formula
C) calculation
D) value

Question 25

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

A) represent values graphically
B) organize data
C) create what-if data scenarios
D) perform calculations

Question 26

The Excel operator for division is ____.

A) /
B) \
C) %
D) ^

Question 27

You can use ____ to move around in a document that is too large to fit on the screen at once.

A) cell pointers
B) mode indicators
C) scroll bars
D) sheet tabs

Question 28

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

A) Cell pointers
B) Mode indicators
C) Scroll bars
D) Sheet tabs

Question 29

The _____ sheet button allows you to add worksheets to a workbook.​

A) ​Blank
B) ​New
C) Create
D) ​Add

Question 30

The name Peter is entered in cell B4. This is a ____.

A) label
B) formula
C) number
D) value

Question 31

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.​

A) ​name box
B) ​taskbar
C) ​insert bar
D) ​formula bar

Question 32

A named range must begin with a letter or a(n) _____.​

A) ​underscore (_)
B) ​asterisk (*)
C) ​ampersand (&)
D) ​pound symbol (#)

Question 33

A(n) ____ is a built-in formula that uses arguments to calculate information.

A) label
B) function
C) template
D) indicator

Question 34

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

A) =A1/A2
B) =10/2
C) 5
D) =5

Question 35

A(n) ____ is an entry in a cell that contains text such as "2016 Sales" or "Travel Expenses."

A) value
B) label
C) formula
D) argument

Question 36

In Excel, a worksheet is contained in a file called a ____.

A) workbook
B) workpad
C) notebook
D) datapad

Question 37

In a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.

A) label
B) formula
C) graphic
D) value

Question 38

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

A) database
B) spreadsheet
C) dataform
D) project

Question 39

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

A) =A1^A2
B) 20
C) 10^2
D) 100

Question 40

All Excel formulas begin with the ____.

A) plus sign (+)
B) asterisk (*)
C) equal sign (=)
D) slash (/)

Question 41

To quickly jump to the last cell in a worksheet press ____.

A) [Alt][Page Down]
B) [Shift][Down]
C) [Page Down]
D) [Ctrl][End]

Question 42

The Undo button allows you to reverse up to ____ previous actions, one at a time.

A) 1
B) 10
C) 100
D) 1,000

Question 43

You can use Excel's ____________________ feature to automatically save your work as often as you want.​

Question 44

Excel recognizes an entry as a value if it is a number or it begins with ____.

A) +
B) =
C) $
D) All of the above.

Question 45

Any time you use a worksheet to ask the question "what if?" you are performing ____________________ analysis.

Question 46

____ operators perform mathematical calculations such as adding and subtracting.

A) Text concatenation
B) Reference
C) Arithmetic
D) Comparison

Question 47

A(n) ____________________ is an equation in a worksheet.

Question 48

You can change, or ____, the contents of an active cell at any time.

A) recover
B) navigate
C) edit
D) calculate

Question 49

Possible paper orientations for printing a worksheet are landscape and ____.

A) preview
B) portrait
C) normal
D) page break

Question 50

To quickly jump to the first cell in a worksheet press ____.

A) [Alt][Page Up]
B) [Shift][Home]
C) [Page Up]
D) [Ctrl][Home]

Question 51

The cell ____________________ is a dark rectangle that outlines the cell you are working in.​

Question 52

Clicking the ____________________ button sums the adjacent cell range above or to the left.

Question 53

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.

A) Preview
B) Zoom
C) Orientation
D) Layout

Question 54

To move one screen to the left press ____.

A) [Ctrl][Home]
B) [Alt][Page Up]
C) [Ctrl][Page Left]
D) [Alt][Page Down]

Question 55

The cell in which you are working is called the ____________________ cell.

Question 56

In a worksheet, the ____ is called the formula prefix.

A) minus sign (-)
B) plus sign (+)
C) pound sign (#)
D) equal sign (=)

Question 57

The ____ option helps fit the data on a single page without making changes to individual margins.

A) Scale to Fit
B) Paginate
C) Page Break View
D) Squeeze

Question 58

You can edit the contents of the active cell by ____.

A) pressing the [Enter] key and starting to type
B) pressing the [Home] key and starting to type
C) just starting to type
D) pressing the [Ctrl] key and the [Home] key and starting to type

Question 59

You can use the ____ key(s) on the keyboard to navigate a worksheet.

A) [Ctrl]
B) Zoom
C) arrow
D) [Enter]

Question 60

To display gridlines on a worksheet, click the Gridlines check box in the _____ group on the View tab.​

A) ​Rulers & Gridlines
B) ​Show
C) ​Margins
D) ​Zoom

Question 61

Critical Thinking Questions Case 1-1 You work in the Sales department of a company that has three store locations; Downtown, Midtown, and Uptown. You are creating a summarized worksheet about the company's sales to send to the General Manager. So far, you have created a worksheet that lists each store location in cells A4 through A6. Quarterly sales for Downtown are in cells B4 through E4, Midtown are in cells B5 through E5, and Uptown quarterly sales are in  cells B6 through E6.  Write the complete formulas for the Total row, cell C8 to calculate the second quarter sales for the three stores.
A. =SUM(C4:C6)
B. =TOT(C4-C6)
C. =TOT(C4:C6)
D. =SUM(C4_C6)

Question 62

Discuss the five guidelines for creating calculations in Excel.

Question 65

Explain the difference between Normal view and Page Layout view in Excel.

Question 68

Critical Thinking Questions Case 1-1 You work in the Sales department of a company that has three store locations; Downtown, Midtown, and Uptown. You are creating a summarized worksheet about the company's sales to send to the General Manager. So far, you have create a worksheet that lists each store location in cells A4 through A6. Quarterly sales for Downtown are in cells B4 through E4, Midtown are in cells B5 through E5, and Uptown quarterly sales are in  cells B6 through E6.  Write the complete formulas for finding the Yearly Sales figures in cell F4 for the Downtown store.
A. =TOT(B4:E4)
B. =SUM(B4:E4)
C. =AVERAGE(B4:E4)
D. =ADD(B4:E4)

Question 69

What do you have the ability to do when you use Excel?

Question 71

Critical Thinking Questions Case 1-2 You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. So far, you have entered the names of your students in cells A4 through A11 as well as scores for Test 1 in cells B4 through B11 and Test 2 in cells C4 through C11. Graham is the first student in cell A4. You want to put a formula in cells D4 through D11 for finding the difference between the two test scores for each student. You enter =C4-B4 in cell D4 and then use what feature to copy the formula down the column through cell D11?
A. formula copier
B. fill handle
C. formula painter
D. formula index

Question 72

Critical Thinking Questions Case 1-2 You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. So far, you have entered the names of your students in cells A4 through A11 as well as scores for Test 1 in cells B4 through B11 and Test 2 in cells C4 through C11. Graham is the first student in cell A4. Which of the following is NOT a valid formula for use in cell B13 for finding the average of Test 1?
A. =(B4+B5+B6+B7+B8+B9+B10+B11)/8
B. =SUM(B4:B11)/8
C. =(B4+B5+B6+B7+B8+B9+B10+B11)/COUNT(B4:B11)
D. =AVG(B4:B11)

Question 73

Describe calculation operators, including the different types of calculation operators.

Question 74

Describe Excel's AutoRecover feature.

Question 75

Critical Thinking Questions Case 1-2 You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. So far, you have entered the names of your students in cells A4 through A11 as well as scores for Test 1 in cells B4 through B11 and Test 2 in cells C4 through C11. Graham is the first student in cell A4. You realize that you have made an error in the spreadsheet. Graham's score for test 2 should be 76, not 67. To fix this error, navigate to cell C4, type 76, and then press what key?
A. [F4]
B. [Ctrl]
C. [Enter]
D. [Alt]