Register

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…

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…
asked 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)​

asked
User Chris Markle
by
8.1k points

2 Answers

1 vote
B2/C2 ; average amount
answered
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

answered
User Karim Tarabishy
by
8.3k points
← Prev Question Next Question →

Related questions

Ask a Question
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.

Categories

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
Link Copied!