Excel Functions Quiz
Authored by Retno Sri Hartati
Business
12th Grade
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
41 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to determine a decision based on certain conditions?
Arithmetic Function
VLOOKUP Function
IF Logic Function
SUM Function
Mathematical Function
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to calculate the total value of a range?
Count
Sum
Average
Max
Round
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to calculate the average value of a range?
Count
Sum
Average
Max
Round
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula is used to read a range of data table?
=VLOOKUP(KEY CELL;TABLE RANGE;COLUMN INDEX;)
=VLOOKUP(KEY CELL;TABLE RANGE;ROW INDEX;)
=VLOOKUP(KEY CELL;COLUMN INDEX;TABLE RANGE)
=VLOOKUP(KEY CELL;ROW INDEX;TABLE RANGE)
=HLOOKUP(KEY CELL;TABLE RANGE;ROW INDEX; false)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the function that retrieves text data from the right?
=LEFT(Text,Number of Characters)
=RIGHT(Text,Number of Characters)
=MID(Text,First Character Position,Number of Characters)
=RIGHT(Text,First Character Position,Number of Characters)
=MID(Text,Number of Characters)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to get a value from a table vertically?
VLOOKUP
HLOOKUP
MID
RIGHT
LEFT
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the name of the cell address that changes when copied or moved?
Relative
Absolute
Positive
Negative
Flat
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
40 questions
ESB- Domain 1: Entrepreneurial and Small Business Concepts
Quiz
•
9th - 12th Grade
40 questions
Business Essentials 2.01 - 2.02 Review
Quiz
•
9th - 12th Grade
37 questions
Saving (B10)
Quiz
•
9th - 12th Grade
36 questions
TestOut Chapter 1 (minus section 1.4)
Quiz
•
9th - 12th Grade
40 questions
Produktif Manajemen Perkantoran
Quiz
•
12th Grade
36 questions
Trade theories International Business Grade 12
Quiz
•
12th Grade
44 questions
Business Finance Terms
Quiz
•
12th Grade
38 questions
FBLA Economics
Quiz
•
9th - 12th 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