• A) To store data
• B) To execute instructions
• C) To process data
• D) To display output

• A) Hard Drive
• B) ROM
• C) RAM
• D) GPU

• A) Manages power supply
• B) Connects and allows communication between various components
• C) Houses the CPU, memory, and other essential components
• D) Provides cooling to the CPU

• A) Hard Drive
• B) RAM
• C) CPU
• D) GPU

• A) To cool the computer
• B) To manage data storage
• C) To convert AC power to DC power for internal components
• D) To process data

• A) 10 MB
• B) 100 MB
• C) 2 GB
• D) 4 GB

• A) It compresses the file size significantly
• B) It supports only ASCII characters
• C) It ensures compatibility with multiple languages and special characters
• D) It allows for variable-length character encoding, making it compatible with a wide range of characters

• A) Go to the Home tab and choose Font Style
• B) Right-click the text and select Font Style
• C) Go to the Home tab and select Font, then choose the desired style
• D) Use the shortcut Ctrl + F

• A) Go to Insert tab and select Picture
• B) Drag and drop the image into the document
• C) Go to the Home tab and click on Insert, then choose Picture
• D) Use the shortcut Ctrl + P

• A) Deletes a file or directory
• B) Displays a list of files and directories
• C) Lists the contents of a directory
• D) Creates a new directory

• A) `DEL directory`
• B) `MKDIR directory`
• C) `MD directory`
• D) `CREATE directory`

• A) To move files from one location to another
• B) To delete files
• C) To duplicate files
• D) To display file contents

• A) Go to File > Options > Document Inspector
• B) Go to Review > Document Inspector
• C) Go to File > Info > Check for Issues > Inspect Document
• D) Use the View tab and select Document Inspector

• A) AutoText stores pre-defined text blocks, while Quick Parts includes more complex reusable content
• B) AutoText is a subset of Quick Parts designed specifically for frequently used text snippets
• C) Quick Parts is used for text formatting, while AutoText is for inserting images
• D) Quick Parts and AutoText are the same feature under different names

• A) Go to View > Customize Ribbon
• B) Use the Design tab to add a new tab
• C) Go to File > Options > Customize Ribbon, then add a new tab and commands
• D) Use the Home tab and select Customize Ribbon

• A) It allows for advanced formatting; enabled via the View tab
• B) It is used for creating custom templates; enabled via the Design tab
• C) It provides tools for creating macros, forms, and advanced document properties; enabled via File > Options > Customize Ribbon
• D) It is used for inserting data fields; enabled via the Insert tab

• A) Go to File > Options > Quick Access Toolbar
• B) Use the Home tab and select Customize Shortcuts
• C) Go to File > Options > Customize Ribbon > Customize Keyboard Shortcuts
• D) Use the Developer tab to create shortcuts

• A) They are used for document formatting; applied via the Home tab
• B) They enable the insertion of images into documents; managed through the Insert tab
• C) They are used for adding structured data fields, such as text boxes, drop-down lists, and date pickers in forms; accessible via the Developer tab
• D) They track document changes; configured through the Review tab

• A) By creating a new document and linking to sub-documents
• B) By using the Table of Contents to navigate through sections
• C) By creating a Master Document that contains links to multiple sub-documents, allowing for easier organization and management of large documents
• D) By applying document styles for consistency

• A) They manage document security settings; edited via the Review tab
• B) They include metadata like author, title, and keywords; edited via File > Info > Properties
• C) They provide information about the document's metadata and characteristics; edited via File > Info > Properties
• D) They allow for document formatting; edited via the Design tab

• A) Use the References tab to insert citations and generate a bibliography
• B) Manually create a bibliography using the Insert tab
• C) Use the References tab to add sources and then insert a bibliography based on the citations
• D) Use the Review tab to add bibliographic information

• A) It applies color changes to text; accessed via the Home tab
• B) It allows for text transformations such as shadows, glows, and reflections; applied via the Home tab > Text Effects
• C) It adds visual enhancements such as shadows, glows, and reflections to text; accessed via the Home tab > Text Effects
• D) It manages font sizes and styles; edited via the Font tab

• A) Go to Review > Track Changes
• B) Go to View > Compare
• C) Go to Review > Compare and select the two documents to compare
• D) Use the File tab to access version history

