wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Quiz

Total questions: 80

Worksheet time: 2hrs 0mins

Name
Class
Date
1.

What is the purpose of the Ribbon/Menu Bar in PowerPoint?

a)

To access various tools and features

b)

To change slide layouts

c)

To add speaker notes

d)

To display all slides in order

2.

Which shortcut is used to create a new slide in PowerPoint?

a)

Ctrl + M

b)

Ctrl + S

c)

Ctrl + P

d)

Ctrl + N

3.

What should you do to apply a theme in PowerPoint slides?

a)

Go to 'Design' tab

b)

Select 'Layout' under the 'Home' tab

c)

Click 'Theme' on the right panel

d)

Use 'Insert' menu

4.

What is a best practice for slide design regarding text?

a)

Keep text minimal

b)

Use small fonts for clarity

c)

Avoid bullet points

d)

Use as much text as possible

5.

Which of the following is NOT a recommended font for presentations?

a)

Comic Sans

b)

Calibri

c)

Arial

d)

Verdana

6.

What is the function of the Notes Section in PowerPoint?

a)

To insert images

b)

To change slide layouts

c)

To add speaker notes

d)

To display the current slide

7.

How can you group multiple shapes in PowerPoint?

a)

Use the 'Insert' menu

b)

Select and right-click, then choose 'Group'

c)

Use the 'Format' tab

d)

Drag them together

8.

What is the purpose of using SmartArt in presentations?

a)

To add animations

b)

To insert charts

c)

To visualize concepts

d)

To change slide backgrounds

9.

Which of the following is a recommended practice for using visuals in slides?

a)

Avoid using images

b)

Ensure visuals are relevant

c)

Use as many visuals as possible

d)

Use visuals as decoration

10.

What is the difference between transitions and animations in PowerPoint?

a)

Transitions apply to slides; animations apply to objects.

b)

Both apply to slides.

c)

Animations apply to slides; transitions apply to objects.

d)

There is no difference.

11.

What should you do to ensure that text stands out against the background?

a)

Use similar colors

b)

Check contrast

c)

Avoid using colors

d)

Use small fonts

12.

How can you export a PowerPoint presentation?

a)

File > Save As

b)

File > Export > Create PDF or Video

c)

File > Share

d)

File > Print

13.

What is a key feature of Presenter View?

a)

To add animations

b)

To see the current slide only

c)

To view notes and timers

d)

To change slide layouts

14.

What is the recommended number of animations per slide?

a)

3-4

b)

1-2

c)

No limit

d)

5-6

15.

How can you ensure consistency in your presentation's theme?

a)

Use different colors for each slide

b)

Avoid using themes

c)

Use the same theme throughout

d)

Change themes frequently

16.

What feature allows you to add a video to a PowerPoint presentation?

a)

Insert > Video

b)

View > Video

c)

Design > Video

d)

Home > Video

17.

How can you change the background of a slide in PowerPoint?

a)

Use the 'Home' tab

b)

Click on 'Design' and select 'Background Styles'

c)

Use the 'Insert' tab

d)

Right-click on the slide and select 'Format Background'

18.

What is the purpose of using the slide master in PowerPoint?

a)

To change the text color

b)

To add animations to individual slides

c)

To insert images on each slide

d)

To create a consistent layout across slides

19.

How can you effectively use charts in your presentation?

a)

Include too much data in one chart

b)

Ensure they are easy to read and understand

c)

Use them only for decoration

d)

Make them as complicated as possible

20.

What is the benefit of rehearsing your presentation?

a)

To memorize every word

b)

To improve delivery and timing

c)

To avoid using visuals

d)

To make it longer

