• A) MIN
• B) MAX
• C) LARGE
• D) BIGGEST

• A) Using the VLOOKUP function
• B) Using Data Validation
• C) Using the Filter feature
• D) Using Conditional Formatting

• A) SUM
• B) AVERAGE
• C) MEDIAN
• D) MEAN

• A) AutoFormat
• B) AutoCorrect
• C) Spell Check
• D) Grammar Check

• A) Animations
• B) Slide Layouts
• C) Slide Transitions
• D) Themes

• A) To perform complex calculations
• B) To format cells based on conditions
• C) To test conditions and return values based on them
• D) To merge cells

• A) Query
• B) Report
• C) Form
• D) Table

• A) To find a value in a vertical column
• B) To find a value in a horizontal row
• C) To create a lookup table
• D) To sum up a range of values

• A) Headers
• B) Footers
• C) Styles
• D) Themes

• A) Slide Transitions
• B) Themes
• C) Animations
• D) Layouts

• A) Using the 'Remove Duplicates' feature
• B) Using the 'Find and Replace' feature
• C) Using the 'Filter' feature
• D) Using the 'Sort' feature

• A) To sum values based on a single condition
• B) To sum values based on multiple conditions
• C) To calculate average values
• D) To count cells that meet criteria

• A) Creates tables
• B) Designs forms
• C) Retrieves data from tables
• D) Generates reports

• A) Track Changes
• B) Change History
• C) Revision History
• D) Document Review

• A) Counts cells that meet a single condition
• B) Counts cells that meet multiple conditions
• C) Calculates the sum of cells
• D) Calculates the average of cells

• A) To create custom layouts for slides
• B) To manage slide transitions
• C) To apply consistent formatting across slides
• D) To add animations to slides

• A) Using Document Protection settings
• B) Using Encryption settings
• C) Using Password Protection
• D) Using File Permissions

• A) To calculate the sum of a range
• B) To look up values in a table
• C) To return the value of a cell based on row and column numbers
• D) To format cells

• A) Queries
• B) Forms
• C) Datasheet View
• D) Reports

• A) By using the 'Data Consolidation' feature
• B) By using named ranges
• C) By referencing the sheet names in the formula
• D) By using the 'Find and Replace' feature

• A) By applying themes
• B) By using Slide Layouts
• C) By using the Slide Master
• D) By copying and pasting styles

• A) To find the position of a value in a range
• B) To sum a range of values
• C) To calculate the average of a range
• D) To return the value of a cell

• A) Using the 'Header & Footer' tools
• B) Using the 'Page Layout' tab
• C) Using the 'Design' tab
• D) Using the 'Insert' tab

• A) CONCATENATE
• B) TEXTJOIN
• C) JOIN
• D) MERGE

• A) By using 'File Encryption'
• B) By using 'Cell Protection'
• C) By using 'Password Protection'
• D) By using 'Workbook Sharing'

• A) Add animations to slides
• B) Apply themes to slides
• C) Arrange and reorder slides
• D) Create custom layouts for slides

• A) By using the 'Form Wizard'
• B) By setting the 'Record Source' property of the form
• C) By creating a relationship in the database
• D) By using a macro

• A) =PERCENTAGE
• B) =TOTAL%
• C) =SUM()/TOTAL
• D) =PERCENT

• A) Using the 'Insert' tab and 'Link' option
• B) Using the 'Hyperlink' button in the toolbar
• C) Using the 'Insert' tab and 'Hyperlink' option
• D) Using the 'Links' option in the 'References' tab

• A) Tables
• B) Queries
• C) Relationships
• D) Forms

• A) By using the 'Review' tab and 'New Comment' option
• B) By using the 'Insert' tab and 'Comment' option
• C) By right-clicking on the cell and selecting 'Insert Comment'
• D) By using the 'Data' tab and 'Comment' option

• A) To protect the document from unauthorized access
• B) To highlight text changes and comments
• C) To review and accept or reject changes made to the document
• D) To add footnotes and endnotes

• A) Data Validation
• B) Conditional Formatting
• C) Charts
• D) Pivot Tables

• A) By clicking on 'New Slide' in the 'View' tab
• B) By using the 'Insert' tab and 'New Slide' option
• C) By pressing 'Ctrl+M' or using the 'Home' tab
• D) By right-clicking on the slide pane and selecting 'New Slide'

