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
PivotTable
B
Table
C
Range
D
Worksheet
3) Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
A
Design
B
Format
C
Analyze
D
Layout
4) In Microsoft Excel, which tab is used to add shape effects to a chart?
A
Insert
B
Chart Tools Format
C
Chart Tools Layout
D
Chart Tools Design
5) John would like to add a banner at the top of his spreadsheet. Which object should he insert?
A
Shapes
B
Screenshot
C
Pictures
D
SmartArt
6) Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?
A
Design
B
Format
C
Style
D
Data
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
Picture Styles
C
WordArt 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
Picture Styles
C
Corrections
D
Artistic Effects
9) Which command creates decorative text in a worksheet?
A
SmartArt
B
Draw
C
Shape
D
WordArt
10) Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
A
SmartArt
B
Pictures
C
Shapes
D
Screenshot
11) Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
A
Screenshot
B
Screen clipping
C
Picture Cropping
D
Shapes
12) Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
A
SmartArt
B
Online Pictures
C
Pictures
D
InstantArt
13) Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
A
Rotate
B
Align
C
Arrange
D
Group
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
Column
C
Pie
D
Line
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
NOT
C
OR
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
AND
B
OR
C
IF
D
NOT
17) James wants his spreadsheet to return true when the logical value is false. What function should he use?
A
AND
B
IF
C
OR
D
NOT
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
Comma Delimited
C
Convert Text to Column Wizard
D
Split View
19) SUMIF and SUMIFS are in which category of functions?
A
Lookup reference
B
Math Trig
C
Text
D
Logical
20) IF, AND, OR and NOT are all part of which category of functions?
A
Logical
B
Math Trig
C
Text
D
Lookup Reference
*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?