Microsoft MS Excel MCQ 100 Best Question Answer

Correct Answer: A. Workbook. A workbook is like a container holding one or more worksheets.

Correct Answer: B. Worksheets. Worksheets are the individual pages where you enter and work with data.

Correct Answer: C. Cell. A cell is the basic unit for storing data in Excel. It’s where a row and column meet.

Correct Answer: B. Rows. Rows run horizontally across the worksheet.

Correct Answer: C. Ribbon. The Ribbon is located at the top of the Excel window and organizes commands in tabs and groups.

Correct Answer: D. Selecting the cell and pressing the Delete key. The Delete key removes data from a cell, it doesn’t enter it.

Correct Answer: D. Range. A range is a rectangular block of selected cells.

Correct Answer: B. Fill Handle. The Fill Handle is the small square at the bottom right of a cell that allows you to drag and copy content.

Correct Answer: B. Use the Cut and Paste commands. Cut removes data from the original location, while Paste places it in the new location.

Correct Answer: A. Add new rows or columns. The Insert command lets you add new rows, columns, or cells to your worksheet.

Correct Answer: B. Right-click the row number and choose Delete. Right-clicking the row number and choosing Delete is the correct way to remove a row.

Correct Answer: C. To automatically continue a series of data or formulas. AutoFill helps you quickly fill cells with a series of data, like numbers or dates, or to copy formulas.

Correct Answer: C. Justify. Justify is an alignment option, not a font style.

Correct Answer: C. Currency. Currency format adds currency symbols and decimal places appropriate for monetary values.

Correct Answer: B. Vertical Alignment. Vertical Alignment controls whether text is at the top, middle, or bottom of a cell.

Correct Answer: A. Merge & Center. Merge & Center combines selected cells and centers the content.

Correct Answer: B. Applying a Border. Borders allow you to add lines of varying styles and thicknesses to cells.

Correct Answer: B. Cell Styles. Cell Styles are pre-designed combinations of formatting options.

Correct Answer: A. Page Setup. Page Setup is where you control margins, orientation, and other print-related settings.

Correct Answer: B. Sheet Options. Sheet Options allow you to show or hide gridlines and headings.

Correct Answer: C. Print Preview. Print Preview shows you the layout of your worksheet as it will appear on the printed page.

Correct Answer: B. To add titles, page numbers, or dates to the top and bottom of each printed page. Headers and footers provide information on each page of a printed worksheet.

Correct Answer: B. By using the Page Setup options. Page Setup allows you to switch between portrait and landscape orientation.

Correct Answer: B. Adjusts the size of the worksheet to fit on a specific number of pages. Scaling allows you to shrink or enlarge the printed output to fit your desired page count.

Correct Answer: C. Print Selection. Print Selection lets you choose a specific area of the worksheet to print.

Correct Answer: B. . The asterisk () represents multiplication in Excel.

Correct Answer: B. Relative reference. Relative references adjust based on the formula’s new position.

Correct Answer: A. $. The dollar sign ($) is used to create absolute references (e.g., $A$1).

Correct Answer: C. Parentheses, Exponents, Multiplication, Division, Addition, Subtraction. Excel follows the standard mathematical order of operations (PEMDAS/BODMAS).

Correct Answer: C. Exponentiation. The ^ symbol is used to raise a number to a power (e.g., 2^3 = 8).

Correct Answer: C. SUM. The SUM function adds all the numbers in a specified range.

Correct Answer: C. AVERAGE. The AVERAGE function finds the mean of a set of numbers.

Correct Answer: A. COUNT. COUNT specifically counts cells with numerical data.

Correct Answer: A. MAX. The MAX function identifies the highest value.

Correct Answer: B. IF. The IF function performs a logical test and returns different results based on whether the test is true or false.

Correct Answer: A. AND. The AND function checks if all logical conditions are met.

Correct Answer: A. VLOOKUP. VLOOKUP performs a vertical lookup in a table.

Correct Answer: A. CONCATENATE. CONCATENATE combines text from different cells.

Correct Answer: B. TEXT. The TEXT function allows you to format numbers as text.

Correct Answer: B. Performs a horizontal lookup in a table array. HLOOKUP searches horizontally across a table.

Correct Answer: B. By typing an equals sign (=). Formulas always start with an equals sign.

Correct Answer: B. A formula refers to its own cell, directly or indirectly. A circular reference occurs when a formula creates a loop by referencing itself.

Correct Answer: A. A potential error in the formula. A green triangle signals that Excel has detected a possible issue with the formula.

Correct Answer: C. Use the AutoSum feature. AutoSum automatically creates a SUM formula for a selected range.

Correct Answer: C. F4. Pressing F4 while editing a formula toggles through the reference types.

Correct Answer: B. By using the Sort Ascending command. Sort Ascending arranges data from smallest to largest.

Correct Answer: B. Filtering. Filtering hides rows that don’t match your criteria.

Correct Answer: B. Filter by font size. Excel’s standard filters don’t include filtering by font size.

Correct Answer: A. Removes the filter and displays all data. Clear Filter removes the filtering criteria and shows all rows again.

