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

COUNT

Answer

AVERAGE

Answer

MAX

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

The cell reference updates automatically when the formula is copied to another cell

Answer

The formula only works on the first row of the spreadsheet

Answer

The cell displays a dollar amount

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

To sort a column of values in ascending order

Answer

To count how many cells in a range contain text

Answer

To merge two separate spreadsheet files into one

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

Formula Auditing toolbar

Answer

The Name Box

Answer

Conditional Formatting panel

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

It prevents users from entering data that does not meet set rules

Answer

It sorts and filters data according to a chosen condition

Answer

It protects selected cells from being edited

Question 6

When you freeze panes in a spreadsheet, what is the main benefit?

Accepted Answer

Selected rows or columns remain visible on screen as you scroll through the rest of the data

Answer

All cells outside the frozen area are locked so they cannot be edited

Answer

The spreadsheet saves a snapshot of the current view for printing

Answer

Formulas in frozen rows recalculate faster than those in unfrozen rows