Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Which key places the selected cell into Edit mode in desktop Microsoft Excel and positions the insertion point for editing its existing contents?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• F2 places the selected Excel cell into Edit mode.
• It allows the existing contents of the cell to be modified without replacing the entire entry automatically.
• Double-clicking a cell or editing through the Formula Bar are other ways of modifying existing cell contents.
• It allows the existing contents of the cell to be modified without replacing the entire entry automatically.
• Double-clicking a cell or editing through the Formula Bar are other ways of modifying existing cell contents.
వివరణ:
Question 2
ప్రశ్న 2
While editing a cell in desktop Microsoft Excel, which keyboard combination inserts a manual line break within the same cell?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Alt+Enter starts a new line at the selected position within the same Excel cell.
• This allows several lines of text to be stored and displayed inside one cell.
• Pressing Enter normally completes the current cell entry rather than inserting an internal line break.
• This allows several lines of text to be stored and displayed inside one cell.
• Pressing Enter normally completes the current cell entry rather than inserting an internal line break.
వివరణ:
Question 3
ప్రశ్న 3
Cell B5 contains the value 1500 and has Currency formatting. If B5 is selected and the Delete key is pressed without entering Edit mode, what normally happens?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Pressing Delete on a selected cell normally clears its contents rather than deleting the cell structure itself.
• Existing formatting such as number format, fill and borders can remain applied to the now-empty cell.
• Removing formatting requires an appropriate Clear Formats or related formatting operation.
• Existing formatting such as number format, fill and borders can remain applied to the now-empty cell.
• Removing formatting requires an appropriate Clear Formats or related formatting operation.
వివరణ:
Question 4
ప్రశ్న 4
Which keyboard shortcut opens the Format Cells dialog box in desktop Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+1 opens the Format Cells dialog box in desktop Excel.
• The dialog provides categories such as Number, Alignment, Font, Border, Fill and Protection.
• It is an important shortcut for detailed cell-formatting operations.
• The dialog provides categories such as Number, Alignment, Font, Border, Fill and Protection.
• It is an important shortcut for detailed cell-formatting operations.
వివరణ:
Question 5
ప్రశ్న 5
Cell A1 contains the numeric value 0.25. It is then formatted using the Percentage number format without changing the underlying value. Which statement is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Percentage formatting displays a numeric value as a percentage by multiplying its displayed representation by 100 and adding a percent sign.
• Thus the numeric value 0.25 is displayed as 25% with zero decimal places.
• Applying a number format changes how a value appears; it does not by itself replace the stored numeric value.
• Thus the numeric value 0.25 is displayed as 25% with zero decimal places.
• Applying a number format changes how a value appears; it does not by itself replace the stored numeric value.
వివరణ:
Question 6
ప్రశ్న 6
A cell contains 1265.5 and should display the value with a thousands separator and two decimal places, such as 1,265.50, without converting it to text. Which Excel number-format category is suitable?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Number category provides controls for decimal places and the use of a thousands separator.
• It preserves the value as numeric data so that calculations can continue to use it normally.
• Text, Date and Percentage formats have different display purposes.
• It preserves the value as numeric data so that calculations can continue to use it normally.
• Text, Date and Percentage formats have different display purposes.
వివరణ:
Question 7
ప్రశ్న 7
An Excel cell contains a valid date value and currently displays it as 3/15/2026. The user wants it to display as 15-Mar-26 without changing the underlying date. Which action is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel dates can be displayed in different forms by applying different date number formats.
• Changing the display from 3/15/2026 to 15-Mar-26 does not require changing the underlying date value.
• Keeping the value as a real date preserves its usefulness in date calculations and sorting.
• Changing the display from 3/15/2026 to 15-Mar-26 does not require changing the underlying date value.
• Keeping the value as a real date preserves its usefulness in date calculations and sorting.
వివరణ:
Question 8
ప్రశ్న 8
A cell contains a long sentence that should appear on several lines within the same cell without manually widening the column. Which Excel command is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Wrap Text displays cell content on multiple lines so that it fits within the available column width.
• The wrapping adjusts if the column width later changes.
• If all wrapped lines are not visible, the row height may need to be increased or automatically fitted.
• The wrapping adjusts if the column width later changes.
• If all wrapped lines are not visible, the row height may need to be increased or automatically fitted.
వివరణ:
Question 9
ప్రశ్న 9
Which Alignment command places the contents of a selected Excel cell horizontally in the middle between its left and right boundaries?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Center alignment positions cell contents horizontally between the left and right sides of the cell.
• Align Left and Align Right control other horizontal positions.
• Middle Align is a vertical-alignment command and therefore affects a different direction.
• Align Left and Align Right control other horizontal positions.
• Middle Align is a vertical-alignment command and therefore affects a different direction.
వివరణ:
Question 10
ప్రశ్న 10
A row has been made taller, and the text in a cell should be positioned vertically midway between the top and bottom edges of that cell. Which alignment option should be used?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Middle Align positions cell content vertically between the top and bottom edges of the cell.
• Top Align and Bottom Align position the content at the respective vertical edges.
• Center by itself refers to horizontal centering in the standard Excel Alignment group.
• Top Align and Bottom Align position the content at the respective vertical edges.
• Center by itself refers to horizontal centering in the standard Excel Alignment group.
వివరణ:
Question 11
ప్రశ్న 11
Cell A1 has the exact font, fill, border and number formatting required for several other cells, but its value must not be copied. Which Excel feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Format Painter copies formatting from one cell or range and applies it to another location.
• It is appropriate when visual and number formatting should be transferred without intentionally copying the source cell's value.
• AutoSum and Flash Fill perform different data-processing operations.
• It is appropriate when visual and number formatting should be transferred without intentionally copying the source cell's value.
• AutoSum and Flash Fill perform different data-processing operations.
వివరణ:
Question 12
ప్రశ్న 12
A cell contains the value 2500 with bold text, yellow fill and Currency formatting. The user wants to keep the value 2500 but remove the applied formatting. Which operation is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Clear Formats removes formatting while retaining the cell's underlying content.
• Formatting can include font settings, fills, borders, alignment and number-format appearance.
• Clear All would remove more than just formatting, while Delete normally clears cell contents rather than serving as the specific Clear Formats command.
• Formatting can include font settings, fills, borders, alignment and number-format appearance.
• Clear All would remove more than just formatting, while Delete normally clears cell contents rather than serving as the specific Clear Formats command.
వివరణ:
Question 13
ప్రశ్న 13
Which Excel formatting command changes the background colour of selected cells without changing the colour of the characters themselves?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Fill Color changes the background or fill appearance of selected cells.
• Font Color changes the visible colour of text or numbers themselves.
• Borders affect the lines around cells, while Number Format affects how numeric values are displayed.
• Font Color changes the visible colour of text or numbers themselves.
• Borders affect the lines around cells, while Number Format affects how numeric values are displayed.
వివరణ:
Question 14
ప్రశ్న 14
A column contains entries of different lengths, and its width should automatically adjust to fit the longest visible cell content. Which Excel operation is designed for this purpose?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• AutoFit Column Width automatically adjusts the selected column width according to its contents.
• It is useful when a column is too narrow or unnecessarily wide for the data it contains.
• Wrap Text instead keeps the existing column width and places content on multiple lines where necessary.
• It is useful when a column is too narrow or unnecessarily wide for the data it contains.
• Wrap Text instead keeps the existing column width and places content on multiple lines where necessary.
వివరణ:
Question 15
ప్రశ్న 15
A worksheet heading must be displayed diagonally inside its cell to save horizontal space. Which Excel formatting feature is intended for changing the angle of cell text?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Orientation controls the angle or rotation of text displayed within cells in desktop Excel.
• It can be used to display headings vertically or diagonally when appropriate.
• Wrap Text changes line wrapping, while Merge & Center combines cells and centers content.
• It can be used to display headings vertically or diagonally when appropriate.
• Wrap Text changes line wrapping, while Merge & Center combines cells and centers content.
వివరణ:
Question 16
ప్రశ్న 16
The cells B2:D10 must all receive the same Currency number format and two decimal places. Which procedure is most efficient?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel formatting can be applied to an entire selected cell range at one time.
• Selecting B2:D10 and applying the required format avoids unnecessary repetitive formatting of individual cells.
• The underlying values can remain numeric and continue to participate in calculations.
• Selecting B2:D10 and applying the required format avoids unnecessary repetitive formatting of individual cells.
• The underlying values can remain numeric and continue to participate in calculations.
వివరణ:
Question 17
ప్రశ్న 17
Which statement about Excel's General number format is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• General is Excel's default general-purpose cell number format.
• It does not intentionally apply a specialized representation such as Currency or Percentage.
• Excel may still display values in different convenient forms depending on their content and available column width.
• It does not intentionally apply a specialized representation such as Currency or Percentage.
• Excel may still display values in different convenient forms depending on their content and available column width.
వివరణ:
Question 18
ప్రశ్న 18
A cell contains the value 12.3456 and currently displays 12.35. The user wants to show one additional decimal place without changing the stored numeric value. Which formatting operation should be used?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Increase Decimal increases the number of decimal places shown for selected numeric cells.
• In this example, displaying one additional decimal place can show 12.346 according to normal rounding of the stored value 12.3456.
• The formatting operation changes the displayed precision rather than replacing the underlying numeric value.
• In this example, displaying one additional decimal place can show 12.346 according to normal rounding of the stored value 12.3456.
• The formatting operation changes the displayed precision rather than replacing the underlying numeric value.
వివరణ:
Question 19
ప్రశ్న 19
Consider the following statements about Excel cell formatting:
1. A number format can change how a numeric value appears without necessarily changing the stored value.
2. Wrap Text can display cell content on multiple lines.
3. Fill Color changes the background appearance of selected cells.
4. Clear Formats is specifically intended to delete the cell's data while preserving all formatting.
Which statements are correct?
1. A number format can change how a numeric value appears without necessarily changing the stored value.
2. Wrap Text can display cell content on multiple lines.
3. Fill Color changes the background appearance of selected cells.
4. Clear Formats is specifically intended to delete the cell's data while preserving all formatting.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1, 2 and 3 correctly describe number formatting, Wrap Text and Fill Color.
• Statement 4 is false because Clear Formats removes formatting while retaining the cell contents.
• Clearing cell contents and clearing cell formats are distinct Excel operations.
• Statement 4 is false because Clear Formats removes formatting while retaining the cell contents.
• Clearing cell contents and clearing cell formats are distinct Excel operations.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) F2
(b) Ctrl+1
(c) Alt+Enter
(d) Wrap Text
List II
1. Opens the Format Cells dialog box
2. Inserts a manual line break within a cell
3. Edits the selected cell
4. Automatically displays long cell content on multiple lines according to available width
Choose the correct matching code.
List I
(a) F2
(b) Ctrl+1
(c) Alt+Enter
(d) Wrap Text
List II
1. Opens the Format Cells dialog box
2. Inserts a manual line break within a cell
3. Edits the selected cell
4. Automatically displays long cell content on multiple lines according to available width
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• F2 edits the selected cell, giving (a)-3, while Ctrl+1 opens Format Cells, giving (b)-1.
• Alt+Enter inserts a manual line break within the cell, giving (c)-2.
• Wrap Text automatically displays long cell content on multiple lines according to the available width, giving (d)-4.
• Alt+Enter inserts a manual line break within the cell, giving (c)-2.
• Wrap Text automatically displays long cell content on multiple lines according to the available width, giving (d)-4.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. F2 సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: C. Alt+Enter సమాధానం: C.
-
Question 3 ప్రశ్న 3Answer: A. The cell contents are cleared, but the existing cell formatting remains. సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: D. Ctrl+1 సమాధానం: D.
-
Question 5 ప్రశ్న 5Answer: D. The cell can display 25% while the underlying numeric value remains 0.25. సమాధానం: D.
-
Question 6 ప్రశ్న 6Answer: B. Number సమాధానం: B.
-
Question 7 ప్రశ్న 7Answer: C. Apply an appropriate Date or custom date number format. సమాధానం: C.
-
Question 8 ప్రశ్న 8Answer: A. Wrap Text సమాధానం: A.
-
Question 9 ప్రశ్న 9Answer: B. Center సమాధానం: B.
-
Question 10 ప్రశ్న 10Answer: D. Middle Align సమాధానం: D.
-
Question 11 ప్రశ్న 11Answer: A. Format Painter సమాధానం: A.
-
Question 12 ప్రశ్న 12Answer: C. Home > Clear > Clear Formats సమాధానం: C.
-
Question 13 ప్రశ్న 13Answer: C. Fill Color సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: B. AutoFit Column Width సమాధానం: B.
-
Question 15 ప్రశ్న 15Answer: D. Orientation సమాధానం: D.
-
Question 16 ప్రశ్న 16Answer: A. Select B2:D10 and apply the required formatting to the entire selected range. సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: D. It is the default general-purpose number format and does not impose a specialized format such as Currency, Percentage or Date. సమాధానం: D.
-
Question 18 ప్రశ్న 18Answer: C. Increase Decimal సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: A. 1, 2 and 3 only సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: B. (a)-3, (b)-1, (c)-2, (d)-4 సమాధానం: B.