Question 1

What happens if you remove the check mark from Row & Column headers on Options dialog box?

Accepted Answer

Correct Answer: This will remove row headings and column headings of your data

Explanation: Unchecking 'Row & Column Headers' in the View options hides the standard Excel grid labels—the letters at the top (A, B, C...) and the numbers on the left (1, 2, 3...). This makes the sheet look like a blank white page without the coordinate frame.

Question 2

Which of the following cannot be hidden from Tools > Options then View tab?

Accepted Answer

Correct Answer: Startup Task Pane

Explanation: In the 'View' tab of the Options dialog (in older Excel), you had explicit checkboxes to show/hide the Formula Bar, Status Bar, and Scroll Bars. The 'Startup Task Pane' settings were managed separately (usually checking a box on the pane itself or General options), not in the View tab.

Question 3

The minimum and maximum value you can set for Save AutoRecovery info in Excel are

Accepted Answer

Correct Answer: 1 and 120 minutes

Explanation: AutoRecover saves a backup of your file at set intervals in case of a crash. Excel allows you to set this interval anywhere from every 1 minute (very frequent) to every 120 minutes (every 2 hours). You cannot set it to 0 or higher than 120.

Question 4

When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?

Accepted Answer

Correct Answer: Custom List

Explanation: Excel relies on 'Custom Lists' to know the order of days and months. Lists like 'Sunday, Monday...' and 'Jan, Feb...' are built-in. Users can also create their own Custom Lists (e.g., list of employees) to use with the AutoFill handle.

Question 5

The default and maximum number of sheets for a new workbook in Excel 2003 is

Accepted Answer

Correct Answer: 3 and 255

Explanation: In Excel 2003, a new workbook opened with 3 sheets by default. The standard limit for the number of sheets you could insert via the menu was typically cited as 255 in older documentation, although strictly speaking, it is limited mainly by available system memory.

Question 6

When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as

Accepted Answer

Correct Answer: AutoComplete

Explanation: AutoComplete is a data entry convenience feature. If you type the first few letters of a word that already exists in the column above, Excel suggests the rest of the word. You can press Enter to accept the suggestion, speeding up repetitive data entry.

Question 7

By default the cell pointer moves down when you press Enter. From where can you change this setting?

Accepted Answer

Correct Answer: Tools > Options > Edit tab

Explanation: In older versions of Excel (2003), the direction of the Enter key (Down, Right, Up, Left) was controlled in the 'Edit' tab of the Options menu. In modern Excel versions, this setting is found under File > Options > Advanced.

Question 8

You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?

Accepted Answer

Correct Answer: F9

Explanation: The F9 key is the universal shortcut to 'Calculate Now'. When Excel is in Manual Calculation mode (to save processing power on large sheets), formulas do not update when you change numbers. Pressing F9 forces Excel to recalculate the entire workbook immediately.

Question 9

Which of the following is not What IF analysis tool in Excel?

Accepted Answer

Correct Answer: Macros

Explanation: Excel's dedicated What-If Analysis tools are 'Goal Seek', 'Scenario Manager', and 'Data Tables'. 'Macros' are automation scripts (VBA) used to record and repeat tasks; they are not inherently analysis tools, although they can be programmed to perform analysis.

Question 10

To apply Goal Seek command your cell pointer must be in

Accepted Answer

Correct Answer: The Result Cell where formula is entered

Explanation: When you start Goal Seek, Excel assumes the active cell is the 'Set Cell' (the one containing the formula you want to resolve). While you can manually select it later in the dialog box, it is standard practice to click on the formula cell (Result Cell) first before opening the tool.

Question 11

Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?

Accepted Answer

Correct Answer: Goal Seek

Explanation: This describes the exact function of Goal Seek. It is used when you know the 'Result' you want from a formula, but you are unsure of the 'Input' value required to get there. It iterates through values until it finds the exact number that satisfies your requirement.

Question 12

Excel is a good application for What IF analysis. Which of the following tool help you for this?

Accepted Answer

Correct Answer: Goal Seek

Explanation: Goal Seek is a fundamental 'What-If Analysis' tool in Excel. It allows you to work backwards: you tell Excel the answer you want (e.g., 'I want a monthly payment of 500'), and Goal Seek calculates what input value (e.g., 'Interest Rate') is needed to achieve that result.

Question 13

Which of the following options is not available to remove arrows of Formula Auditing?

Accepted Answer

Correct Answer: Remove all arrows for this cell

Explanation: The Formula Auditing toolbar typically provides three specific removal options: 'Remove Precedent Arrows', 'Remove Dependent Arrows', and 'Remove All Arrows' (globally). There is no specific standard button labeled 'Remove all arrows for this cell' in the default menu structure.

Question 14

The arrows created by Auditing can be removed by

Accepted Answer

Correct Answer: Both of above

Explanation: To clear the blue tracer arrows, the standard method is to click the 'Remove Arrows' button on the Formula Auditing toolbar. However, in many versions, you can also manually select the arrows and delete them. Both methods effectively clean up the worksheet view.

Question 15

The Trace Dependence in auditing shows

Accepted Answer

Correct Answer: In which formula the current cell is used

Explanation: Trace Dependents is the opposite of Precedents. It draws arrows FROM the active cell pointing to other cells. This shows you which other formulas in the workbook rely on the active cell's value, so you know what will change if you edit the current cell.

Question 16

The Trace Precedence on Auditing shows

Accepted Answer

Correct Answer: Which cells are used in current formula

Explanation: Trace Precedents is an auditing tool that draws blue arrows pointing TO the active cell. It visually shows you which other cells (Precedents) provide the data for the formula in the currently selected cell, helping you understand where the numbers are coming from.

Question 17

Which of the following is invalid regarding the Protection in Excel?

Accepted Answer

Correct Answer: All of above are valid

Explanation: Excel provides multiple levels of security. 'Protect Sheet' locks individual cells. 'Protect Workbook' prevents adding/deleting sheets. 'Protect Workspace' (available in older versions like Excel 2003) saved the layout of open windows. Therefore, all listed options represent valid protection features in the context of Excel's history.

Question 18

What is the short cut key to replace a data with another in sheet?

Accepted Answer

Correct Answer: Ctrl + H

Explanation: The keyboard shortcut 'Ctrl + H' opens the 'Find and Replace' dialog box with the Replace tab active. This allows you to quickly search for specific text or numbers (e.g., '2023') and replace them with something else (e.g., '2024') throughout the entire worksheet.

Question 19

You can move a sheet from one workbook into new book by

Accepted Answer

Correct Answer: From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Explanation: To move a sheet to a completely separate file, you use the 'Move or Copy' feature. In the dialog box, there is a dropdown labeled 'To book:'. Selecting '(new book)' from this list creates a brand new Excel file and moves your sheet into it.

Question 20

Which of the following is not true about Find and Replace in Excel

Accepted Answer

Correct Answer: You can search by rows or columns or sheets

Explanation: You can search by 'Rows' or 'Columns' (search order), and you can search within a 'Sheet' or 'Workbook'. However, the phrasing 'search by sheets' as a specific search direction/order is not a standard option in the Find dialog like Rows/Columns are. Also, options A, B, and C are definitely TRUE features.

MS Excel MCQs