Excel - Formulas and Functions Part 3 (MCQ)
6th Grade
•20 Qs
Similar activities
DPS Jorhat - Robotics Skill Assessment
6th - 8th Grade
•20 Qs
Q7/Q8 Email Vocabulary (Basics in 21t4s)
5th - 9th Grade
•17 Qs
KIỂM TRA 15P TIN 7 (18-23/10-2022)
6th - 9th Grade
•20 Qs
NXT Parts
6th - 7th Grade
•20 Qs
Computer objective test(Fundamentals)
5th - 7th Grade
•21 Qs
Linux-2 Quiz 2 -- LAMP
1st - 12th Grade
•15 Qs
Name The Disney Animation Films
KG - University
•20 Qs
Empowerment Technologies
KG - 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
Already have an account?
Similar Resources on Wayground
20 questions
7.5 MCQ Assessment
Quiz
•
6th Grade
20 questions
SDA Chapter 1A VOCABULARY
Quiz
•
6th - 8th Grade
20 questions
Microsoft PPT. - Scavenger Hunt
Quiz
•
6th - 12th Grade
18 questions
NGHS GCSE PROGRAMMING LANGUAGES
Quiz
•
6th Grade
17 questions
Presentation Purpose
Quiz
•
6th - 8th Grade
20 questions
New Scratch
Quiz
•
6th - 8th Grade
15 questions
History of Computers
Quiz
•
6th - 12th Grade
16 questions
Python Basics
Quiz
•
KG - University
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade