✅ 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.
242
Which of the following is NOT true regarding Conditional Formatting?
✅ 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.
243
You can check the conditions against ___ when applying conditional formatting:
✅ 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.
244
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply:
✅ 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.
245
You can set Page Border in Excel from:
✅ 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.
246
Where can you set the shading color for a range of cells in Excel?
✅ 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.
247
How can you remove borders applied in cells?
✅ 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.
248
Which of the following format you can decide to apply or not in AutoFormat dialog box?
✅ 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.
249
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from:
✅ 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'.
250
Merge cells option can be applied from:
✅ 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.
251
Special category of Number tab in Format Cells dialog box can be used to apply formats like:
✅ 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.
252
Which function will you use to enter current time in a worksheet cell?
✅ 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.
253
What is entered by the function =today()?
✅ 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.
254
When formatting a cell in Number format you can't set:
✅ 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.
255
When formatting a cell in Currency, you can specify:
✅ 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.
256
You can automatically adjust the size of text in a cell if they do not fit in width by:
✅ 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.
257
Can you set 0.5 inch left Indentation for a cell in Excel?
✅ 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.
258
If you need a text to show vertically in a cell. How will you achieve this?
✅ 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.
259
The spelling tool is placed on which toolbar in older Excel versions?
✅ 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.
260
Which of the following is not a valid Zoom percentage in Excel?
✅ 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.