Question 1

In Excel, MAX and AVERAGE are examples of ____.

Accepted Answer

A)   functions
B)   arguments
C)   lists
D)   buttonsE) All of the above
F) None of the above

Question 2

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

Accepted Answer

A)   Home tab, Styles group
B)   Page Layout tab, Page Format group
C)   Home tab, Cells group
D)   Page Layout tab, Cells groupE) None of the above
F) A) and B)

Question 3

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

Accepted Answer

A)   SUM function
B)   redo
C)   fill handle
D)   copy/pasteE) B) and D)
F) None of the above

Question 4

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

Accepted Answer

A)   C1/F3
B)   D1+C1
C)   D1/F3
D)   D1+F3E) All of the above
F) A) and B)

Question 5

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.

Accepted Answer

The order of precedence in Excel is that...

Question 6

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

Accepted Answer

The answer of When copying or moving formulas in an...

Question 7

Match between columns
                        Premises: Mixed cell reference.

Accepted Answer

The Answer of $G6 and $G$6 and COUNT and AVERAGE is...

Question 8

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.

Accepted Answer

The answer of To complete the days of the week...

Question 9

Excel templates include which of these common documents?

Accepted Answer

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

Question 10

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

Accepted Answer

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.E) C) and D)
F) B) and D)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which formula contains a mixed cell reference?

Accepted Answer

A)   =(A6+A7) *0.20
B)   =($A$6+A7) *0.20
C)   =($A$6+$A$7) *0.20
D)   =($A6+$A$7) *0.20E) B) and C)
F) None of the above

Question 14

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

Accepted Answer

A)   the Insert Function dialog box
B)   the AutoSum button
C)   typing the function
D)   typing the function argumentE) A) and D)
F) B) and D)

Question 15

All functions begin with the formula prefix ____.

Accepted Answer

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

Question 16

Match between columns
                        Premises: The type of cell reference used to preserve the relationship to the formula location.

Accepted Answer

The Answer of template and COUNT and relative and AVERAGE is...

Question 17

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

Accepted Answer

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.E) B) and D)
F) A) and D)

Question 18

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

Accepted Answer

After the Excel user selects a range of ...

Question 19

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

Accepted Answer

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.E) None of the above
F) A) and C)

Question 20

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

Accepted Answer

A)   manually typing the function
B)   using the Insert Function button
C)   using the Sum button
D)   using the Sum list arrowE) None of the above
F) All of the above

Exam 7: Excel 2: Working With Formulas and Functions

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

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

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

Correct Answer
verified
After the Excel user selects a range of ...
View Answer

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.

Correct Answer
verified
The order of precedence in Excel is that...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Excel templates include which of these common documents?

Correct Answer
verified

Which formula contains a mixed cell reference?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

All functions begin with the formula prefix ____.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

In Excel, MAX and AVERAGE are examples of ____.

Correct Answer
verified

Exam 7: Excel 2: Working With Formulas and Functions

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

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

Correct AnswerverifiedAfter the Excel user selects a range of ...View AnswerShow Answer

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.

Correct AnswerverifiedThe order of precedence in Excel is that...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Excel templates include which of these common documents?

Correct AnswerverifiedShow Answer

Which formula contains a mixed cell reference?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

All functions begin with the formula prefix ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

In Excel, MAX and AVERAGE are examples of ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
After the Excel user selects a range of ...
View Answer

Correct Answer
verified
The order of precedence in Excel is that...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified