Question 1: What does clicking 'Check Accessibility' in PowerPoint do?

• Identifies content that may be difficult for people with disabilities to read (Correct answer)
• Ensures the color theme meets brand guidelines
• Checks that all images have correct file sizes
• Verifies that all hyperlinks in the presentation are working

Correct answer: Identifies content that may be difficult for people with disabilities to read

The Accessibility Checker finds content issues such as missing alt text on images that make the presentation harder to use for people with disabilities.

Question 2: What happens when Cascade Delete is enabled on an Access table relationship?

• Child records are copied to an archive table
• Related child records are reformatted when the parent changes
• Field values in child records are set to null
• All related child records are automatically deleted when the parent record is deleted (Correct answer)

Correct answer: All related child records are automatically deleted when the parent record is deleted

Cascade Delete automatically removes all child records associated with a parent record when that parent is deleted.

Question 3: What does 'Join Geometry' do when applied to two overlapping Revit elements?

• Merges their type properties into one combined type
• Locks the two elements so they move together
• Removes the overlapping material volume and creates a clean intersection (Correct answer)
• Converts both elements to a single Generic Model

Correct answer: Removes the overlapping material volume and creates a clean intersection

Join Geometry removes the duplicate material where elements overlap, producing a clean, accurate intersection in section and 3D views.

Question 4: To export a PowerPoint presentation as a PDF, which path do you follow?

• View > Export > Create PDF
• Insert > Export > PDF
• File > Export > Create PDF/XPS Document (Correct answer)
• File > Save As > PDF Format > Export

Correct answer: File > Export > Create PDF/XPS Document

File > Export > Create PDF/XPS Document is the standard way to export a PowerPoint presentation as a PDF.

Question 5: When using 'Object Styles' in InDesign, what advantage do they provide in a publication workflow?

• They restrict images to specific color profiles
• They save a combination of frame formatting attributes that can be applied consistently and updated globally (Correct answer)
• They convert all objects to grouped Smart Objects
• They permanently lock object position to prevent accidental moves

Correct answer: They save a combination of frame formatting attributes that can be applied consistently and updated globally

Object Styles store frame fill, stroke, effects, and text wrap settings so you can apply a consistent look to multiple objects and update all instances by editing the style.

Question 6: What is the function of the 'Book' feature in InDesign for long publications?

• Combines multiple InDesign documents into a single book with synchronized styles and sequential page numbers (Correct answer)
• Exports all chapters as separate PDFs simultaneously
• Locks all documents in a folder to prevent editing
• Converts an InDesign document to an ePub book format automatically

Correct answer: Combines multiple InDesign documents into a single book with synchronized styles and sequential page numbers

An InDesign Book file links multiple documents so you can synchronize paragraph/character styles, swatches, and maintain continuous page numbering across chapters.

Question 7: A user has a list of sales figures in column B, starting from B2. In cell C2, they want to display the word "Bonus" if the sales figure in B2 is greater than $5,000, and "No Bonus" otherwise. Which of the following formulas should be entered in cell C2 to achieve this?

• =BONUS(B2>5000)
• =IF(B2>5000, "Bonus", "No Bonus") (Correct answer)
• =IF(B2<5000, "Bonus", "No Bonus")
• =IF(B2>5000, No Bonus, Bonus)

Correct answer: =IF(B2>5000, "Bonus", "No Bonus")

The IF function is used for conditional logic. Its syntax is IF(logical_test, [value_if_true], [value_if_false]). The formula =IF(B2>5000, "Bonus", "No Bonus") correctly tests if the value in B2 is greater than 5000, returns the text "Bonus" if true, and "No Bonus" if false. Text values within a formula must be enclosed in double quotes.

Question 8: In the Layers panel, what does the small padlock icon on the Background layer signify?

• The layer is linked to another layer
• The layer cannot be moved, deleted, or made transparent by default (Correct answer)
• The layer has a pixel lock applied
• The layer is password protected

Correct answer: The layer cannot be moved, deleted, or made transparent by default

The Background layer is locked by default, preventing accidental moves, transparency edits, or deletion; double-clicking it converts it to a regular layer.

