1. Which of the following is the default file extension for Microsoft Excel 2016 and later versions?

A) .xls
B) .xlsx
C) .docx
D) .csv

Answer: B) .xlsx
Explanation: Excel 2016 and later versions use .xlsx as the default file extension, which supports enhanced features compared to the older .xls format.

2. What is the purpose of the “AutoSum” feature in Excel?

A) To sort numbers
B) To automatically calculate the sum of selected cells
C) To format numbers
D) To create a chart

Answer: B) To automatically calculate the sum of selected cells
Explanation: AutoSum quickly calculates the total of a range of cells with one click, often used for summing columns or rows.

3. Which of the following is an example of a valid cell reference?

A) A1:B2
B) Sheet1!A1
C) A1
D) All of the above

Answer: D) All of the above
Explanation: Cell references in Excel can be a single cell (e.g., A1), a range (e.g., A1:B2), or include a sheet name (e.g., Sheet1!A1).

4. What is the shortcut key to create a new workbook in Excel?

A) Ctrl + N
B) Ctrl + O
C) Ctrl + W
D) Ctrl + Shift + N

Answer: A) Ctrl + N
Explanation: Pressing Ctrl + N opens a new blank workbook in Excel.

5. Which Excel function is used to find the largest number in a range?

A) MIN
B) SUM
C) MAX
D) AVERAGE

Answer: C) MAX
Explanation: The MAX function returns the largest value in a specified range of cells.

6. What does the formula =A1+A2 do in Excel?

A) Concatenates the values of A1 and A2
B) Subtracts the value of A2 from A1
C) Adds the values of A1 and A2
D) Multiplies the values of A1 and A2

Answer: C) Adds the values of A1 and A2
Explanation: In Excel, the + operator is used to perform addition between two or more cells.

7. What is the function of the “Freeze Panes” feature in Excel?

A) To hide rows and columns
B) To lock specific rows and columns for scrolling
C) To highlight cells
D) To sort data

Answer: B) To lock specific rows and columns for scrolling
Explanation: Freeze Panes allows users to keep certain rows or columns visible while scrolling through the rest of the sheet.

8. Which function would you use to count the number of numeric entries in a range?

A) COUNT
B) COUNTA
C) COUNTIF
D) SUM

Answer: A) COUNT
Explanation: The COUNT function calculates the number of numeric entries in a specified range.

9. What does the term “Pivot Table” refer to in Excel?

A) A chart used for graphical representation
B) A tool used to summarize and analyze data
C) A table used to insert formulas
D) A feature to filter data

Answer: B) A tool used to summarize and analyze data
Explanation: Pivot Tables are used for summarizing, analyzing, and reorganizing data in a spreadsheet.

10. Which of the following options will open the “Save As” dialog box in Excel?

A) Ctrl + S
B) F12
C) Alt + F4
D) Ctrl + Shift + S

Answer: B) F12
Explanation: Pressing F12 opens the Save As dialog box, allowing users to save their file in a desired location or format.

11. What does the “Conditional Formatting” feature do in Excel?

A) Sorts data in ascending order
B) Changes the appearance of cells based on their values
C) Protects the worksheet
D) Filters data

Answer: B) Changes the appearance of cells based on their values
Explanation: Conditional Formatting applies formatting such as colors or icons to cells that meet specified conditions.

12. Which symbol is used to begin a formula in Excel?

A) =
B) +
C) –
D) @

Answer: A) =
Explanation: In Excel, formulas always start with the = symbol to indicate a calculation or function.

13. What is the maximum number of rows in an Excel 2016 worksheet?

A) 65,536
B) 1,048,576
C) 104,857
D) Unlimited

Answer: B) 1,048,576
Explanation: Excel 2016 supports up to 1,048,576 rows per worksheet.

14. Which of the following is not a type of chart available in Excel?

A) Line Chart
B) Bar Chart
C) Pie Chart
D) Text Chart

Answer: D) Text Chart
Explanation: Excel offers various chart types like Line, Bar, and Pie, but there is no such thing as a Text Chart.

15. What is the shortcut key to apply a filter to a selected range in Excel?

A) Ctrl + F
B) Ctrl + Shift + L
C) Ctrl + L
D) Alt + F4

Answer: B) Ctrl + Shift + L
Explanation: Ctrl + Shift + L toggles filters on or off for a selected range.

16. What does the shortcut Ctrl + Z do in Excel?

