ICT Spreadsheets Lesson 1 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? Column C, =SUM, Row 1, A5

Back

A5

Front

Which format would be recommended for a cell that contained the data 1/24/2015? Options: Time, Date, Number, Currency

Back

Date

Front

Which of the following will place data in a specific order? Sorting, Centering, Filtering, Copying

Back

Sorting

Front

How can users customize spreadsheets to only display specific criteria?

Back

Filter the data

Front

Instead of resizing your column to accommodate your content, what can you use to fit your content to the size of the cell? Options: Paint formatting, Text wrapping, Filtering, Sorting

Back

Text wrapping

Front

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

Back

the right side of the cell.

Front

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

Back

the left side of the cell.