EXCEL FORMULA ASSESSMENT
40 Qs
Similar activities
UJIAN TEORI MOSES 1-4
8th Grade
•35 Qs
OLIMPIADA DEL SABER - DÍA CULTURAL.
KG
•40 Qs
QUIS SRACTCH
6th - 8th Grade
•40 Qs
Year 9 end of year assessment
10th Grade
•45 Qs
Flowcharts
9th Grade
•35 Qs
LESSON 3 AND 4 (Individual quiz)
12th Grade
•43 Qs
MIDTERM EXAM - Opportunity Seeking
University
•40 Qs
Soal Ekonomi Mikro 2
University
•35 Qs
EXCEL FORMULA ASSESSMENT
Quiz
•
Business, Computers, Education
•
•
Practice Problem
•
Medium
Glaizess Salisi
Used 4+ times
FREE Resource
Enhance your content in a minute
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Calculates the mean of a group of values
SUM
AVERAGE
ROUND
COUNT
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
True or False:
The IF function tests for a true or false condition and then returns one value or another.
True
False
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Calculates a sum from a group of values, but just of values
that are included because a condition is met.
COUNTIF
SUMIF
AVERAGEIF
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Counts the number of cells in a range that match a
criteria
COUNTIF
SUMIF
AVERAGEIF
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Assembles two or more text strings into one
CONCATENATE
REPLACE
PROPER
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would be a correct formula for SUM in excel?
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol must all formula begin with?
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
Computer Network
Quiz
•
12th Grade - University
40 questions
Tin6-Ôn tập HK2-2024-P1-MS Word
Quiz
•
6th Grade
44 questions
Data Organization in Windows 10
Quiz
•
3rd Grade
36 questions
Unit 1 FY Economics Study Area 1
Quiz
•
12th Grade
38 questions
Final revision
Quiz
•
University
35 questions
RPL-Web-02 (Web)
Quiz
•
12th Grade - University
40 questions
Ulang Kaji Prinsip Perakaun T5an
Quiz
•
11th Grade
39 questions
Informatika Kelas X SMT 2
Quiz
•
10th 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