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?
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)
22 questions
TIN HỌC 7
Quiz
•
9th Grade - University
20 questions
Google Sheets: Functions and Behavior Check-Up
Quiz
•
12th Grade - University
20 questions
Examen Excel Básico
Quiz
•
12th Grade
23 questions
ÔN TẬP GIỮA KÌ 2 TIN 9 24-25
Quiz
•
9th Grade - University
20 questions
Bài 5. Thao tác với bảng tính
Quiz
•
1st - 12th Grade
20 questions
SPREADSHEET CR
Quiz
•
12th Grade
22 questions
Excel Basics and More
Quiz
•
7th - 12th Grade
20 questions
Spreadsheet Formulas and Functions
Quiz
•
9th - 12th Grade
25 questions
Equations of Circles
Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)
Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System
Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice
Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers
Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons
Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)
Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review
Quiz
•
10th Grade