Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?

Which tab is used to display the area that contains the print command?

Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?

Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:

Which area on the left side of the formula bar indicates the cell address of a selected cell?

Which notebook-like feature organizes the sheets for use in Excel?

Which view is the default view used in Microsoft Excel?

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?

What occurs when the cursor is moved over a cell and a user clicks?

Which ribbon option opens a related dialog box?

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?

Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?

In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?

Which command on the Fill options dialog box is the default option if a month or day is entered?

What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?

Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?

What is the process of using the mouse to move or copy cells called?

John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?

David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?

Which command on the Home ribbon allows data to be moved from one worksheet location to another?

Which would be used to help organize and identify Microsoft Excel files by providing details about the files?

Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?

Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?

In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?

Alicia needs to move the data in cell B5 to cell E5. Which command would she select?

Alicia needs to delete the data in cell B5. Which command would she select?

Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:

What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?

Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?

7. Jim would like to print only the cell range A1:F20. What page setup option should he change?

Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?

Steve would like to print only the worksheet he is currently working on. What print option should he choose?

John's workbook includes 3 worksheets. Which option should he choose to print them?

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?

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

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

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

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

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

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?

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

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

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

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

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 is a prewritten formula that is built into Microsoft Excel?

Which are valid Microsoft Excel functions?

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?

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

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

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

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

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

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?

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

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

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

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

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

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

. Trey would like to outline the cell range A1:F20. 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?

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?

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

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

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

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

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

Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?

Which term describes the blank portions of a page that fall outside the main body of the printed document?

Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?

Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?

John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?

Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?

Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?