Excel - Formulas and Functions Part 3 (MCQ)
6th Grade
•20 Qs
Similar activities
The Microsoft PowerPoint
6th Grade
•20 Qs
Play with MS Excel - 1
5th - 7th Grade
•15 Qs
KS3 Sensors
6th Grade
•15 Qs
Grade 6 Scratch
6th Grade
•20 Qs
pronous-местоимения
5th - 6th Grade
•15 Qs
YEAR 6 BLENDED
6th Grade
•21 Qs
Ispace Quiz Questions(Scratch and Tynker)
2nd - 6th Grade
•20 Qs
Ap computer science a
1st - 12th Grade
•15 Qs
Excel - Formulas and Functions Part 3 (MCQ)
Quiz
•
Computers
•
6th Grade
•
Practice Problem
•
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
20 questions
Biztonságos internet
Quiz
•
5th - 12th Grade
17 questions
Networks Lesson 2 - Recap and Review
Quiz
•
6th - 8th Grade
20 questions
P6 Review Term 2 2022
Quiz
•
6th Grade
20 questions
Characteristics of Computer Generation-G6
Quiz
•
6th Grade
20 questions
икт 21-40
Quiz
•
1st Grade - University
20 questions
Computer 5
Quiz
•
4th - 6th Grade
20 questions
Basic Operations and Concepts
Quiz
•
6th Grade
16 questions
Tips for Searching the Internet
Quiz
•
6th Grade - University
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade