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

印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

自動保存: を復元しますか?