Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Which statement best describes a workbook in Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A workbook is the Excel file in which spreadsheet work is stored.
• A workbook can contain one or more worksheets, each providing its own grid of cells.
• A cell range and an active cell are components used within worksheets, not definitions of a workbook.
• A workbook can contain one or more worksheets, each providing its own grid of cells.
• A cell range and an active cell are components used within worksheets, not definitions of a workbook.
వివరణ:
Question 2
ప్రశ్న 2
What is a worksheet in Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A worksheet is a spreadsheet page within an Excel workbook.
• It consists of rows and columns whose intersections form cells.
• A workbook can contain multiple worksheets for organizing different sets of related data.
• It consists of rows and columns whose intersections form cells.
• A workbook can contain multiple worksheets for organizing different sets of related data.
వివరణ:
Question 3
ప్రశ్న 3
How are rows identified in a standard Microsoft Excel worksheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel worksheet rows are identified by numbers displayed along the left side of the worksheet.
• The first row is Row 1, followed by Row 2, Row 3 and so on.
• Columns, in contrast, are identified by letters.
• The first row is Row 1, followed by Row 2, Row 3 and so on.
• Columns, in contrast, are identified by letters.
వివరణ:
Question 4
ప్రశ్న 4
How are columns identified in a standard Microsoft Excel worksheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel columns are identified by letters beginning with A, B, C and continuing through combinations such as AA and AB.
• Row identifiers are numeric.
• Combining a column identifier with a row number produces a cell reference such as B7.
• Row identifiers are numeric.
• Combining a column identifier with a row number produces a cell reference such as B7.
వివరణ:
Question 5
ప్రశ్న 5
What is formed at the intersection of a row and a column in an Excel worksheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A cell is the basic worksheet location formed where a row and a column intersect.
• Cells can contain values such as text, numbers, dates or formulas.
• A cell is identified by a reference combining its column and row identifiers.
• Cells can contain values such as text, numbers, dates or formulas.
• A cell is identified by a reference combining its column and row identifiers.
వివరణ:
Question 6
ప్రశ్న 6
What is meant by the active cell in Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The active cell is the currently selected cell in a worksheet.
• Data typed by the user is entered into the active cell unless another destination is selected.
• Excel visually distinguishes the active cell from surrounding cells.
• Data typed by the user is entered into the active cell unless another destination is selected.
• Excel visually distinguishes the active cell from surrounding cells.
వివరణ:
Question 7
ప్రశ్న 7
What does the Excel cell reference B5 identify?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• In the A1 reference style, the column identifier appears first and the row number follows it.
• B5 therefore means Column B, Row 5.
• A cell reference identifies one specific cell unless a range notation is used.
• B5 therefore means Column B, Row 5.
• A cell reference identifies one specific cell unless a range notation is used.
వివరణ:
Question 8
ప్రశ్న 8
How many cells are included in the Excel range A1:C3?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A1:C3 covers Columns A through C, giving 3 columns.
• It also covers Rows 1 through 3, giving 3 rows.
• Therefore the range contains 3 × 3 = 9 cells.
• It also covers Rows 1 through 3, giving 3 rows.
• Therefore the range contains 3 × 3 = 9 cells.
వివరణ:
Question 9
ప్రశ్న 9
How many rows are available in one worksheet in modern Microsoft Excel versions that use the .xlsx format?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Modern Excel worksheets support 1,048,576 rows.
• The earlier limit of 65,536 rows applied to older Excel worksheet formats.
• This row limit is a standard specification of modern Excel worksheets.
• The earlier limit of 65,536 rows applied to older Excel worksheet formats.
• This row limit is a standard specification of modern Excel worksheets.
వివరణ:
Question 10
ప్రశ్న 10
How many columns are available in one worksheet in modern Microsoft Excel versions?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Modern Excel worksheets contain 16,384 columns.
• These columns extend from A through XFD.
• The value 1,048,576 is the number of worksheet rows, not columns.
• These columns extend from A through XFD.
• The value 1,048,576 is the number of worksheet rows, not columns.
వివరణ:
Question 11
ప్రశ్న 11
What is the identifier of the last column in a modern Microsoft Excel worksheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Modern Excel provides 16,384 columns extending from Column A through Column XFD.
• XFD is therefore the final valid worksheet column identifier.
• IV was the final column in much older Excel worksheet versions that supported only 256 columns.
• XFD is therefore the final valid worksheet column identifier.
• IV was the final column in much older Excel worksheet versions that supported only 256 columns.
వివరణ:
Question 12
ప్రశ్న 12
Which file extension is the standard default workbook format for modern Microsoft Excel when macros are not required?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• .xlsx is the standard Excel Workbook file format used by modern Excel for ordinary workbooks without VBA macros.
• .docx is associated with Word, while .pptx is associated with PowerPoint.
• Macro-enabled Excel workbooks normally use a different extension such as .xlsm.
• .docx is associated with Word, while .pptx is associated with PowerPoint.
• Macro-enabled Excel workbooks normally use a different extension such as .xlsm.
వివరణ:
Question 13
ప్రశ్న 13
Which Excel interface element normally displays the reference or defined name associated with the active cell or current selection?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Name Box is located near the Formula Bar and normally displays the reference of the active cell.
• It can also display defined names associated with selected cells or ranges.
• The Name Box can additionally be used to navigate directly to a specified cell or range.
• It can also display defined names associated with selected cells or ranges.
• The Name Box can additionally be used to navigate directly to a specified cell or range.
వివరణ:
Question 14
ప్రశ్న 14
What does the colon in the Excel range reference B2:D6 indicate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A colon between two cell references identifies the continuous rectangular range between those endpoints.
• B2:D6 includes Columns B through D and Rows 2 through 6.
• The endpoint cells B2 and D6 are included in the range.
• B2:D6 includes Columns B through D and Rows 2 through 6.
• The endpoint cells B2 and D6 are included in the range.
వివరణ:
Question 15
ప్రశ్న 15
Consider the following statements about Excel fundamentals:
1. A workbook can contain more than one worksheet.
2. Rows are identified by numbers.
3. Columns are identified by letters.
4. A cell is formed at the intersection of a row and a column.
Which statements are correct?
1. A workbook can contain more than one worksheet.
2. Rows are identified by numbers.
3. Columns are identified by letters.
4. A cell is formed at the intersection of a row and a column.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A workbook can organize data across multiple worksheets.
• Excel identifies rows numerically and columns alphabetically.
• Their intersections form cells, so all four statements are correct.
• Excel identifies rows numerically and columns alphabetically.
• Their intersections form cells, so all four statements are correct.
వివరణ:
Question 16
ప్రశ్న 16
How many cells are contained in the continuous Excel range B2:D5?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Columns B through D give 3 columns: B, C and D.
• Rows 2 through 5 give 4 rows: 2, 3, 4 and 5.
• Therefore the range contains 3 × 4 = 12 cells.
• Rows 2 through 5 give 4 rows: 2, 3, 4 and 5.
• Therefore the range contains 3 × 4 = 12 cells.
వివరణ:
Question 17
ప్రశ్న 17
Assertion (A): A workbook and a worksheet are not identical concepts in Microsoft Excel.
Reason (R): A workbook is the Excel file, while a worksheet is an individual spreadsheet grid contained within that workbook.
Choose the correct answer.
Reason (R): A workbook is the Excel file, while a worksheet is an individual spreadsheet grid contained within that workbook.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A workbook is the overall Excel file used to store spreadsheet content.
• Individual worksheets are contained within that workbook and provide separate row-and-column grids.
• Both statements are true, and the Reason correctly explains the distinction made in the Assertion.
• Individual worksheets are contained within that workbook and provide separate row-and-column grids.
• Both statements are true, and the Reason correctly explains the distinction made in the Assertion.
వివరణ:
Question 18
ప్రశ్న 18
Match List I with List II:
List I
(a) Workbook
(b) Worksheet
(c) Cell
(d) Range
List II
1. One or more selected cells
2. Excel file containing spreadsheet sheets
3. Intersection of a row and column
4. Spreadsheet grid contained within a workbook
Choose the correct matching code.
List I
(a) Workbook
(b) Worksheet
(c) Cell
(d) Range
List II
1. One or more selected cells
2. Excel file containing spreadsheet sheets
3. Intersection of a row and column
4. Spreadsheet grid contained within a workbook
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A workbook is an Excel file containing worksheets, giving (a)-2.
• A worksheet is the spreadsheet grid within the workbook, while a cell is a row-column intersection, giving (b)-4 and (c)-3.
• A range consists of one or more selected or referenced cells, giving (d)-1.
• A worksheet is the spreadsheet grid within the workbook, while a cell is a row-column intersection, giving (b)-4 and (c)-3.
• A range consists of one or more selected or referenced cells, giving (d)-1.
వివరణ:
Question 19
ప్రశ్న 19
Which statement about Excel cell references is NOT correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• In the standard A1 reference style, the column identifier comes before the row number.
• The cell in Column D and Row 15 is therefore written D15, not 15D.
• C8 and A1 follow the correct pattern, while XFD1048576 is the last cell of a modern worksheet.
• The cell in Column D and Row 15 is therefore written D15, not 15D.
• C8 and A1 follow the correct pattern, while XFD1048576 is the last cell of a modern worksheet.
వివరణ:
Question 20
ప్రశ్న 20
A user selects the continuous range B2:B6 in an Excel worksheet. How many cells are selected?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• B2:B6 includes B2, B3, B4, B5 and B6.
• Both endpoints are included in the range.
• Therefore exactly 5 cells are selected.
• Both endpoints are included in the range.
• Therefore exactly 5 cells are selected.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: C. An Excel file that can contain one or more worksheets సమాధానం: C.
-
Question 2 ప్రశ్న 2Answer: A. A spreadsheet grid of rows and columns contained within a workbook సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: D. By numbers such as 1, 2 and 3 సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. By letters such as A, B, C and continuing combinations of letters సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. Cell సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: D. The currently selected cell in which data can be entered or edited సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: A. The cell at the intersection of Column B and Row 5 సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: C. 9 సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: A. 1,048,576 సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: C. 16,384 సమాధానం: C.
-
Question 11 ప్రశ్న 11Answer: D. XFD సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: B. .xlsx సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: D. Name Box సమాధానం: D.
-
Question 14 ప్రశ్న 14Answer: B. The rectangular range extending inclusively from B2 through D6 సమాధానం: B.
-
Question 15 ప్రశ్న 15Answer: D. 1, 2, 3 and 4 సమాధానం: D.
-
Question 16 ప్రశ్న 16Answer: A. 12 సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: C. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: D. (a)-2, (b)-4, (c)-3, (d)-1 సమాధానం: D.
-
Question 19 ప్రశ్న 19Answer: B. 15D is the standard A1-style reference for the cell in Column D and Row 15. సమాధానం: B.
-
Question 20 ప్రశ్న 20Answer: A. 5 సమాధానం: A.