YEAR 12 DATA PROCESSING SECOND TERM UNIFIED TEST

What is a spreadsheet?

• A type of database

• A type of word processor

• A type of electronic table used for storing and analyzing data

• A type of presentation software

Which of the following is a popular spreadsheet package?

• Microsoft Word

• Microsoft Excel

• Microsoft PowerPoint

• Microsoft Access

What is a cell in a spreadsheet?

• A row in a spreadsheet

• A column in a spreadsheet

• A box in a spreadsheet where data can be entered

• A sheet in a spreadsheet

What is a formula in a spreadsheet?

• A mathematical equation used to calculate a value

• A function used to format data

• A chart used to display data

• A table used to organize data

What is a function in a spreadsheet?

• A mathematical equation used to calculate a value

• A pre-built formula used to perform a specific task

• A chart used to display data

• A table used to organize data

What is a chart in a spreadsheet?

• A table used to organize data

• A graph used to display data

• A formula used to calculate a value

• A function used to perform a specific task

What is a pivot table in a spreadsheet?

• A table used to organize data

• A chart used to display data

• A formula used to calculate a value

• A table used to summarize and analyze large datasets

What is a worksheet in a spreadsheet?

• A single page in a spreadsheet

• A collection of pages in a spreadsheet

• A formula used to calculate a value

• A function used to perform a specific task

What is a workbook in a spreadsheet?

• A single page in a spreadsheet

• A collection of pages in a spreadsheet

• A formula used to calculate a value

• A function used to perform a specific task

How do you select an entire column in a spreadsheet?

• By clicking on the column header

• By clicking on the row header

• By clicking on a cell

• By pressing Ctrl+A