Question 1

Which of the following is invalid statement?

Accepted Answer

Correct Answer: The width of a row and be specified manually or fit automatically

Explanation: This statement is invalid because in Excel terminology, Rows have 'Height' and Columns have 'Width'. You can adjust 'Row Height' and 'Column Width'. Saying 'Width of a row' is technically incorrect. The other options (coloring tabs, background pictures, auto-fitting column width) are all valid features.

Question 2

Which of the following is NOT true regarding Conditional Formatting?

Accepted Answer

Correct Answer: You can set condition to look for Bold and apply Italics on them

Explanation: Conditional Formatting in Excel is designed to format cells based on their 'Values' (numbers, text, dates) or 'Formulas'. It cannot natively check the existing formatting of a cell (like whether it is already Bold) to apply new formatting. To do that, you would need complex VBA scripts or legacy functions.

Question 3

You can check the conditions against ___ when applying conditional formatting:

Accepted Answer

Correct Answer: Both of above

Explanation: In Conditional Formatting, you can set rules based on two main criteria: 'Cell Value Is' (e.g., greater than 50) or 'Formula Is' (e.g., =A1>B1). The 'Formula' option allows for more complex and dynamic conditions that go beyond simple value comparisons, giving you full control over when the format is applied.

Question 4

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply:

Accepted Answer

Correct Answer: Apply Conditional Formatting command on Format menu

Explanation: Conditional Formatting is the correct tool for changing appearance based on cell values. You can set a rule (e.g., 'Cell Value is between 0 and 100') and define the format as Red text. The IF function changes values, not formats. Manual coloring (Option C) is static and won't update if the number changes to 101.

Question 5

You can set Page Border in Excel from:

Accepted Answer

Correct Answer: You cannot set page border in Excel

Explanation: Unlike Microsoft Word, Excel does NOT have a dedicated 'Page Border' feature. You can apply borders to individual cells or ranges of cells, but you cannot apply a border around the entire printed page automatically through a Page Border menu. Users often simulate this by adding borders to the outer cells of the print area.

Question 6

Where can you set the shading color for a range of cells in Excel?

Accepted Answer

Correct Answer: All of above

Explanation: You can change the background color (shading) of cells in several ways. The most common is using the 'Fill Color' bucket icon on the Formatting toolbar. You can also do it via the Format Cells dialog box (Patterns or Fill tab). In older Excel versions, the Drawing toolbar also offered a Fill Color tool that worked on cells.

Question 7

How can you remove borders applied in cells?

Accepted Answer

Correct Answer: Both of above

Explanation: To remove borders, you have multiple options. You can use the Border dropdown menu on the toolbar and select 'No Border'. Alternatively, you can open the Format Cells dialog box, navigate to the Border tab, and click the 'None' preset button. Both methods effectively remove all lines around the selected cells.

Question 8

Which of the following format you can decide to apply or not in AutoFormat dialog box?

Accepted Answer

Correct Answer: All of above

Explanation: When you use the AutoFormat feature, it applies a complete design. However, there is an 'Options' button in the dialog box that allows you to uncheck specific attributes. You can choose to include or exclude Number formats, Borders, Fonts, Patterns, Alignment, and Width/Height from the style being applied.

Question 9

Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from:

Accepted Answer

Correct Answer: From Format > AutoFormat

Explanation: This refers to the 'AutoFormat' feature available in older versions of Excel (like Excel 2003). By going to the Format menu and selecting AutoFormat, users could apply a collection of pre-designed styles (like Classic 1, Accounting 1, Colorful 2) to a range of data instantly. In newer Excel, this is similar to 'Format as Table'.

Question 10

Merge cells option can be applied from:

Accepted Answer

Correct Answer: Both of above

Explanation: You can merge cells in Excel using two main methods. First, you can select the cells and click the 'Merge and Center' button on the Formatting toolbar (Home tab). Second, you can open the Format Cells dialog box (Ctrl + 1), go to the Alignment tab, and check the 'Merge cells' box under Text control.

Question 11

Special category of Number tab in Format Cells dialog box can be used to apply formats like:

Accepted Answer

Correct Answer: Both of above

Explanation: The 'Special' category in the Format Cells dialog box is designed for location-specific data formats. For example, in the United States locale, it allows you to quickly format numbers as Zip Codes, Phone Numbers (e.g., (555) 123-4567), or Social Security Numbers without creating a custom format manually.

