
Spreadsheet Functions and Formatting Quiz y9
Quiz
•
Computers
•
7th Grade
•
Practice Problem
•
Medium
Conor Frater
Used 12+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of a spreadsheet?
Play music
create an interesting presentation
Write a letter
Organize, analyze, and store data in a tabular format
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format cells to display currency in a spreadsheet?
Choose the 'Currency' format from the 'Number' menu in the 'Format' options.
Apply the 'Italic' format from the 'Alignment' options
Select the 'Date' format from the 'Format' menu
Use the 'Bold' option in the 'Font' menu
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to calculate the average of a range of cells in a spreadsheet?
=MEDIAN(range)
=MAX(range)-MIN(range)
=SUM(range)/COUNT(range)
=AVERAGE(range)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of data analysis in spreadsheets?
To make decisions based on random guesses
To create chaos and confusion
To organize, interpret, and visualize data to make informed decisions.
To waste time and effort without any purpose
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you create a pie chart in a spreadsheet?
Using the 'Format' menu to create a pie chart
Selecting the data and using the 'Insert' or 'Chart' menu to choose 'Pie Chart'
Typing 'Pie Chart' in the search bar
Right-clicking on the data and selecting 'Pie Chart'
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of the SUM function in spreadsheets?
To add up a range of numbers
To subtract a range of numbers
To multiply a range of numbers
To find the average of a range of numbers
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you apply conditional formatting to a range of cells in a spreadsheet?
Select the range, go to 'Format' menu, choose 'Conditional formatting'
Use the shortcut Ctrl + C to apply conditional formatting to the range
Type 'Conditional formatting' in the search bar and click on the first result
Right-click on the range and choose 'Conditional formatting'
Create a free account and access millions of resources
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
10 questions
Kuis Analisis Data Kelas 7
Quiz
•
7th Grade
10 questions
Working with tables
Quiz
•
5th - 12th Grade
10 questions
Blue Cross Websites
Quiz
•
7th Grade
15 questions
7ICT - Algorithms Revision Quiz
Quiz
•
7th Grade
15 questions
Quiz informatyczny
Quiz
•
1st - 8th Grade
11 questions
What is a computer
Quiz
•
KG - University
15 questions
S2 Business Letters Assessment
Quiz
•
7th Grade
10 questions
7 ICT Sem 2 Reviewer
Quiz
•
7th Grade
Popular Resources on Wayground
10 questions
Forest Self-Management
Lesson
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
30 questions
Thanksgiving Trivia
Quiz
•
9th - 12th Grade
30 questions
Thanksgiving Trivia
Quiz
•
6th Grade
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
48 questions
The Eagle Way
Quiz
•
6th Grade
10 questions
Identifying equations
Quiz
•
KG - University
10 questions
Thanksgiving
Lesson
•
5th - 7th Grade
Discover more resources for Computers
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University
10 questions
Thanksgiving
Lesson
•
5th - 7th Grade
18 questions
Thanksgiving Trivia
Quiz
•
4th - 12th Grade
20 questions
Thanksgiving Trivia!
Quiz
•
6th - 8th Grade
20 questions
Thanksgiving
Quiz
•
KG - 12th Grade
12 questions
Thanksgiving Trivia
Quiz
•
3rd - 8th Grade
2 questions
6W3 Week 4 Day 2
Quiz
•
7th Grade