• A) INDEX retrieves the value, and MATCH finds the position of the value
• B) MATCH retrieves the value, and INDEX finds the position of the value
• C) INDEX returns the value at a given position, and MATCH finds the position of the value in a specified range
• D) INDEX and MATCH are not used together for lookups

• A) It calculates the average of a range of cells
• B) It returns a cell reference that is a specified number of rows and columns from a starting cell
• C) It returns a cell or range of cells that is offset from a starting cell by a specified number of rows and columns, used for creating dynamic ranges
• D) It formats the cells in a specified range

• A) It applies a formula to a range of cells; it is available in Excel 2019
• B) It allows for array calculations without needing to use Ctrl + Shift + Enter; limited to a single column
• C) It allows for array calculations across multiple cells; however, it is not a built-in function in Excel 2019 and requires array formulas instead
• D) It performs multiple calculations on a single cell

• A) To apply conditional formatting; use the Home tab
• B) To restrict the type of data entered into a cell; use the Data tab and select Data Validation, then choose List
• C) To set rules for what data can be entered into a cell; use the Data tab, select Data Validation, and create a drop-down list from a list of values
• D) To format cells based on their values; use the Format tab

• A) By specifying the lookup value, the table array, the column index number, and whether an exact or approximate match is required
• B) By specifying the value to search for, the table range, the column to return the value from, and the match type
• C) By entering the value directly into the cell
• D) By sorting the data before applying the function

• A) COUNTIF counts cells that meet one criterion, while COUNTIFS counts cells that meet multiple criteria
• B) COUNTIF counts cells based on one condition, while COUNTIFS counts cells based on multiple conditions across different ranges
• C) COUNTIF counts cells in a single range, while COUNTIFS counts cells in multiple ranges
• D) COUNTIF and COUNTIFS are identical functions

• A) By manually copying and pasting data into the worksheet
• B) By using the 'Get External Data' feature under the Data tab
• C) By using the 'Get & Transform Data' section in the Data tab to connect to external sources and apply transformations
• D) By importing data using the File tab

• A) It solves basic arithmetic problems
• B) It analyzes data using statistical methods
• C) It performs optimization by finding the best solution to a problem with multiple constraints; accessed via the Data tab after enabling the add-in
• D) It visualizes data trends

• A) By entering each cell reference separated by commas
• B) By using the 'Text to Columns' feature
• C) By specifying the cells to combine as arguments in the CONCAT function
• D) By copying and pasting text from different cells

• A) Dynamic Arrays are used for static data; SEQUENCE is not available
• B) Dynamic Arrays automatically expand to accommodate multiple results; SEQUENCE generates an array of sequential numbers based on specified parameters
• C) Dynamic Arrays allow for formulas that return multiple results to spill over into adjacent cells; SEQUENCE creates a range of sequential numbers dynamically
• D) Dynamic Arrays are used for sorting data; SEQUENCE is used for filtering

• A) By applying the same design template to each slide individually
• B) By formatting each slide separately
• C) By accessing the Slide Master view to make changes that apply to all slides, such as fonts, colors, and logos
• D) By manually copying formatting from one slide to another

• A) To change the theme of the presentation
• B) To apply different animations to slides
• C) To modify the predefined slide layouts or create custom layouts in the Slide Master view to suit your presentation needs
• D) To insert multimedia elements into the slides

• A) By applying basic transitions and animations to individual slides
• B) By using the Animation Pane to sequence and customize animations for different elements and transitions between slides
• C) By using advanced animation options and sequencing in the Animation Pane to create custom animation effects and slide transitions
• D) By using preset animation templates

• A) To apply automatic design themes to slides
• B) To enable easy text formatting
• C) To provide visual alignment guides that help position objects accurately relative to each other and the slide margins
• D) To automatically adjust the size of objects

• A) By applying different slide layouts to each slide
• B) By editing text and images on each slide
• C) By rearranging, grouping, and deleting slides to improve the overall structure and flow of the presentation
• D) By adding animations and transitions to each slide

• A) By creating custom tags only
• B) By using tags to mark important notes and then filtering or searching for notes based on these tags
• C) By applying standard tags such as Important, To Do, or Question to categorize and prioritize notes, and then using the Tags Summary to review them
• D) By manually organizing notes into folders

