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

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

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

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

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?

Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?

What is the spellchecker located?

Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature should she modify?

Dorothy designed a column chart and would like to add an element that will help the eye and improve readability of the chart. which chart feature should she include?

Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?

John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?

What graphically represents trends in plotted data and predicts future values?

Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?

Which command creates decorative text in a worksheet?

Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What functions should she use?

IF, AND, OR and NOT are all part of which category of functions?

Which command on the Home Ribbon do you use to organize data in ascending or descending order?

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

David only wants to view the employees in the Marketing department who earns a salary of more than $25,000. What command should he use to complete this task?

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?

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

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

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

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 type of formatting appears only when the value in a cell meets conditions specified by a user?

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

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

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?

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

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

What is this icon?

What is this icon?

What is this icon?

What do you change from the drop down menu?

What is this icon?

What is this icon?

What is this icon?

What is this icon?

What is this icon?

What is this icon?

What are these icons?

What is this icon?

What do these icons edit?

This is the freeze pane symbol?

These are examples of formatting/styles for what feature in Excel?

This icon will change the HORIZONTAL alignment of your text?

These icons will change the VERTICAL alignment of your text (left, right, center)

The picture is of what GROUP?