Question 9: What does the 'Proof Colors' option (View > Proof Colors) do in Photoshop?

• Checks for out-of-gamut pixels only
• Converts the image permanently to the selected profile
• Shows a screen simulation of how the image will look when printed in the chosen profile (Correct answer)
• Embeds the ICC profile into the file

Correct answer: Shows a screen simulation of how the image will look when printed in the chosen profile

Proof Colors is a soft-proofing mode that simulates on screen how the image will appear when reproduced using the currently selected proof profile, without altering the actual data.

Question 10: When using the Array tool in Revit with 'Linear' type, what must you define?

• The number of elements and the spacing distance or total span (Correct answer)
• The host element for each array member
• A rotation center and angular increment
• A path curve for elements to follow

Correct answer: The number of elements and the spacing distance or total span

A linear array requires the number of elements and either the spacing between them or the total distance to distribute them across.

Question 11: Which blending mode is most useful for adding shadows and darkening an image since white has no effect?

• Screen
• Color Dodge
• Lighten
• Multiply (Correct answer)

Correct answer: Multiply

Multiply darkens by multiplying pixel values, and white (value 255) multiplied with any color has no effect, making it ideal for painting shadows.

Question 12: Which paragraph formatting option prevents a single last line of a paragraph from appearing alone at the top of the next page?

• Keep lines together
• Widow/Orphan control (Correct answer)
• Keep with next
• Page break before

Correct answer: Widow/Orphan control

Widow/Orphan control automatically moves text to prevent lone lines at the top or bottom of a page.

Question 13: Represents a set of connected data horizontally across a table.

• Column
• Row
• Cell

Explanation: <br> A "row" in a table represents a set of related data that is organized horizontally across the table. Each row typically contains different values or pieces of information related to a specific entity or category.

Question 14: Which layer type automatically appears at the bottom of the layer stack when you create a new document with a white or colored background?

• Smart Object layer
• Background layer (Correct answer)
• Adjustment layer
• Fill layer

Correct answer: Background layer

Photoshop creates a locked Background layer at the bottom of the stack when a new document is made with a white or color background option.

Question 15: Which function returns the largest value in a set of values?

• LARGE
• UPPER
• TOP
• MAX (Correct answer)

Correct answer: MAX

MAX returns the maximum (largest) numeric value from a range or list of values.

Question 16: In Outlook, which option allows you to schedule an email to be sent at a later date and time?

• Use 'Schedule Send' in the Home tab
• Use 'Timed Message' in the View menu
• Use 'Deferred Send' in the File menu
• Use 'Delay Delivery' found in the Options tab of the compose window (Correct answer)

Correct answer: Use 'Delay Delivery' found in the Options tab of the compose window

The 'Delay Delivery' option in the Options tab of the compose window lets you specify a future date and time for Outlook to send the message.

Question 17: In Photoshop, what is the function of a Clipping Mask?

• Merges all visible layers into one
• Creates a mask based on luminance values
• Removes the background of the selected layer
• Clips the content of one layer to the shape of the layer below it (Correct answer)

Correct answer: Clips the content of one layer to the shape of the layer below it

A Clipping Mask confines the visibility of the upper layer to the shape or transparent areas of the layer directly beneath it.

Question 18: What is the function of 'Package Presentation for CD' (or folder) in PowerPoint?

• Burns a DVD with the slideshow for playback on TV
• Creates a compressed .zip archive of the presentation
• Exports each slide as a separate image file
• Bundles the presentation with linked files and a viewer for offline use (Correct answer)

Correct answer: Bundles the presentation with linked files and a viewer for offline use

Package Presentation for CD collects the presentation, all linked files, and optionally the PowerPoint Viewer into one folder for portable sharing.

Question 19: In Inventor's Hole feature dialog, which hole type produces a conical countersink angle for a flat-head screw?

• Counterbore
• Drilled
• Countersink (Correct answer)
• Tapped

Correct answer: Countersink

A Countersink hole has a conical angled entrance that allows flat-head screws to sit flush with or below the surface.

Question 20: What happens when you Alt-click (Option-click on Mac) on a layer mask thumbnail?

