Excel - Part 9 Question Preview (ID: 8957)


2nd 50. TEACHERS: click here for quick copy question ID numbers.

Which command on the Chart Tools Ribbon do you use to swap data over the axis in a chart?
a) Select Data
b) Swap Data
c) Switch Row/Column
d) Switch Data

What ribbon is used to create charts in a workbook?
a) Insert ribbon
b) Home ribbon
c) View ribbon
d) File tab

In Microsoft Excel 2010, which is a graphical representation of data that is created from information in a workbook?
a) Table
b) Chart
c) List
d) Picture

Which of the following is a valid Excel 2010 function?
a) AVERAGE, MAX, and NUM
b) MAX, MIN, and WEEK
c) AVERAGE, MAX, and MIN
d) WEEKDAY, MAX, and CLOSE

What is a prewritten formula that is built into Excel 2010 called?
a) Utility
b) Procedure
c) Function
d) Statement

What function adds all of the numbers in a range of cells?
a) Calculate
b) Sum
c) Compute
d) Add

Which function will find the minimum value in a selected area
a) Sum
b) Max
c) Average
d) Min

Which will display formulas in a worksheet?
a) ALT + ~
b) CTRL + !
c) CTRL + `
d) CMD + ~

What function finds the maximum value in a range?
a) sum
b) max
c) average
d) min

What adds a range of cells together and divides them by the number of entries?
a) sum
b) max
c) average
d) min

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 8957 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register