Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
In Sam’s spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
Ken has inserted a picture into his spreadsheet and would like it to standout with a frame or 3D effect. Which tool would he use to achieve this?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
SUMIF and SUMIFS are in which category of functions?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
Collapse/Expand
Design
Rotate
Convert Text to Column Wizard
Math Trig
Format
Picture Styles
Screenshot
Check it!