IC3 - Digital Literacy Certification Digital Literacy Spreadsheet Applications 1

Question 1

Which spreadsheet function calculates the total of all values in a selected range of cells?

Accepted Answer

SUM

Answer

The SUM function adds together all numeric values within a specified range, making it the correct choice for calculating a total. COUNT counts the number of cells, AVERAGE computes the mean, and MAX returns the highest value.

Question 2

What happens when you use an absolute cell reference (e.g., $A$1) instead of a relative reference in a formula?

Accepted Answer

The cell reference stays fixed and does not change when the formula is copied

Answer

An absolute cell reference locks the row and column with dollar signs ($), so the reference points to the same cell regardless of where the formula is copied. A relative reference, by contrast, shifts automatically based on the formula's new position.

Question 3

What is the purpose of the VLOOKUP function in a spreadsheet?

Accepted Answer

To search for a value in the leftmost column of a table and return a corresponding value from another column

Answer

VLOOKUP (Vertical Lookup) searches down the first column of a defined table range for a match, then returns a value from a column you specify to the right. It is commonly used to pull related data from large reference tables.

Question 4

Which feature allows you to instantly see summary statistics (such as sum and average) for selected cells without writing a formula?

Accepted Answer

The status bar at the bottom of the spreadsheet window

Answer

Most spreadsheet applications display quick statistics like Sum, Average, Count, Min, and Max in the status bar at the bottom of the screen whenever one or more cells containing numbers are selected — no formula required.

Question 5

What does conditional formatting do in a spreadsheet?

Accepted Answer

It automatically changes the appearance of cells based on the values they contain

Answer

Conditional formatting applies visual styling — such as background color, font color, or icons — to cells whose values meet criteria you define, making patterns and outliers easy to spot at a glance. Data validation (not conditional formatting) restricts what can be entered.

IC3 - Digital Literacy Certification Practice Test

IC3 - Digital Literacy Certification Practice Test

IC3 - Digital Literacy Certification Digital Literacy Spreadsheet Applications 1