Exam 7: Excel 2: Working With Formulas and Functions

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

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

=D8+E8*0.5 is a complex formula.

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

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

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

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

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?

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

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

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

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