Excel(Task2,Functions (1,2)

Quiz
•
Computers
•
12th Grade
•
Hard
Yousra Abdelhamed
Used 3+ times
FREE Resource
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)
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Google Sheets: Functions and Behavior Check-Up

Quiz
•
12th Grade - University
20 questions
Aplikasi Pengolah Angka

Quiz
•
12th Grade - University
19 questions
Excel 2P-2RVW-Formulas and Functions in Excel

Quiz
•
10th - 12th Grade
20 questions
BAI 11 THAO TAC VOI CSDL QUAN HE

Quiz
•
12th Grade
20 questions
Fungsi IF, AND dan OR

Quiz
•
10th - 12th Grade
20 questions
Dasar Komputer

Quiz
•
10th Grade - University
20 questions
Ôn tập kiểm tra 1 tiết _HK2

Quiz
•
12th Grade
20 questions
Spreadsheet Formulas and Functions

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade