
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
19 questions
RBT TING 1 BAB 2
Quiz
•
1st Grade
15 questions
Safety Quiz
Quiz
•
1st Grade
15 questions
Estimulación Cognitiva
Quiz
•
1st - 5th Grade
16 questions
Counting Dimes and Nickels
Quiz
•
KG - 10th Grade
13 questions
Induccion
Quiz
•
1st - 5th Grade
15 questions
Tour de ROAR mid-year review
Quiz
•
1st - 5th Grade
15 questions
RBT Tingkatan 3 Bab 1 : Aplikasi Teknologi
Quiz
•
1st Grade - Professio...
15 questions
TES TIU (sinonim, antonim, analogi)
Quiz
•
1st - 3rd Grade
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
Discover more resources for Life Skills
20 questions
Telling Time to the Hour and Half hour
Quiz
•
1st Grade
10 questions
Life Cycle of a Frog
Quiz
•
1st - 2nd Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
10 questions
100th Day of School 1st/2nd
Quiz
•
1st - 2nd Grade
15 questions
Reading Comprehension
Quiz
•
1st - 5th Grade
10 questions
Identifying Physical and Chemical Changes
Interactive video
•
1st - 5th Grade
10 questions
Exploring the American Revolution
Interactive video
•
1st - 5th Grade
