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)

Question

Christine Brandt

3 July, 09:09

+2

Answers (1)

Know the Answer?

Winston Hanson · Answer 1

It will be average (B2:C2)

as it will select all the data between B2 and C2

Using the spreadsheet below, which formula can be used to determine Albert's hourly wage?21 Employee Hours Worked Amount Earned2 Albert$101.50Brandon19$147.25Callie$164.45Dora$157.500-average (B2:C2)O = average (C2:B2)O = (C2/B2)O = (B2/C2)