Practice Test GeeksIC3 - Digital Literacy Certification Practice Test
← All IC3 Flashcard Decks

Digital Literacy Spreadsheet Applications 1 Flashcards

6 cards from real IC3 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Digital Literacy Spreadsheet Applications 1 flashcards as text

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

    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.

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

    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.

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

    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.

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

    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.

  5. What does conditional formatting do in a spreadsheet?

    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.

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

    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.