21.
Which feature in Word is required for tracking document edits made by different users?
a)
Comments
b)
Track Changes
c)
Version History
d)
Compare Documents
22.
What is the correct file format to save a reusable Word template?
a)
.docx
b)
.dotx
c)
.pdf
d)
.txt
23.
What is the purpose of a company naming convention for documents?
a)
Improve file size
b)
Maintain version control
c)
Convert to PDF
d)
Password protection
24.
Which tab contains the option to open the Styles pane?
a)
Review
b)
View
c)
Home
d)
Insert
25.
Which tool allows restoring previous versions of a document?
a)
Document Inspector
b)
Version History
c)
AutoRecover
d)
Check Accessibility
26.
What must be applied to titles to generate a Table of Contents?
a)
Bullets
b)
Heading styles
c)
Custom fonts
d)
Paragraph spacing
27.
Which shortcut updates all fields in a document?
a)
Ctrl + F9
b)
Ctrl + A → F9
c)
Ctrl + Shift + F9
d)
Ctrl + Alt + F9
28.

Which view is used before splitting a document using the Master Document?

a)

Web Layout

b)

Reading View

c)

Outline View

d)

Draft View

29.

What is commonly used as a mail merge data source?

a)

PDF

b)

PowerPoint

c)

Excel Sheet

d)

Outlook Calendar

30.

How do you disconnect a mail merge document from a data source?

a)

Turn off tracking

b)

Break Link under Edit Links

c)

Delete merge fields

d)

Export PDF

31.
Which tab is required for inserting form controls?
a)
Design
b)
Review
c)
Developer
d)
View
32.
What records repetitive tasks for automation?
a)
Styles
b)
Macro Recorder
c)
Mail Merge
d)
SmartArt
33.
What is needed to apply different background colors to pages?
a)
Page Breaks
b)
Line Breaks
c)
Section Breaks
d)
Column Breaks
34.
Which feature aligns objects precisely?
a)
Themes
b)
Gridlines
c)
Footnotes
d)
Watermarks
35.

Which option saves only the current page as a PDF?

a)

Print → Save as PDF

b)

Save As → Options → Current Page

c)

Export → XPS

d)

Share

36.
Which command inserts placeholders like «FirstName»?
a)
Insert Field
b)
Insert Footnote
c)
Insert Merge Field
d)
Insert Symbol
37.
What does Ctrl + Shift + F9 do?
a)
Update fields
b)
Convert fields to text
c)
Delete fields
d)
Highlight fields
38.
Which tab is used to add comments?
a)
Review
b)
Home
c)
Insert
d)
Design
39.
Which approach ensures consistency in styles?
a)
Manual formatting
b)
Use style hierarchy
c)
Avoid styles
d)
Use only Normal
40.
Where can you manage citations?
a)
Mailings
b)
References
c)
Design
d)
Layout
41.
What does the LOWER function do?
a)
Converts text to uppercase
b)
Removes extra spaces
c)
Converts text to lowercase
d)
Extracts characters from the right
42.
Which formula converts text to uppercase?
a)
UPPER
b)
PROPER
c)
LEFT
d)
EXACT
43.
What does the LEFT function return?
a)
Characters from the end
b)
Characters from the start
c)
Middle characters
d)
Text length
44.

The LEN function returns:

a)

Number of letters

b)

Total characters including spaces

c)

Characters excluding numbers

d)

Position of text

