ICT Spreadsheet Essentials - Lesson 1 (Part 1)

Data stored in a series of rows and columns is called a:

• spreadsheet.

• graphics file.

• presentation.

• text document.

What is a spreadsheet?

• A document that displays text within defined margins

• A document that stores data in a grid of horizontal rows and vertical columns

• A document that stores audio/video files for use in other documents

• A document that stores images for use in other documents

Vera is an accountant. She decides to use a spreadsheet program to keep track of profit and loss data for her customer. Why did she make this choice?

• Spreadsheets are very useful for processing numeric data.

• Spreadsheets are very useful for manipulating HTML code.

• Spreadsheets are very useful for manipulating images and animations.

• Spreadsheets are very useful for processing text data.

Rows within a spreadsheet are identified by:

• numbers.

• Roman numerals.

• icons.

• letters.

Columns within a spreadsheet are identified by:

• numbers.

• Roman numerals.

• icons.

• letters.

You have created a spreadsheet containing information about each of your classmates. You have included each person's name, home address, phone number and age. One such record for a person would typically be contained in:

• the formula bar.

• a column.

• a row.

• a cell.

Which menu is used to create a new spreadsheet?

• New

• File

• Edit

• View

Tina has selected cells A1 through A25. Which of the following has Tina selected?

• Cell

• Record

• Range

• Row

What is the most efficient way to access multiple worksheets in the same spreadsheet file?

• Create a named custom view and open it for each sheet.

• Click the tab at the bottom of the file that represents the worksheet you want to view.

• Open multiple copies of the spreadsheet file and display a different worksheet in each copy of the file.

• Select New Worksheet to access the worksheet you want to view.

What is the most efficient way to select multiple adjacent cells in your spreadsheet?

• Drag the mouse to select the range you want.

• Press and hold the SHIFT key while clicking the mouse in each cell you want to select.

• Press and hold the ALT key while dragging the mouse to select the range you want.

• Press and hold the CTRL key while clicking the mouse to select the range you want.