wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Word and Excel Quiz

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.

Which file extension is used for Microsoft Word documents by default?

a)

.xls

b)

.docx

c)

.pptx

d)

.txt

2.

In MS Word, which tab contains the “Font” and “Paragraph” groups?

a)

Insert

b)

View

c)

Home

d)

Layout

3.

What is the function of the “Ctrl + A” shortcut in MS Word?

a)

Select all text

b)

Align text

c)

Add a hyperlink

d)

Select one paragraph

4.

Which shortcut key is used to **save** a document in MS Word?

a)

Ctrl + N

b)

Ctrl + S

c)

Ctrl + C

d)

Ctrl + V

5.

The “Mailings” tab in Word is used primarily for:

a)

Drawing shapes

b)

Merging data with letters or labels

c)

Creating charts

d)

Adjusting page layout

6.

The “Ctrl + F” shortcut is used to:

a)

Find text

b)

Format paragraph

c)

Insert table

d)

Copy text

7.

In MS Word, what is a “header”?

a)

Text at the bottom of the page

b)

Text at the top of the page

c)

A footnote reference

d)

A citation marker

8.

Which view is best for reading long documents on screen?

a)

Print Layout

b)

Web Layout

c)

Read Mode

d)

Outline

9.

To insert a page break, you can press:

a)

Ctrl + Enter

b)

Shift + Enter

c)

Alt + Enter

d)

Ctrl + Shift + Enter

10.

What is the default font style in MS Word (modern versions)?

a)

Arial

b)

Times New Roman

c)

Calibri

d)

Verdana

11.

The “Track Changes” feature is used to:

a)

Protect the document

b)

Show or hide formatting marks

c)

Record edits and revisions

d)

Merge cells in a table

12.

In Word, “Ctrl + E” aligns the text:

a)

Left

b)

Right

c)

Center

d)

Justify

13.

What is the function of the “Format Painter”?

a)

Changes the font color

b)

Copies and applies text formatting

c)

Inserts shapes

d)

Opens the Page Setup dialog

14.

To open a new blank document, press:

a)

Ctrl + O

b)

Ctrl + N

c)

Ctrl + Shift + N

d)

Ctrl + Alt + N

15.

Which of the following is NOT a valid view in MS Word?

a)

Draft View

b)

Outline View

c)

Slide Sorter View

d)

Print Layout View

16.

“Ctrl + K” is used to:

a)

Insert a hyperlink

b)

Add a bookmark

c)

Delete a hyperlink

d)

Insert a table

17.

The “Ctrl + Shift + L” shortcut applies:

a)

Numbering

b)

Bulleted list

c)

Alignment

d)

Indentation

18.

To open the “Save As” dialog box directly, press:

a)

F12

b)

Ctrl + F12

c)

Shift + F12

d)

Alt + F4

19.

Which of the following can be used to combine letters with a data source in MS Word?

a)

Mail Merge

b)

Format Painter

c)

Document Inspector

d)

SmartArt

20.

The “Ctrl + Shift + >” increases:

a)

Line spacing

b)

Font size

c)

Indentation

d)

Page margin

21.

Mail Merge is used to:

a)

Format text styles

b)

Send bulk letters with personalized information

c)

Insert images

d)

Protect a document

22.

The data file in Mail Merge is usually created in:

a)

Word

b)

Excel

c)

PowerPoint

d)

Access only

23.

Which of the following is NOT a Mail Merge component?

a)

Main document

b)

Data source

c)

Merge fields

d)

Comment pane

24.

The placeholder for personalized data (like >) is called:

a)

Merge field

b)

Data link

c)

Filter

d)

Form control

25.

In Mail Merge, which document type is used to create mailing labels?

a)

Main letter document

b)

Directory

c)

Label document

d)

Form letter

26.

The command to start the Mail Merge wizard is found under:

a)

Home → Paragraph

b)

Mailings → Start Mail Merge

c)

Insert → Quick Parts

d)

View → Macros

27.

The process of combining data from the main document and the data source is called:

a)

Linking

b)

Merging

c)

Formatting

d)

Sorting

28.

Which file format is ideal for data sources in Mail Merge?

a)

.csv

b)

.jpg

c)

.pptx

d)

.pdf

29.

When using Mail Merge, which step comes first?

a)

Select recipients

b)

Write your letter

c)

