wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Quiz tentang Microsoft Office

Total questions: 120

Worksheet time: 1hrs 3mins

Name
Class
Date
1.

Microsoft Word adalah perangkat lunak pengolah …

a)

Angka

b)

Gambar

c)

Basis Data

d)

Kata

e)

Presensi

2.

Berikut ini merupakan perangkat lunak pengolah angka pada paket Microsoft Office adalah …

a)

Microsoft Windows

b)

Microsoft PowerPoint

c)

Microsoft Excel

d)

Microsoft Word

e)

Microsoft Paint

3.

Fungsi yang digunakan untuk menemukan nilai terbesar pada sebuah range data di Ms. Excel adalah …

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

e)

COUNT

4.

Fungsi yang digunakan untuk menemukan nilai rata-rata pada sebuah range data di Ms. Excel adalah …

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

e)

COUNT

5.

Fungsi yang digunakan untuk menemukan jumlah nilai pada sebuah range di Ms. Excel adalah …

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

e)

COUNT

6.

Untuk membuat presentasi, perangkat lunak yang digunakan adalah …

a)

PowerPoint

b)

Word

c)

Excel

d)

Access

e)

Windows

7.

Perangkat lunak Office yang paling banyak penggunanya adalah …

a)

Libre Office

b)

Open Office

c)

Star Office

d)

WPS Office

e)

Microsoft Office

8.

Perangkat lunak juga disebut …

a)

Hardware

b)

Brainware

c)

Software

d)

Malware

e)

Spyware

9.

Komputer terdiri dari perangkat keras yang meliputi berikut ini, kecuali …

a)

Keyboard

b)

CPU

c)

Mouse

d)

Memory

e)

RAM

10.

Perangkat keras komputer yang berfungsi untuk memasukkan data ke dalam komputer adalah …

a)

Perangkat input

b)

Media penyimpanan

c)

Perangkat output

d)

Perangkat pemroses

e)

Perangkat media

11.

Peralatan komputer berupa papan ketik yang berfungsi memasukkan data, angka, dan karakter serta menjalankan perintah pada komputer adalah …

a)

Mouse

b)

Scanner

c)

Joystick

d)

Keyboard

e)

CPU

12.

Pengoperasian mouse dengan mengarahkan pointer mouse pada objek lalu tekan dan tahan tombol kiri mouse sambil gerakkan mouse ke tempat yang diinginkan lalu dilepas disebut …

a)

Click

b)

Double click

c)

Drag

d)

Right click

e)

Drag click

13.

Berikut ini yang termasuk perangkat keras output adalah …

a)

Mouse

b)

Keyboard

c)

Monitor

d)

Joystick

e)

CPU

14.

Perangkat keras komputer yang bisa disebut juga mikroprosesor adalah …

a)

Monitor

b)

Mouse

c)

CPU

d)

Keyboard

e)

LCD

15.

Tombol Caps Lock yang ada pada keyboard berfungsi untuk …

a)

Mengunci tombol angka

b)

Mengunci penggulung layar

c)

Mematikan komputer secara otomatis

d)

Mengunci huruf kapital/besar

e)

Mengubah jenis huruf

16.

Aplikasi saling terhubung satu sama lain dengan bertukar pesan adalah integrasi dengan cara …

a)

Pemanggil prosedur / function

b)

Messaging

c)

Sharing database

d)

File transfer

e)

Pemanggil file

17.

Alat yang digunakan untuk menampilkan presentasi agar dapat terlihat di layar lebar adalah …

a)

Televisi

b)

OHP

c)

LCD Proyektor

d)

Screen

e)

CPU

18.

Berikut ini adalah dokumen yang bisa dibuat dengan Microsoft Word adalah …

a)

Surat

b)

Laporan

c)

Piagam

d)

Brosur

e)

Pengolah foto

19.

Lembar kerja Microsoft Excel berbentuk …

a)

Kertas kosong

b)

Tabel

c)

Slide

d)

Area gambar

e)

Kolom

20.

