• A) To manage hardware and software resources
• B) To compile programming code
• C) To design graphics
• D) To connect to the internet

• A) LEN
• B) LEN()
• C) CHAR
• D) COUNT

• A) DIR
• B) DIR
• C) LIST
• D) SHOW

• A) Track Changes
• B) Spell Check
• C) Track Changes
• D) Word Count

• A) SEARCH
• B) INDEX
• C) VLOOKUP
• D) MATCH

• A) To check the availability of a network connection
• B) To display the current IP configuration
• C) To trace the route of a packet
• D) To test the reachability of a host

• A) ALT + F4
• B) CTRL + ESC
• C) SHIFT + ESC
• D) CTRL + SHIFT + ESC

• A) Table Wizard
• B) Query Builder
• C) Report Generator
• D) Table Design View

• A) By selecting the slide and choosing a transition from the Transition tab
• B) By adding animations to the slide content
• C) By inserting a video into the slide
• D) By selecting the slide and choosing a transition from the Transition tab

• A) To sum a range of cells
• B) To calculate average values
• C) To perform conditional logic and return values based on the condition
• D) To format cells

• A) CD
• B) DIR
• C) COPY
• D) CD

• A) CTRL + C
• B) CTRL + V
• C) CTRL + X
• D) CTRL + C

• A) To calculate the sum of a range based on specified criteria
• B) To find the average of a range
• C) To count the number of cells in a range
• D) To calculate the sum of a range based on specified criteria

• A) CTRL + S
• B) CTRL + P
• C) CTRL + A
• D) F12

• A) Internet Provider Address
• B) Internet Protocol Address
• C) Internal Private Address
• D) Internet Protocol Address

• A) By using the Insert tab and selecting New Slide
• B) By pressing CTRL + N
• C) By copying an existing slide
• D) By using the Insert tab and selecting New Slide

• A) Table Design
• B) Query Wizard
• C) Relationships
• D) Relationships

• A) Counts the number of cells that meet a specified criterion
• B) Sums the number of cells that meet a specified criterion
• C) Averages the number of cells that meet a specified criterion
• D) Counts the number of cells that meet a specified criterion

• A) ipconfig
• B) ping
• C) netstat
• D) ipconfig

• A) Header and Footer
• B) Page Layout
• C) Page Setup
• D) Header and Footer

• A) A vertical lookup for a value in the leftmost column of a range
• B) A horizontal lookup for a value in the top row of a range
• C) A vertical lookup for a value in the rightmost column of a range
• D) A vertical lookup for a value in the leftmost column of a range

• A) To create and manage custom slide layouts and formatting
• B) To edit individual slide contents
• C) To apply transition effects to slides
• D) To create and manage custom slide layouts and formatting

• A) COPY
• B) MOVE
• C) RENAME
• D) COPY

• A) CTRL + F
• B) CTRL + H
• C) CTRL + J
• D) CTRL + F

• A) To find the position of a value in a range
• B) To return a value from a specified row and column in a table
• C) To search for a value within a range
• D) To return a value from a specified row and column in a table

• A) Query Wizard
• B) Query Design View
• C) Form Design
• D) Query Design View

• A) To sum the product of corresponding ranges or arrays
• B) To calculate the average of a range of cells
• C) To find the maximum value in a range
• D) To sum the product of corresponding ranges or arrays

• A) By using the Hyperlink button on the Insert tab
• B) By using the Text Box tool
• C) By inserting an image and adding a link
• D) By using the Hyperlink button on the Insert tab

• A) TYPE
• B) LIST
• C) SHOW
• D) TYPE

• A) Themes
• B) Styles
• C) Templates
• D) Styles

• A) To perform a horizontal lookup for a value in the top row of a table
• B) To perform a vertical lookup for a value in the leftmost column of a table
• C) To find the maximum value in a row
• D) To perform a horizontal lookup for a value in the top row of a table

• 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) CTRL + SHIFT + +
• B) CTRL + N
• C) CTRL + R
• D) CTRL + SHIFT + +

• A) Slide Sorter View
• B) Slide Show View
• C) Normal View
• D) Slide Sorter View

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

• A) DEL
• B) RMDIR
• C) ERASE
• D) RMDIR

• A) To count cells based on multiple criteria
• B) To count the number of cells in a range that meet a specific condition
• C) To count the number of cells in a range that meet a specific condition
• D) To count all the cells in a range

• A) CTRL + N
• B) CTRL + W
• C) CTRL + F
• D) CTRL + N

• A) Styles
• B) Themes
• C) Page Layout
• D) Styles

• A) RENAME
• B) MOVE
• C) COPY
• D) RENAME

• A) MAX
• B) MIN
• C) AVERAGE
• D) MAX

• A) Animations
• B) Transitions
• C) Design
• D) Transitions

• A) DIR
• B) LIST
• C) SHOW
• D) DIR

• A) To find the position of a value within a range
• B) To search for a value within a table
• C) To return a value from a specified row and column
• D) To find the position of a value within a range

• A) Index
• B) Table of Figures
• C) Table of Contents
• D) Table of Contents

• A) By using the Design tab
• B) By using the Background Styles button
• C) By applying a theme
• D) By using the Background Styles button

• A) To sum data based on the visible cells after filtering
• B) To find the average of a range of cells
• C) To count the number of cells in a range
• D) To sum data based on the visible cells after filtering

• A) Select Query
• B) Action Query
• C) Crosstab Query
• D) Crosstab Query

• A) To remove extra spaces from a text string
• B) To convert text to uppercase
• C) To calculate the number of characters in a text string
• D) To remove extra spaces from a text string

• A) References
• B) Insert
• C) Review
• D) References

• A) To create a clickable link to a web page or document
• B) To link cells within a worksheet
• C) To link cells between different worksheets
• D) To create a clickable link to a web page or document

• A) Animations
• B) Slide Layout
• C) Transitions
• D) Transitions

• A) TYPE
• B) LIST
• C) SHOW
• D) TYPE

• A) AVERAGE
• B) SUM
• C) COUNT
• D) AVERAGE

• A) To search for a value in the first column of a range and return a value in the same row from another column
• B) To return a value from a specific row and column
• C) To look up data in a table
• D) To search for a value in the first column of a range and return a value in the same row from another column

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

• A) To return the leftmost characters from a text string
• B) To return the rightmost characters from a text string
• C) To return a specific character from a text string
• D) To return the leftmost characters from a text string

• A) References
• B) Review
• C) Insert
• D) References

• A) To test a condition and return one value if true and another if false
• B) To find the largest value in a range
• C) To count cells based on a condition
• D) To test a condition and return one value if true and another if false

• A) Animations
• B) Transitions
• C) Slide Layout
• D) Animations