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

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?