- Digital Literacy Spreadsheet Applications 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 flashcards as text
What is a pivot table and what is it used for?
Answer: A data summarization tool that automatically groups, sorts, counts, and aggregates large datasets
A pivot table can automatically summarize, group, sort, count, and calculate totals and averages from large datasets.
What does the IF function do in a spreadsheet?
Answer: It performs a logical test and returns one value if true and another if false
The IF function evaluates a logical condition and returns one value when true and a different value when false.
What is data validation in a spreadsheet?
Answer: Rules that restrict the type or range of data that can be entered into specific cells
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.
How do you create and use named ranges in a spreadsheet?
Answer: Named ranges assign a descriptive name to a cell or range of cells for use in formulas and navigation
Named ranges assign a meaningful name to cells, making formulas more readable and easier to maintain.
What is the difference between a relative, absolute, and mixed cell reference?
Answer: Relative references adjust when copied, absolute references stay fixed, and mixed references lock either the row or column
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.
What is the purpose of the CONCATENATE or CONCAT function?
Answer: It joins two or more text strings together into one combined string
CONCAT joins multiple text strings into a single string, useful for combining names or building descriptions from separate data fields.