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

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

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

Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?

Where is the Insert Function button found in Microsoft Excel?

Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?

Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?

Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?

Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:

Joshua created a budget workbook that contains the formula =(Summary!B3). 'Summary' is an example of a/an:

Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?

Trey would like to outline the cell range A1:F20. Which formatting style should he select?

What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?

What function adds all of the numbers in a range of cells?

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

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?

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?

Which are valid Microsoft Excel functions?

Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?

Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?

Where is the command to apply a fill color to a cell or range of cells in a worksheet?

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

Tyler created a monthly sales workbook that contains the formula =(January!B3). 'January' is an example of a/an:

What defines the color of the characters in a Microsoft Excel worksheet?

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

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

Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?

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

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?

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?

How is a cell reference in a formula and its corresponding location in a worksheet identified?

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

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?

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

Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?

Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?

On the Home Ribbon, what is used to change the font size of characters in a cell?

What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

Amanda 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?

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

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

What type of formatting appears only when the value in a cell meets conditions specified by a user?

What command is used to apply a background color to cells in a worksheet?

Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?

Which quick-number style button formats numbers to display as currency in the worksheet?

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?

Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

Which command is used to reduce the margin between the border and the text in an indented cell?

On the Home Ribbon, what can be used to change the text color of characters in a cell?