• A) =TODAY()
• B) =DATE()
• C) =NOW()
• D) =CURRENT_DATE()

• A) To apply formatting based on cell values or conditions
• B) To create charts and graphs
• C) To manage data validation rules
• D) To create and manage pivot tables

• A) By using the 'Layout' tab and 'Page Break' option
• B) By using the 'Insert' tab and 'Page Break' option
• C) By pressing 'Ctrl+Enter'
• D) By using the 'References' tab

• A) To create custom slide layouts
• B) To add animations to slide objects
• C) To add visual effects when transitioning between slides
• D) To format text and images on slides

• A) By using 'Password Protection' for the workbook
• B) By using 'File Permissions'
• C) By using 'Protect Sheet' feature
• D) By setting up a user account with restricted access

• A) To calculate the average of a range of values
• B) To lookup a value in a column and return a value in the same row
• C) To sum a range of values
• D) To count the number of cells in a range

• A) By using the 'Home' tab and 'Bold' button
• B) By using the 'Font' dialog box
• C) By pressing 'Ctrl+B'
• D) By using the 'Format' tab

• A) By using the 'Insert' tab and 'Chart' option
• B) By using the 'Data' tab and 'Chart' option
• C) By using the 'Formulas' tab
• D) By right-clicking on a data range and selecting 'Insert Chart'

• A) By using the 'Insert' tab and 'Video' option
• B) By using the 'Design' tab
• C) By using the 'Transitions' tab
• D) By dragging and dropping the video file onto the slide

• A) To create and manage tables
• B) To apply text formatting and styles
• C) To set margins, orientation, and size of the page
• D) To insert images and objects

• A) By using the 'Insert' tab and 'Table' option
• B) By using the 'Home' tab and 'Table' option
• C) By selecting a range of cells and clicking 'Insert Table'
• D) By using the 'Formulas' tab

• A) By using the 'Insert' tab and 'Header' option
• B) By using the 'Page Layout' tab
• C) By double-clicking the top margin of the page
• D) By using the 'Design' tab

• A) By using the 'Review' tab
• B) By using the 'Mailings' tab and 'Start Mail Merge' option
• C) By using the 'Insert' tab
• D) By using the 'Design' tab

• A) To automatically create a chart
• B) To automatically format cells
• C) To automatically calculate the sum of a range of cells
• D) To automatically sort data

• A) To apply slide transitions
• B) To manage slide layouts and themes
• C) To control the appearance of all slides in a presentation
• D) To insert and format text and images on slides

• A) By using the 'File' tab and 'Protect Workbook' option
• B) By using the 'Home' tab
• C) By using the 'Review' tab and 'Protect Workbook' option
• D) By using the 'Insert' tab

• A) By using the 'Home' tab and 'Font Size' drop-down menu
• B) By using the 'Layout' tab
• C) By selecting the text and using 'Font Size' in the 'Home' tab
• D) By using the 'Design' tab

• A) By using the 'Insert' tab and 'Hyperlink' option
• B) By using the 'Data' tab
• C) By right-clicking the cell and selecting 'Hyperlink'
• D) By using the 'Review' tab

• A) By using the 'Design' tab
• B) By using the 'Transitions' tab
• C) By using the 'Slide Master' tab and 'Insert Layout' option
• D) By using the 'Animations' tab

• A) Data Validation
• B) Conditional Formatting
• C) Sort
• D) Filter

• A) By using the 'Insert' tab and 'Table of Contents' option
• B) By using the 'References' tab and 'Table of Contents' option
• C) By using the 'Design' tab
• D) By using the 'Page Layout' tab

• A) By using the 'Data Validation' feature in the 'Data' tab
• B) By using the 'Insert' tab
• C) By using the 'Formulas' tab
• D) By using the 'Review' tab

• A) By using the 'Design' tab and 'Themes' option
• B) By using the 'Transitions' tab
• C) By using the 'Insert' tab
• D) By using the 'Animations' tab

• A) To format text
• B) To add comments to text
• C) To search for specific text and replace it with new text
• D) To change page layout

• A) By using the 'Page Layout' tab and 'Margins' option
• B) By using the 'Insert' tab
• C) By using the 'Design' tab
• D) By using the 'Review' tab

• A) By using the 'Data' tab
• B) By using the 'Home' tab and 'Conditional Formatting' option
• C) By using the 'Formulas' tab
• D) By using the 'Review' tab