
Sec 4 CPA - Spreadsheet Revision
Quiz
•
Computers
•
10th Grade
•
Hard
ChangJin Chen
Used 4+ times
FREE Resource
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
A spreadsheet is made up of
titles
table
rows and columns
templates
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
You always start a spreadsheet formula with?
=
+
-
*
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The count formula counts
the number of cells in the range as long as it contains text
the number of cells in the range
the number of cells outside the range
the number of cells in the range as long as it contains numbers
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
what does the formula COUNTA do?
Count the number of cells in a range that is empty
Count the number of cells in a range that is not empty
Count the number of cells in a range that contains numbers
Count the number of cells in a range that contains alphabets
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which formula can help you find the largest value from a range of data?
Average
Highest
Maximum
Minimum
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Which formula do you use to key in the date for today?
=day()
=time()
=today
=today()
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
#### is seen in spreadsheet sometimes because
the formula is wrong
the cell has an error
the cell contains a longer message than the cell width
the formula is ####
8.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The function RANDBETWEEN has a range of
0 to 1
0 to 10
0 to 1000
0 to any number range
Similar Resources on Wayground
10 questions
Data in a Table
Quiz
•
5th - 12th Grade
10 questions
WJEC GCSE ICT Unit 1 - Data
Quiz
•
10th Grade
10 questions
SUMIFs and COUNTIFs Functions Quiz
Quiz
•
9th Grade - University
12 questions
Spreadsheets Quiz
Quiz
•
9th - 12th Grade
8 questions
Advanced Excel
Quiz
•
10th - 11th Grade
10 questions
Formatting in Excel
Quiz
•
10th Grade
12 questions
Microsoft Excel Features
Quiz
•
9th - 12th Grade
11 questions
Soal ulangan kelas X
Quiz
•
10th Grade - University
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines
Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22
Lesson
•
9th - 12th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
20 questions
US Constitution Quiz
Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
20 questions
Analog vs Digital
Quiz
•
9th - 12th Grade
10 questions
Exploring Cybersecurity Techniques and Threats
Interactive video
•
6th - 10th Grade
10 questions
Understanding the Internet and Data Transmission
Interactive video
•
7th - 12th Grade
