MS Excel Honors #8 Question Preview (ID: 54179)
Review.
TEACHERS: click here for quick copy question ID numbers.
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
a) Decrease/Increase
b) Collapse/Expand
c) Reduce/Add
d) Subtract/Add
In order to directly report the data, what must a PivotChart always be associated with?
a) Table
b) Range
c) PivotTable
d) Worksheet
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
a) Design
b) Format
c) Layout
d) Analyze
In Microsoft Excel, which tab is used to add shape effects to a chart?
a) Chart Tools Design
b) Chart Tools Format
c) Chart Tools Layout
d) Insert
John would like to add a banner at the top of his spreadsheet. Which object should he insert?
a) Shapes
b) Pictures
c) SmartArt
d) Screenshot
Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?
a) Data
b) Design
c) Style
d) Format
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?
a) Picture Styles
b) Artistic Effects
c) Corrections
d) WordArt Styles
Ken has inserted a picture into his spreadsheet that was taken with a low-quality camera. Which tool would allow him to sharpen the image?
a) Picture Styles
b) Artistic Effects
c) Corrections
d) WordArt Styles
Which command creates decorative text in a worksheet?
a) SmartArt
b) WordArt
c) Draw
d) Shape
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
a) Shapes
b) Pictures
c) SmartArt
d) Screenshot
Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
a) Shapes
b) Picture Cropping
c) Screen clipping
d) Screenshot
Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
a) Online Pictures
b) Pictures
c) SmartArt
d) InstantArt
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
a) Align
b) Arrange
c) Group
d) Rotate
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
a) Bar
b) Column
c) Line
d) Pie
Jill would like to use a function that will return “True” when only one of the arguments in the function is true. What function should she use?
a) VLOOKUP
b) AND
c) OR
d) NOT
Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?
a) IF
b) AND
c) OR
d) NOT
James wants his spreadsheet to return true when the logical value is false. What function should he use?
a) IF
b) AND
c) OR
d) NOT
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?
a) Convert Text to Column Wizard
b) Split View
c) View Side-by-Side
d) Comma Delimited
SUMIF and SUMIFS are in which category of functions?
a) Math Trig
b) Text
c) Logical
d) Lookup reference
IF, AND, OR and NOT are all part of which category of functions?
a) Math Trig
b) Text
c) Logical
d) Lookup Reference
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 54179 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 54179 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register