ICT Spreadsheets Lesson 1 Review

A spreadsheet program is used to store data in:

• a database.

• a text document

• rows and columns

• letters and numbers

Spreadsheet rows are easily identified by:

• numbers.

• letters.

• Roman numerals.

• colors.

Spreadsheet columns are easily identified by:

• Roman numerals.

• numbers.

• letters.

• colors.

Which of the following is an example of a cell reference?

• Column C

• =SUM

• Row 1

• A5

Which format would be recommended for a cell that contained the data 1/24/2015?

• Time

• Date

• Number

• Currency

Which of the following will place data in a specific order?

• Sorting

• Centering

• Filtering

• Copying

How can users customize spreadsheets to only display specific criteria?

• Copy the data

• Filter the data

• Align the data

• Sort the data

Instead of resizing your column to accommodate your content, what can you use to fit your content

to the size of the cell?

• Paint formatting

• Text wrapping

• Filtering

• Sorting

When entering numbers into a cell, your spreadsheet program automatically aligns your numbers to:

• the left side of the cell.

• the top of the cell.

• the right side of the cell.

• the bottom of the cell.

When entering text into a cell, your spreadsheet program automatically aligns your text to:

• the left side of the cell.

• the top of the cell.

• the right side of the cell.

• the bottom of the cell.