Correct Answer: C. Advanced Filter. Advanced Filter provides more flexible options for filtering data.

Correct Answer: A. Data Validation. Data Validation allows you to set rules for what data is allowed in a cell.

Correct Answer: D. Font color. Font color is a formatting option, not a data validation rule.

Correct Answer: A. By using the Data Validation feature. Data Validation allows you to create a list of valid entries for a cell.

Correct Answer: B. A message that appears when the cell is selected, providing instructions or information. Input messages guide users on what data to enter.

Correct Answer: C. A message that appears when invalid data is entered. Error alerts inform users that they’ve entered data that doesn’t meet the validation rules.

Correct Answer: D. All of the above. Excel tables offer all these advantages and more.

Correct Answer: D. All of the above. You can create a table using any of these methods.

Correct Answer: A. Cell references that use column headers instead of letters and numbers. Structured references make formulas more readable by using table and column names.

Correct Answer: D. All of the above. Excel provides multiple ways to add rows to tables.

Correct Answer: B. The filtered rows are hidden. Filtering in a table temporarily hides rows that don’t meet the criteria.

Correct Answer: C. Line chart. Line charts are ideal for illustrating changes in data over a period.

Correct Answer: D. Column chart. Column charts (or bar charts) effectively compare distinct categories.

Correct Answer: C. Select the data you want to include in the chart. Selecting the relevant data is essential for accurate chart creation.

Correct Answer: B. Insert tab. The Insert tab contains the chart library.

Correct Answer: D. Both A and B. Both options allow you to modify the chart type.

Correct Answer: B. To provide a clear description of what the chart represents. A chart title concisely explains the chart’s content.

Correct Answer: B. Data points. Data points are the individual values represented on the chart.

Correct Answer: B. To identify the different data series. The legend clarifies what each color or symbol in the chart represents.

Correct Answer: B. To show the general direction of the data. Trendlines help visualize the overall trend in the data.

Correct Answer: B. Lines that extend from the axes to help read values. Gridlines provide a visual reference for data values on the chart.

Correct Answer: D. All of the above. All these methods provide access to chart formatting options.

Correct Answer: D. All of the above. Chart layouts control the arrangement of chart elements.

Correct Answer: D. All of the above. Excel offers multiple ways to add data labels to charts.

Correct Answer: B. To display the exact values of the data points. Data labels show the precise values represented by each data point.

Correct Answer: D. Both A and C. You can use chart styles or copy formatting from another chart.

Correct Answer: B. To summarize and analyze large amounts of data. PivotTables are designed to quickly summarize data and identify trends.

Correct Answer: C. Values. The Values area determines the calculations shown in the PivotTable.

Correct Answer: B. To include or exclude specific data from the PivotTable. Filters allow you to focus on specific subsets of data within the PivotTable.

Correct Answer: A. A chart created from the data in a PivotTable. PivotCharts provide a visual representation of PivotTable data.

Correct Answer: D. All of the above. All these methods will refresh the PivotTable to reflect the latest data.

Correct Answer: B. A recorded sequence of actions that can be replayed to automate tasks. Macros automate repetitive actions by recording your steps.

Correct Answer: A. By using the “Record Macro” command on the Developer tab. The “Record Macro” command captures your actions as a macro.

Correct Answer: B. .xlsm. The .xlsm extension indicates that a workbook has macros enabled.

Correct Answer: C. It finds the input value needed to achieve a specific target output. Goal Seek helps you determine the input required to reach a desired outcome.

Correct Answer: C. To find the optimal solution to a problem with constraints. Solver is a powerful tool for optimization problems.

Correct Answer: A. Ctrl + A. Ctrl + A selects all cells in the active worksheet.

Correct Answer: A. Home. The Home key navigates to the first cell in the row.

Correct Answer: A. Ctrl + Shift + $. Ctrl + Shift + $ quickly formats cells for currency.

Correct Answer: A. Shift + F11. Shift + F11 adds a new worksheet to the workbook.

Correct Answer: A. Ctrl + 1. Ctrl + 1 provides access to all cell formatting options.

Correct Answer: B. Use the Format Painter. The Format Painter copies formatting from one selection to another.

Correct Answer: B. Paste Values. Paste Values inserts the results of formulas, not the formulas themselves.

Correct Answer: C. Paste Formats. Paste Formats applies the source cell’s formatting without changing the destination cell’s content.

Correct Answer: D. Paste Transpose. Paste Transpose flips the orientation of copied data.

Correct Answer: D. Both B and C. Both TODAY() and NOW() can be used, but TODAY() only inserts the date.

Correct Answer: C. Use the NOW() function. The NOW() function inserts both the current date and time.

Correct Answer: A. To provide access to frequently used commands. The Quick Access Toolbar allows you to customize shortcuts for common actions.

Correct Answer: D. All of the above. All of these methods can be used to customize the Quick Access Toolbar.

Correct Answer: B. Locks the position of rows or columns so they remain visible while scrolling. Freeze Panes keeps headers or labels visible as you navigate through data.

Correct Answer: D. All of the above. Named ranges offer all these benefits for improved worksheet organization and clarity.