Excel - Formulas and Functions Part 3 (MCQ)
6th Grade
•20 Qs
Similar activities
Bill Gates
6th - 12th Grade
•19 Qs
Phishing quiz
1st - 12th Grade
•20 Qs
Steve Jobs
6th - 12th Grade
•22 Qs
Arduino Hardware
6th Grade
•16 Qs
Acceptable Use Policy
6th - 9th Grade
•16 Qs
Semester 1- Exploration of Robotics (Units 5-7)
6th - 8th Grade
•17 Qs
Google SketchUp Tool
KG - University
•20 Qs
Basic of Computers
6th - 12th Grade
•20 Qs
Excel - Formulas and Functions Part 3 (MCQ)
Quiz
•
Computers
•
6th Grade
•
Hard
RYAN TAN
Used 34+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
If =left(A1,3) is applied, what is the result?
SEC
OND
123
SECO
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
If =right(B2,2) is applied, what is the result?
_7
0)
ND
56
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
If =mid(B1,3,4) is applied, what is the result?
LE(2
LE(
8_7
3456
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
If =mid(A1,4,2) is applied, what is the result?
ON
ECON
45
2345
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
If =left(B2,1) is applied, what is the result?
:
:9
F
7
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
If =right(A2,3) is applied, what is the result?
456
654
123
SEC
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is =COUNTA function?
counts the number of cells that are not empty.
counts the number of cells that contain a number.
counts the number of cells in a range, that meets a given criteria.
counts the number of cells that are empty.
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
15 questions
KS3 Sensors
Quiz
•
6th Grade
15 questions
KS3 Y8 Kodu Quiz
Quiz
•
5th - 8th Grade
15 questions
3D Printing
Quiz
•
6th - 8th Grade
15 questions
Computer Lab Rules
Quiz
•
KG - 8th Grade
15 questions
Year 7 Artificial Intelligence
Quiz
•
6th - 8th Grade
15 questions
IT General Knowledge Quiz!
Quiz
•
5th - 6th Grade
16 questions
Revision MIT App Inventor after lvl3 clouds
Quiz
•
5th - 12th Grade
19 questions
Edublock input and ouput
Quiz
•
6th Grade
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
4 questions
Activity set 10/24
Lesson
•
6th - 8th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
30 questions
October: Math Fluency: Multiply and Divide
Quiz
•
7th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
14 questions
Email your Teacher
Quiz
•
6th - 8th Grade
40 questions
Programming with Karel
Quiz
•
6th - 8th Grade
20 questions
Binary Numbers Quiz
Quiz
•
6th - 8th Grade
10 questions
Exploring Computer Hardware and Software Components
Interactive video
•
6th - 10th Grade