Bar program yang berisi tentang judul atau nama file program yang sedang aktif disebut …

a)

Title Bar

b)

Standard Bar

c)

Menu Bar

d)

Formatting Toolbar

e)

Insert Bar

21.

Ikon mail merge terdapat pada menu …

a)

Insert

b)

Page Layout

c)

References

d)

Mailings

e)

View

22.

Untuk mencetak dokumen menggunakan …

a)

Microsoft Word

b)

Scanner

c)

Printer

d)

Microsoft PowerPoint

e)

Microsoft Excel

23.

Program pengolah kata dari Microsoft Office adalah …

a)

Ms. Access

b)

Ms. Excel

c)

Ms. Word

d)

Ms. PowerPoint

e)

Windows

24.

Perintah untuk melakukan cetak miring melalui keyboard adalah …

a)

Ctrl + A

b)

Ctrl + C

c)

Ctrl + I

d)

Ctrl + U

e)

Ctrl + P

25.

Perintah untuk melakukan cetak tebal melalui keyboard pada Microsoft Word adalah …

a)

Ctrl + V

b)

Ctrl + Z

c)

Ctrl + U

d)

Ctrl + B

e)

Ctrl + C

26.

Tab yang digunakan untuk mengatur jenis huruf dan ukuran huruf adalah …

a)

Home

b)

Insert

c)

View

d)

Reference

e)

Page Layout

27.

Tab yang digunakan untuk menyisipkan gambar adalah …

a)

Home

b)

Insert

c)

View

d)

Reference

e)

Page Layout

28.

Tab yang digunakan untuk mengatur ukuran kertas adalah …

a)

Tab Home

b)

Tab Insert

c)

Tab Layout

d)

Tab View

e)

Tab Reference

29.

Perintah untuk menyisipkan gambar/foto pada dokumen Microsoft Word adalah …

(a)  

30.

Apa yang digunakan untuk mengatur ukuran kertas?

a)

Tab Beranda

b)

Tab Sisipkan

c)

Tab Tata Letak

d)

Tab Tampilan

e)

Tab Referensi

31.

How to select or block all letters using the keyboard?

a)

Ctrl + A

b)

Ctrl + S

c)

Ctrl + C

d)

Ctrl + E

e)

Ctrl + B

32.

The tab used to insert a table is?

a)

Home

b)

Insert

c)

Mailings

d)

View

e)

Reference

33.

The margin tab is used to set?

a)

Header and Footer

b)

Hyperlink

c)

Paragraph

d)

Paper size

e)

Font size

34.

The button to minimize the Microsoft Word window is called?

a)

Maximize

b)

Minimize

c)

Restore

d)

Close

e)

Cut

35.

The button used to maximize the Microsoft Word window is?

a)

Maximize

b)

Minimize

c)

Restore

d)

Close

e)

Cut

36.

An area on the worksheet that is rectangular and contains a collection of cells is called?

a)

Sheet

b)

Column

c)

Range

d)

Pointer

e)

Gridline

37.

To give a border to a cell, the menu that must be selected in the format cells dialog box is?

a)

Number

b)

Alignment

c)

Borders

d)

Font

e)

File

38.

The button used to format text to italic is?

a)

Ctrl + B

b)

Ctrl + I

c)

Ctrl + U

d)

Ctrl + S

e)

Ctrl + O

39.

In Excel, the meaning of range is?

a)

Intersection of worksheets

b)

Intersection of workbooks

c)

Collection of arbitrary cells

d)

Collection of rectangular cells

e)

Intersection of rows and columns

40.

In Excel, the meaning of worksheet is?

a)

Collection of worksheets

b)

Collection of several cells

c)

Intersection of rows and columns

d)

Intersection of cells and range

e)

Worksheet in Excel

41.

The command used to duplicate data is?

a)

Cut and Paste

b)

Copy and Paste

c)

Copy and Cut

d)

Select All and Copy

e)

Copy and Save

42.

When working with Excel, information about the page, rows, columns, etc. can be seen on?

a)

Status Bar

b)

Menu Bar

c)

