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 pivot table can automatically summarize, group, sort, count, and calculate totals and averages from large datasets.

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

The IF function evaluates a logical condition and returns one value when true and a different value when false.

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

Data validation sets rules on cells that restrict what data can be entered, such as numbers within a range, dates, or items from a dropdown list.

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 assign a meaningful name to cells, making formulas more readable and easier to maintain.

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

Relative references (A1) adjust when copied, absolute references ($A$1) remain fixed, and mixed references ($A1 or A$1) lock only the column or row.

IC3 - Digital Literacy Certification Practice Test