• A) To change the font style for all notes
• B) To apply different colors to pages
• C) To use pre-designed page layouts for different types of notes and create a custom template by designing a page and saving it as a template
• D) To set up automatic reminders for notes

• A) By using the Eraser tool to remove unwanted text
• B) By using the Pen, Highlighter, and Shapes tools to add handwritten notes, highlight text, and draw shapes
• C) By using drawing tools to sketch diagrams, annotate notes, and highlight important sections, making notes more interactive and visually engaging
• D) By changing the background color of the notes

• A) To merge multiple notebooks into one
• B) To create sub-sections within a section
• C) To organize sections into hierarchical groups, making it easier to manage and navigate large notebooks by grouping related sections together
• D) To apply different colors to sections

• A) By copying and pasting content manually
• B) By using the 'Print to OneNote' option from the print menu of other applications
• C) By using the 'Send to OneNote' button in the Share menu or Print dialog of other applications to directly send content to a designated OneNote page
• D) By uploading files directly into OneNote

• A) Word processing
• B) Spreadsheet management
• C) Database management and creation
• D) Graphic design

• A) To perform calculations
• B) To create visual charts
• C) To store data in a structured format
• D) To draft reports

• A) By using the 'Create' tab and selecting 'Query Design'
• B) By clicking on the 'Create' tab and then 'Query Wizard'
• C) By importing data from Excel
• D) By adding a new table

• A) To generate data reports
• B) To create a user-friendly interface for data entry and viewing
• C) To analyze data trends
• D) To manage database security

• A) To store large amounts of data
• B) To design the database schema
• C) To generate and print formatted reports based on data in tables and queries
• D) To perform data calculations

• A) To increase advertising revenue
• B) To control how personal information is shared and viewed by others
• C) To protect personal information and control who can see your content
• D) To enhance the visual appeal of your profile

• A) By looking for unusual spelling and grammar errors in messages
• B) By recognizing messages from unknown sources requesting personal information or login details
• C) By noticing urgent or threatening messages asking for personal information or directing you to fake websites
• D) By reviewing the social media platform's privacy policies

• A) To ensure easy access to your account from any device
• B) To avoid having to remember multiple passwords
• C) To reduce the risk of unauthorized access and protect your account from being hacked
• D) To comply with the terms of service of the platform

• A) By checking the number of followers
• B) By looking for verified badges or official confirmation from credible sources
• C) By cross-referencing the information with multiple reputable sources and checking for verification badges
• D) By reviewing the account's profile picture

• A) Ignore the messages and hope they stop
• B) Respond aggressively to the bully
• C) Report the behavior to the social media platform, block the offending user, and seek support from trusted individuals
• D) Share the messages publicly to warn others

• A) To connect devices within the same network
• B) To provide wireless internet access
• C) To direct data packets between different networks and manage traffic
• D) To store and retrieve data

• A) Internet Protocol
• B) Internet Protocol
• C) Internal Protocol
• D) Integrated Protocol

• A) To encrypt data packets
• B) To assign static IP addresses
• C) To define the network and host portions of an IP address
• D) To manage network traffic

• A) A switch sends data to all connected devices, while a hub sends data to specific devices
• B) A switch manages traffic more efficiently by sending data only to the intended recipient, while a hub broadcasts data to all connected devices
• C) A switch can handle higher network traffic and reduces collisions compared to a hub
• D) There is no significant difference between a switch and a hub

• A) Virtual Private Network; used to securely connect to a remote network over the internet
• B) Virtual Personal Network; used to create local networks
• C) Virtual Private Network; used to encrypt data and provide a secure connection over the internet
• D) Virtual Public Network; used to enhance internet speed

• A) IPv4 uses 128-bit addresses, while IPv6 uses 32-bit addresses
• B) IPv4 and IPv6 are identical in addressing
• C) IPv4 uses 32-bit addresses, while IPv6 uses 128-bit addresses, allowing for a much larger address space
• D) IPv4 is used for wireless connections, while IPv6 is used for wired connections

• A) To encrypt network traffic
• B) To assign IP addresses to devices
• C) To translate domain names into IP addresses
• D) To manage network traffic