• Applies the mask permanently
• Links the mask to a new layer
• Deletes the layer mask
• Shows the mask as a grayscale image in the document window (Correct answer)

Correct answer: Shows the mask as a grayscale image in the document window

Alt-clicking (Option-clicking) the layer mask thumbnail switches the canvas view to show the mask itself as a grayscale image, making it easy to paint and refine.

Question 21: What does the GMetrix 'Score Trend' graph show on a student's profile?

• How the student's scores have changed across multiple test attempts over time (Correct answer)
• Average time per question across all attempts
• The student's ranking among peers globally
• The number of questions answered per session

Correct answer: How the student's scores have changed across multiple test attempts over time

The Score Trend graph displays how a student's scores have evolved over multiple attempts, helping track improvement over time.

Question 22: What does the Document Inspector in PowerPoint primarily help you do?

• Review animation timings
• Find and remove hidden data and personal information (Correct answer)
• Check spelling and grammar errors
• Inspect slide layout inconsistencies

Correct answer: Find and remove hidden data and personal information

Document Inspector scans for hidden metadata, comments, personal information, and other content you may not want to share.

Question 23: Which Inventor feature allows you to remove material by projecting a 2D sketch profile along a path through a 3D solid?

• Revolve Cut
• Extrude Cut
• Sweep Cut (Correct answer)
• Loft Cut

Correct answer: Sweep Cut

A Sweep Cut removes material by sweeping a profile sketch along a separate path curve.

Question 24: What do data labels display on an Excel chart?

• The numeric value of each data point (Correct answer)
• The series name only
• The axis unit
• The chart title

Correct answer: The numeric value of each data point

Data labels annotate each data point with its actual value, making charts easier to read without referencing the axis.

Question 25: When saving a Photoshop file for the web using 'Export As', which format retains full alpha channel transparency and supports millions of colors?

• PNG-24 (Correct answer)
• BMP
• JPEG
• GIF

Correct answer: PNG-24

PNG-24 supports millions of colors and a full 256-level alpha channel for smooth transparency, making it the best choice for full-color web graphics that require transparency.

Question 26: Which function returns the absolute (positive) value of a number?

• SIGN
• ABS (Correct answer)
• POSITIVE
• MOD

Correct answer: ABS

ABS returns the absolute value of a number, removing any negative sign.

Question 27: What does the 'Rib' feature in Inventor create?

• A hollow tube connecting two solid regions
• A thin structural support wall added between two faces (Correct answer)
• A raised text embossment
• A series of parallel grooves cut into a surface

Correct answer: A thin structural support wall added between two faces

The Rib feature builds a thin web or gusset from an open sketch profile between existing solid faces, used to add structural strength.

Question 28: The Blob Brush tool differs from the regular Brush tool in that it:

• Produces raster output
• Merges overlapping strokes into a single filled shape (Correct answer)
• Creates open paths only
• Only works with calligraphic brushes

Correct answer: Merges overlapping strokes into a single filled shape

The Blob Brush merges strokes that share the same fill and appearance into one unified filled path.

Question 29: What does the 'Edit Selected Paths' option in the Pencil Tool Options allow you to do?

• Unlock path editing for guides
• Convert the path to a shape
• Merge two pencil paths
• Redraw a selected path by drawing over it with the Pencil tool (Correct answer)

Correct answer: Redraw a selected path by drawing over it with the Pencil tool

When enabled, drawing over a selected path with the Pencil tool redraws that portion of the path rather than creating a new one.

Question 30: Before sending a multi-page brochure to a commercial printer, a designer wants to perform an automated check for potential issues like missing fonts, overset text, and low-resolution images. Which InDesign feature is specifically designed for this purpose?

• The Links panel
• The Swatches panel
• The Pages panel
• The Preflight panel (Correct answer)

Correct answer: The Preflight panel

The Preflight panel is an essential tool for quality control. It actively monitors the document for a wide range of potential output errors based on a selected profile, such as missing links or fonts, overset text, and low image resolution, allowing the designer to identify and fix them before printing.

Question 31: Which color mode provides the largest gamut and is recommended for images that will only be displayed on screens?

• RGB (Correct answer)
• CMYK
• Grayscale
• Lab Color

