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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?