Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel - Part 9
Test Description: 2nd 50
Instructions: Answer all questions to get your test result.
1) Which command on the Chart Tools Ribbon do you use to swap data over the axis in a chart?
A
Swap Data
B
Select Data
C
Switch Row/Column
D
Switch Data
2) What ribbon is used to create charts in a workbook?
A
View ribbon
B
Insert ribbon
C
File tab
D
Home ribbon
3) In Microsoft Excel 2010, which is a graphical representation of data that is created from information in a workbook?
A
List
B
Picture
C
Table
D
Chart
4) Which of the following is a valid Excel 2010 function?
A
MAX, MIN, and WEEK
B
AVERAGE, MAX, and MIN
C
AVERAGE, MAX, and NUM
D
WEEKDAY, MAX, and CLOSE
5) What is a prewritten formula that is built into Excel 2010 called?
A
Function
B
Procedure
C
Statement
D
Utility
6) What function adds all of the numbers in a range of cells?
A
Calculate
B
Sum
C
Compute
D
Add
7) Which function will find the minimum value in a selected area
A
Min
B
Sum
C
Average
D
Max
8) Which will display formulas in a worksheet?
A
ALT + ~
B
CTRL + !
C
CTRL + `
D
CMD + ~
9) What function finds the maximum value in a range?
A
average
B
sum
C
min
D
max
10) What adds a range of cells together and divides them by the number of entries?
A
sum
B
average
C
max
D
min
*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?