Excel(Task2,Functions (1,2)
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Yousra Abdelhamed
Used 3+ times
FREE Resource
Enhance your content in a minute
24 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Someone is trying to find the average profit amount between January and July, using the formula in cell B9.
What mistake did this person make?
Using parentheses in the formula
Using an incorrect formula
The location of the equals sign
Using the incorrect range
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is the formula in cell B3 doing?
Subtracting inventory costs from the total budget
Subtracting the total budget from inventory costs
Finding the average budget total
Multiplying inventory costs by the total budget
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In this example, what information would this formula find:
=MAX(B2:B6)
Average distance
Longest distance
Total distance
Shortest distance
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In this example, what's wrong with the formula in cell B5?
It should use division instead of multiplication.
It should use subtraction instead of addition.
Without parentheses, multiplication is performed too early.
Nothing. This formula is correct.
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Select the formula that will subtract the inventory costs from the monthly budget.
=B3/B2
=B3-B2
=B3*B2
=B2-B3
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which formula will subtract the inventory costs from the annual budget and then divide by 12?
=(B2-B1)/12
=(B1-B2)/12
=B2-B1/12
=B2-(B1/12)
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which formula would find the fastest time for this running log?
=AVERAGE(B2:B6)
=SUM(B2:B6)
=MIN(B2:B6)
=MAX(B2:B6)
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
20 questions
Database&Relation
Quiz
•
12th Grade
20 questions
Data structure test1
Quiz
•
12th Grade
20 questions
Latihan Soal Administrasi Infrastruktur Jaringan XII TKJ
Quiz
•
10th - 12th Grade
27 questions
Adobe Illustrator Quiz Review
Quiz
•
9th - 12th Grade
20 questions
Mobile Apps PayKu
Quiz
•
1st Grade - Professio...
20 questions
Internal Elements of a Computer Quiz
Quiz
•
12th Grade
20 questions
Quiz on Excel
Quiz
•
12th Grade
20 questions
All about scratch blocks _Scratch
Quiz
•
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
