Excel Lesson 5

Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?

Where can you find the Insert Function button in Microsoft Excel?

What is a prewritten formula that is built into Microsoft Excel called?

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?

Which command on the Home Tab displays the total of the selected cells directly after the selected cells?

Which group on the Formulas Ribbon enables a user to specify when a formula is computed?

Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?

What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?

What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?

Which of the following are valid Microsoft Excel functions?

Which command group on the Formulas Ribbon allows a user to choose from various categories of functions to use in a worksheet?

Madison is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?

Chelsea has created a spreadsheet containing student grades. Which function would she use to return the current date in cell F1?

Jordan is calculating her average sales for the past four months. If she uses "=AVERAGE(A1:A7)", this is an example of which type of entry?