Practice Test GeeksGMetrix Exam Practice Test
← All GMetrix Exam Flashcard Decks

Microsoft Office Skills Flashcards

6 cards from real GMetrix Exam practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Microsoft Office Skills flashcards as text

  1. In Microsoft Word, what keyboard shortcut saves the current document?

    Answer: Ctrl+S

    Ctrl+S is the universal shortcut for saving in Microsoft Office applications. Regular saving prevents loss of work.

  2. What is mail merge in Microsoft Word used for?

    Answer: Creating personalized letters, labels, or envelopes by merging a document with a data source

    Mail merge connects a Word template with a data source (like an Excel list) to automatically generate personalized documents for each recipient.

  3. In Excel, what function calculates the average of a range of cells?

    Answer: =AVERAGE()

    The AVERAGE function calculates the arithmetic mean of the values in the specified range. For example, =AVERAGE(A1:A10) averages cells A1 through A10.

  4. What is a pivot table in Excel?

    Answer: A data summarization tool that automatically sorts, counts, totals, or averages data

    Pivot tables reorganize and summarize selected data to help users analyze patterns and trends without altering the original data.

  5. In PowerPoint, what is the Slide Master used for?

    Answer: Defining consistent formatting, fonts, colors, and layouts that apply to all slides in a presentation

    The Slide Master controls the overall design and layout templates, ensuring consistency across all slides in the presentation.

  6. What does the VLOOKUP function do in Excel?

    Answer: Searches for a value in the first column of a range and returns a value from a specified column in the same row

    VLOOKUP searches vertically down the first column of a range for a match, then returns the corresponding value from a specified column to the right.