WorksheetsSpreadsheet Fundamentals Assessment
Total questions: 15
Worksheet time: 8mins
What is a cell in a spreadsheet?
A row in a spreadsheet
A column in a spreadsheet
The intersection of a row and column
The formula bar at the top of a spreadsheet
In a spreadsheet, what does the SUM formula do?
Finds the average of a range of cells
Adds up all values in a specified range
Counts the number of cells in a range
Displays the minimum value in a range
Which of the following correctly represents the structure of an IF statement in a spreadsheet?
IF(logical_test, value_if_true)
IF(logical_test, value_if_false, value_if_true)
IF(logical_test, value_if_true, value_if_false)
IF(value_if_true, logical_test, value_if_false)
Which chart type would be most appropriate to show the percentage breakdown of a budget?
Line graph
Bar chart
Pie chart
Scatter plot
If cell A1 contains the value 10, cell A2 contains 15, and cell A3 contains 20, what would the formula =MAX(A1:A3) return?
10
15
20
45
What does the COUNT formula do in a spreadsheet?
Counts the number of cells that contain numbers in a range
Counts the total number of cells in a range
Counts only cells containing text in a range
Counts the number of formulas in a range
Which chart type is most effective for showing trends over time?
Pie chart
Line graph
Bar chart
Radar chart
In spreadsheet terminology, what is a "range"?
The difference between the maximum and minimum values
A group of adjacent cells selected together
The maximum possible value a cell can contain
A type of chart showing data distribution
If cell B1 contains the value 5 and cell B2 contains the value 10, what would the formula =IF(B1>B2, "Greater", "Less") return?
"Greater"
"Less"
TRUE
FALSE
Which formula would find the lowest value in the range C1:C10?
=LOWEST(C1:C10)
=MIN(C1:C10)
=SMALLEST(C1:C10)
=MINIMUM(C1:C10)
How are columns typically labeled in a spreadsheet?
With numbers (1, 2, 3...)
With letters (A, B, C...)
With Roman numerals (I, II, III...)
With custom names created by the user
Which of the following is NOT a common type of chart available in spreadsheet applications?
Bubble chart
Histogram
Holographic chart
Scatter plot
What happens when you drag the fill handle (small square in the bottom-right corner of a selected cell) down a column?
It copies the exact content of the selected cell
It creates a new chart based on the selected data
It can extend a pattern or formula to adjacent cells
It deletes the contents of the cells below
In a bar chart, what does the height or length of each bar typically represent?
The category name
The time period
The value or quantity
The percentage of the total
When using the IF function, what is the purpose of the third argument?
It specifies what action to take if the condition is neither true nor false
It specifies what value to return if the condition is false
It specifies an alternative condition to test
It specifies what formula to use for calculation
