Question

Please provide an excel Formula for the last 2 questions, cell reference is not required. Thank You

Using the numbers below, answer the questions using nested formulas 14 11 15 30 28 15 25 11 41 20 20 50 6 24 20 28 47 Add all the numbers together using SUM and round them with ROUND Use SUM to add 5 to the AVERAGE of all the numbers above Use SUM to add the MIN and MAX numbers from the table above

Answer 1

Solution
8	14	11	7	15	30
28	15	25	2	11	1
1	20	20	20	41	50
7	24	20	28	47	6
451	(use SUM=(range))
451	(use ROUND=C1,0)
18.79167	(use Average=(range))
23.79167	(use SUM=(5+C2))
1	(use MIN=(range)
50	(use MAX=(range))
51	(use SUM=(MIN+MAX))