Spreadsheet and Graphs Flashcard

Front

Which of the following is NOT used to identify a cell: Cell Reference, Active cell, B5, Location

Back

Location

Front

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?

Back

Spreadsheet

Front

Which of the following is a correct cell reference? 5R, 17-D, J:12, AB1

Back

AB1

Front

What feature allows you to format pictures to represent the number of items in the chart? Options: Gap Width, Stack, Gradient Fill, Stack and Scale

Back

Stack and Scale

Front

Which cell range is correctly formatted? Options: C3:C10, D1-E1, B4 to F2, G5>G15

Back

C3:C10

Front

Which of the following is a properly formatted FORMULA? =SUM(A3:45), =MAX(A3-A98), =(A4-G4)/J5, =ROUNDA1-5

Back

=SUM(A3:45)

Front

What is the best graph to use with one set of data points?

Back

Pie

Front

If I wanted to multiply A1 and B1, then subtract A2 from B2, and then add the two results, how would I type that in Excel?

Back

=(A1*B1)+(B2-A2)

Front

What function would you use to add a range of cells together?

Back

SUM

Front

Which feature was NOT used to make Figure A look like Figure B? Options: Wrap Text, Gradient Fill, Merge & Center

Back

Align Right