Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Quiz 3
Test Description: Contains questions about various features in Excel and charts.
Instructions: Answer all questions to get your test result.
1) Which button displays the formulas used in your worksheet?
A
View
B
Insert
C
Show Formulas
D
Sort & Filter
2) Which button is useful for creating a title that goes across all columns of information?
A
Center Align
B
Merge & Center
C
Sort & Filter
D
Left Align
3) Which chart is used to display data measured in horizontal stacks?
A
Bar Chart
B
Pie Chart
C
Line Chart
D
Column Chart
4) What chart is used to compare data over a period of time?
A
Line Chart
B
Pie Chart
C
Bar Chart
D
Column Chart
5) What chart is used to compare pieces of data using vertical stacks?
A
Bar Chart
B
Column Chart
C
Pie Chart
D
Line Chart
6) What chart is used to show how a total number is broken down into individual parts?
A
Column Chart
B
Bar Chart
C
Line Chart
D
Pie Chart
7) You can use the AutoFill feature to copy formulas from one cell to another.
A
True
B
False
8) When the chart appears on the same worksheet as the data, it is a(an) _______ chart.
A
Embedded
B
Pie
C
Line
D
Column
9) Which two functions produce opposite results?
A
Sum and Average
B
Sum and Min
C
Max and Min
D
Sum and Max
10) Instead of typing the range of cells in the function, you can also click and drag to select the cells.
A
True
B
False
*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?