Question 1

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

Accepted Answer

The answer of The ____________________ function specifies the number of...

Question 2

=D8+E8*0.5 is a complex formula.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)   Excel template
B)   Excel workbook
C)   Excel worksheet
D)   Excel formulas only worksheetE) All of the above
F) A) and C)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

Often, you need to fill cells with seque...

Question 6

Match between columns
                        Premises: A statistical function.

Accepted Answer

The Answer of template and $G$6 and COUNT and relative is...

Question 7

Match between columns
                        Premises: Allows the user to move or copy data from one cell to another without using the Clipboard.

Accepted Answer

The Answer of drag-and-drop method and template and COUNT and is...

Question 8

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

Accepted Answer

Excel templates are predesigned workbook...

Question 9

Match between columns
                        Premises: Absolute cell reference.

Accepted Answer

The Answer of $G$6 and Paste list arrow and $G6 is...

Question 10

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?

Accepted Answer

A)   formula painter
B)   formula copier
C)   fill handle
D)   formula indexE) A) and D)
F) A) and C)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A)   .xltx
B)   .xslx
C)   .xlsx
D)   .xltsE) A) and C)
F) A) and D)

Question 15

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

Accepted Answer

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

Exam 7: Excel 2: Working With Formulas and Functions

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

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

Correct Answer
verified
Excel templates are predesigned workbook...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified
Often, you need to fill cells with seque...
View Answer

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

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

=D8+E8*0.5 is a complex formula.

Correct Answer
verified

Exam 7: Excel 2: Working With Formulas and Functions

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

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

Correct AnswerverifiedExcel templates are predesigned workbook...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedOften, you need to fill cells with seque...View AnswerShow Answer

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

=D8+E8*0.5 is a complex formula.

Correct AnswerverifiedShow Answer

Correct Answer
verified
Excel templates are predesigned workbook...
View Answer

Correct Answer
verified

Correct Answer
verified
Often, you need to fill cells with seque...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified