Excel Projects 1-5 Review

Front

A spreadsheet program is used to store data in:

Back

rows and columns.

Front

Spreadsheet rows are easily identified by:

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

Which of these are not an example of how MS Excel can be used? a. Budget, b. Research Paper, c. Track sales, d. Track Inventory

Back

Research Paper

Front

What is the purpose of spreadsheets?

Back

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

Front

What does this symbol represent in MS Excel?

Back

AutoSum

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

When you sort data...

Back

You choose how the data will be displayed.