Excel Quiz 3 Question Preview (ID: 3082)


Contains Questions About Various Features In Excel And Charts. TEACHERS: click here for quick copy question ID numbers.

Which button displays the formulas used in your worksheet?
a) Sort & Filter
b) View
c) Show Formulas
d) Insert

Which button is useful for creating a title that goes across all columns of information?
a) Left Align
b) Merge & Center
c) Center Align
d) Sort & Filter

Which chart is used to display data measured in horizontal stacks?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Column Chart

What chart is used to compare data over a period of time?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Column Chart

What chart is used to compare pieces of data using vertical stacks?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Column Chart

What chart is used to show how a total number is broken down into individual parts?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Column Chart

You can use the AutoFill feature to copy formulas from one cell to another.
a) True
b) False
c)
d)

When the chart appears on the same worksheet as the data, it is a(an) _______ chart.
a) Pie
b) Column
c) Embedded
d) Line

Which two functions produce opposite results?
a) Sum and Average
b) Sum and Max
c) Max and Min
d) Sum and Min

Instead of typing the range of cells in the function, you can also click and drag to select the cells.
a) True
b) False
c)
d)

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: 3082 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register