1) What is a Pivot Table used for? a) Data analysis b) Creating charts c) Writing formulas d) Formatting cells 2) Which function returns current date? a) TODAY() b) DATE() c) NOW() d) TIME() 3) What does VLOOKUP do? a) Finds data b) Sorts data c) Calculates sum d) Formats text 4) How to lock a cell reference? a) Use $ sign b) Use # sign c) Use & sign d) Use * sign 5) Which function counts blank cells? a) COUNTBLANK() b) COUNTA() c) COUNT() d) COUNTIF() 6) What does CONCATENATE do? a) Joins text b) Splits text c) Formats text d) Deletes text 7) Which chart shows trends over time? a) Line chart b) Pie chart c) Bar chart d) Scatter plot 8) What is conditional formatting? a) Formats based on rules b) Formats all cells c) Formats text only d) Formats numbers only 9) Which function finds maximum value? a) MAX() b) MIN() c) AVERAGE() d) SUM() 10) What is the shortcut for Save? a) Ctrl + S b) Ctrl + C c) Ctrl + V d) Ctrl + X

Advanced Excel Quiz

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

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

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

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