Choose document type

d)

Insert merge fields

30.

To preview merged results, click:

a)

Mailings → Preview Results

b)

Insert → Merge Field

c)

Review → Compare

d)

View → Draft

31.

What is the default file extension of Excel 2019?

a)

.docx

b)

.xlsx

c)

.csv

d)

.xlsm

32.

In Excel, rows are labeled as:

a)

Letters (A, B, C, …)

b)

Numbers (1, 2, 3, …)

c)

Both A and B

d)

None

33.

Which function adds up all the numbers in a range?

a)

=AVERAGE()

b)

=SUM()

c)

=ADD()

d)

=COUNT()

34.

The intersection of a row and column is called:

a)

Formula

b)

Cell

c)

Box

d)

Table

35.

Shortcut to copy content in Excel:

a)

Ctrl + X

b)

Ctrl + C

c)

Ctrl + Z

d)

Ctrl + S

36.

Shortcut to paste content:

a)

Ctrl + C

b)

Ctrl + V

c)

Ctrl + P

d)

Ctrl + A

37.

Which formula calculates the average of B2 to B6?

a)

=MEAN(B2:B6)

b)

=AVERAGE(B2:B6)

c)

=SUM(B2:B6)/5

d)

Both B and C

38.

What is the function of “Ctrl + ;” in Excel?

a)

Insert current time

b)

Insert current date

c)

Insert formula

d)

Insert link

39.

Which chart type is best for showing parts of a whole?

a)

Line chart

b)

Column chart

c)

Pie chart

d)

Scatter plot

40.

Which key combination creates a new workbook?

a)

Ctrl + N

b)

Ctrl + O

c)

Ctrl + Shift + N

d)

Ctrl + Alt + N

41.

Which of the following represents a cell reference correctly?

a)

1A

b)

A1

c)

A-1

d)

RowA

42.

Which function counts numeric entries only?

a)

COUNTA

b)

COUNT

c)

COUNTIF

d)

SUM

43.

To freeze the first row, click:

a)

View → Freeze Panes → Freeze Top Row

b)

Home → Format → Freeze

c)

Data → Sort → Freeze

d)

Insert → Table → Freeze

44.

The AutoSum button is represented by which Greek letter?

a)

Alpha (α)

b)

Beta (β)

c)

Sigma (Σ)

d)

Delta (Δ)

45.

To edit the contents of a cell, press:

a)

F2

b)

F1

c)

F4

d)

F12

46.

Shortcut key to undo last action:

a)

Ctrl + X

b)

Ctrl + Z

c)

Ctrl + U

d)

Ctrl + P

47.

“Ctrl + Shift + L” toggles what feature?

a)

Filter

b)

Formula bar

c)

Chart

d)

Pivot Table

48.

The “IF” function is used to:

a)

Filter text

b)

Perform logical tests

c)

Sort data

d)

Add numbers

49.

The cell reference that remains constant when copied is called:

a)

Relative reference

b)

Absolute reference

c)

Mixed reference

d)

Conditional reference

50.

To quickly move to cell A1, press:

a)

Ctrl + Home

b)

Ctrl + End

c)

Alt + Home

d)

Shift + Home

Similar Resources on Wayground

Diagnostics Test 01 in Thermodynamics

50 questions

Diagnostics Test 01 in Thermodynamics

quiz

Worksheet

•

University

Parts of Speech in Automation and Robotics

50 questions

Parts of Speech in Automation and Robotics

quiz

Worksheet

•

University

QUIZ PTI PERTEMUAN I-III

45 questions

QUIZ PTI PERTEMUAN I-III

quiz

Worksheet

•

University

Unit 3.2 – Pumps

47 questions

Unit 3.2 – Pumps

quiz

Worksheet

•

University

MID SEMESTER ENGLISH ENGINEER

50 questions

MID SEMESTER ENGLISH ENGINEER

quiz

Worksheet

•

University

Casting and Moulding Quiz (MES unit 3)

50 questions

Casting and Moulding Quiz (MES unit 3)

quiz

Worksheet

•

University

Quiz Teknik Tegangan Tinggi

50 questions

Quiz Teknik Tegangan Tinggi

quiz

Worksheet

•

University

Johnson Controls India Assessment Test 02

50 questions

Johnson Controls India Assessment Test 02

quiz

Worksheet

•

University