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

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

Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1?

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

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?

Abigail has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?

Emma has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?

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

Which are valid Microsoft Excel functions?

Which is a prewritten formula that is built into Microsoft Excel?

Juan has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?

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

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

Where would Olivia find the Insert Function button in Microsoft Excel?