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
4.4k 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
4.4k points