What happens if you remove the check mark from Row & Column headers on Options dialog box?
✅ 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.
2
Which of the following cannot be hidden from Tools > Options then View tab?
✅ 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.
3
The minimum and maximum value you can set for Save AutoRecovery info in Excel are
✅ 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.
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?
✅ 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.
5
The default and maximum number of sheets for a new workbook in Excel 2003 is
✅ 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.
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
✅ 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.
7
By default the cell pointer moves down when you press Enter. From where can you change this setting?
✅ 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.
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?
✅ 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.
9
Which of the following is not What IF analysis tool in Excel?
✅ 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.
10
To apply Goal Seek command your cell pointer must be in
✅ 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.
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?
✅ 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.
12
Excel is a good application for What IF analysis. Which of the following tool help you for this?
✅ 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.
13
Which of the following options is not available to remove arrows of Formula Auditing?
✅ 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.
14
The arrows created by Auditing can be removed by
✅ 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.
15
The Trace Dependence in auditing shows
✅ 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.
16
The Trace Precedence on Auditing shows
✅ 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.
17
Which of the following is invalid regarding the Protection in Excel?
✅ 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.
18
What is the short cut key to replace a data with another in sheet?
✅ 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.
19
You can move a sheet from one workbook into new book by
✅ 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.
20
Which of the following is not true about Find and Replace in Excel
✅ 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.