Copied!
01. In Excel, which function is used to find the highest value in a range of cells?
a) MAX
b) HIGH
c) TOP
d) HIGHEST
a) MAX
b) HIGH
c) TOP
d) HIGHEST
Ans. A
02. What is the maximum number of rows that Excel 2019 supports?
a) 65,536
b) 104,8576
c) 1,048,576
d) 256
a) 65,536
b) 104,8576
c) 1,048,576
d) 256
Ans. C
03. Which Excel feature allows you to automatically sum a range of numbers based on a specific condition?
a) SUMIF
b) AUTO_SUM
c) RANGE_SUM
d) ADDIF
a) SUMIF
b) AUTO_SUM
c) RANGE_SUM
d) ADDIF
Ans. A
04. What is the keyboard shortcut to copy selected cells in Excel?
a) Ctrl+C
b) Ctrl+X
c) Ctrl+V
d) Ctrl+Z
a) Ctrl+C
b) Ctrl+X
c) Ctrl+V
d) Ctrl+Z
Ans. A
05. In Excel, which chart type is best for showing the relationship between two or more variables?
a) Pie chart
b) Line chart
c) Bar chart
d) Scatter plot
a) Pie chart
b) Line chart
c) Bar chart
d) Scatter plot
Ans. D
06. Which function can be used to count the number of cells in a range that meet a specific condition?
a) COUNT
b) COUNTIF
c) SUM
d) AVERAGE
a) COUNT
b) COUNTIF
c) SUM
d) AVERAGE
Ans. B
07. What is the default file extension for Excel workbooks?
a) .xls
b) .xlsx
c) .xl
d) .exl
a) .xls
b) .xlsx
c) .xl
d) .exl
Ans. B
08. Which Excel feature allows you to create two or more complementary data ranges within a single chart?
a) Data Consolidation
b) Data Validation
c) Data Splitting
d) Data Series
a) Data Consolidation
b) Data Validation
c) Data Splitting
d) Data Series
Ans. D
09. What is the keyboard shortcut to open the “Save As” dialog box in Excel?
a) Ctrl+S
b) Ctrl+O
c) Ctrl+A
d) Ctrl+P
a) Ctrl+S
b) Ctrl+O
c) Ctrl+A
d) Ctrl+P
Ans. F
10. In Excel, which function returns the current date and time?
a) NOW
b) DATE
c) TIME
d) DATETIME
a) NOW
b) DATE
c) TIME
d) DATETIME
Ans. A
11. What is the maximum number of columns that Excel 2019 supports?
a) 256
b) 16,384
c) 32,768
d) 65,536
a) 256
b) 16,384
c) 32,768
d) 65,536
Ans. B
12. Which Excel feature allows you to create a visual representation of data using shapes, images, and text?
a) Sparklines
b) SmartArt
c) Pivot Tables
d) Data Validation
a) Sparklines
b) SmartArt
c) Pivot Tables
d) Data Validation
Ans. B
13. What does the function VLOOKUP stand for in Excel?
a) Vertical Look and Update
b) Value Lookup
c) Variable Lookup
d) Vertical Lookup
a) Vertical Look and Update
b) Value Lookup
c) Variable Lookup
d) Vertical Lookup
Ans. D
14. Which function can be used to round a number up to the nearest integer in Excel?
a) ROUNDUP
b) ROUNDDOWN
c) ROUND
d) INT
a) ROUNDUP
b) ROUNDDOWN
c) ROUND
d) INT
Ans. A
15. In Excel, what is the keyboard shortcut to insert a new worksheet?
a) Ctrl+I
b) Ctrl+N
c) Ctrl+W
d) Ctrl+H
a) Ctrl+I
b) Ctrl+N
c) Ctrl+W
d) Ctrl+H
Ans. B
16. Which chart type is best for displaying the distribution of a data set in Excel?
a) Pie chart
b) Bar chart
c) Histogram
d) Line chart
a) Pie chart
b) Bar chart
c) Histogram
d) Line chart
Ans. C
17. What is the function of the IFERROR function in Excel?
a) It returns an error if a condition is met.
b) It performs a calculation if an error is encountered.
c) It replaces errors with a specified value or message.
d) It checks for errors in a worksheet.
a) It returns an error if a condition is met.
b) It performs a calculation if an error is encountered.
c) It replaces errors with a specified value or message.
d) It checks for errors in a worksheet.
Ans. C
18. Which Excel feature allows you to create interactive, data-driven documents and reports?
a) Excel Pivot Tables
b) Excel Charts
c) Power Query
d) Power BI
a) Excel Pivot Tables
b) Excel Charts
c) Power Query
d) Power BI
Ans. D
19. What is the function of the CONCATENATE function in Excel?
a) It adds numbers together.
b) It combines two or more text strings into one.
c) It calculates the average of a range of numbers.
d) It sorts data in ascending order.
a) It adds numbers together.
b) It combines two or more text strings into one.
c) It calculates the average of a range of numbers.
d) It sorts data in ascending order.
Ans. B
20. Which Excel function is used to find the largest value in a range while satisfying a condition?
a) MAX
b) LARGE
c) MAXIF
d) MAXVALUE
a) MAX
b) LARGE
c) MAXIF
d) MAXVALUE
Ans. B
21. In Excel, what is the keyboard shortcut to undo the last action?
a) Ctrl+U
b) Ctrl+Z
c) Ctrl+Y
d) Ctrl+X
a) Ctrl+U
b) Ctrl+Z
c) Ctrl+Y
d) Ctrl+X
Ans. B
22. Which Excel function is used to count the number of cells that are not empty in a range?
a) COUNTA
b) COUNTIF
c) COUNTBLANK
d) COUNT
a) COUNTA
b) COUNTIF
c) COUNTBLANK
d) COUNT
Ans. A
23. What is the function of the HLOOKUP function in Excel?
a) It looks up values in a horizontal table.
b) It calculates the horizontal average of a range.d) It creates horizontal headers in a worksheet.
a) It looks up values in a horizontal table.
b) It calculates the horizontal average of a range.
Ans. A
24. In Excel, what does the A1 reference style mean?
a) Absolute reference
b) Relative reference
c) Mixed reference
d) Circular reference
a) Absolute reference
b) Relative reference
c) Mixed reference
d) Circular reference
Ans. B
25. Which Excel feature allows you to filter and extract specific data from a larger dataset?
a) Data Validation
b) Data Sorting
c) Data Filtering
d) Data Validation
a) Data Validation
b) Data Sorting
c) Data Filtering
d) Data Validation
Ans. C
26. What is the purpose of the IF function in Excel?
a) To insert images into a worksheet.
b) To format cells with bold text.
c) To perform conditional calculations.
d) To create hyperlinks.
a) To insert images into a worksheet.
b) To format cells with bold text.
c) To perform conditional calculations.
d) To create hyperlinks.
Ans. C
27. Which Excel feature allows you to quickly copy the formula or value of a cell to adjacent cells?
a) AutoFill
b) Formula Painter
c) Fill Down
d) Copy-Paste Special
a) AutoFill
b) Formula Painter
c) Fill Down
d) Copy-Paste Special
Ans. A
28. What is the function of the NOW function in Excel?
a) It returns the current date.
b) It returns the current time.
c) It returns both the current date and time.
d) It returns the current year.
a) It returns the current date.
b) It returns the current time.
c) It returns both the current date and time.
d) It returns the current year.
Ans. C
29. In Excel, which function is used to find the average value of a range of cells?
a) AVG
b) MEAN
c) AVERAGE
d) SUM
a) AVG
b) MEAN
c) AVERAGE
d) SUM
Ans. C
30. What is the purpose of the Freeze Panes feature in Excel?
a) To prevent unauthorized access to a worksheet.
b) To lock specific rows and columns in a worksheet.
c) To change the color scheme of a worksheet.
d) To hide selected rows and columns.
a) To prevent unauthorized access to a worksheet.
b) To lock specific rows and columns in a worksheet.
c) To change the color scheme of a worksheet.
d) To hide selected rows and columns.
Ans. B
Copied!