IC3 - Digital Literacy Spreadsheet Applications 2

Question 1

What is a pivot table and what is it used for?

Accepted Answer

A data summarization tool that automatically groups, sorts, counts, and aggregates large datasets

Answer

A table that can be physically rotated on screen

Answer

A table with only two columns

Answer

A method for merging two spreadsheets

Question 2

What does the IF function do in a spreadsheet?

Accepted Answer

It performs a logical test and returns one value if true and another if false

Answer

It formats cells with different colors

Answer

It inserts an image into a cell

Answer

It imports data from another file

Question 3

What is data validation in a spreadsheet?

Accepted Answer

Rules that restrict the type or range of data that can be entered into specific cells

Answer

A process of backing up spreadsheet data

Answer

A method for validating internet connections

Answer

A formula for checking password strength

Question 4

How do you create and use named ranges in a spreadsheet?

Accepted Answer

Named ranges assign a descriptive name to a cell or range of cells for use in formulas and navigation

Answer

Named ranges automatically sort data

Answer

Named ranges are only available in premium versions

Answer

Named ranges delete data in the specified range

Question 5

What is the difference between a relative, absolute, and mixed cell reference?

Accepted Answer

Relative references adjust when copied, absolute references stay fixed, and mixed references lock either the row or column

Answer

There is no functional difference between them

Answer

Relative references are for text, absolute for numbers

Answer

Absolute references are faster to calculate

Question 6

What is the purpose of the CONCATENATE or CONCAT function?

Accepted Answer

It joins two or more text strings together into one combined string

Answer

It calculates the total of a range of cells

Answer

It splits text in a cell into separate cells

Answer

It counts the number of characters in a cell