1. What is the default file extension for Excel 2016 workbooks?
a) .xls
b) .xlsx
c) .xlsm
d) .csv
Answer: b
2. Which of the following is the formula to sum up values in Excel?
a) =SUM()
b) =ADD()
c) =TOTAL()
d) =SUMALL()
Answer: a
3. What is the shortcut key to open a new workbook in Excel?
a) Ctrl + N
b) Ctrl + O
c) Ctrl + S
d) Ctrl + P
Answer: a
4. Which function is used to find the largest number in a range?
a) =MAX()
b) =MIN()
c) =AVERAGE()
d) =LARGE()
Answer: a
5. How do you add a comment to a cell in Excel?
a) Right-click the cell and select "Insert Comment"
b) Press Ctrl + C
c) Press Ctrl + Alt + C
d) Go to Insert tab and click on "Text Box"
Answer: a
6. Which of the following is NOT a valid Excel data type?
a) Text
b) Number
c) Boolean
d) Link
Answer: d
7. Which Excel function returns the current date and time?
a) =NOW()
b) =TODAY()
c) =TIME()
d) =CURRENT()
Answer: a
8. What is the maximum number of rows in an Excel worksheet?
a) 32,000
b) 1,048,576
c) 65,536
d) 100,000
Answer: b
9. What does the "VLOOKUP" function do in Excel?
a) Returns a value from a vertical lookup in a table
b) Sums the values in a column
c) Counts the number of cells in a range
d) Finds the vertical distance between two cells
Answer: a
10. How can you protect a worksheet from editing in Excel?
a) Go to File > Protect Sheet
b) Right-click the worksheet tab and select "Protect"
c) Go to Review tab and select "Protect Sheet"
d) Press Ctrl + Shift + P
Answer: c
11. What is the maximum number of columns in an Excel worksheet?
a) 256
b) 1,024
c) 16,384
d) 10,000
Answer: c
12. Which chart type is best for showing trends over time?
a) Pie Chart
b) Line Chart
c) Column Chart
d) Scatter Chart
Answer: b
13. How do you combine data from multiple cells into one in Excel?
a) =MERGE()
b) =CONCATENATE()
c) =COMBINE()
d) =JOIN()
Answer: b
14. What is the purpose of the "Freeze Panes" feature in Excel?
a) To freeze columns and rows in place while scrolling
b) To lock cells for editing
c) To remove columns and rows
d) To add borders to cells
Answer: a
15. What is the function of the "COUNTIF" function in Excel?
a) Counts the number of cells that meet a criterion
b) Counts all non-empty cells
c) Counts the total number of rows
d) Counts the cells that contain text
Answer: a
16. How do you merge two or more cells in Excel?
a) Use the "Merge & Center" button on the Home tab
b) Right-click and select "Merge"
c) Use the "Combine Cells" option in the Insert tab
d) Select cells and press Ctrl + M
Answer: a
17. Which of the following symbols is used to indicate absolute reference in Excel?
a) !
b) *
c) $
d) &
Answer: c
18. What is the purpose of the "IF" function in Excel?
a) To perform a logical test and return one value for TRUE and another for FALSE
b) To sum up a range of cells
c) To count cells with specific text
d) To find the largest number
Answer: a
19. Which of the following is NOT a valid Excel chart type?
a) Bar Chart
b) Line Chart
c) Circle Chart
d) Pie Chart
Answer: c
20. How do you highlight duplicate values in Excel?
a) Use the "Find & Select" option
b) Use conditional formatting
c) Use the "Duplicate Cells" option in Data Tools
d) Right-click and select "Highlight Duplicates"
Answer: b
21. What is the function of the "SUMIF" function in Excel?
a) Sums cells based on a given condition
b) Sums all cells in a range
c) Subtracts cells based on a condition
d) Counts cells based on a condition
Answer: a
22. What is the keyboard shortcut for Paste Special in Excel?
a) Ctrl + V
b) Ctrl + Alt + V
c) Ctrl + Shift + V
d) Ctrl + P
Answer: b
23. How do you apply a filter to a column in Excel?
a) Select the column and press Ctrl + F
b) Click on Data tab and select "Filter"
c) Right-click the column and select "Apply Filter"
d) Go to View tab and select "Filter"
Answer: b
24. How can you add a hyperlink to a cell in Excel?
a) Right-click and select "Insert Hyperlink"
b) Go to Insert tab and select "Link"
c) Use the "HYPERLINK" function
d) All of the above
Answer: d
25. What does the "SUMPRODUCT" function do in Excel?
a) Multiplies corresponding ranges or arrays and returns the sum of those products
b) Sums up all the values in a range
c) Calculates the average of the values
d) Counts the number of cells in a range
Answer: a