Correct answer: RGB

RGB (Red, Green, Blue) is the native color mode for monitors and provides a wider gamut for screen display than CMYK, which is optimized for print.

Question 32: Which Word feature lets you restrict certain users to editing only specific sections of a document?

• Document Inspector
• Password Protect
• Mark as Final
• Restrict Editing with section protection (Correct answer)

Correct answer: Restrict Editing with section protection

Restrict Editing allows you to assign editable sections to specific users while protecting the rest of the document.

Question 33: What happens when you drag with the Eraser tool across a closed filled shape in Illustrator?

• Deletes the entire shape
• Cuts through the shape creating two or more separate closed paths (Correct answer)
• Rasterizes the shape at the erased area
• Converts the shape to a stroked path

Correct answer: Cuts through the shape creating two or more separate closed paths

The Eraser tool cuts through vector shapes, creating new closed paths from the remaining portions on either side of the erased area.

Question 34: What type of data relationship does a scatter (XY) chart best display?

• Hierarchical category comparisons
• Part-to-whole proportions
• The correlation or distribution between two numeric variables (Correct answer)
• Trends over time with categorical labels

Correct answer: The correlation or distribution between two numeric variables

Scatter charts plot pairs of numeric values on two axes to reveal correlations, clusters, or patterns between variables.

Question 35: Which keyboard shortcut opens the Find and Replace dialog in Word?

• Ctrl+F
• Ctrl+H (Correct answer)
• Ctrl+R
• Ctrl+G

Correct answer: Ctrl+H

Ctrl+H opens the Find and Replace dialog, which lets you search for text and replace it with different text.

Question 36: Which vector drawing tool automatically closes a path when you click near the starting anchor point?

• Pencil tool
• Both Pen and Pencil tools (Correct answer)
• Pen tool
• Paintbrush tool

Correct answer: Both Pen and Pencil tools

Both the Pen and Pencil tools display a small circle next to the cursor when near the starting point, indicating the path will close on click.

Question 37: Which function returns the current date and time that updates automatically?

• TODAY()
• NOW() (Correct answer)
• TIME()
• DATE()

Correct answer: NOW()

NOW() returns the current date and time and recalculates every time the worksheet is recalculated.

Question 38: A user is attempting to place a door in a floor plan view but finds that the door element will not place and the cursor shows a 'not allowed' symbol when moved over the open floor area. What is the most likely reason for this issue?

• The view's detail level is set to 'Coarse'.
• The correct Level for the door is not currently active.
• The door family requires a Wall element to act as a host. (Correct answer)
• The 'Doors' category is turned off in the Visibility/Graphics settings.

Correct answer: The door family requires a Wall element to act as a host.

In Revit, standard door and window families are 'hosted' components, meaning they must be placed into a 'host' element, which for doors and windows is typically a wall. [21, 29] Without a wall to place the door into, the command will not work.

Question 39: When troubleshooting a formula in Excel, you see the '#NAME?' error in a cell. What is the most likely cause of this error?

• The formula is attempting to divide by zero.
• The formula contains a circular reference.
• A referenced cell contains a value of the wrong data type.
• Excel does not recognize text in the formula, such as a misspelled function name or an undefined named range. (Correct answer)

Correct answer: Excel does not recognize text in the formula, such as a misspelled function name or an undefined named range.

The #NAME? error occurs when Excel doesn't recognize something in the formula's text. This is most commonly due to a typo in a function name (e.g., `VLLOKUP` instead of `VLOOKUP`) or a reference to a named range that does not exist or is misspelled.

Question 40: In Word, how do you change the default font so it applies to all new documents?

• Update the page setup defaults
• Set the font and click 'Set As Default' in the Font dialog (Correct answer)
• Edit the Normal paragraph style
• Change the theme fonts in the Design tab

Correct answer: Set the font and click 'Set As Default' in the Font dialog

Clicking 'Set As Default' in the Font dialog box saves the font settings to the Normal template so all new documents use them.

Question 41: Which Photoshop feature allows you to non-destructively adjust brightness and contrast on a layer without permanently changing pixel data?

