MS Excel – Formulas, Functions, Charts, Pivot Tables

1. : In Excel, which symbol is always used to start a formula?
(A) +
(B) =
(C) #
(D) $

2. : Which function is used to find the average of a range of numbers in Excel?
(A) SUM()
(B) COUNT()
(C) AVERAGE()
(D) MAX()

3. : Which function is used to return the largest value in a given range?
(A) MIN()
(B) MAX()
(C) LARGE()
(D) BIG()

4. : Which type of chart is best for showing trends over time?
(A) Pie Chart
(B) Line Chart
(C) Column Chart
(D) Bar Chart

5. : Which Excel feature allows you to summarize and analyze large amounts of data quickly?
(A) Conditional Formatting
(B) Pivot Table
(C) Data Validation
(D) VLOOKUP

6. : Which function counts only numeric values in a range?
(A) COUNTA()
(B) COUNT()
(C) COUNTIF()
(D) COUNTBLANK()

7. : Which chart type is most suitable for showing proportions or percentages of a whole?
(A) Pie Chart
(B) Line Chart
(C) Column Chart
(D) Scatter Chart

8. : Which function is used to look up a value in a table vertically?
(A) HLOOKUP()
(B) VLOOKUP()
(C) SEARCH()
(D) MATCH()

9. : Which Pivot Table feature allows you to filter data interactively?
(A) Slicer
(B) Data Bar
(C) Goal Seek
(D) Sort

10. : In Excel, which function returns the current date?
(A) TODAY()
(B) DATE()
(C) NOW()
(D) TIME()