ICT Spreadsheets Lesson 1 Quiz

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.

Roman numerals.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

• Row1

• 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.