IC3 - Digital Literacy Spreadsheet Applications 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?

Accepted Answer

=SUM(B2:B25)

Answer

=TOTAL(B2-B25)

Answer

=ADD(B2:B25)

Answer

SUM(B2..B25)

Question 2

In a spreadsheet application, what does the dollar sign ($) indicate when used in a cell reference like `$A$1`?

Accepted Answer

The cell reference is absolute and will not change when copied.

Answer

The cell contains currency data.

Answer

The formula in the cell has an error.

Answer

The cell is locked and cannot be edited.

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?

Accepted Answer

Freeze Panes

Answer

Conditional Formatting

Answer

Sort Data

Answer

Filter Data

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?

Accepted Answer

=MAX(C2:C30)

Answer

=AVERAGE(C2:C30)

Answer

=COUNT(C2:C30)

Answer

=SUM(C2:C30)

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?

Accepted Answer

Pie Chart

Answer

Line Chart

Answer

Bar Chart

Answer

Scatter Plot

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?

Accepted Answer

Filtering

Answer

Sorting

Answer

Find and Replace

Answer

Charting