Question 12

Which function will you use to enter current time in a worksheet cell?

Accepted Answer

Correct Answer: =now()

Explanation: The =NOW() function returns the current date AND the current time. While Excel doesn't have a specific function just for 'current time' that updates dynamically without the date, =NOW() is the standard answer. You can format the cell to display only the time part if needed. =TODAY() only gives the date.

Question 13

What is entered by the function =today()?

Accepted Answer

Correct Answer: The date value for the day according to system clock

Explanation: The =TODAY() function in Excel returns the current date based on your computer's system clock. It is a dynamic function, meaning if you open the worksheet tomorrow, the date will update automatically. It does not include the time, only the date.

Question 14

When formatting a cell in Number format you can't set:

Accepted Answer

Correct Answer: Currency Symbol

Explanation: The general 'Number' format is used for general display of numbers. It allows setting decimal places, using a 1000 separator (comma), and defining how negative numbers look (e.g., in red). However, it does NOT allow adding a Currency Symbol. For symbols, you must use the 'Currency' or 'Accounting' format.

Question 15

When formatting a cell in Currency, you can specify:

Accepted Answer

Correct Answer: Both of above

Explanation: The Currency format in Excel allows you to customize how monetary values are displayed. You can choose how many decimal places to show (e.g., $10.00 vs $10) and which currency symbol to use (e.g., $, €, £, or Rs). Therefore, both options are configurable.

Question 16

You can automatically adjust the size of text in a cell if they do not fit in width by:

Accepted Answer

Correct Answer: From Format Cells dialog box mark Shrink to fit check box

Explanation: The question asks to adjust the size of the TEXT, not the column. 'Shrink to fit' automatically reduces the font size of the text so it fits inside the cell without changing the column width. Options A and B adjust the column width, not the text size.

Question 17

Can you set 0.5 inch left Indentation for a cell in Excel?

Accepted Answer

Correct Answer: Indentation can be set from Format Cells dialog box

Explanation: Yes, you can set indentation in Excel just like in Word. To do this, go to the 'Format Cells' dialog box and select the 'Alignment' tab. Under the 'Text alignment' section, you can change the 'Indent' value to 0.5 or any other number to shift the text away from the cell border.

Question 18

If you need a text to show vertically in a cell. How will you achieve this?

Accepted Answer

Correct Answer: Choose 90 Degrees in Orientation of Format Cells dialog box

Explanation: To make text appear vertically, you need to change its orientation. This is done by opening the 'Format Cells' dialog box (Ctrl + 1), going to the 'Alignment' tab, and setting the Orientation degree to 90 degrees. This rotates the text upwards, making it read vertically.

Question 19

The spelling tool is placed on which toolbar in older Excel versions?

Accepted Answer

Correct Answer: Standard

Explanation: In older versions of Excel (like Excel 2003), the Spelling tool (ABC check icon) was located on the 'Standard' toolbar for quick access. In modern versions (Excel 2007 and later), this feature has been moved to the 'Review' tab on the Ribbon, under the Proofing group.

Question 20

Which of the following is not a valid Zoom percentage in Excel?

Accepted Answer

Correct Answer: 500

Explanation: In Microsoft Excel, the Zoom range is restricted between 10% (minimum) and 400% (maximum). You cannot zoom in beyond 400% or zoom out below 10%. Therefore, 500 is an invalid zoom percentage. 10, 100, and 300 are all within the valid range.

MS Excel MCQs

Which of the following is invalid statement?

Which of the following is NOT true regarding Conditional Formatting?

You can check the conditions against ___ when applying conditional formatting:

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply:

You can set Page Border in Excel from:

Where can you set the shading color for a range of cells in Excel?

How can you remove borders applied in cells?

Which of the following format you can decide to apply or not in AutoFormat dialog box?

Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from:

Merge cells option can be applied from:

Special category of Number tab in Format Cells dialog box can be used to apply formats like:

Which function will you use to enter current time in a worksheet cell?

What is entered by the function =today()?

When formatting a cell in Number format you can't set:

When formatting a cell in Currency, you can specify:

You can automatically adjust the size of text in a cell if they do not fit in width by:

Can you set 0.5 inch left Indentation for a cell in Excel?

If you need a text to show vertically in a cell. How will you achieve this?

The spelling tool is placed on which toolbar in older Excel versions?

Which of the following is not a valid Zoom percentage in Excel?