Scribd
Upload
6 views3 pages

Essential Excel Functions and Features

The document consists of a quiz with 25 questions related to Excel functions, features, and shortcuts. It covers topics such as finding maximum values, starting formulas, counting numeric values, and using VLOOKUP. Additionally, it addresses various Excel tools and functionalities, including Pivot Tables, data validation, and workbook protection.

Uploaded by

mahaswaruprkpm
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views3 pages

Essential Excel Functions and Features

The document consists of a quiz with 25 questions related to Excel functions, features, and shortcuts. It covers topics such as finding maximum values, starting formulas, counting numeric values, and using VLOOKUP. Additionally, it addresses various Excel tools and functionalities, including Pivot Tables, data validation, and workbook protection.

Uploaded by

mahaswaruprkpm
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1. Which Excel function is used to find the highest value?

A. HIGH()
B. MAX()
C. LARGE()
D. TOP()
2. What symbol is used to start a formula in Excel?
A. +
B. =
C. #
D. $
3. Which function counts only numeric values?
A. COUNT()
B. COUNTA()
C. COUNTBLANK()
D. TOTAL()
4. What does VLOOKUP do?
A. Searches vertically
B. Searches horizontally
C. Sorts data
D. Filters data
5. Which feature combines multiple cells into one?
A. Wrap Text
B. Merge Cells
C. Freeze Panes
D. Split Cells
6. Which function returns today's date?
A. NOW()
B. DATE()
C. TODAY()
D. CURRENT()
7. Which Excel chart is best for trends over time?
A. Pie
B. Bar
C. Line
D. Area
8. What is a Pivot Table used for?
A. Data entry
B. Data analysis and summary
C. Chart creation
D. Formatting
9. Which function combines text from cells?
A. JOIN()
B. MERGE()
C. CONCAT()
D. APPEND()
10. Which shortcut saves a workbook?
A. Ctrl + C
B. Ctrl + S
C. Ctrl + V
D. Ctrl + X
11. What does IF function do?
A. Looping
B. Conditional logic
C. Sorting
D. Filtering
12. Which tool restricts data entry?
A. Conditional Formatting
B. Data Validation
C. Filter
D. Protect Sheet
13. Which function calculates average?
A. MEAN()
B. AVG()
C. AVERAGE()
D. MID()
14. Which Excel feature locks rows/columns?
A. Protect Sheet
B. Freeze Panes
C. Split
D. Group
15. What does COUNTBLANK do?
A. Counts zeros
B. Counts text
C. Counts empty cells
D. Counts formulas
16. Which file extension is default for Excel?
A. .xls
B. .xlsx
C. .csv
D. .xml
17. Which function extracts text?
A. MID()
B. CUT()
C. SPLIT()
D. TEXTCUT()
18. Which feature highlights data automatically?
A. Filter
B. Conditional Formatting
C. Pivot Table
D. Sort
19. Which function rounds numbers?
A. ROUND()
B. FIX()
C. FLOOR()
D. INT()
20. What does Ctrl + Z do?
A. Redo
B. Undo
C. Copy
D. Paste
21. Which function searches text?
A. FIND()
B. SEARCH()
C. LOOKUP()
D. Both A and B
22. What is the intersection of row and column called?
A. Field
B. Box
C. Cell
D. Range
23. Which function counts non-empty cells?
A. COUNT()
B. COUNTA()
C. COUNTBLANK()
D. TOTAL()
24. Which Excel tool removes duplicate values?
A. Filter
B. Sort
C. Remove Duplicates
D. Validation
25. Which feature protects workbook structure?
A. Protect Sheet
B. Protect Workbook
C. Lock Cells
D. Encrypt

You might also like