Spreadsheets – Formulas, functions, graphs
Ict
high_school
10 questions
~20 mins
0 views0 downloads
About This Worksheet
A comprehensive ICT worksheet on Spreadsheets – Formulas, functions, graphs for high school students. Includes a variety of question types including multiple choice, short answer, and true/false questions.
Topics covered:
Worksheet Preview
Full preview • 10 questions
Spreadsheets – Formulas, functions, graphs
Subject: IctGrade: high_school
Name:
Date:
TeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizzTeachWhizz
Spreadsheets – Formulas, functions, graphs
ICT
Instructions: Read each question carefully and provide your answers in the spaces provided. Use the knowledge you have gained about spreadsheets to complete the questions. Good luck!
A
Multiple Choice Questions
Select the correct answer for each question.
1.
What is the purpose of a formula in a spreadsheet?
AA) To format text
BB) To perform calculations
CC) To sort data
DD) To create graphs
2.
Which function would you use to find the average of a range of cells?
AA) SUM()
BB) AVERAGE()
CC) COUNT()
DD) MAX()
3.
What symbol is used to start a formula in a spreadsheet?
AA) @
BB) #
CC) $
DD) =
4.
Which of the following functions counts the number of cells that contain numeric values?
AA) COUNTA()
BB) COUNT()
CC) SUM()
DD) AVERAGE()
5.
What type of chart would best represent the percentage distribution of different categories?
AA) Line Chart
BB) Bar Chart
CC) Pie Chart
DD) Scatter Plot
6.
If you want to lock a cell reference in a formula, which symbol do you use?
AA) &
BB) *
CC) $
DD) %
7.
Which function would you use to find the highest value in a range?
AA) MIN()
BB) MAX()
CC) AVERAGE()
DD) SUM()
8.
What is the purpose of the VLOOKUP function?
AA) To calculate averages
BB) To search for a value in a table
CC) To create pivot tables
DD) To sort data
9.
Which of the following is NOT a valid data type in spreadsheets?
AA) Text
BB) Number
CC) Boolean
DD) Color
10.
How can you quickly create a chart from your data?
AA) Use the SUM function
BB) Highlight the data and click on the chart icon
CC) Manually draw the chart
DD) Copy and paste the data into a drawing program
B
True/False Questions
Circle True or False for each statement.
1.
You can create multiple worksheets within a single spreadsheet file.
2.
The CONCATENATE function can be used to combine text from multiple cells.
3.
All functions in spreadsheets require at least one argument to work.
C
Short Answer Questions
Answer each question in the space provided.
1.
Explain what a cell reference is in a spreadsheet.
2.
What is the difference between absolute and relative cell references?
3.
Describe the process of creating a bar chart from a data set.
4.
How can you sort data in a spreadsheet?
5.
What is a pivot table, and what is its purpose?
Unlock Full Worksheet & Answers
Get instant access to the complete worksheet, answer keys, and 1,899 others
Unlimited answer keys for all worksheets
Download clean, formatted PDFs
Customize and remix any worksheet
Cancel anytime • No commitment • Start today
Quick Actions
What is Remix?
Create a new worksheet based on this one. Change the grade level, topic, number of questions, or difficulty - then generate a fresh version.
- • Change grade level (Grade 6 → Grade 7)
- • Swap topics (Harry Potter → Macbeth)
- • Add more questions (10 → 15)
- • Adjust difficulty
Details
- Created
- 4/14/2025
- Updated
- 12/29/2025
- Type
- worksheet