
050623
Quiz
•
Life Skills
•
1st Grade
•
Practice Problem
•
Hard
phanh ler
Used 1+ times
FREE Resource
Enhance your content in a minute
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Which is the correct way to write this function:
IF F1 is greater than or equal to 60, show "Senior", otherwise, show "X"
=IF(F1>=60,"Senior",X)
=IF(F1>=60,"Senior","X")
=IF(F1=>60,"X","Senior")
=IF(F1>60,"Senior","X")
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Which function to use to convert the first character of each word to an uppercase character in a cell that contains a string type data type (Text)
Trim
Lower
Upper
Proper
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
This description refers to which function: “Returns TRUE if all of the arguments evaluate to TRUE.”
OR
AND
XOR
NOT
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Which function is used to trap and handle errors?
IFERROR()
ERROR()
IFNA()
IFTRAP()
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
At a cell address, we perform a calculation function but with the wrong function name, the error message will appear
#N/A
#VALUE!
#NAME?
FALSE
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following scenarios would NOT be suitable for using the IFS function in Excel?
Assigning letter grades (A, B, C, etc.) based on a student's numeric score
Calculating the shipping cost based on the weight and destination of a package.
Determining the commission percentage based on the sales amount achieved by a salesperson.
Sorting a list of values in ascending order.
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which formula, when entered into cell C2, would correctly apply the XOR function to check if either cell A2 or cell B2 (or both) contains a non-zero value?
=XOR(A2<>0, B2<>0)
=XOR(A2=0, B2=0)
=XOR(A2>0, B2>0)
=XOR(A2=0, B2<>0)
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
11 questions
EDU ENFE. planificación familiar.
Quiz
•
1st - 2nd Grade
15 questions
Ingredientes básicos de la repostería
Quiz
•
1st Grade
15 questions
Corona virus
Quiz
•
1st - 2nd Grade
10 questions
GAME ÔN TẬP GDHN TIẾT 11_KHỐI 09
Quiz
•
KG - University
13 questions
Supa Strikas Piłkarskie zagrywki
Quiz
•
1st Grade
14 questions
NFL DRAFT 2020
Quiz
•
KG - Professional Dev...
10 questions
Name the car
Quiz
•
1st - 3rd Grade
10 questions
GAME B3-Cộng Nghiệp Biệt Nghiệp_TYHN3G-K4
Quiz
•
1st Grade - 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 Life Skills
20 questions
Telling Time to the Hour and Half hour
Quiz
•
1st Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
13 questions
Fractions
Quiz
•
1st - 2nd Grade
20 questions
CVC Words
Quiz
•
KG - 1st Grade
15 questions
Place Value tens and ones
Quiz
•
1st Grade
16 questions
Money - Coins
Lesson
•
1st - 2nd Grade
20 questions
Halves and Fourths
Quiz
•
1st Grade
