What function is case sensitive?

Excel II

Quiz
•
Anastasia Frecautan
•
Other
•
Professional Development
•
2 plays
•
Medium
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SEARCH
FIND
LEFT
SUM
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What function to use to get this ->55555 from the initial value -> 55555-End
LEFT
MID
RIGHT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function uses delimiter as a parameter in its syntaxis?
&
CONCATENATE
CONCAT
TEXTJOIN
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In this image, which formula could you use to subtract the inventory costs from the monthly budget?
=B3-B2
=B3/B2
=SUM(B2:B3)
=B2-B3
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula would you use to find the average of the values in cell range A1 to A10?
=AVG(A1:A10)
=AVERAGE(A1:A10)
=TOTAL/A10
=MEAN(A1:A10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to add several numeric values?
COUNTA
TOTAL
SUM
AVERAGE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function can find the highest value in a cell range?
HIGHEST
MAX
MAXVALUE
TOP
8.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function can display a differnece value depending on a condition?
IF
AVERAGE
CONDITION
TEST
9.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the formula =A1&" "&A2 do in Excel?
Adds the value in A2 to the value in A1
Combines the values in cells A1 and A2 into a single cell with a space between them
Multiplies the values in cells A1 and A2
Subtracts the value in A2 from the value in A1
10.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"
IF(B4>200,"High","Low")
=IF(B4>200,"High","Low")
=IF(B4<200,"High","Low")
=IF(B4>200"High","")
Explore all questions with a free account
Similar Resources on Quizizz
15 questions
Engaging Students Quiz

Quiz
•
Professional Development
15 questions
Culture Week Quiz

Quiz
•
Professional Development
11 questions
Excel Imil Quiz

Quiz
•
Professional Development
15 questions
Financeiro Quiz!

Quiz
•
Professional Development
12 questions
Recapitulation Test

Quiz
•
Professional Development
18 questions
Health Unit 1 Test

Quiz
•
5th Grade - Professio...
15 questions
Fun Quiz - WS

Quiz
•
Professional Development
9 questions
Python Functions

Quiz
•
Professional Development
Popular Resources on Quizizz
17 questions
CAASPP Math Practice 3rd

Quiz
•
3rd Grade
15 questions
Grade 3 Simulation Assessment 1

Quiz
•
3rd Grade
20 questions
math review

Quiz
•
4th Grade
19 questions
HCS Grade 5 Simulation Assessment_1 2425sy

Quiz
•
5th Grade
16 questions
Grade 3 Simulation Assessment 2

Quiz
•
3rd Grade
21 questions
6th Grade Math CAASPP Practice

Quiz
•
6th Grade
13 questions
Cinco de mayo

Interactive video
•
6th - 8th Grade
20 questions
Reading Comprehension

Quiz
•
5th Grade
Discover more resources for Other
10 questions
How to Email your Teacher

Quiz
•
Professional Development
11 questions
All about me

Quiz
•
Professional Development
14 questions
2019 Logos

Quiz
•
Professional Development
20 questions
90s Cartoons

Quiz
•
Professional Development
26 questions
Guess the fast food place/Food

Quiz
•
KG - Professional Dev...
50 questions
50 States and Capitals

Quiz
•
5th Grade - Professio...
20 questions
Sports trivia

Quiz
•
Professional Development
12 questions
Verbals

Lesson
•
KG - Professional Dev...