Spreadsheet and Graphs Quiz

Which type of graph would NOT work for multiple sets of data?

• Pie

• Bar

• Line

• Column

Emma is working on a project where she needs to organize data in columns of a grid and perform calculations. Which program should she use?

• Presentation

• Book

• Spreadsheet

• Document

To get the minimum score on Assignment 1, what would I enter into cell B15?

• =MINIMUM(CD:C12)

• =MIN(B3:B12)

• =MIN(B3:B14)

• =MINIMUM(B3:B14)

What function is used to make multiple sheets fit on one page?

• Alignment

• Scale to Fit

• Page Setup

• Number

Which is an example of a cell reference?

• Column C

• A1:B4

• C2

• Row 3

Which of the following is a correct cell reference?

• 5R

• 17-D

• J:12

• AB1

Which of the following is a properly formatted FORMULA?

• =SUM(A3:45)

• =MAX(A3-A98)

• =(A4-G4)/J5

• =ROUNDA1-5

What feature allows you to format pictures to represent the number of items in the chart?

• Gap Width

• Stack

• Gradient Fill

• Stack and Scale

_______ is what you do when you organize data numerically or alphabetically.

• Formatting

• Charting

• Filtering

• Sorting

What function allows you to find the total number of items in a cell range?

• SUM

• ROUND

• COUNT

• MAX

• AVERAGE