Format Bar

d)

Toolbar

e)

Formula Bar

43.

The content of cell B3 below is?

a)

I

b)

I LOVE CYBER WORLD

c)

CYBER WORLD

d)

I LIKE PHYSICS

e)

I LIKE CYBER WORLD

44.

Which of the following cannot be used to run Excel?

a)

Shortcut on Desktop

b)

Start Menu

c)

Excel File

d)

Word Document

e)

Search Excel

45.

One of the benefits of spreadsheet software, except?

a)

Creating graphs

b)

Creating financial reports

c)

Creating logos

d)

Creating tables

e)

Creating cards

46.

The open command can be executed from the file menu and the open button in the standard toolbar. Additionally, the open command can also be executed by pressing the button?

a)

Ctrl + V

b)

Ctrl + O

c)

Ctrl + U

d)

Ctrl + B

e)

Ctrl + S

47.

The command used to cut or move the contents of a cell is?

a)

Undo

b)

Redo

c)

Cut

d)

Copy

e)

Save

48.

The name of the icon is?

a)

Short time

b)

Merge cell

c)

Open cell

d)

Read cell

e)

Close cell

49.

From the dialog box above, the document is saved with the file name?

a)

Train1

b)

Train2

c)

Train3

d)

Train4

e)

Train5

50.

Every time you exit Microsoft Excel or Microsoft Word, unsaved edits are always warned with a dialog box. What does this statement mean?

4 lines
51.

The statement means that before exiting, whether the changes to the manuscript should be saved.

a)

Before exiting, whether the changes to the manuscript should be saved

b)

Whether to exit directly

c)

Whether the manuscript is not closed

d)

Whether the changes to the manuscript are merged with another manuscript

e)

Whether the manuscript should be deleted

52.

The meaning of the term 'drag' in mouse usage is...

a)

Moving or directing the mouse pointer to the desired part

b)

Pressing the right mouse button twice

c)

Pressing the left mouse button once

d)

Pressing the mouse button and moving the mouse to the desired position without releasing it

e)

Blocking all text

53.

To close and exit Microsoft Word from the menu bar using...

a)

File - Quit

b)

File - Close

c)

File - Exit

d)

File - Shutdown

e)

File - Open

54.

The program that can be used to manage book loans in the library is...

a)

Ms. Word

b)

Ms. Excel

c)

Ms. PowerPoint

d)

FrontPage

e)

Windows

55.

A data storage space in Windows Explorer, based on certain types of data is...

a)

File

b)

Field

c)

Folder

d)

Function

e)

Menu

56.

In the Microsoft Office Excel table, there is a box that is horizontal, called...

a)

Row

b)

Column

c)

Cell

d)

Range

e)

Drag

57.

The intersection between rows and columns that forms a data box is called...

a)

Row

b)

Column

c)

Cell

d)

Range

e)

Drag

58.

A combination of several cells that are shaded or blocked is called...

a)

Row

b)

Column

c)

Cell

d)

Range

e)

Drag

59.

Microsoft Word is a software for processing...

a)

Words

b)

Numbers

c)

Data

d)

Images

e)

Videos

60.

The software used for processing numbers in the Microsoft Office package is...

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft PowerPoint

d)

FrontPage

e)

Windows

61.

The function used to find the largest value in a range of data in Ms. Excel is...

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

e)

COUNT

62.

The function used to find the average value in a range of data in Ms. Excel is...

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

e)

COUNT

63.

The function used to find the sum of values in a range in Ms. Excel is...

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

e)

COUNT

64.

To create a presentation, the software used is...

a)

PowerPoint

b)

Word

c)

Excel

d)

Access

e)

Publisher

65.

The Office software with the most users is...

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft PowerPoint

d)

Microsoft Access

e)

Microsoft Office

66.

Software is also called...

a)

Hardware

b)

Firmware

c)

Software

d)

Malware

e)

Adware

67.

A computer consists of hardware, except...

a)

CPU

b)

Memory

c)

Input devices

d)

Output devices

e)

Software

68.

