Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data?
What is PivotTable
100
Which command creates decorative text in a worksheet?
What is WordArt.
100
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
What is Review?
100
What ribbon contains the commands used to create a chart in Excel?
What is Insert ribbon.
100
which is typically included in the range of data selected to create a chart?
What is Numeric data and titles.
200
What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivtoCharts?
What is Slicers.
200
which is the name of an interactive graphical representation of data that allows a user to change the groupings?
What is PivotChart.
200
Which group on the Formulas Ribbon contains the command that checks for comma errors found in a formula?
What is Formula Auditing
200
What is the process of viewing a PivotTable report for a subset that meets the criterion only?
What is Filtering.
200
What is the process of bringing data containing text fields separated by commas into Excel called?
What is Importing data.
300
In a worksheet, which command suggests other words with a similar meaning that can be used?
What is Thesaurus.
300
Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?
What is Layout.
300
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
What is Screenshot.
300
Dorothy designed a column chart and would like to change the background color yellow. Which chart feature should she modify?
What is Plot Area.
300
David wants to arrange the employees salaries in Column A of his spreadsheet from lowest to highest. what commands should he use to complete this task?
What is Sort.
400
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?
What is Conditional Formatting.
400
john would like to display the count of employees last names on the Y-axis. what area would her drag this information to in order to display correctly?
What is Values.
500
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?