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

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？