NEW
Font size
WorksheetsSpreadsheet Basics Quiz
Total questions: 10
Worksheet time: 5mins
Which of the following best describes a "Row" in a spreadsheet?
A horizontal group of cells in a spreadsheet.
A vertical group of cells in a spreadsheet.
A single cell in a spreadsheet.
A type of formula in a spreadsheet.
What is the main difference between a "Worksheet" and a "Workbook" in spreadsheet software?
A worksheet is a single page, while a workbook is a collection of worksheets.
A worksheet is used for text only, while a workbook is for numbers.
A worksheet is a type of formula, while a workbook is a formatting tool.
A worksheet is for presentation, while a workbook is for calculations.
Which function would you use to find the highest value in a range of spreadsheet cells?
MAX
SUM
AVERAGE
MIN
If you want to combine two or more cells into one larger cell in a spreadsheet, which formatting option should you use?
Merge Cells
Borders
SUM
IF
A teacher wants to calculate the average score of students in a test using a spreadsheet. Which function should they use, and what steps should they follow to apply it to a range of cells?
Use the AVERAGE function; select the range of cells with the scores and apply the AVERAGE formula.
Use the SUM function; select the range of cells and divide by the number of students.
Use the MAX function; select the highest score only.
Use the IF function; set a condition for passing scores.
Which of the following is a type of chart commonly used to display data in the form of slices representing parts of a whole?
Pie Chart
Line Graph
Axis
Filter
What is the main purpose of using a filter in data tools?
To display only specific data that meets certain criteria
To create a bar chart
To add a legend to a graph
To validate data entries
Which element of a graph is used to explain the meaning of different colors or symbols used in the chart?
Legend
Axis
Data Validation
Sort
Imagine you have a large dataset and you want to organize it alphabetically. Which data tool would you use?
Sort
Pie Chart
Conditional Formatting
Axis
A teacher wants to highlight all values above 90 in a test score spreadsheet. Which feature should they use to automatically change the cell color for these values?
Conditional Formatting
Data Validation
Filter
Line Graph