A) Redoes an action
B) Undoes the last action
C) Saves the workbook
D) Deletes the selected content

Answer: B) Undoes the last action
Explanation: Ctrl + Z is a universal shortcut to undo the last action in Excel and most other applications.

17. Which function would you use to combine text from two cells in Excel?

A) CONCAT
B) TEXTJOIN
C) CONCATENATE
D) Any of the above

Answer: D) Any of the above
Explanation: The CONCAT, TEXTJOIN, and older CONCATENATE functions can all be used to combine text from multiple cells in Excel.

18. What is the shortcut key to insert the current date in a cell in Excel?

A) Ctrl + D
B) Ctrl + ; (semicolon)
C) Ctrl + Shift + ;
D) Alt + D

Answer: B) Ctrl + ; (semicolon)
Explanation: Pressing Ctrl + ; inserts the current date into the selected cell.

19. What does the “Wrap Text” feature do in Excel?

A) Deletes text that doesn’t fit in a cell
B) Resizes the text automatically
C) Moves text to a new line within the same cell
D) Aligns text to the center

Answer: C) Moves text to a new line within the same cell
Explanation: Wrap Text ensures that long text fits within a cell by displaying it on multiple lines.

20. Which of the following is a valid Excel error code?

A) #VALUE!
B) #DIV/0!
C) #NAME?
D) All of the above

Answer: D) All of the above
Explanation: Errors like #VALUE!, #DIV/0!, and #NAME? indicate issues in formulas or cell references.

21. Which of these can be used to remove duplicate values in Excel?

A) Sort tool
B) Remove Duplicates feature
C) Data Validation
D) Conditional Formatting

Answer: B) Remove Duplicates feature
Explanation: The Remove Duplicates feature under the Data tab allows users to identify and eliminate duplicate values from a dataset.

22. What is the purpose of the “VLOOKUP” function in Excel?

A) To filter data based on criteria
B) To find and retrieve data from a table based on a specific value
C) To perform arithmetic calculations
D) To format cells

Answer: B) To find and retrieve data from a table based on a specific value
Explanation: The VLOOKUP function searches for a value in the first column of a table and returns a corresponding value from a specified column.

23. What does pressing F2 in Excel do?

A) Opens a new workbook
B) Saves the workbook
C) Edits the active cell
D) Opens the Help menu

Answer: C) Edits the active cell
Explanation: Pressing F2 allows users to edit the content of the currently active cell.

24. Which of the following is used to lock a cell reference in a formula?

A) Dollar sign ($)
B) Asterisk (*)
C) Hash (#)
D) Ampersand (&)

Answer: A) Dollar sign ($)
Explanation: The $ symbol locks a cell reference in Excel, making it absolute (e.g., $A$1).

25. What is the maximum number of columns in an Excel 2016 worksheet?

A) 16,384
B) 10,000
C) 1,048,576
D) 256

Answer: A) 16,384
Explanation: Excel 2016 supports up to 16,384 columns in a worksheet, ranging from column A to column XFD.

26. Which feature allows you to find the sum, average, or count of selected cells without using a formula?

A) Quick Analysis
B) Status Bar
C) Data Validation
D) AutoFilter

Answer: B) Status Bar
Explanation: The Status Bar at the bottom of Excel displays quick calculations like sum, average, and count for the selected cells.

27. Which of these is not a valid function in Excel?

A) SUM
B) AVERAGE
C) TOTAL
D) IF

Answer: C) TOTAL
Explanation: While SUM, AVERAGE, and IF are valid functions in Excel, there is no function named TOTAL.

28. What is the keyboard shortcut to open the Find and Replace dialog box?

A) Ctrl + F
B) Ctrl + R
C) Ctrl + H
D) Both A and C

Answer: D) Both A and C
Explanation: Ctrl + F opens the Find dialog box, and Ctrl + H opens Find and Replace.

29. Which type of chart is best suited for showing proportions?

A) Line Chart
B) Bar Chart
C) Pie Chart
D) Column Chart

Answer: C) Pie Chart
Explanation: Pie Charts are ideal for displaying parts of a whole as proportions.

30. What does Ctrl + Shift + “+” do in Excel?

A) Deletes the selected cells
B) Inserts new cells, rows, or columns
C) Adds a new worksheet
D) Sorts the data

Answer: B) Inserts new cells, rows, or columns
Explanation: Ctrl + Shift + “+” quickly inserts new rows, columns, or cells based on the selection.