45.
TRIM removes:
a)
All spaces
b)
Leading & trailing spaces
c)
Double spaces
d)
All formatting
46.
Which function returns the square root?
a)
MOD
b)
SQRT
c)
FACT
d)
RAND
47.
What does MOD calculate?
a)
Quotient
b)
Remainder
c)
Random number
d)
Factorial
48.
FACT returns:
a)
Average
b)
Factorial
c)
Rounded value
d)
Decimal part
49.
ROUND function:
a)
Rounds up
b)
Rounds down
c)
Rounds to nearest digit
d)
Returns smallest integer
50.
SUMIF allows:
a)
Sum all
b)
Sum with one condition
c)
Sum with many conditions
d)
Count totals
51.
MIN returns:
a)
Largest value
b)
Average
c)
Sum
d)
Smallest value
52.
AVERAGE returns:
a)
Total values
b)
Text count
c)
Arithmetic mean
d)
Highest number
53.
TODAY returns:
a)
Current date
b)
Current time
c)
Date & time
d)
Month number
54.
NOW returns:
a)
Date only
b)
Time only
c)
Date & time
d)
Week number
55.
DAYS function calculates:
a)
Days in month
b)
Days between dates
c)
Workdays
d)
Weekends
56.
EDATE is used to:
a)
Add workdays
b)
Add months
c)
Add years
d)
Convert text
57.
NETWORKDAYS returns:
a)
Calendar days
b)
Workdays excl. weekends & holidays
c)
Weekends
d)
Months
58.
IF requires at least:
a)
1 argument
b)
2 arguments
c)
3 arguments
d)
4 arguments
59.
COUNT counts:
a)
Text
b)
Numbers
c)
Blank cells
d)
Errors
60.
COUNTA counts:
a)
Numbers
b)
Blank cells
c)
Non-blank cells
d)
Errors
61.
COUNTBLANK counts:
a)
Blank cells
b)
Non-blank cells
c)
Errors
d)
Formulas
62.
COUNTIFS allows:
a)
One condition
b)
Multiple conditions
c)
Only text
d)
Only numbers
63.
AVERAGEIF does:
a)
Average by one condition
b)
Average by many conditions
c)
Averages blanks
d)
Counts averages
64.
VLOOKUP searches:
a)
Right to left
b)
Left to right
c)
Upward
d)
Diagonal
65.
Which returns left & right lookup?
a)
VLOOKUP
b)
HLOOKUP
c)
XLOOKUP
d)
INDEX
66.
MATCH returns:
a)
Value
b)
Position
c)
Entire table
d)
Max match
67.
INDEX returns:
a)
Cell address
b)
Value at row & column
c)
Sum
d)
Max value
68.
FILTER function:
a)
Manual filter
b)
Dynamic filtered array
c)
Deletes rows
d)
Sorts data
69.
PMT calculates:
a)
Total interest
b)
Monthly loan payment
c)
Loan period
d)
Interest rate
70.
FV returns:
a)
Future value
b)
Present value
c)
Payment
d)
Count
71.
RATE returns:
a)
Time period
b)
Interest rate
c)
Principal
d)
Payment
72.
PV returns:
a)
Future value
b)
Present value
c)
Term
d)
Interest earned
73.
Pivot Table does:
a)
Filters raw data
b)
Summarizes data
c)
Deletes duplicates
d)
Creates formulas
74.
A slicer is used to:
a)
Create charts
b)
Filter pivot visually
c)
Remove duplicates
d)
Highlight cells
75.
Timeline slicer filters by:
a)
Color
b)
Text
c)
Date periods
d)
Numbers
76.
Conditional formatting:
a)
Creates formulas
b)
Applies colors/icons by condition
c)
Protects cells
d)
Hides formulas
77.
Macros are used for:
a)
Formatting
b)
Data entry
c)
Automation
d)
Printing
78.
Remove Duplicates is under:
a)
Home
b)
Insert
c)
Data
d)
Review
79.
Text to Columns:
a)
Merges data
b)
Splits into columns
c)
Copies formulas
d)
Formats text
80.
Data Validation:
a)
Checks spelling
b)
Restricts data entry
c)
Formats cells
d)
Creates charts

Similar Resources on Wayground

Security+ Part 2 - Architecture and Design

80 questions

Security+ Part 2 - Architecture and Design

quiz

Worksheet

•

Professional Development

Piggy Update Wave 3 :)

81 questions

Piggy Update Wave 3 :)

quiz

Worksheet

•

KG - Professional Dev...

Generative AI MCQ Quiz

75 questions

Generative AI MCQ Quiz

quiz

Worksheet

•

Professional Development

UJIAN DIAGNOSTIK SAINS KOMPUTER TINGKATAN 4

78 questions

UJIAN DIAGNOSTIK SAINS KOMPUTER TINGKATAN 4

quiz

Worksheet

•

7th Grade - Professio...

IT Fundamentals Pro Prep Hardware

75 questions

IT Fundamentals Pro Prep Hardware

quiz

Worksheet

•

7th Grade - Professio...

Python Programming

75 questions

Python Programming

quiz

Worksheet

•

Professional Development

01-Developer 1-85

83 questions

01-Developer 1-85

quiz

Worksheet

•

Professional Development

5/23 - IT Bridge Final Review

84 questions

5/23 - IT Bridge Final Review

quiz

Worksheet

•

Professional Development