
Spreadsheet Skills
Quiz
•
Education
•
9th Grade
•
Practice Problem
•
Hard
Jeanette O'Connor
Used 6+ times
FREE Resource
Enhance your content in a minute
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Noah is working on his spreadsheet for a school project. Which function should he use to calculate the average of a range of cells?
SUM
AVERAGE
MEDIAN
COUNT
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Ella is creating a budget spreadsheet. What is the purpose of data validation in her spreadsheet?
To format cells based on conditions
To restrict the type of data that can be entered in a cell
To create charts and graphs
To sort and filter data
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
James is working on a spreadsheet. Which of the following is an example of conditional formatting?
Changing the font size
Applying a colour scale to cells based on their values
Inserting a new row
Merging cells
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Harry is tracking his monthly expenses over the year. What type of chart would be most suitable for showing the trend of his expenses over time?
Pie Chart
Bar Chart
Line Chart
Scatter Plot
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Poppy is working on a spreadsheet and needs to add up the number of cells that contain numbers in a range. Which function should she use?
SUM
COUNT
ADD UP
AVERAGE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Aarav is creating a spreadsheet to track project deadlines. How can he ensure that a cell only accepts dates within a specific range?
Use a formula
Apply conditional formatting
Use data validation
Sort the data
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Harry is organizing a list of his favorite books in a spreadsheet. What does Sorting do in a spreadsheet?
Changes the order of the selected values so they are organised largest to smallest or in alphabetical order
Looks up a value in a horizontal row
Counts the number of cells in a range
Sums the values in a range
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
25 questions
QUIZ 1 l TOPIC 10 [ACCOUNTING FOR LIABILITIES]
Quiz
•
1st Grade - University
25 questions
MAPEH 9_QUIZ 3
Quiz
•
9th Grade
25 questions
Prakarya US 2021
Quiz
•
7th - 9th Grade
25 questions
Fashion Merchandising Unit 1 Review
Quiz
•
9th - 12th Grade
25 questions
buku fiksi nonfiksi
Quiz
•
7th - 9th Grade
30 questions
MAULIDUR RASUL 1442H
Quiz
•
1st Grade - University
25 questions
Kemana Setelah SMP ?
Quiz
•
9th Grade
25 questions
laporan percobaan kls 9
Quiz
•
9th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
