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

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

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

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

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

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

Ans. B

**07. What is the default file extension for Excel workbooks?**

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

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

Ans. F

**10. In Excel, which function returns the current date and time?**

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

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

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

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

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

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

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.

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

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.

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

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

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

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.

Ans. A

**24. In Excel, what does the A1 reference style mean?**

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

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.

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

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.

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

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.

Ans. B

Copied!