Google Spreadsheets

Front

A spreadsheet program is used to store data in:

Back

rows and columns.

Front

Spreadsheet rows are easily identified by: numbers, letters, Roman numerals, colors.

Back

numbers.

Front

Spreadsheet columns are easily identified by: Roman numerals, numbers, letters, colors.

Back

letters.

Front

Which of the following is an example of a cell reference? Options: Column C, =SUM, Row 1, A5

Back

A5

Front

A ___________________ is a visual representation of data

Back

chart

Front

What is the purpose of spreadsheets?

Back

To perform basic and complex math computations in an organized way.

Front

If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:

Back

=sum(D2:D11)

Front

If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

Back

=average(C2:C11)

Front

Which of these is NOT a reason to freeze a row or column? To keep others from being able to edit it, To keep the row or column visible as you scroll through the data, To exclude the row or column name when you sort the data, To create a header row with column titles

Back

To keep others from being able to edit it

Front

When you sort data...

Back

You choose how the data will be displayed.