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

Spausdinti
Įterpti

Lyderių lentelė

Vizualinis stilius

Parinktys

Pakeisti šabloną

Atkurti automatiškai įrašytą: ?