NEW
Font size
S
M
L
XL
WorksheetsFINAL QUIZ
Total questions: 40
Worksheet time: 20mins
Name
Class
Date
1.
Which feature in Word is used to track document edits by different users?
a)
Track Changes
b)
Version History
c)
Comments
d)
Compare Documents
2.
The correct file format for a reusable Word template is:
a)
.dotx
b)
.pdf
c)
.docx
d)
.txt
3.
A naming convention mainly helps with:
a)
Convert to PDF
b)
Improve file size
c)
Maintain version control
d)
Password protection
4.
The Styles pane can be opened from which tab?
a)
View
b)
Home
c)
Review
d)
Insert
5.
To generate a Table of Contents, you must apply:
a)
Heading styles
b)
Custom fonts
c)
Paragraph spacing
d)
Bullets
6.
Which view is used before splitting a Master Document?
a)
Reading View
b)
Web Layout
c)
Outline View
d)
Draft View
7.
Common mail merge data source:
a)
Excel Sheet
b)
PowerPoint
c)
PDF
d)
Outlook Calendar
8.
Disconnect a mail merge document from data source:
a)
Break Link under Edit Links
b)
Export PDF
c)
Delete merge fields
d)
Turn off tracking
9.
Which tab is required for inserting form controls?
a)
Review
b)
View
c)
Design
d)
Developer
10.
What records repetitive tasks for automation?
a)
Mail Merge
b)
Macro Recorder
c)
Styles
d)
SmartArt
11.
What is needed to apply different background colors to pages?
a)
Column Breaks
b)
Section Breaks
c)
Page Breaks
d)
Line Breaks
12.
Which feature aligns objects precisely?
a)
Watermarks
b)
Gridlines
c)
Footnotes
d)
Themes
13.
Which command inserts placeholders like «FirstName»?
a)
Insert Symbol
b)
Insert Footnote
c)
Insert Field
d)
Insert Merge Field
14.
Which formula converts text to uppercase?
a)
PROPER
b)
LEFT
c)
UPPER
d)
EXACT
15.
LEFT returns:
a)
Characters from the end
b)
Text length
c)
Middle characters
d)
Characters from the start
16.
LEN returns:
a)
Position of text
b)
Characters excluding numbers
c)
Number of letters
d)
Total characters including spaces
17.
TRIM removes:
a)
All formatting
b)
All spaces
c)
Leading & trailing spaces
d)
Double spaces
18.
Which function returns the square root?
a)
FACT
b)
SQRT
c)
MOD
d)
RAND
19.
ROUND function:
a)
Returns smallest integer
b)
Rounds to nearest digit
c)
Rounds up
d)
Rounds down
20.
SUMIF allows:
a)
Sum with one condition
b)
Sum all
c)
Sum with many conditions
d)
Count totals
21.
MIN returns:
a)
Smallest value
b)
Largest value
c)
Average
d)
Sum
22.
AVERAGE returns:
a)
Highest number
b)
Total values
c)
Text count
d)
Arithmetic mean
23.
TODAY returns:
a)
Month number
b)
Date & time
c)
Current time
d)
Current date
24.
NOW returns:
a)
Week number
b)
Time only
c)
Date & time
d)
Date only
25.
EDATE is used to:
a)
Add workdays
b)
Convert text
c)
Add months
d)
Add years
26.
NETWORKDAYS returns:
a)
Weekends
b)
Calendar days
c)
Months
d)
Workdays excl. weekends & holidays
27.
IF requires at least:
a)
3 arguments
b)
2 arguments
c)
4 arguments
d)
1 argument
28.
COUNTA counts:
a)
Errors
b)
Numbers
c)
Non-blank cells
d)
Blank cells
29.
COUNTIFS allows:
a)
Only numbers
b)
Only text
c)
One condition
d)
Multiple conditions
30.
VLOOKUP searches:
a)
Upward
b)
Right to left
c)
Left to right
d)
Diagonal
31.
Which returns left & right lookup?
a)
INDEX
b)
XLOOKUP
c)
HLOOKUP
d)
VLOOKUP
32.
MATCH returns:
a)
Value
b)
Position
c)
Entire table
d)
Max match
33.
FILTER function:
a)
Manual filter
b)
Sorts data
c)
Dynamic filtered array
d)
Deletes rows
34.
PMT calculates:
a)
Interest rate
b)
Monthly loan payment
c)
Total interest
d)
Loan period
35.
FV returns:
a)
Payment
b)
Present value
c)
Count
d)
Future value
36.
What is the purpose of the Ribbon/Menu Bar in PowerPoint?
a)
To display all slides in order
b)
To add speaker notes
c)
To access various tools and features
d)
To change slide layouts
37.
Which shortcut is used to create a new slide in PowerPoint?
a)
Ctrl + N
b)
Ctrl + M
c)
Ctrl + S
d)
Ctrl + P
38.
To apply a theme in PowerPoint slides:
a)
Use 'Insert' menu
b)
Click 'Theme' on right panel
c)
Go to 'Design' tab
d)
Select 'Layout' under 'Home' tab
39.
What is a best practice for slide design regarding text?
a)
Use as much text as possible
b)
Keep text minimal
c)
Avoid bullet points
d)
Use small fonts
40.
What is the purpose of using SmartArt in presentations?
a)
To change slide backgrounds
b)
To insert charts
c)
To visualize concepts
d)
To add animations
Reset
