MS Office Fundamentals

Explore subjects and practice MCQs

8
Topics
800
Total MCQs

MS Office Fundamentals

100 MCQs Page 5 of 5
0
0
/ 100
0%
81
A. Office 2007
B. Office 97
C. Office 2003
D. Office 2010
Answer: The Office Assistant was removed in Office 2007.
82
A. Clippy
B. Ribbon
C. Bob
D. Zippy
Answer: Clippy was the paperclip Office Assistant.
83
A. Alt+F8
B. Alt+F11
C. Ctrl+F8
D. Shift+F11
Answer: Alt+F8 opens the Macro dialog box.
84
A. Trust Center
B. Control Panel
C. Task Manager
D. Action Center
Answer: The Trust Center manages macro and privacy settings.
85
A. Protected View
B. Print Preview
C. Read Mode
D. Compatibility Mode
Answer: Protected View limits risk from unsafe files.
86
A. File > Info > Check for Issues
B. Home > Inspect
C. Review > Inspect
D. Insert > Inspect
Answer: Document Inspector finds hidden data in a file.
87
A. File > Save As > PDF
B. Home > PDF
C. Review > PDF
D. Insert > PDF
Answer: Save As lets you export the file as a PDF.
88
A. Manage Access
B. Version History
C. Check Out
D. Copy Link
Answer: Manage Access shows and changes sharing permissions.
89
A. Signature Line
B. Watermark
C. Footer
D. Drop Cap
Answer: Insert > Signature Line adds a signature placeholder.
90
A. Compares two versions of a document
B. Prints two copies
C. Merges mail lists
D. Counts words
Answer: Version Compare highlights differences between documents.
91
A. OneDrive Sync
B. Teams
C. Sway
D. Visio
Answer: OneDrive syncs files formerly handled by SharePoint Workspace.
92
A. PDF
B. TXT
C. RTF
D. CSV
Answer: PDF preserves fonts and layout for printing.
93
A. Web Layout
B. Print Layout
C. Outline
D. Draft
Answer: Web Layout shows the document as a web page.
94
A. Error Checking
B. Spell Check
C. Track Changes
D. Watch Window
Answer: Error Checking scans for common formula errors.
95
A. Power Pivot
B. Power View
C. Solver
D. Analysis ToolPak
Answer: Power Pivot creates and analyzes in-memory data models.
96
A. Power Query
B. Power Pivot
C. Solver
D. Consolidate
Answer: Power Query (Get & Transform) imports and cleans data.
97
A. Solver
B. Analysis ToolPak
C. Sparklines
D. Camera
Answer: Solver finds optimal solutions for constraint problems.
98
A. XLSM
B. XLSX
C. XLS
D. XLST
Answer: Excel macro-enabled workbooks use the .xlsm extension.
99
A. Updates linked or imported data
B. Saves the file
C. Prints the file
D. Checks spelling
Answer: Refresh pulls the latest data from a source.
100
A. Insert > QR Code
B. Insert > Symbol
C. Insert > Chart
D. Insert > Link
Answer: Recent Word versions can insert QR codes from the Insert menu.
3 4 5