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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?