Basic Spreadsheets Quiz
Quiz
•
Computers
•
University
•
Practice Problem
•
Medium
Mr Aluko
Used 3+ times
FREE Resource
Enhance your content in a minute
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format a cell to display currency in a spreadsheet?
Choose the 'Date' format from the formatting options.
Select the 'Bold' format from the formatting options.
Pick the 'Italic' format from the formatting options.
Choose the 'Currency' format from the formatting options.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the shortcut key to save a spreadsheet?
Ctrl + A
Ctrl + S
Shift + S
Alt + S
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you merge cells in a spreadsheet?
Select the cells and use the 'Merge Cells' option in the formatting or layout menu.
Right-click on the cells and select 'Merge'
Press the 'M' key while the cells are selected
Use the 'Merge' function in the formula bar
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of the AVERAGE formula in a spreadsheet?
Multiplies a range of numbers
Calculates the average of a range of numbers
Counts the number of cells in a range
Finds the maximum value in a range of numbers
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of the COUNT formula in a spreadsheet?
Calculates the sum of a range of numbers
Calculates the average of a range of numbers
Counts the number of cells in a range
Finds the minimum value in a range of numbers
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the shortcut key to undo the last action in a spreadsheet?
Ctrl + Z
Ctrl + U
Shift + Z
Alt + Z
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format a cell to display percentage in a spreadsheet?
Choose the 'Percentage' format from the formatting options.
Select the 'Bold' format from the formatting options.
Pick the 'Italic' format from the formatting options.
Choose the 'Currency' format from the formatting options.
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
14 questions
IOTA : Web Development Bootcamp Quiz 2
Quiz
•
University
10 questions
BOOLEAN CLUB QUIZ 1
Quiz
•
University
10 questions
Concept of Computer Network
Quiz
•
University
11 questions
What is a computer
Quiz
•
KG - University
10 questions
Server Administration- Quiz 1
Quiz
•
12th Grade - University
11 questions
Computer Science (1-9) - Identifying & Preventing Threats
Quiz
•
University
14 questions
Semi-Long Quiz#1 - SAM, NW3A-3E
Quiz
•
University
12 questions
CIS1103 Week 9_10 CLO3 Part 1
Quiz
•
University
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
4 questions
Conflict Resolution
Lesson
•
KG
20 questions
Place Value
Quiz
•
KG - 3rd Grade
20 questions
CVC Words
Quiz
•
KG - 1st Grade
24 questions
CKLA Unit 5 assessment K
Quiz
•
KG
10 questions
STAAR Review - Editing & Revising Clusters
Quiz
•
KG
10 questions
Reflexive Pronouns
Quiz
•
KG - 5th Grade
10 questions
Long i- igh, ie, and y Quiz
Quiz
•
KG - 3rd Grade
12 questions
Quarter Past, Half Past, and Quarter To
Quiz
•
KG - 12th Grade
