Which type of Excel file, saved with a .xlsm extension, is enabled to contain macros?
Correct answer: A
The .xlsm extension denotes a macro-enabled Excel workbook.
Computer
✓ 0
✗ 0
Your Result
0 correct out of 0 attempted (0%)
Which file format stores plain tabular data separated by commas, commonly used to exchange data between programs?
Correct answer: A
CSV files store simple tabular data as plain text, separated by commas, for easy exchange between applications.
Which Excel feature allows grouping detailed rows or columns so they can be collapsed and expanded, like for subtotals?
Correct answer: C
Group and Outline lets users collapse or expand rows/columns, often used with subtotals.
Which Excel tool automatically calculates subtotal values for grouped data, such as totals per category?
Correct answer: C
The Subtotal tool automatically inserts summary calculations for grouped ranges of data.
Which Excel feature allows splitting a single column of text (like 'First Last') into multiple columns based on a delimiter?
Correct answer: B
Text to Columns splits data in a single column into multiple columns based on delimiters like commas or spaces.
Which Excel feature automatically detects patterns and fills in data intelligently based on examples you provide?
Correct answer: D
Flash Fill recognizes patterns in your input and automatically fills the rest based on examples.
Which Excel feature merges two or more adjacent cells into a single larger cell?
Correct answer: D
Merge Cells combines multiple selected cells into one larger cell.
Which Excel protection feature prevents changes to a worksheet's structure or cell content without a password?
Correct answer: C
Protect Sheet restricts editing of a worksheet's cells and structure, often requiring a password to unlock.
Which Excel function returns the number of working days between two dates, excluding weekends and specified holidays?
Correct answer: C
NETWORKDAYS calculates the number of working days between two dates, excluding weekends and holidays.
Which Microsoft Office application is primarily used for creating slide-based presentations?
Correct answer: A
Microsoft PowerPoint is the presentation software in the MS Office suite.
What is the default file extension for a presentation saved in PowerPoint 2007 or later?
Correct answer: D
PowerPoint 2007 and later versions use the .pptx extension by default.
What was the default file extension for presentations in PowerPoint 2003 and earlier?
Correct answer: D
Older PowerPoint versions (before 2007) used the .ppt extension.
What is an individual page within a PowerPoint presentation called?
Correct answer: D
Each individual page in a presentation is called a slide.
Which PowerPoint view shows small thumbnail images of all slides for easy reordering?
Correct answer: A
Slide Sorter view displays thumbnails of all slides, useful for reordering them.
Which PowerPoint view is used for actually editing the content of individual slides?
Correct answer: A
Normal view is the default editing view for working on individual slide content.
Which PowerPoint view displays the presentation full-screen as the audience would see it?
Correct answer: B
Slide Show view presents the slides full-screen, as they would appear to an audience.
Which PowerPoint view allows the presenter to see speaker notes alongside each slide while presenting?
Correct answer: A
Presenter view shows the presenter's notes and upcoming slides while the audience sees only the slide.
Which PowerPoint view displays a hierarchical, text-only outline of all slide content?
Correct answer: B
Outline view shows the textual content of all slides in a structured, hierarchical list.
Which PowerPoint feature adds visual effects when moving from one slide to the next?
Correct answer: C
Transitions are visual effects applied when moving between slides.
Which PowerPoint feature adds visual effects to individual objects or text within a single slide?
Correct answer: D
Animations apply movement or visual effects to elements within a single slide.
Which PowerPoint feature applies a consistent design, including colors and fonts, across the entire presentation?
Correct answer: C
A theme applies a coordinated design of colors, fonts, and effects across all slides.
Which PowerPoint feature lets you define a master design that controls formatting for all slides using a specific layout?
Correct answer: A
The Slide Master controls the overarching design elements applied to slides throughout the presentation.
Which PowerPoint feature arranges placeholders for content like titles, text, and images on a slide?
Correct answer: C
Slide Layout defines the arrangement of placeholders for content on a given slide.
Which PowerPoint feature lets a presenter write reminders or additional information not shown to the audience?
Correct answer: A
Speaker Notes let a presenter add private reminders visible only in Presenter view or printed notes.
Which printed PowerPoint output shows multiple small slide thumbnails per page, useful for distributing to an audience?
Correct answer: C
Handouts print multiple slide thumbnails per page for audience distribution.