1) What is the purpose of a formula in Excel? a) Make text bold b) Perform Calculation c) Change the font colour 2) If cell A1 contains 20 and cell B1 contains 10, what will be the result of the formula "=A1-B1" a) 10 b) 20 c) 30 3) What does the formula "=A2*B2" do in Excel? a) Adds A2 and B2 b) Multiplies A2 and B2 c) Divides A2 by B2 4) Which Excel function is used to find the average of a range of numbers? a) MIN b) MAX c) AVERAGE 5) If you want to divide the value in cell C3 by the value in cell D3, what formula would you use? a) =C3+D3 b) =C3-D3 c) =C3/D3

Excel Lesson 3

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

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

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

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