The computer hardware that functions to input data into the computer is...

a)

Input device

b)

Output device

c)

Storage device

d)

Processing device

e)

Network device

69.

The computer equipment in the form of a keyboard that functions to input data, numbers, and characters and execute commands on the computer is...

a)

Mouse

b)

Keyboard

c)

Monitor

d)

Printer

e)

Scanner

70.

The operation of the mouse by directing the mouse pointer to an object, then pressing and holding the left mouse button while moving the mouse to the desired place and then releasing it is called...

a)

Click

b)

Drag

c)

Drop

d)

Select

e)

Highlight

71.

The following are included in output hardware...

a)

Printer

b)

Monitor

c)

Speaker

d)

Projector

e)

All of the above

72.

The computer hardware that can also be called a microprocessor is...

a)

RAM

b)

CPU

c)

Motherboard

d)

Hard Drive

e)

Power Supply

73.

The Caps Lock key on the keyboard functions to...

a)

Lock capital letters

b)

Unlock capital letters

c)

Switch between upper and lower case

d)

Turn on the keyboard light

e)

None of the above

74.

Applications that are interconnected with each other by exchanging messages are integrated in the way of...

a)

Networking

b)

Messaging

c)

Cloud Computing

d)

Data Sharing

e)

None of the above

75.

The tool used to display presentations so that they can be seen on a large screen is...

a)

Projector

b)

Screen

c)

Monitor

d)

Television

e)

Laptop

76.

The following is a document that can be created with Microsoft Word...

a)

Letter

b)

Spreadsheet

c)

Presentation

d)

Database

e)

Webpage

77.

The worksheet in Microsoft Excel is shaped like...

a)

Table

b)

Chart

c)

Graph

d)

Diagram

e)

List

78.

The program bar that contains the title or name of the active program file is called...

a)

Menu Bar

b)

Title Bar

c)

Status Bar

d)

Tool Bar

e)

Navigation Bar

79.

The mail merge icon is found in the menu...

a)

Home

b)

Insert

c)

Layout

d)

Mailings

e)

Review

80.

To print a document using...

a)

Scanner

b)

Printer

c)

Fax

d)

Email

e)

Cloud

81.

The word processing program from Microsoft Office is...

a)

Ms. Word

b)

Ms. Excel

c)

Ms. PowerPoint

d)

Ms. Access

e)

Ms. Publisher

82.

The command to italicize through the keyboard is...

a)

Ctrl + I

b)

Ctrl + B

c)

Ctrl + U

d)

Ctrl + S

e)

Ctrl + P

83.

The command to bold through the keyboard in Microsoft Word is...

a)

Ctrl + I

b)

Ctrl + B

c)

Ctrl + U

d)

Ctrl + S

e)

Ctrl + P

84.

What is the keyboard shortcut for italicizing text?

a)

Ctrl + A

b)

Ctrl + B

c)

Ctrl + I

d)

Ctrl + J

85.

What is the keyboard shortcut for bolding text in Microsoft Word?

a)

Ctrl + A

b)

Ctrl + B

c)

Ctrl + I

d)

Ctrl + J

86.

Which tab is used to set font type and size?

a)

Home

b)

Insert

c)

Layout

d)

View

87.

Which tab is used to insert images?

a)

Home

b)

Insert

c)

Layout

d)

View

88.

Which tab is used to set paper size?

a)

Home

b)

Insert

c)

Layout

d)

View

89.

What is the command to insert a picture in a Microsoft Word document?

a)

Insert

b)

Copy

c)

Paste

d)

Delete

90.

How to open a new document in Microsoft Word?

a)

Office button - New - Blank Document

b)

File - New

c)

Ctrl + N

d)

Ctrl + O

91.

What does Ctrl + J do in Microsoft Word?

a)

Align left

b)

Align right

c)

Justify

d)

Center

92.

How to align text to the left using the keyboard?

a)

Ctrl + L

b)

Ctrl + R

c)

Ctrl + E

d)

Ctrl + J

93.

How to save the current file using the keyboard?

