IC3 - Digital Literacy Spreadsheet Applications Questions and Answers — Questions and Answers
Question 1: A user wants to calculate the total sales from cells B2 through B25 in a spreadsheet. Which formula should they enter into the cell where they want the total to appear?
- =TOTAL(B2-B25)
- =ADD(B2:B25)
- SUM(B2..B25)
- =SUM(B2:B25) (Correct answer)
Correct answer: =SUM(B2:B25)
The SUM function is the standard spreadsheet function used to add all the numbers in a range of cells. The range is specified with a colon (:) between the starting and ending cells, and all formulas must begin with an equals sign (=).
Question 2: In a spreadsheet application, what does the dollar sign ($) indicate when used in a cell reference like `$A$1`?
- The cell contains currency data.
- The cell reference is absolute and will not change when copied. (Correct answer)
- The formula in the cell has an error.
- The cell is locked and cannot be edited.
Correct answer: The cell reference is absolute and will not change when copied.
The dollar sign ($) creates an absolute reference. When a formula containing an absolute reference like `$A$1` is copied and pasted to other cells, the reference to cell A1 will not change. A relative reference (like A1) would change based on the new location.
Question 3: You have a large spreadsheet with column headers in the first row. When you scroll down, these headers disappear, making it difficult to identify the data in each column. Which feature should you use to keep the headers visible while scrolling?
- Conditional Formatting
- Freeze Panes (Correct answer)
- Sort Data
- Filter Data
Correct answer: Freeze Panes
The Freeze Panes feature is specifically designed to lock specific rows or columns in place, so they remain visible on the screen as you scroll through the rest of the worksheet. This is ideal for keeping headers in view.
Question 4: A teacher is using a spreadsheet to manage student grades. To find the highest score in a list of grades located in cells C2 through C30, which function would be the most appropriate to use?
- =AVERAGE(C2:C30)
- =COUNT(C2:C30)
- =MAX(C2:C30) (Correct answer)
- =SUM(C2:C30)
Correct answer: =MAX(C2:C30)
The MAX function is used to find the maximum or highest value in a given range of cells. AVERAGE calculates the mean, COUNT counts the number of cells with numbers, and SUM adds the values.
Question 5: Which type of chart is best suited for showing the proportion of individual parts to a whole, such as the percentage breakdown of a monthly budget?
- Line Chart
- Pie Chart (Correct answer)
- Bar Chart
- Scatter Plot
Correct answer: Pie Chart
A Pie Chart is the ideal visualization for representing data as percentages or proportions of a whole. Each 'slice' of the pie represents a category's contribution to the total.
Question 6: A sales manager has a spreadsheet containing data for all sales transactions for the year. They want to view only the sales made by a specific employee, 'Jane Doe'. Which feature should they use to temporarily hide all rows except those for Jane Doe?
- Sorting
- Find and Replace
- Filtering (Correct answer)
- Charting
Correct answer: Filtering
Filtering allows a user to display only the rows that meet certain criteria while temporarily hiding all other rows. Sorting would rearrange the data but would still show all employees. Find and Replace is for changing data, and Charting is for visualizing it.
IC3 - Digital Literacy Spreadsheet Applications Questions and Answers
A user wants to calculate the total sales from cells B2 through B25 in a spreadsheet.
Which formula should they enter into the cell where they want the total to appear?