Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
What is the main purpose of using an Excel workbook template?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An Excel template provides a reusable starting point for creating new workbooks.
• A template can contain predefined formatting, layouts, formulas and other content that should appear in workbooks based on it.
• Templates reduce repeated setup when similar workbook structures are required regularly.
• A template can contain predefined formatting, layouts, formulas and other content that should appear in workbooks based on it.
• Templates reduce repeated setup when similar workbook structures are required regularly.
వివరణ:
Question 2
ప్రశ్న 2
Which file extension is normally used for an Excel template that does not contain VBA macros?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• .xltx is the standard Excel Template format for a template that does not contain VBA macros.
• .xlsx is the standard non-macro Excel workbook format rather than a template format.
• Macro-enabled Excel templates use the .xltm extension.
• .xlsx is the standard non-macro Excel workbook format rather than a template format.
• Macro-enabled Excel templates use the .xltm extension.
వివరణ:
Question 3
ప్రశ్న 3
An Excel template must retain VBA macros so that workbooks created from it can use those macros. Which template format should be selected?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• .xltm is the Excel Macro-Enabled Template format.
• It is designed for templates that need to retain VBA macro code.
• .xltx is a template format but does not support storing VBA macros.
• It is designed for templates that need to retain VBA macro code.
• .xltx is a template format but does not support storing VBA macros.
వివరణ:
Question 4
ప్రశ్న 4
What is the primary purpose of worksheet protection in Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Worksheet protection is primarily used to control editing of cells and other protected worksheet elements.
• Specific cells can be unlocked before protection so that users can still enter or modify permitted data.
• Worksheet protection differs from workbook-structure protection and file-level encryption.
• Specific cells can be unlocked before protection so that users can still enter or modify permitted data.
• Worksheet protection differs from workbook-structure protection and file-level encryption.
వివరణ:
Question 5
ప్రశ్న 5
Which statement correctly describes the Locked property of ordinary Excel cells?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel cells are normally marked as Locked by default, but that setting is enforced when worksheet protection is applied.
• Before protecting a worksheet, cells intended for user entry can be unlocked.
• The Locked property is a worksheet-protection mechanism and is not the same as file encryption.
• Before protecting a worksheet, cells intended for user entry can be unlocked.
• The Locked property is a worksheet-protection mechanism and is not the same as file encryption.
వివరణ:
Question 6
ప్రశ్న 6
Which action is specifically associated with protecting the structure of an Excel workbook?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Protect Workbook can protect the workbook structure from structural worksheet changes.
• When structure protection is active, operations such as inserting, deleting, renaming, moving, hiding and unhiding worksheets can be unavailable.
• Workbook-structure protection is different from both worksheet protection and file-level password protection.
• When structure protection is active, operations such as inserting, deleting, renaming, moving, hiding and unhiding worksheets can be unavailable.
• Workbook-structure protection is different from both worksheet protection and file-level password protection.
వివరణ:
Question 7
ప్రశ్న 7
In desktop Excel for Windows, which procedure is used for file-level encryption when a password must be required to open the Excel file?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• File-level password encryption can be applied through File > Info > Protect Workbook > Encrypt with Password.
• The password is then required for access to the encrypted Excel file.
• This is different from Protect Sheet and Protect Workbook Structure, which control editing or workbook organization.
• The password is then required for access to the encrypted Excel file.
• This is different from Protect Sheet and Protect Workbook Structure, which control editing or workbook organization.
వివరణ:
Question 8
ప్రశ్న 8
Which statement about Excel protection is NOT correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Worksheet protection is not intended to provide the same security as file-level encryption.
• Its main role is to prevent unwanted changes to locked cells and protected worksheet elements.
• File-level encryption is the appropriate protection when access to the Excel file itself must require a password.
• Its main role is to prevent unwanted changes to locked cells and protected worksheet elements.
• File-level encryption is the appropriate protection when access to the Excel file itself must require a password.
వివరణ:
Question 9
ప్రశ్న 9
A worksheet contains formulas that users must not modify, but cells B2:B20 must remain available for data entry. What is the appropriate protection approach?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Cells that users must edit should be unlocked before worksheet protection is enabled.
• Formula cells can remain locked so that worksheet protection restricts their modification.
• This provides controlled data-entry areas while protecting other worksheet content.
• Formula cells can remain locked so that worksheet protection restricts their modification.
• This provides controlled data-entry areas while protecting other worksheet content.
వివరణ:
Question 10
ప్రశ్న 10
Which command path is normally used to change an Excel worksheet from Portrait to Landscape orientation?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Page orientation is controlled from Page Layout > Orientation.
• Landscape orientation makes the printed page wider than it is tall.
• Orientation can be set on a worksheet-by-worksheet basis.
• Landscape orientation makes the printed page wider than it is tall.
• Orientation can be set on a worksheet-by-worksheet basis.
వివరణ:
Question 11
ప్రశ్న 11
A worksheet has many columns, and the user wants all columns to fit across one printed page while allowing the rows to continue onto as many pages as necessary. Which Scale to Fit setting is appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Setting Width to 1 page makes Excel scale the worksheet so that its columns fit across one printed page.
• Leaving Height as Automatic allows the rows to extend vertically across multiple pages when necessary.
• This is useful for wide worksheets where horizontal page breaks should be minimized.
• Leaving Height as Automatic allows the rows to extend vertically across multiple pages when necessary.
• This is useful for wide worksheets where horizontal page breaks should be minimized.
వివరణ:
Question 12
ప్రశ్న 12
Only cells A1:F40 should normally be printed from a much larger worksheet. Which command is designed to save that range as the worksheet's defined print area?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Set Print Area defines the selected cells as the worksheet area intended for printing.
• Excel saves a defined print area with the workbook.
• The print area can later be expanded, ignored for a particular print job or cleared.
• Excel saves a defined print area with the workbook.
• The print area can later be expanded, ignored for a particular print job or cleared.
వివరణ:
Question 13
ప్రశ్న 13
Row 1 contains column headings that must appear at the top of every printed page of a long Excel worksheet. Which Page Setup entry correctly specifies this requirement?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Rows to repeat at top is the Print Titles setting used for repeating specified worksheet rows on every printed page.
• The reference $1:$1 represents the complete first row.
• Columns to repeat at left performs a different function by repeating selected columns on each printed page.
• The reference $1:$1 represents the complete first row.
• Columns to repeat at left performs a different function by repeating selected columns on each printed page.
వివరణ:
Question 14
ప్రశ్న 14
Which keyboard shortcut opens the Print interface and print preview in current desktop Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+P opens Excel's Print interface.
• The interface includes a preview of the worksheet together with printer and print-setting controls.
• It can be used to review the output before sending the worksheet to a printer.
• The interface includes a preview of the worksheet together with printer and print-setting controls.
• It can be used to review the output before sending the worksheet to a printer.
వివరణ:
Question 15
ప్రశ్న 15
Where is the standard Print Preview displayed when printing a worksheet in current desktop Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• File > Print opens Excel's printing interface and displays the worksheet preview.
• Users can inspect pages before printing and adjust settings such as printer, orientation, margins and scaling.
• Print Preview is therefore integrated with the normal printing workflow.
• Users can inspect pages before printing and adjust settings such as printer, orientation, margins and scaling.
• Print Preview is therefore integrated with the normal printing workflow.
వివరణ:
Question 16
ప్రశ్న 16
A worksheet contains data from A1:H200, but only the currently selected range B2:E30 should be printed for this print job. Which setting is most appropriate in the Print interface?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Print Selection limits the print job to the cells that are currently selected.
• It is appropriate for printing a temporary subset without necessarily defining a permanent Print Area.
• Print Active Sheets and Print Entire Workbook include broader worksheet content.
• It is appropriate for printing a temporary subset without necessarily defining a permanent Print Area.
• Print Active Sheets and Print Entire Workbook include broader worksheet content.
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about Excel printing and protection:
1. Print Active Sheets prints the currently active selected worksheet or worksheets.
2. Print Entire Workbook can print worksheets throughout the workbook rather than only the active sheet.
3. Protect Workbook Structure is the same operation as encrypting the file so that it cannot be opened without a password.
4. A defined Print Area can restrict which worksheet range is normally printed.
Which statements are correct?
1. Print Active Sheets prints the currently active selected worksheet or worksheets.
2. Print Entire Workbook can print worksheets throughout the workbook rather than only the active sheet.
3. Protect Workbook Structure is the same operation as encrypting the file so that it cannot be opened without a password.
4. A defined Print Area can restrict which worksheet range is normally printed.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly distinguish printing active sheets from printing the entire workbook.
• Statement 3 is false because workbook-structure protection and file encryption are separate protection mechanisms.
• Statement 4 is correct because a defined Print Area specifies the worksheet range normally included in printing.
• Statement 3 is false because workbook-structure protection and file encryption are separate protection mechanisms.
• Statement 4 is correct because a defined Print Area specifies the worksheet range normally included in printing.
వివరణ:
Question 18
ప్రశ్న 18
A worksheet is 25 columns wide and 600 rows long. In Page Layout > Scale to Fit, Width is set to 1 page and Height is set to Automatic. Which result should be expected when printing?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Width: 1 page controls the horizontal fit and scales the worksheet so all required columns fit across one page width.
• Height: Automatic does not force all 600 rows onto a single page vertically.
• The worksheet can therefore extend onto multiple pages downward while remaining one page wide.
• Height: Automatic does not force all 600 rows onto a single page vertically.
• The worksheet can therefore extend onto multiple pages downward while remaining one page wide.
వివరణ:
Question 19
ప్రశ్న 19
Assertion (A): Protecting an Excel workbook's structure can prevent users from renaming, moving, hiding or deleting worksheets.
Reason (R): Workbook structure protection is designed to restrict structural changes to the collection of worksheets in the workbook.
Choose the correct answer.
Reason (R): Workbook structure protection is designed to restrict structural changes to the collection of worksheets in the workbook.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Workbook structure protection restricts structural worksheet operations such as renaming, moving, deleting, hiding and unhiding sheets.
• Its purpose is specifically to preserve the workbook's worksheet structure.
• Both statements are true, and the Reason correctly explains the Assertion.
• Its purpose is specifically to preserve the workbook's worksheet structure.
• Both statements are true, and the Reason correctly explains the Assertion.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) .xltx
(b) Protect Sheet
(c) Protect Workbook Structure
(d) Print Area
List II
1. Restricts changes to locked worksheet cells and protected sheet elements
2. Standard non-macro Excel template format
3. Specifies the worksheet range normally intended for printing
4. Restricts structural changes such as adding, deleting or renaming worksheets
Choose the correct matching code.
List I
(a) .xltx
(b) Protect Sheet
(c) Protect Workbook Structure
(d) Print Area
List II
1. Restricts changes to locked worksheet cells and protected sheet elements
2. Standard non-macro Excel template format
3. Specifies the worksheet range normally intended for printing
4. Restricts structural changes such as adding, deleting or renaming worksheets
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• .xltx is the standard non-macro Excel template format, giving (a)-2.
• Protect Sheet restricts changes to locked worksheet elements, while Protect Workbook Structure restricts workbook-level structural changes, giving (b)-1 and (c)-4.
• Print Area specifies the range normally intended for printing, giving (d)-3.
• Protect Sheet restricts changes to locked worksheet elements, while Protect Workbook Structure restricts workbook-level structural changes, giving (b)-1 and (c)-4.
• Print Area specifies the range normally intended for printing, giving (d)-3.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: C. To create new workbooks from a reusable predefined layout, formatting or content సమాధానం: C.
-
Question 2 ప్రశ్న 2Answer: A. .xltx సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: D. .xltm సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. To restrict changes to locked cells and selected worksheet elements while permitting specified operations సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. The Locked property takes effect for restricting edits when worksheet protection is enabled. సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: D. Preventing structural changes such as adding, deleting, moving, hiding or renaming worksheets సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: A. File > Info > Protect Workbook > Encrypt with Password సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: C. Worksheet protection by itself is intended to provide the same file-access security as encrypting the Excel file with a password. సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: A. Unlock B2:B20 first, leave the formula cells locked, and then protect the worksheet. సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: C. Page Layout > Orientation > Landscape సమాధానం: C.
-
Question 11 ప్రశ్న 11Answer: B. Width: 1 page; Height: Automatic సమాధానం: B.
-
Question 12 ప్రశ్న 12Answer: D. Page Layout > Print Area > Set Print Area సమాధానం: D.
-
Question 13 ప్రశ్న 13Answer: D. Rows to repeat at top: $1:$1 సమాధానం: D.
-
Question 14 ప్రశ్న 14Answer: A. Ctrl+P సమాధానం: A.
-
Question 15 ప్రశ్న 15Answer: C. In the File > Print screen together with printing settings సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: B. Print Selection సమాధానం: B.
-
Question 17 ప్రశ్న 17Answer: B. 1, 2 and 4 only సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: C. The columns will be scaled to fit one page across, while the rows may continue onto multiple pages vertically. సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: D. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: D.
-
Question 20 ప్రశ్న 20Answer: A. (a)-2, (b)-1, (c)-4, (d)-3 సమాధానం: A.