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

प्रिंट
एम्बेड

लीडरबोर्ड

दृश्य शैली

विकल्प

टेम्पलेट स्विच करें

ऑटो-सेव पुनःस्थापित करें: ?