MS Excel Functions and Formulas
Authored by rps.informatika rps.informatika
Computers
2nd Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
21 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
45 sec • 2 pts
According to the figure left write the necessary
formulas to calculate the average salary of all employees in the cell C10
2.
FILL IN THE BLANK QUESTION
45 sec • 2 pts
According to the figure left write the necessary
formulas to find the maximum salary in cell C11
3.
FILL IN THE BLANK QUESTION
45 sec • 2 pts
According to the figure left write the necessary
formulas to find minimum salary in cell C12
4.
FILL IN THE BLANK QUESTION
45 sec • 2 pts
According to the figure left write the necessary
formulas to find the total salary in cell c13
5.
FILL IN THE BLANK QUESTION
1 min • 3 pts
Write a function in B14, so that, it will take the Sum of the Amounts (B2:B11), if the date in column B is less than the Due Date (B13).
6.
FILL IN THE BLANK QUESTION
30 sec • 2 pts
In the left Figure, write a formula in A3 to calculate the multiplication of the numbers in range A1:F1
7.
FILL IN THE BLANK QUESTION
30 sec • 2 pts
In the left Figure, write a formula in B6 to calculate the absolute value of the given number in A6.
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
18 questions
G3-W12-REVIEW Final 1
Quiz
•
2nd - 5th Grade
25 questions
Name the DC Superheroes
Quiz
•
KG - University
20 questions
Computer Revision Test 2 - Grade 2
Quiz
•
2nd Grade
20 questions
Name The Disney Animation Films
Quiz
•
KG - University
20 questions
Tux Paint-Quiz-3
Quiz
•
2nd Grade
21 questions
ÔN TẬP KIỂU XÂU
Quiz
•
1st - 12th Grade
19 questions
G5 | Week 2 | Format and Text style
Quiz
•
2nd - 5th Grade
17 questions
Microsoft Office Quiz
Quiz
•
KG - 9th 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
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
Telling Time to the Nearest 5 Minutes
Quiz
•
2nd Grade
22 questions
Equal Groups and Arrays
Quiz
•
2nd Grade
30 questions
Multiplication Facts 1-12
Quiz
•
2nd - 5th Grade
17 questions
2nd Grade Graphs (Bar & Picture)
Quiz
•
2nd Grade
20 questions
Multiplication Facts
Quiz
•
2nd - 3rd Grade
10 questions
3 Digit Addition and Subtraction with Regrouping
Quiz
•
2nd - 4th Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Counting Coins
Quiz
•
2nd Grade