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

Stampa
Incorpora

Classifica

Stile di visualizzazione

Opzioni

Cambia modello

Ripristinare il titolo salvato automaticamente: ?