1) Which function is used to sum a range of cells? a) SUM() b) AVERAGE() c) MAX() d) MIN() e) COUNT() f) CONCATENATE() 2) What is the correct formula to add the values in cells A1 and B1? a) =A1/B1 b) =SUM(A1, B1) c) =ADD(A1, B1) d) =A1+B1 e) =A1-B1 f) =A1*B1 3) How do you insert a new row in an Excel worksheet? a) Data - Insert Row b) View - Insert Row c) Right-click the row number - Insert d) File - Insert Row e) Right-click the column letter - Insert f) Formulas - Insert Row 4) Which one of these charts is not in Excel a) Pie Chart b) Flow Chart c) Bar Chart d) Scatter Chart e) Combo Chart f) Map Chart 5) What symbol is not used in an a) + b) * c) - d) / e) : f) ! 6) Which formular is incorrect a) =C2+C9 b) =SUM(C4:C9) c) =(C2*C9) d) =AVERAGE(C4:C9) e) =MAX(C4:C9) f) =MIN(C4:C9) 7) What is the symbol for AutoSum? a) b) c) d) e) f) 8) What is a Cell Reference a) 5G b) G 5 c) G-5 d) (G5) e) G,5 f) G5 9) What format does Excel need to be in for autosave to work a) .xlsm b) .xlsx c) .xltx d) .csv e) .txt f) .pdf 10) How do you insert a Picture a) File - Insert b) Home - Picture c) Data - Picture d) View - Picture e) Insert - Picture f) Insert - Shape

Computer Science

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

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