a)

Ctrl + S

b)

Ctrl + A

c)

Ctrl + P

d)

Ctrl + O

94.

How to select or highlight all text using the keyboard?

a)

Ctrl + A

b)

Ctrl + C

c)

Ctrl + V

d)

Ctrl + X

95.

Which tab is used to insert tables?

a)

Home

b)

Insert

c)

Layout

d)

View

96.

What does the margin tab control?

a)

Page size

b)

Text alignment

c)

Paper size

d)

Margins

97.

What is the button to minimize the Microsoft Word window?

a)

Maximize

b)

Minimize

c)

Close

d)

Restore

98.

What is the button used to maximize the Microsoft Word window?

a)

Maximize

b)

Minimize

c)

Close

d)

Restore

99.

What is a rectangular area in a worksheet that contains a group of cells called?

a)

Cell

b)

Range

c)

Row

d)

Column

100.

To add a border to a cell, which menu should be selected in the format cells dialog box?

a)

Borders

b)

Fill

c)

Font

d)

Alignment

101.

Which key combination is used to italicize text?

a)

Ctrl + I

b)

Ctrl + B

c)

Ctrl + U

d)

Ctrl + A

102.

In Excel, what does the term 'range' refer to?

a)

A single cell

b)

A group of cells

c)

A worksheet

d)

A workbook

103.

In Excel, what does the term 'worksheet' refer to?

a)

A single cell

b)

A group of cells

c)

A worksheet

d)

A workbook

104.

What command is used to duplicate data?

a)

Copy and Paste

b)

Cut and Paste

c)

Delete

d)

Move

105.

When working in Excel, where can you see information about the page, rows, columns, etc.?

a)

Status Bar

b)

Formula Bar

c)

Menu Bar

d)

Ribbon

106.

What is the content of cell B3?

a)

SAYA SUKA DUNIA MAYA

b)

Hello World

c)

Excel is fun

d)

Data Science

107.

Which of the following cannot be used to run Excel?

a)

Excel file

b)

Word document

c)

Shortcut

d)

Command line

108.

Which of the following is not a benefit of spreadsheet software?

a)

Data analysis

b)

Creating charts

c)

Making logos

d)

Data storage

109.

The open command can be executed from the file menu and the open button in the standard toolbar. Additionally, the open command can also be executed by pressing which key on the keyboard?

a)

Ctrl + O

b)

Ctrl + N

c)

Ctrl + P

d)

Ctrl + S

110.

What command is used to cut or move the contents of a cell?

a)

Cut

b)

Copy

c)

Paste

d)

Delete

111.

What is the name of the icon?

a)

Merge cells

b)

Split cells

c)

Delete cells

d)

Format cells

112.

From the dialog box above, the document is saved with the file name:

a)

Latih1

b)

Latih2

c)

Latih3

d)

Latih4

113.

Every time you exit Microsoft Excel or Word, unsaved edits are always warned with a dialog box. What does this statement mean?

a)

Before exiting, whether to save changes

b)

Exit without saving

c)

Save automatically

d)

Close the program

114.

What does the term 'drag' mean in mouse usage?

a)

Press the mouse button and move the mouse

b)

Click and release

c)

Double click

d)

Right click

115.

To close and exit Microsoft Word from the menu bar, use:

a)

File - Exit

b)

File - Close

c)

Ctrl + Q

d)

Alt + F4

116.

What program can be used to manage book loans in the library?

a)

Ms. Excel

b)

Ms. Word

c)

PowerPoint

d)

Access

117.

What is a storage space for data in Windows Explorer, based on certain types of data?

a)

Folder

b)

File

c)

Drive

d)

Shortcut

118.

In Microsoft Office Excel, what is a horizontal box called?

a)

Row

b)

Column

c)

Cell

d)

Range

119.

What is the intersection of rows and columns that forms a data box called?

a)

Cell

b)

Range

c)

Row

d)

Column

120.

What is a group of cells that are shaded or blocked called?

a)

Range

b)

Cell

c)

Row

d)

Column