IC3 - Digital Literacy Certification Digital Literacy Spreadsheet Applications 1 — Questions and Answers
Question 1: Which spreadsheet function calculates the total of all values in a selected range of cells?
- COUNT
- SUM (Correct answer)
- AVERAGE
- MAX
Correct answer: SUM
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?
- The cell reference updates automatically when the formula is copied to another cell
- The cell reference stays fixed and does not change when the formula is copied (Correct answer)
- The formula only works on the first row of the spreadsheet
- The cell displays a dollar amount
Correct answer: The cell reference stays fixed and does not change when the formula is copied
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?
- To sort a column of values in ascending order
- To search for a value in the leftmost column of a table and return a corresponding value from another column (Correct answer)
- To count how many cells in a range contain text
- To merge two separate spreadsheet files into one
Correct answer: To search for a value in the leftmost column of a table and return a corresponding value from another column
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?
- Formula Auditing toolbar
- The status bar at the bottom of the spreadsheet window (Correct answer)
- The Name Box
- Conditional Formatting panel
Correct answer: The status bar at the bottom of the spreadsheet window
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?
- It prevents users from entering data that does not meet set rules
- It automatically changes the appearance of cells based on the values they contain (Correct answer)
- It sorts and filters data according to a chosen condition
- It protects selected cells from being edited
Correct answer: It automatically changes the appearance of cells based on the values they contain
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.
Question 6: When you freeze panes in a spreadsheet, what is the main benefit?
- Selected rows or columns remain visible on screen as you scroll through the rest of the data (Correct answer)
- All cells outside the frozen area are locked so they cannot be edited
- The spreadsheet saves a snapshot of the current view for printing
- Formulas in frozen rows recalculate faster than those in unfrozen rows
Correct answer: Selected rows or columns remain visible on screen as you scroll through the rest of the data
Freezing panes keeps specific rows (such as a header row) or columns (such as a label column) stationary on screen while you scroll through a large dataset, so you always know what each row or column represents.
IC3 - Digital Literacy Certification Digital Literacy Spreadsheet Applications 1
Which spreadsheet function calculates the total of all values in a selected range of cells?