logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

In Excel, what is the use of the VLOOKUP function?

  • To look up data vertically in a table
  • To find the maximum value in a range
  • To calculate the sum of a range
  • To perform a logical test
Mark for review

In PowerPoint, how do you add a new slide to a presentation?

  • Use the "Home" tab and select "New Slide"
  • Press Ctrl + N
  • Use the "Design" tab
  • Right-click in the slide pane and choose "New Slide"
Mark for review

In Outlook, how do you categorize an email?

  • Use the "Categories" option in the "Home" tab
  • Use the "Flags" option
  • Use the "Rules" option
  • Use the "Reply" button
Mark for review

In Excel, which function calculates the average of a range of cells?

  • SUM
  • AVERAGE
  • MAX
  • MIN
Mark for review

Which PowerPoint feature allows you to apply a consistent look to your presentation?

  • Slide Layouts
  • Themes
  • Slide Transitions
  • Custom Animation
Mark for review

In Excel, what does the SUM function do?

  • Adds all numbers in a range
  • Finds the average of numbers in a range
  • Counts the number of cells in a range
  • Finds the highest number in a range
Mark for review

In Excel, how can you apply conditional formatting to a cell?

  • Use the "Home" tab and select "Conditional Formatting"
  • Use the "Formulas" tab
  • Right-click the cell and choose "Format"
  • Use the "Insert" tab
Mark for review

In Excel, how do you lock a cell reference in a formula?

  • By using a relative reference
  • By using an absolute reference
  • By using a named range
  • By using a text function
Mark for review

How do you create a hyperlink in Excel?

  • Use the "Insert Hyperlink" option from the right-click menu
  • Type the URL directly into the cell
  • Use the "Data Validation" feature
  • Apply a conditional format
Mark for review

What does the "Print Preview" option in Word show you?

  • How the document will look when printed
  • The document's word count
  • The document's layout
  • The document's revision history
Mark for review

What is the function of the "Merge & Center" button in Excel?

  • To merge selected cells and center the content
  • To merge multiple sheets
  • To split a cell into two
  • To center text in a cell
Mark for review

In Excel, what does the "Flash Fill" feature do?

  • Automatically fills in values based on patterns
  • Adds a comment to a cell
  • Creates a table from a range
  • Changes cell formatting
Mark for review

How do you apply a theme to a Word document?

  • Use the "Design" tab and select "Themes"
  • Use the "Layout" tab
  • Right-click and select "Themes"
  • Use the "Insert" tab
Mark for review

How do you insert a chart in Word?

  • Use the "Insert" tab and select "Chart"
  • Right-click and choose "Insert Chart"
  • Use the "Design" tab
  • Use the "References" tab
Mark for review

How can you adjust the margins of a Word document?

  • Use the "Page Layout" tab and select "Margins"
  • Use the "Insert" tab
  • Use the "Design" tab
  • Right-click on the document
Mark for review

What feature in Excel helps you quickly calculate totals, averages, and other functions?

  • AutoSum
  • Data Validation
  • Conditional Formatting
  • Flash Fill
Mark for review

In Excel, which feature allows you to create a chart from your data?

  • Pivot Table
  • Conditional Formatting
  • Chart Wizard
  • Data Validation
Mark for review

Which tab in Word 2016 contains the options to change font size and style?

  • Home
  • Insert
  • Review
  • View
Mark for review

Which feature in PowerPoint allows you to add animations to text or objects?

  • Slide Layout
  • Animations
  • Transitions
  • Design Ideas
Mark for review

How do you set up a mail merge in Word?

  • Use the "Mailings" tab and select "Start Mail Merge"
  • Use the "Insert" tab
  • Use the "Design" tab
  • Use the "Review" tab
Mark for review

What is the purpose of the "Data Validation" feature in Excel?

  • To restrict the type of data entered into a cell
  • To create a chart
  • To format cells
  • To protect a worksheet
Mark for review

Which view in PowerPoint shows the slide in full-screen mode?

  • Normal View
  • Slide Sorter View
  • Reading View
  • Slide Show View
Mark for review

What is the purpose of the "Slide Sorter" view in PowerPoint?

  • To view and arrange all slides in a presentation
  • To edit individual slides
  • To add notes to slides
  • To review slide transitions
Mark for review

How can you set up a repeating task in Microsoft Outlook?

  • Use the "Task Recurrence" option
  • Use the "Quick Steps" feature
  • Apply a category to the task
  • Set a reminder
Mark for review

What does the "AutoSum" button do in Excel?

  • Automatically calculates the sum of a selected range
  • Adds a new column to the worksheet
  • Applies a sum formula to the selected cell
  • Changes the cell format to currency
Mark for review

In Word, what is the function of the "Track Changes" feature?

  • To hide text changes
  • To make permanent changes to the document
  • To keep a record of edits and comments
  • To change the document format
Mark for review

Which feature in Word helps you find synonyms for a word?

  • Thesaurus
  • Spelling & Grammar
  • Word Count
  • Research
Mark for review

What does the "Paste Special" option allow you to do in Word or Excel?

  • Paste only text
  • Paste with formatting options
  • Paste without formatting
  • Paste as a link
Mark for review

How do you track changes made to a document in Word?

  • Use the "Track Changes" feature under the "Review" tab
  • Use the "History" tab
  • Use the "File" tab
  • Use the "View" tab
Mark for review

What does the "Undo" button do in Microsoft Office applications?

  • Reverses the last action
  • Redoes the last undone action
  • Saves the document
  • Closes the application
Mark for review

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session