# MS Excel MCQ

Microsoft Excel is a spreadsheet application made by the Microsoft Corporation that enables users to produce, modify, and work with data in a tabular manner. It offers methods and resources for effectively and efficiently gathering, processing, and presenting data. Users may enter data, utilize built-in functions to do calculations, make charts and graphs, and produce reports in Excel using a grid of cells arranged in rows and columns. Budgeting, data analysis, and project management are just a few of the many uses it is used for in business, education, and personal finance.

**1. What does a cell mean in Microsoft Excel?**

- A program for organizing
- A collection of data
- The intersection of a row and a column
- A type of chart

**Answer: C)** The intersection of a row and a column

**2. Which key combination in Excel should be used to start a new worksheet?**

- Ctrl + N
- Ctrl + W
- Ctrl + S
- Ctrl + A

**Answer: A) **Ctrl + N

**3. What is a workbook in Microsoft Excel?**

- A collection of worksheets
- A type of chart
- A type of function
- A type of format

**Answer: A)** A collection of worksheets

**4. Which Excel function is employed to compute the sum of a range of cells?**

- COUNT
- AVERAGE
- SUM
- MAX

**Answer: C)** SUM

**5. What does a formula mean in Microsoft Excel?**

- A mathematical equation that performs a calculation
- A type of chart
- A type of format
- A type of function

**Answer: A) **A mathematical equation that performs a calculation

**6.What keyboard shortcut in Excel may be used to select an entire worksheet?**

- Ctrl + A
- Ctrl + Shift + End
- Ctrl + Home
- Ctrl + Shift + Home

**Answer: D)** Ctrl + Shift + Home

**7. Which of the following does Excel not accept as a legitimate data type?**

- Text
- Date
- Time
- Boolean

**Answer: D)** Boolean

**8. In Microsoft Excel, what is a function?**

- A built-in formula that performs a specific calculation
- A type of chart
- A type of format
- A type of cell

**Answer: A)** A built-in formula that performs a specific calculation

**9.Which of the following chart types is invalid in Excel?**

- Bubble chart
- Radar chart
- Heat map chart
- Pyramid chart

**Answer: D)** Pyramid chart

**10.In Excel, what function is employed to round a number up to the next full number?**

- ROUND
- ROUNDUP
- ROUNDDOWN
- CEILING

**Answer: B) **ROUNDUP

**11.Which Excel function is used to get a number's square root?**

- SQRT
- POWER
- EXP
- LOG

**Answer: A)** SQRT

**12.In Microsoft Excel, what does a chart mean?**

- A visual representation of
- A type of function
- A type of cell
- A type of worksheet

**Answer: A)** A visual representation of data

**13. What keyboard shortcut in Excel is used to style certain cells as bold?**

- Ctrl + B
- Ctrl + U
- Ctrl + I
- Ctrl + Shift + B

**Answer: A)** Ctrl + B

**14. Which Excel function is used to determine how many cells in a range satisfy a certain condition?**

- COUNT
- COUNTA
- COUNTIF
- COUNTBLANK

**Answer: C)** COUNTIF

**15. What does Microsoft Excel's conditional formatting mean?**

- A feature that highlights cells based on certain criteria
- A type of chart
- A type of function
- A type of format

**Answer: A)** A feature that highlights cells based on certain criteria

**16. What is a pivot table in Microsoft Excel?**

- A tool used for summarizing and analyzing
- A type of chart
- A type of function
- A type of format

**Answer: A)** A tool used for summarizing and analyzing data

**17. How does Microsoft Excel define data validation?**

- A feature that ensures data is entered correctly in a cell
- A type of chart
- A type of function
- A type of worksheet

**Answer: A) **A feature that ensures data is entered correctly in a cell

**18. Which Excel function is used to locate the least value across a group of cells?**

- MAX
- MIN
- AVERAGE
- SUM

**Answer: B)** MIN

**19.Which kind of chart is used to demonstrate the relationship between two variables?**

- Line chart
- Scatter chart
- Bar chart
- Pie chart

**Answer: B)** Scatter chart

**20.Which keyboard shortcut in Excel is used to select cells for cutting?**

- Ctrl + X
- Ctrl + C
- Ctrl + V
- Ctrl + A

**Answer: A)** Ctrl + X

**21. Which form of chart is used to display a whole's proportions?**

- Line chart
- Bar chart
- Pie chart
- Scatter chart

**Answer: C)** Pie chart

**22. What key combination should you use to save an Excel file?**

- Ctrl + S
- Ctrl + P
- Ctrl + N
- Ctrl + O

**Answer: A)** Ctrl + S

**23. What Excel formula is used to combine two or more text strings?**

- CONCATENATE
- TEXT
- JOIN
- MERGE

**Answer: A)** CONCATENATE

**24. Which Excel function calculates the average value of a set of cells?**

- AVERAGE
- SUM
- MAX
- MIN

**Answer: A)** AVERAGE