1) Compute the total sales of all employees. a) 5,344.24 b) 5,345.25 c) 5,347.24 d) 5,364.24 2) Find the highest sales value. a) 951.65 b) 820.4 c) 1050.65 d) 950.65 3) Find the lowest sales value. a) 510.1 b) 120.55 c) 260.45 d) 110.67 4) Count how many employees have sales above 500. a) 5 b) 8 c) 6 d) 7 5) Multiply the highest two sales values. a) 779.913.26 b) 779,913.26 c) 879.113.26 d) 779.913.28 6) Count how many sales values are below 300. a) 1 b) 0 c) 2 d) 3 7) Find the average of the top 3 sales numbers. a) 990.78 b) 880.90 c) 830.68 d) 830.678 8) =ROUND(B4,0) a) 299.10 b) 300 c) 298 d) 298.5 9) =ROUND(B7,1) a) 120.56 b) 120.57 c) 120 d) 120.5

SOLVING-EXCEL

I-print
Naka-embed

Leaderboard

Estilo ng visual

Mga pagpipilian

Magpalit ng template

Ibalik ng awtomatikong pag-save: ?