Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
A long Microsoft Word document uses Heading 1, Heading 2 and Heading 3 styles correctly. Which feature provides a hierarchical list of those headings and can help the user navigate quickly to different sections?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Navigation Pane can display document headings when appropriate heading styles are used.
• Clicking a heading allows the user to navigate directly to that part of a long document.
• Mail Merge creates personalized documents, while Format Painter copies formatting.
• Clicking a heading allows the user to navigate directly to that part of a long document.
• Mail Merge creates personalized documents, while Format Painter copies formatting.
వివరణ:
Question 2
ప్రశ్న 2
An Excel table has been filtered so that some rows are hidden by the filter. Which formula returns the SUM of the visible filtered records in D2:D100 while excluding rows hidden by the filter?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• SUBTOTAL can perform calculations on a filtered list while excluding rows removed from view by filtering.
• Function number 9 specifies the SUM operation.
• Therefore =SUBTOTAL(9,D2:D100) calculates the sum of the records remaining visible after filtering.
• Function number 9 specifies the SUM operation.
• Therefore =SUBTOTAL(9,D2:D100) calculates the sum of the records remaining visible after filtering.
వివరణ:
Question 3
ప్రశ్న 3
A PowerPoint presenter wants to print one slide per page together with the speaker notes associated with that slide. Which print layout is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Notes Pages are designed to present each slide together with its associated speaker notes.
• They are useful when the presenter needs a printed reference containing both visual content and explanatory notes.
• Handouts primarily arrange multiple slide thumbnails for audience distribution.
• They are useful when the presenter needs a printed reference containing both visual content and explanatory notes.
• Handouts primarily arrange multiple slide thumbnails for audience distribution.
వివరణ:
Question 4
ప్రశ్న 4
An Access database receives 500 new employee records from an imported temporary table. The records must be added to the end of an existing Employees table without replacing existing records. Which query type is designed for this task?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An Append query adds records from one source to an existing destination table.
• Existing records in the destination are retained while qualifying new records are inserted.
• An Update query changes existing records, whereas a Delete query removes them.
• Existing records in the destination are retained while qualifying new records are inserted.
• An Update query changes existing records, whereas a Delete query removes them.
వివరణ:
Question 5
ప్రశ్న 5
A department maintains employee names, addresses and reference numbers in an Excel worksheet and needs to produce 1,000 personalized appointment letters. Which Office workflow is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Word Mail Merge combines a standard main document with recipient information from a structured data source.
• An Excel worksheet can provide fields such as employee name, address and reference number.
• This generates large numbers of personalized letters without manually creating each one.
• An Excel worksheet can provide fields such as employee name, address and reference number.
• This generates large numbers of personalized letters without manually creating each one.
వివరణ:
Question 6
ప్రశ్న 6
Cell C2 in Excel contains the formula =$A2*B$1. The formula is copied to cell E5. What formula will appear in E5?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Moving from C2 to E5 shifts the formula two columns right and three rows down.
• $A2 keeps column A fixed while relative row 2 changes to row 5, producing $A5.
• B$1 keeps row 1 fixed while relative column B moves two columns to D, producing D$1.
• $A2 keeps column A fixed while relative row 2 changes to row 5, producing $A5.
• B$1 keeps row 1 fixed while relative column B moves two columns to D, producing D$1.
వివరణ:
Question 7
ప్రశ్న 7
A Word report requires a special header on only the first page, while all later pages should use another header. Which Word option is specifically intended for this requirement within a section?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Different First Page permits the first page of a section to have a header or footer different from subsequent pages.
• It is commonly useful for title pages, official reports and chapter openings.
• Track Changes records revisions and does not control first-page header behavior.
• It is commonly useful for title pages, official reports and chapter openings.
• Track Changes records revisions and does not control first-page header behavior.
వివరణ:
Question 8
ప్రశ్న 8
An Access query must display CaseID from the Cases table together with OfficerName from the Officers table. Cases.OfficerID is related to Officers.OfficerID. Which design is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A relational join combines related records from separate tables using matching key values.
• The query can retrieve CaseID from Cases and OfficerName from the corresponding Officers record.
• This preserves normalized storage instead of unnecessarily duplicating officer information.
• The query can retrieve CaseID from Cases and OfficerName from the corresponding Officers record.
• This preserves normalized storage instead of unnecessarily duplicating officer information.
వివరణ:
Question 9
ప్రశ్న 9
Several shapes in PowerPoint are aligned horizontally but the spacing between adjacent shapes is uneven. Which Arrange operation is specifically intended to make their horizontal spacing even?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Distribute Horizontally adjusts selected objects so that the horizontal spacing between them is even.
• Alignment and distribution are different operations: alignment positions objects relative to an edge or center line.
• Grouping combines objects for joint manipulation but does not itself equalize spacing.
• Alignment and distribution are different operations: alignment positions objects relative to an edge or center line.
• Grouping combines objects for joint manipulation but does not itself equalize spacing.
వివరణ:
Question 10
ప్రశ్న 10
An Excel worksheet should allow users to choose a case status only from the values Open, Pending and Closed. Which feature is most appropriate for creating this controlled drop-down list in cells?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data Validation can restrict the values permitted in selected cells.
• Choosing the List validation type allows users to select from predefined entries such as Open, Pending and Closed.
• This helps improve consistency and reduces data-entry variations.
• Choosing the List validation type allows users to select from predefined entries such as Open, Pending and Closed.
• This helps improve consistency and reduces data-entry variations.
వివరణ:
Question 11
ప్రశ్న 11
An Access database contains Employees and TrainingRecords tables. The administrator needs to identify employees who have no corresponding training record. Which Access feature is specifically designed to help create such a query?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Find Unmatched Query Wizard helps identify records in one table that have no related record in another table.
• It is suitable for finding employees without corresponding training records.
• Form and Report Wizards create interface or presentation objects rather than this type of relational comparison.
• It is suitable for finding employees without corresponding training records.
• Form and Report Wizards create interface or presentation objects rather than this type of relational comparison.
వివరణ:
Question 12
ప్రశ్న 12
A PowerPoint presentation contains several embedded video and audio files and has become very large. Which built-in operation can reduce the size of supported embedded media?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PowerPoint's Compress Media operation can reduce the size of supported embedded audio and video content.
• Compression can lower presentation file size, although quality may be reduced depending on the selected settings.
• Slide Sorter and Animation Painter do not compress multimedia files.
• Compression can lower presentation file size, although quality may be reduced depending on the selected settings.
• Slide Sorter and Animation Painter do not compress multimedia files.
వివరణ:
Question 13
ప్రశ్న 13
A Word document should be distributed so that most users can read it but are prevented from making unrestricted edits. Which Word feature is specifically intended to apply editing restrictions?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Restrict Editing can limit the types of changes users are permitted to make in a Word document.
• Depending on configuration, editing can be restricted while selected exceptions or permitted operations remain available.
• Word Count and Format Painter do not provide document-editing access restrictions.
• Depending on configuration, editing can be restricted while selected exceptions or permitted operations remain available.
• Word Count and Format Painter do not provide document-editing access restrictions.
వివరణ:
Question 14
ప్రశ్న 14
In Excel, B2:B6 contain District values {East, West, East, East, West}, C2:C6 contain Status values {Open, Open, Closed, Open, Closed}, and D2:D6 contain Amount values {100, 200, 300, 400, 500}. What is returned by =SUMIFS(D2:D6,B2:B6,"East",C2:C6,"Open")?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• SUMIFS adds Amount only for rows satisfying all specified conditions.
• East and Open occur together in the first row with Amount 100 and the fourth row with Amount 400.
• Therefore the result is 100 + 400 = 500.
• East and Open occur together in the first row with Amount 100 and the fourth row with Amount 400.
• Therefore the result is 100 + 400 = 500.
వివరణ:
Question 15
ప్రశ్న 15
An Access report displays records grouped by District. The administrator wants to add grouping levels and specify sorting for the report without redesigning the underlying tables. Which report feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Group, Sort, and Total controls how records are organized and summarized within an Access report.
• It can create grouping levels and sorting rules based on selected fields.
• These report-layout operations do not require changing the structure of the underlying tables.
• It can create grouping levels and sorting rules based on selected fields.
• These report-layout operations do not require changing the structure of the underlying tables.
వివరణ:
Question 16
ప్రశ్న 16
A department must maintain Cases, Officers, EvidenceItems and Locations as related entities with primary keys, foreign keys, controlled forms and reusable queries. Which Microsoft Office application is the most appropriate primary tool?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access is designed for relational database management using related tables, keys and relationships.
• Queries retrieve or manipulate data, while forms provide structured user interfaces for working with records.
• Word, PowerPoint and a simple Excel worksheet do not provide the same relational database framework.
• Queries retrieve or manipulate data, while forms provide structured user interfaces for working with records.
• Word, PowerPoint and a simple Excel worksheet do not provide the same relational database framework.
వివరణ:
Question 17
ప్రశ్న 17
Two versions of a Word document were edited independently, and the author wants Word to identify the differences between them as revisions. Which feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Word's Compare feature compares two document versions and identifies differences between them.
• The detected differences can be presented as revisions for review.
• Track Changes records edits while they are being made, whereas Compare is useful when separate versions already exist.
• The detected differences can be presented as revisions for review.
• Track Changes records edits while they are being made, whereas Compare is useful when separate versions already exist.
వివరణ:
Question 18
ప్రశ్న 18
A PowerPoint presenter wants to record slide timings together with spoken narration for a self-running presentation. Which feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Record Slide Show supports recording narration and presentation timing information.
• The resulting presentation can reproduce the recorded delivery more automatically.
• Selection Pane manages slide objects, while Handout Master controls printed handout formatting.
• The resulting presentation can reproduce the recorded delivery more automatically.
• Selection Pane manages slide objects, while Handout Master controls printed handout formatting.
వివరణ:
Question 19
ప్రశ్న 19
A newly installed SATA hard disk does not appear anywhere in UEFI/BIOS storage information. Which action is the most appropriate first troubleshooting step?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• If the firmware cannot detect a SATA drive, hardware connectivity must be checked before operating-system configuration.
• A SATA drive normally requires both an appropriate data connection and power connection.
• Office application settings cannot influence whether firmware electrically detects the storage device.
• A SATA drive normally requires both an appropriate data connection and power connection.
• Office application settings cannot influence whether firmware electrically detects the storage device.
వివరణ:
Question 20
ప్రశ్న 20
Several unnecessary programs launch automatically whenever a user signs in to Windows, increasing startup time. Which Windows tool can be used to review and disable many startup applications?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Task Manager includes management of applications configured to start automatically with user sign-in in supported Windows versions.
• Disabling unnecessary startup items can reduce the number of applications launched during startup.
• Disk Management manages disks and volumes rather than startup applications.
• Disabling unnecessary startup items can reduce the number of applications launched during startup.
• Disk Management manages disks and volumes rather than startup applications.
వివరణ:
Question 21
ప్రశ్న 21
Which statement correctly distinguishes the normal roles of an Ethernet switch and an IP router?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ethernet switches normally forward frames within a local network according to MAC-address information.
• Routers forward IP packets between different IP networks according to routing information.
• The two devices therefore operate at different logical networking functions even when both are present in one integrated appliance.
• Routers forward IP packets between different IP networks according to routing information.
• The two devices therefore operate at different logical networking functions even when both are present in one integrated appliance.
వివరణ:
Question 22
ప్రశ్న 22
A user signs in using a password and then confirms identity with a fingerprint. Assuming both are independently verified, which security concept is demonstrated?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A password is a knowledge factor: something the user knows.
• A fingerprint is an inherence or biometric factor: something the user is.
• Using independently verified factors from different categories constitutes multi-factor authentication.
• A fingerprint is an inherence or biometric factor: something the user is.
• Using independently verified factors from different categories constitutes multi-factor authentication.
వివరణ:
Question 23
ప్రశ్న 23
An internal HR portal uses HTTPS and web browsers but is intended only for authorized employees inside the organization or connected through approved remote access. How is the portal best classified?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An intranet is a private organizational information environment intended for authorized users.
• It can use the same technologies as public Internet services, including HTTPS and web browsers.
• Use of Internet technologies does not make an internal restricted service part of the public Internet.
• It can use the same technologies as public Internet services, including HTTPS and web browsers.
• Use of Internet technologies does not make an internal restricted service part of the public Internet.
వివరణ:
Question 24
ప్రశ్న 24
A firewall permits a workstation to initiate an outbound TCP session and then automatically recognizes valid return packets as belonging to that established session. Which firewall capability is being used?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Stateful inspection maintains information about active network connections.
• Incoming packets can therefore be evaluated in the context of an existing permitted session.
• A basic stateless filter evaluates packets independently without equivalent connection-state tracking.
• Incoming packets can therefore be evaluated in the context of an existing permitted session.
• A basic stateless filter evaluates packets independently without equivalent connection-state tracking.
వివరణ:
Question 25
ప్రశ్న 25
A police unit needs one integrated Office workflow for structured case records, statistical analysis, formal written reports and briefing presentations. Which allocation of applications is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access is suited to structured relational records, relationships, queries and forms.
• Excel is optimized for spreadsheet calculations and analysis, while Word is suited to formal text documents.
• PowerPoint is designed for slide-based presentations, so the listed workflow assigns each application according to its principal strengths.
• Excel is optimized for spreadsheet calculations and analysis, while Word is suited to formal text documents.
• PowerPoint is designed for slide-based presentations, so the listed workflow assigns each application according to its principal strengths.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. Navigation Pane సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: D. =SUBTOTAL(9,D2:D100) సమాధానం: D.
-
Question 3 ప్రశ్న 3Answer: A. Notes Pages సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: C. Append query సమాధానం: C.
-
Question 5 ప్రశ్న 5Answer: A. Use Word Mail Merge with the Excel worksheet as the recipient data source. సమాధానం: A.
-
Question 6 ప్రశ్న 6Answer: B. =$A5*D$1 సమాధానం: B.
-
Question 7 ప్రశ్న 7Answer: D. Different First Page సమాధానం: D.
-
Question 8 ప్రశ్న 8Answer: C. Create a Select query joining the two tables on their related OfficerID fields. సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: B. Distribute Horizontally సమాధానం: B.
-
Question 10 ప్రశ్న 10Answer: A. Data Validation using a List సమాధానం: A.
-
Question 11 ప్రశ్న 11Answer: C. Find Unmatched Query Wizard సమాధానం: C.
-
Question 12 ప్రశ్న 12Answer: D. Compress Media సమాధానం: D.
-
Question 13 ప్రశ్న 13Answer: A. Restrict Editing సమాధానం: A.
-
Question 14 ప్రశ్న 14Answer: C. 500 సమాధానం: C.
-
Question 15 ప్రశ్న 15Answer: B. Group, Sort, and Total సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: D. Microsoft Access సమాధానం: D.
-
Question 17 ప్రశ్న 17Answer: C. Compare Documents సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: A. Record Slide Show సమాధానం: A.
-
Question 19 ప్రశ్న 19Answer: D. Check the drive's power cable, SATA data cable and motherboard SATA connection. సమాధానం: D.
-
Question 20 ప్రశ్న 20Answer: B. Task Manager సమాధానం: B.
-
Question 21 ప్రశ్న 21Answer: C. A switch primarily forwards frames within a LAN using MAC-address information, while a router forwards IP packets between different networks. సమాధానం: C.
-
Question 22 ప్రశ్న 22Answer: A. Multi-factor authentication using a knowledge factor and a biometric factor సమాధానం: A.
-
Question 23 ప్రశ్న 23Answer: B. Intranet service సమాధానం: B.
-
Question 24 ప్రశ్న 24Answer: D. Stateful inspection సమాధానం: D.
-
Question 25 ప్రశ్న 25Answer: A. Access for structured relational case data; Excel for calculations and analysis; Word for formal reports; PowerPoint for briefing presentations సమాధానం: A.