GMetrix Exam Cheat Sheet 2026

The 30 highest-yield GMetrix Exam facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. In Excel, what function calculates the average of a range of cells? → =AVERAGE()
2. Which of the following doesn't constitute a project plan phase? → Budget Discussion
3. Which of the following statements accurately sums up a copyright? → The exclusive right to copy, distribute, and profit from a work
4. What is the purpose of a legend in an Excel chart? → To identify each data series by its assigned color or pattern
5. When creating a new 3D part in Inventor, what is the fundamental first step required before any 3D feature, such as an extrusion, can be created? → Starting a 2D Sketch
6. Which keyboard shortcut creates a new chart on a separate chart sheet in Excel? → F11
7. Which would be the most effective first step in creating your design? → Talk to the client about any questions or concerns you have about their expectations
8. In Microsoft Outlook, how do you add a Blind Carbon Copy (BCC) field when composing an email? → Click the 'Options' tab in the compose window and select 'Bcc'
9. In Outlook, which option allows you to schedule an email to be sent at a later date and time? → Use 'Delay Delivery' found in the Options tab of the compose window
10. Which data type in Access should you use for a field that stores whole numbers used in calculations? → Number
11. A: Adjustment Layers B: Pixel Layers C: Type Layers D: Smart Objects E: Shape Layers → Match the correct filter layer option with the type of layer it filters.
12. What does enabling referential integrity in an Access relationship do? → Enforces rules that keep related records consistent across tables
13. The tab that Word users utilize to create or insert tables → Insert Tab
14. How do you create a new subfolder inside your Inbox in Outlook? → Right-click the Inbox in the folder pane and select 'New Folder'
15. When you click 'Reply All' on an email, your response is sent to: → The sender and all recipients listed in the To and CC fields
16. Which chart type is best suited for showing trends over a period of time in Excel? → Line chart
17. What is the primary purpose of a PivotChart in Excel? → To interactively visualize data summarized in a PivotTable
18. What is the primary purpose of assigning 'Categories' to emails and calendar items in Outlook? → To color-code and label items for visual organization and quick filtering
19. Which SQL statement is used to retrieve records from an Access table? → SELECT
20. What is the primary purpose of Microsoft Access? → Building and managing relational databases
21. What does the 'Recall This Message' feature in Outlook attempt to do? → Delete or replace a sent email before the recipient opens it
22. What do data labels display on an Excel chart? → The numeric value of each data point
23. In Outlook Contacts, what is a 'Contact Group'? → A saved collection of email addresses under one name for easy group emailing
24. In Outlook, the 'Tasks' feature is primarily used for: → Creating and tracking personal to-do items with due dates and completion status
25. Which type of table relationship connects one record in a parent table to multiple records in a child table? → One-to-many
26. In Microsoft Word, what keyboard shortcut saves the current document? → Ctrl+S
27. Which Excel feature lets you show or hide specific data series on a chart without changing the source data? → Chart Filters
28. The component of a table that links or combines cells. → Merge Cells
29. Which of the following are the fundamental components that define a vector path in Adobe Illustrator? → Anchor Points and Segments
30. What does the asterisk (*) wildcard represent in a Microsoft Access query? → Any sequence of zero or more characters