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
Reduce/Add
B
Subtract/Add
C
Decrease/Increase
D
Collapse/Expand
2) In order to directly report the data, what must a PivotChart always be associated with?
A
Table
B
Range
C
Worksheet
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 Layout
B
Chart Tools Format
C
Chart Tools Design
D
Insert
5) John would like to add a banner at the top of his spreadsheet. Which object should he insert?
A
Screenshot
B
Shapes
C
SmartArt
D
Pictures
6) Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?
A
Format
B
Data
C
Style
D
Design
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
Picture Styles
B
Corrections
C
Artistic Effects
D
WordArt Styles
9) Which command creates decorative text in a worksheet?
A
SmartArt
B
Shape
C
Draw
D
WordArt
10) Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
A
Pictures
B
Screenshot
C
SmartArt
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
Shapes
B
Screen clipping
C
Screenshot
D
Picture Cropping
12) Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
A
InstantArt
B
Online Pictures
C
Pictures
D
SmartArt
13) Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
A
Arrange
B
Group
C
Rotate
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
Bar
B
Line
C
Column
D
Pie
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
AND
B
OR
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
OR
B
IF
C
NOT
D
AND
17) James wants his spreadsheet to return true when the logical value is false. What function should he use?
A
AND
B
NOT
C
IF
D
OR
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
View Side-by-Side
B
Convert Text to Column Wizard
C
Split View
D
Comma Delimited
19) SUMIF and SUMIFS are in which category of functions?
A
Lookup reference
B
Logical
C
Text
D
Math Trig
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?