Microsoft Excel is a powerful tool widely used for data analysis, financial calculations, and creating organized spreadsheets. Testing your knowledge and skills in Excel can help you identify areas for improvement and increase your efficiency. In this blog post, we present Top 100 MCQ of Excel covering various aspects of Microsoft Excel.
Top 100 MCQ of Excel
More – Advance Excel Interview Questions
Go More MCQ Questions
Fundamental of Computer MCQ Questions
20 questions and answers on Introduction to Excel, Basic Excel Functions, Working with Formulas and Functions, and Data Formatting and Manipulation in Excel:
Q: What is Microsoft Excel used for?
A: Microsoft Excel is a spreadsheet program used for organizing, analyzing, and manipulating data. It allows users to perform calculations, create charts, and generate reports.
Q: How do you open a new workbook in Excel?
A: To open a new workbook in Excel, launch the program and click on the “Blank Workbook” option on the startup screen, or use the keyboard shortcut Ctrl+N.
Q: What are cells in Excel?
A: Cells are the basic units in an Excel worksheet. They are identified by their unique combination of column and row, such as A1, B2, etc. Cells can contain data, formulas, or functions.
Q: How do you enter data into a cell in Excel?
A: To enter data into a cell, simply click on the cell and start typing. Press Enter or Tab to move to the next cell.
Q: What is a formula in Excel?
A: A formula in Excel is an equation that performs calculations using cell references, values, and operators. It starts with an equal sign (=) and can include functions as well.
Q: How do you sum a range of cells in Excel?
A: To sum a range of cells in Excel, use the SUM function. For example, to sum cells A1 to A5, you can use the formula “=SUM(A1:A5)”.
Q: What is the function of the IF function in Excel?
A: The IF function in Excel allows you to perform logical tests and return different values based on the result. It is commonly used for conditional calculations and decision-making.
Q: How do you concatenate cells in Excel?
A: To concatenate cells in Excel (combine their contents), use the CONCATENATE function or the “&” operator. For example, “=CONCATENATE(A1, B1)” or “=A1&B1” will concatenate the values in cells A1 and B1.
Q: What is the purpose of the VLOOKUP function in Excel?
A: The VLOOKUP function in Excel is used to search for a value in the first column of a table and return a corresponding value from a specified column. It is useful for data lookup and retrieval.
Q: How do you format numbers as currency in Excel?
A: To format numbers as currency in Excel, select the cells and go to the Home tab. In the Number group, click on the “Currency” button or choose a specific currency format from the dropdown list.
Q: What is conditional formatting in Excel?
A: Conditional formatting in Excel allows you to format cells based on specific conditions or rules. It helps highlight data, identify trends, and make it visually appealing.
Q: How do you freeze panes in Excel?
A: To freeze panes in Excel, select the cell below and to the right of the row and column you want to freeze. Then, go to the View tab, click on the “Freeze Panes” button, and choose the desired option.
Q: What is the purpose of the COUNT function in Excel?
A: The COUNT function in Excel is used to count the number of cells within a range that contains numbers or dates. It ignores blank cells and cells with text.
Q: How do you sort data in Excel?
A: To sort data in Excel, select the range of cells you want to sort and go to the Data tab. Click on the “Sort” button and choose the sorting criteria such as ascending or descending order.
Q: What is the purpose of the SUMIF function in Excel?
A: The SUMIF function in Excel allows you to sum values based on specific criteria. It adds the values in a range that meet the given condition.
Q: How do you insert a new row or column in Excel?
A: To insert a new row, right-click on the row number and choose “Insert” from the context menu. To insert a new column, right-click on the column letter and choose “Insert.”
Q: What is the purpose of the AVERAGE function in Excel?
A: The AVERAGE function in Excel is used to calculate the average (mean) of a range of values. It adds up the values and divides them by the count of numbers.
Q: How do you apply a filter to data in Excel?
A: To apply a filter in Excel, select the range of cells you want to filter and go to the Data tab. Click on the “Filter” button, and filter options will appear in the column headers.
Q: What is the purpose of the MAX function in Excel?
A: The MAX function in Excel is used to find the largest value in a range of cells. It returns the maximum value from the specified range.
Q: How do you create a chart in Excel?
A: To create a chart in Excel, select the data range you want to include in the chart and go to the Insert tab. Choose the desired chart type (e.g., column, line, pie) from the Charts group.