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

สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม