Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #8
Test Description: Review
Instructions: Answer all questions to get your test result.
1) What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
A
Collapse/Expand
B
Subtract/Add
C
Reduce/Add
D
Decrease/Increase
2) In order to directly report the data, what must a PivotChart always be associated with?
A
Table
B
Worksheet
C
Range
D
PivotTable
3) Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
A
Analyze
B
Format
C
Layout
D
Design
4) In Microsoft Excel, which tab is used to add shape effects to a chart?
A
Chart Tools Design
B
Insert
C
Chart Tools Layout
D
Chart Tools Format
5) John would like to add a banner at the top of his spreadsheet. Which object should he insert?
A
Pictures
B
Screenshot
C
SmartArt
D
Shapes
6) Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?
A
Format
B
Design
C
Data
D
Style
7) 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
Artistic Effects
B
WordArt Styles
C
Picture Styles
D
Corrections
8) 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
WordArt Styles
B
Corrections
C
Picture Styles
D
Artistic Effects
9) Which command creates decorative text in a worksheet?
A
WordArt
B
SmartArt
C
Shape
D
Draw
10) Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
A
Screenshot
B
SmartArt
C
Pictures
D
Shapes
11) Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
A
Picture Cropping
B
Screenshot
C
Shapes
D
Screen clipping
12) Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
A
Online Pictures
B
Pictures
C
InstantArt
D
SmartArt
13) Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
A
Rotate
B
Arrange
C
Group
D
Align
14) Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
A
Column
B
Line
C
Pie
D
Bar
15) 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
OR
B
AND
C
NOT
D
VLOOKUP
16) 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
NOT
D
OR
17) James wants his spreadsheet to return true when the logical value is false. What function should he use?
A
NOT
B
OR
C
IF
D
AND
18) 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
View Side-by-Side
C
Comma Delimited
D
Split View
19) SUMIF and SUMIFS are in which category of functions?
A
Math Trig
B
Text
C
Logical
D
Lookup reference
20) IF, AND, OR and NOT are all part of which category of functions?
A
Lookup Reference
B
Math Trig
C
Logical
D
Text
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?