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? Options: 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?

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

How to multiply A1 and B1, subtract A2 from B2, and add the results 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, Align Right, Merge & Center

Back

Align Right