Deck 7: Excel 2: Working With Formulas and Functions

Question 1

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Answer 1

False

Question 2

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

Answer 2

True

Question 3

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

Answer 3

False

Question 4

According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10 . _________________________

Question 5

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. _________________________

Question 6

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

Question 7

The COUNTA function returns the number of cells in a range that contain numeric data.​

Question 8

An absolute cell reference changes the cell references when the formula is copied to a new location.

Question 9

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

Question 10

In this formula,  =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references. _________________________

Question 11

=D8+E8*0.5 is a complex formula.

Question 12

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Question 13

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

Question 14

When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________

Question 15

To insert the AVERAGE function into a cell, click the cell, click the Function Options list arrow in the Editing group on the Home tab, and then click Average. _________________________

Question 16

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result:  =22/2*5  =22/(2*5).

Question 17

Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet. _________________________

Question 18

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

Question 19

You can close the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group. _________________________

Question 20

An Excel complex formula uses more than one arithmetic operator.

Question 21

Which type of cell reference preserves the exact cell address in a formula?

A) absolute
B) mixed
C) relative
D) All of the above.

Question 22

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

A) Cell references are not affected.
B) The user must insert new cell references.
C) The user is prompted to enter new cell references.
D) Cell references are automatically adjusted.

Question 23

Which method of entering a function requires the user to know the name and initial characters of a function?

A) manually typing the function
B) using the Insert Function button
C) using the Sum button
D) using the Sum list arrow

Question 24

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

A) $M$3/4
B) (G15-G14)*$M$3
C) (G15-G14)
D) (G15-G14)/4

Question 25

All functions begin with the formula prefix ____.

A) @ (at symbol)
B) = (equals sign)
C) # (number symbol)
D) + (plus sign)

Question 26

Functions can be entered for formulas using all of the following methods except ____.

A) the Insert Function dialog box
B) the AutoSum button
C) typing the function
D) typing the function argument

Question 27

In Excel, MAX and AVERAGE are examples of ____.

A) functions
B) arguments
C) lists
D) buttons

Question 28

When cells are copied using Excel's copy function, what happens to the data in the copied cells?

A) The data is permanently deleted from the copied cells.
B) The data is temporarily deleted from the copied cells.
C) The data remains in its original location.
D) The data is moved to another location and removed from its original location.

Question 29

You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.

A) %
B) &
C) $
D) @

Question 30

The COUNTA function is used to count the number of cells in a range that contain which type of data?

A) numbers
B) dates
C) formulas
D) All of the above.

Question 31

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?

A) [F1]
B) [F4]
C) [F10]
D) [F12]

Question 32

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

A) The user sees a "clipboard full" message.
B) The clipboard automatically deletes all items and starts over with the new item.
C) The clipboard prompts the user to delete items.
D) The clipboard automatically deletes the oldest item on the clipboard.

Question 33

Which of the following is a complex formula?

A) =SUM(B4:B8)
B) =(B4/B8)*10
C) =AVERAGE(C6:D6)
D) =MIN(D5:D7)

Question 34

An Excel user should use a relative cell reference when it is important to ____.

A) preserve the relationship to the formula location
B) never change the formula
C) preserve the exact cell address in a formula
D) memorize the formula

Question 35

After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be used to fill the cells with only specific elements of the copied cell, if you wish. _________________________

Question 36

To insert cells, click the Insert list arrow in the Cells group on the ____ tab, then click Insert Cells.

A) HOME
B) CELLS
C) INSERT
D) TOOLS

Question 37

Which formula contains a mixed cell reference?

A) =(A6+A7)*0.20
B) =($A$6+A7)*0.20
C) =($A$6+$A$7)*0.20
D) =($A6+$A$7)*0.20

Question 38

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

A) =C12+(C13*F4)
B) =(C12+C13)*F4
C) =$C12+$C13*F4
D) =C12*F4+C13

Question 39

In the formula =D1+C1/F3, which calculation will be performed first?

A) C1/F3
B) D1+C1
C) D1/F3
D) D1+F3

Question 40

Which tab and group will allow the insertion of rows and columns in a worksheet?

A) Home tab, Styles group
B) Page Layout tab, Page Format group
C) Home tab, Cells group
D) Page Layout tab, Cells group

Question 41

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

A) mixed
B) absolute
C) relative
D) parameter

Question 42

The formula =A4+A8*($B$12) is an example of a(n) ____________________ formula.

Question 43

The ____________________ function specifies the number of decimal places to be used for values and formulas.

Question 44

The default file extension for an Excel 2016 workbook is ____.

A) .xltx
B) .xslx
C) .xlsx
D) .xlts

Question 45

In the formula =ROUND(D4:F4,0), what does the zero indicate?

A) The number of decimal places in the rounded number.
B) The number of times the formula should be repeated.
C) A null value.
D) The value for cell F4.

Question 46

The = sign is also called the ____________________ and is automatically inserted when a function is selected.

Question 47

Discuss how the order of precedence works in the formula =25+2/3 and =(25+2)/3. Describe the order of calculations in your answer.

Question 48

Which keyboard shortcut turns on Edit mode?

A) [F1]
B) [F2]
C) [F4]
D) [F8]

Question 49

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.

A) formulas
B) formatting
C) labels
D) data

Question 50

The file extension .xltx indicates what type of Excel file?

A) Excel template
B) Excel workbook
C) Excel worksheet
D) Excel formulas only worksheet

Question 51

To complete the days of the week sequence that begins with the days Monday, Tuesday; the Excel user would select the cells containing Monday and Tuesday and use the ____________________ to complete the sequence.

Question 52

A(n) ____________________ is a predefined worksheet formula that enables Excel users to easily perform complex calculations.

Question 53

When copying or moving formulas in an Excel worksheet, the default type of cell reference is ____________________.

Question 54

Excel's ____________________ feature suggests functions depending on the first letters typed by the user.

Question 55

Which of the following is NOT a Paste list arrow option?

A) pasting values only
B) pasting values with number formatting
C) pasting cell selectors
D) pasting formulas only

Question 56

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

A) SUM function
B) redo
C) fill handle
D) copy/paste

Question 57

Excel templates include which of these common documents?

A) budgets
B) balance sheets
C) time cards
D) All of the above.

Question 58

The ____________________ button on the formula bar is one way to easily insert a function into a worksheet cell.

Question 59

The Office Clipboard contains up to 24 of the most recently cut or copied items from any Office application, and the items may be viewed using the ____________________ feature of Office.

Question 60

The $ symbol placed before a row and column address indicates a(n) ____________________ cell reference.

Question 62

Discuss the difference between a relative cell reference and an absolute cell reference. Include the following information in your answer: how the two types of cell addresses are designated, what happens when each type of cell reference is copied, and when it is appropriate to use each type of reference.

Question 65

Discuss the use of an Excel template to create a workbook.

Question 67

Explain the use of the fill handle to fill cells with sequential information.

Question 68

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6. In your budget, which function can be used to eliminate the two decimal places in all cells with values that include decimal places?
A. VARY
B. ROUND
C. SIGDIGIT
D. MIN

Question 69

Excel Module 2 demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.

Question 70

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6. In your budget, there is a formula in cell C7 that you want to copy to cells C8 and C9. What Excel feature would you use to accomplish this?
A. formula painter
B. formula copier
C. fill handle
D. formula index

Question 72

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6. Write a formula using an absolute cell reference that would return a value of 1550 in cell C6.
A. =$B$3-B6
B. =$B$4-B6
C. =B$3-B6
D. =$B$9-B6