188k views
4 votes
Using the spreadsheet below, which formula can be used to determine Albert's hourly wage?

2
1 Employee Hours Worked Amount Earned
2 Albert
$101.50
Brandon
19
$147.25
Callie
$164.45
Dora
$157.50
0-average(B2:C2)
O =average(C2:B2)
O =(C2/B2)
O =(B2/C2)​

2 Answers

1 vote
B2/C2 ; average amount
User Maquannene
by
8.2k points
2 votes

Answer:

It will be average (B2:C2)

as it will select all the data between B2 and C2

User Karim Tarabishy
by
8.3k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.