• Applying Image > Adjustments > Brightness/Contrast directly
• Using Edit > Fade after applying the adjustment
• Adding a Brightness/Contrast Adjustment Layer (Correct answer)
• Merging the layer before adjusting

Correct answer: Adding a Brightness/Contrast Adjustment Layer

Adjustment Layers apply tonal corrections non-destructively; the original pixel data remains unchanged and the adjustment can be edited or deleted at any time.

Question 42: In Inventor, a 'Derived Component' is created by:

• Mirroring an existing part about a plane
• Importing geometry or parameters from another Inventor part or assembly into the current part (Correct answer)
• Copying a feature from one part and pasting it into another
• Using iLogic to auto-generate a part

Correct answer: Importing geometry or parameters from another Inventor part or assembly into the current part

A Derived Component pulls geometry, work features, or parameters from a source file and creates a linked copy in the current part or assembly.

Question 43: What is a 'Vanishing Point' in Photoshop used for?

• Creating linear perspective guides for printing
• Merging multiple photos taken from different angles
• Editing and cloning in perspective on surfaces like walls and floors (Correct answer)
• Generating a 3D depth map from a flat image

Correct answer: Editing and cloning in perspective on surfaces like walls and floors

Vanishing Point (Filter > Vanishing Point) lets you define perspective planes and then clone, paint, paste, or transform content while maintaining the correct perspective.

Question 44: What is the purpose of the 'Section Marker' special character in InDesign?

• Marks the beginning of a new story in the text flow
• Places a footnote reference in the text
• Inserts a non-breaking space between words
• Displays the current chapter name defined in the Section Options (Correct answer)

Correct answer: Displays the current chapter name defined in the Section Options

A Section Marker automatically displays the section name you define in Section Options, useful for running headers or footers that change per section.

Question 45: Which of the following are the fundamental components that define a vector path in Adobe Illustrator?

• Pixels and Resolution
• Fills and Strokes
• Anchor Points and Segments (Correct answer)
• Layers and Groups

Correct answer: Anchor Points and Segments

A vector path is fundamentally defined by its anchor points, which mark the start, end, or change in direction of a line, and the segments (straight or curved lines) that connect them. Handles extending from anchor points control the shape of curved segments.

Question 46: When drawing a path with the Pen tool, what visual cue indicates the path will close when you click?

• The cursor changes to a crosshair
• A small circle appears next to the Pen cursor (Correct answer)
• The first anchor point turns blue
• A red dot appears near the cursor

Correct answer: A small circle appears next to the Pen cursor

A small circle icon appears next to the Pen tool cursor when it is positioned near the starting anchor point, signaling that clicking will close the path.

Question 47: In Inventor, what is a 'Work Axis' primarily used for?

• As a reference axis for features like Revolve, Circular Pattern, or Holes (Correct answer)
• To define a cutting plane
• To display the X, Y, Z coordinate system
• To anchor the part to an assembly

Correct answer: As a reference axis for features like Revolve, Circular Pattern, or Holes

Work Axes are construction geometry that provide a reusable reference axis for revolves, patterns, and other axis-dependent features.

Question 48: What is the purpose of the XLOOKUP function compared to VLOOKUP?

• XLOOKUP requires sorted data
• XLOOKUP can search in any direction and returns a range instead of a column index (Correct answer)
• XLOOKUP only works with horizontal data
• XLOOKUP is faster but less accurate

Correct answer: XLOOKUP can search in any direction and returns a range instead of a column index

XLOOKUP searches in any direction, returns an array, and doesn't require a col_index_num like VLOOKUP.

Question 49: In Excel, which of the following is a relative cell reference?

• A1 (Correct answer)
• $A$1
• A$1
• $A1

Correct answer: A1

A relative reference like A1 adjusts automatically when a formula is copied to another cell.

Question 50: What is the purpose of the Navigation Pane in Microsoft Word?

• Controls page margins and orientation
• Manages document headers and footers
• Allows browsing headings, pages, and search results within the document (Correct answer)
• Opens the document template library

Correct answer: Allows browsing headings, pages, and search results within the document

The Navigation Pane lets you browse document structure by headings, thumbnail pages, or search results for quick navigation.