wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

SHAHHEN's MSOffice

Total questions: 124

Worksheet time: 2hrs 4mins

Name
Class
Date
1.

PowerPoint is a:

a)

presentation application

b)

spreadsheet application

c)

word processing application

d)

none of the above

2.
Word is a:
a)
spreadsheet application
b)
database application
c)
word processing application
d)
none of the above
3.

In PowerPoint you create:

a)

slide shows

b)

documents

c)

spreadsheets

d)

none of the above

4.

Excel is a:

a)

database application

b)

spreadsheet application

c)

word processing application

d)

none of the above

5.

In Excel you create:

a)

spreadsheets

b)

documents

c)

slide shows

d)

none of the above

6.

The file extension for Excel:

a)

.pptx

b)

.docx

c)

.xlsx

d)

none of the above

7.

The file extension for PowerPoint:

a)

.pptx

b)

.xlsx

c)

.mdbx

d)

none of the above

8.

The "boxes" in Microsoft Excel are called...

a)

Griddies

b)

Boxes

c)

Cells

d)

Spreadsheets

9.

In Excel, the heading "boxes" going from left to right are called...

a)

Rows

b)

Columns

c)

Letters

d)

Headers

10.

Word processing, spreadsheets, and presentation software are examples of what?

a)

Collaboration software

b)

Productivity software

c)

Utility software

d)

Operating System add-ins

11.

In Excel, the heading "boxes" going from top to bottom are called...

a)

Rows

b)

Columns

c)

Numbers

d)

Headers

12.

In which Microsoft Office product can you work with animations?

a)

Excel

b)

Word

c)

Outlook

d)

PowerPoint

13.

In which core Office product can you use the Find and Replace function?

a)

Word

b)

Excel

c)

PowerPoint

d)

Word, Excel, and PowerPoint.

14.
NAME THE ICON
a)
BOLD
b)
ITALIC
c)
CENTER
d)
UNDERLINE
15.
What software program is this?
a)
Word
b)
Excel
c)
Power Point
d)
Outlook
16.
a)
Font Size
b)
Font Color
c)
Font Type
d)
Text Effect
17.
What software program is this?
a)
Word
Word
b)
Excel
c)
One Note
d)
Power Point
18.
a)
Bold
b)
Font Size
c)
Font Type
d)
Font Color
19.
What software program is this?
a)
Word
b)
Excel
c)
Power Point
d)
Outlook
20.
a)
Text Box
b)
Shapes
c)
Word Art
d)
Font Styles
21.
Q12. Which tab to you click to save ?
a)
Home
b)
Insert
c)
File
d)
View
22.
a)
Bold
b)
Font Size
c)
Font Type
d)
Font Color
23.
a)
Spell Check
b)
Word Count
c)
Page Count
d)
Word Art
24.
NAME THE ICON
a)
NEW
b)
CUT
c)
COPY
d)
PASTE
25.
a)
Center align
b)
Increase font
c)
Font name
d)
Underline
26.
a)
save
b)
undo
c)
redo
d)
underline
27.
Q8. what we call the Space around the edges of a page ?
a)
Page orientation
b)
Margins
c)
headers
d)
footers
28.
Q2. If you make a mistake what you can do ?
a)
press control U
b)
delete your work and start over
c)
click the undo button at the top of the page
d)
click the redo button at the top of the page
29.
Q1. A horizontal line that is placed under the word ?
a)
Bold
b)
Underline
c)
Italics
d)
Subscript
30.
A ______________ is a grid of rows and column in which you enter text, numbers and the results of calculations.
a)
document
b)
spreadsheet
c)
table
d)
publisher
31.
What application can you use to create letters and reports?
a)
Word
b)
PowerPoint
c)
Excel
d)
Outlook
32.
What application can you use to create spreadsheets?
a)
Word
b)
PowerPoint
c)
Excel
d)
Outlook
33.
What application can you use to create presentations?
a)
Word
b)
PowerPoint
c)
Excel
d)
Outlook
34.
What type of application is Word?
a)
Word processor
b)
Email
c)
Spreadsheet
d)
Presentations
35.

What is Microsoft Excel designed for?

a)

creating presentations

b)

store formulas

c)

storing, organizing, and manipulating data using spreadsheets.

d)

create documents

36.

Which tab is the default active tab?

a)

The Tools tab

b)

The Home tab

c)

the Insert tab

d)

The File tab

37.

Keyboard shortcut "Ctrl-V" does what?

a)

Copy

b)

Delete

c)

Paste

d)

Print

38.

Keyboard shortcut "Ctrl-P" does what?

a)

Delete

b)

Print

c)

Paste

d)

Copy

39.

Keyboard shortcut "Ctrl-C" does what?

a)

Copy

b)

Delete

c)

Paste

d)

Print

40.

What does PDF stand for?

a)

Portable Document Files

b)

Printed Document Files

c)

Put Dem Far

d)

Portable Document Format

41.
What is the name of the marked cell in the image?
a)

A7

b)

C1

c)

B3

d)

B2

42.
What is shown in the following image?


a)
TRANSITIONS
b)
ANIMATIONS
c)

VIDEOS

d)
sounds
e)
DESIGN
43.


What is shown in the following image?

a)
TRANSITIONS

b)
ANIMATIONS
c)

VIDEOS

d)
SOUNDS
e)
DESIGN
44.
What is shown in the following image?
a)
TRANSITIONS
b)
ANIMATIONS
c)

VIDEOS

d)
SOUNDS
e)
DESIGN
45.
Which formula is correctly written?


a)

B3+C1

b)

=SUMAG2:G7)

c)

=A7+D2

d)

H2/F1*J8

46.
Keyboard shortcut to copy and paste


a)

Ctrl+C , Ctrl+V

b)

Ctrl+X  , Ctrl + V

c)

Ctrl+ Z + Ctrl+ C

d)
None of the above
47.

Short Key for copy

a)

Ctrl+X

b)

Ctrl+C

c)

Ctrl+V

d)

Ctrl+N

48.

Short Key for cut

a)

Ctrl+X

b)

Ctrl+C

c)

Ctrl+V

d)

Ctrl+N

49.

Short Key for paste

a)

Ctrl+X

b)

Ctrl+C

c)

Ctrl+V

d)

Ctrl+N

50.

Short Key for undo

a)

Ctrl+Z

b)

Ctrl+Y

c)

Ctrl+V

d)

Ctrl+N

51.

Short Key for new document

a)

Ctrl+Z

b)

Ctrl+Y

c)

Ctrl+V

d)

Ctrl+N

52.

Short Key for right alignment

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+U

53.

Short Key for underline

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+U

54.

Short Key for bold

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+B

55.

Short Key for center alignment

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+C

56.
What does this button do?
a)
Change the font
b)
Change the size
c)
Change the color
d)
Make it bold
57.
Where do you go to put a picture on your page?
a)
Home
b)
File
c)
Insert
d)
Save
58.
What does this button let you do?
a)
Cut
b)
Copy
c)
Paste
d)
Insert
59.
What does this button let you do?
a)
Cut
b)
Copy
c)
Paste
d)
Insert
60.

Short key for replace is

a)

Ctrl+H

b)

Ctrl+F

c)

Ctrl+I

d)

Ctrl+B

61.

Short key for find

a)

Ctrl+Y

b)

Ctrl+F

c)

Ctrl+H

d)

Ctrl+Z

62.

A ......... is made up of rows and columns.

a)

Power point

b)

Word

c)

Table

d)

Format

63.

To draw your own table, select

a)

Table > Insert

b)

Insert > Table > Insert Table

c)

Insert > Table

d)

Insert > Table > Draw Table

64.

To save a file, Select

a)

Insert > Save

b)

File > Save

c)

View > Save

d)

Review > Save

65.

The ........ sends the cursor to the beginning of the next line or executes a command or operation.

a)

Shift key

b)

Tab key

c)

Enter key

d)

Backspace key

66.

To select all text in a Word document, press ..........

a)

Ctrl + V

b)

Ctrl + B

c)

Ctrl + C

d)

Ctrl + A

67.

The .......... key erases the text to the left of the insertion point one character at a time.

a)

Backspace

b)

Delete

c)

Enter

d)

Shift

68.

The ......... at the top of a window displays an application-defined icon and line of text.

a)

Title bar

b)

Menu bar

c)

Taskbar

d)

Tool box

69.

On the ........., Microsoft Word displays the name of the document you are currently using.

a)

Tool box

b)

Taskbar

c)

Menu bar

d)

Title bar

70.

A .......... is a graphical control element which contains drop-down menus.

a)

Taskbar

b)

Title bar

c)

Menu bar

d)

Tool box

71.

The icon of left alignment is

a)
b)
c)
d)
72.

The icon of right alignment is

a)
b)
c)
d)
73.

The icon of center alignment is

a)
b)
c)
d)
74.

The icon of justify alignment is

a)
b)
c)
d)
75.

Shortcut key to start a presentation from the beginning is

a)

F1

b)

F2

c)

F5

d)

F7

76.

Shortcut key for End the presentation is

a)

ESC

b)

Shift

c)

Control

d)

Enter

77.

Shortcut key to align the selected text in left

a)

Ctrl + L

b)

Ctrl + R

c)

Ctrl + S

d)

Ctrl + U

78.

.......... is a feature included in Microsoft PowerPoint software that allows the user to see all the slides in a presentation at one time.

a)

Normal view

b)

Slide sorter view

c)

View

d)

Slide show view

79.

............ is the main editing view, which is used to write and design a presentation.

a)

Normal View

b)

Slide show view

c)

Slide sorter view

d)

View

80.

......... View takes up the full computer screen, like an actual slide show presentation.

a)

Slide Show

b)

Normal

c)

Slide sorter

d)

Views

81.

To save an existing file with new location we should........command.

a)

Save

b)

Save and replace

c)

Save as

d)

New file

82.

We have two kinds of view in Access. Datasheet view and (a)   view.

83.

A table is divided into __________________

a)

field and form

b)

fields and records

c)

datasheet and design

d)

record and form

84.

One example of a database would be ...

a)

grocery list

b)

stamp collection

c)

movie collection

d)

cell phone contact list

85.

Access offers different views of objects. Which view do you use to edit a table?

a)

Datasheet View

b)

Design View

c)

Table View

d)

Print View

86.

What software do you use to make databases?

a)

Access

b)

Excel

c)

PowerPoint

d)

Word

87.

These sort, filter, and summarize data.

a)

Tables

b)

Forms

c)

Queries

d)

Reports

88.

Which of these options is the best to use for a primary key?

a)

Number

b)

Currency

c)

Short Text

d)

Autonumber

89.

In Microsoft Access, a field labelled “Price” must be created as

a)

Currency

b)

Primary Key

c)

Number 

d)

Short Text

90.

A __________ helps us to keep the information in our database structured

a)

Primary Key

b)

Record

c)

Autonumber

d)

Field

91.

To delete or rename a field in Microsoft Access, the first thing to do is _________

a)

Right click on the field

b)

Delete the field

c)

Double Click on the field

d)

Open the field

92.

Which view can be used to enter data into the database?

a)

Design View 

b)

Record View

c)

Field View

d)

Form View

93.

Which of these is not an example of a field type?

a)

Picture

b)

Short Text

c)

Date and Time

d)

Yes/No

94.

Microsoft Excel uses columns while Microsoft Access uses _________

a)

Fields

b)

Records

c)

Tables

d)

Movement

95.

These provide printable views of table or query data that you can share.

a)

Tables

b)

Forms

c)

Queries

d)

Reports

96.

What software do you use to make databases?

a)

Access

b)

Excel

c)

PowerPoint

d)

Word

97.

In your database, information is stored in the ...

a)

Table

b)

Report

c)

Query

d)

Form

98.

Records in a table can be updated any time.

a)

True

b)

False

99.

Which object would you create to share the data from your database with others?

a)

Form

b)

Report

c)

Query

d)

Table

100.

The most common way to look at a table in Access is ...

a)

Datasheet View

b)

Design View

c)

Table View

d)

Print View

101.

Multiple tables that are related to each other is known as ...

a)

Access Database

b)

Relational Database

c)

Database Tables

d)

Informational Database

102.

These are key objects in a database. They contain the data that is stored in the database and are made up of rows and columns.

a)

Table

b)

Report

c)

Query

d)

Form

103.

A request for data results from a database or for action on the data.

a)

query

b)

table

c)

file

d)

record

104.

A database object that you can use to create a user interface for a database application.

a)

form

b)

report

c)

record

d)

field

105.

This can offer a way to view, format, and summarize the information in your Microsoft Access database.

a)

query

b)

table

c)

form

d)

report

e)

record

106.

A group of fields, such as a telephone number, address and name, which are pertinent to a particular item. These are also known as rows.

a)

query

b)

field

c)

report

d)

records

107.

A piece of information related to a single person or thing; also known sometimes as columns.

a)

table

b)

query

c)

form

d)

field

108.

A field or set of fields with values that are unique throughout a table.

a)

primary key

b)

foreign key

c)

database

d)

record

109.

The properties of a field describe the characteristics and behavior of data added to that field.

a)

database

b)

data type

c)

field

d)

record

110.

An organized collection of structured information, or data, typically stored electronically in a computer system.

a)

database

b)

record

c)

primary key

d)

foreign key

111.

In a database, the rows are also known as

a)

fields

b)

records

c)

tables

d)

forms

112.
What extension is the data file created in Microsoft Access  program?
a)

*.acd

b)

*.doc

c)

*.accdb

d)

*.mdb

113.

Division symbol in spreadsheet.

a)

/

b)

+

c)

=

114.

Which page orientation makes the sides longer than the top and bottom?

a)

landscape

b)

portrait

c)

fixed

d)

variable

115.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

116.

If you see a series of "######" in a cell, that means the following:

a)

Row height is too high

b)

Column width is not wide enough

117.

To sort names in a worksheet, we can use ____ button

a)
b)
c)
d)
118.

Excel refers to files as

a)

Databases

b)

Workbook

c)

Document

119.

To arrange data in alphabetical or numerical order is what?

a)

coding

b)

sorting

c)

graphing

d)

grouping

120.

When inserting a formula, always start with

a)

-

b)

*

c)

+

d)

=

121.

___ are vertical

a)

Row

b)

Column

122.
Microsoft Word is used to collect Numeric data
a)
True
b)
False
123.
A PowerPoint Presentation shouldn't present too much information
a)
True
b)
False
124.

Identify the name of the red cell

a)

A11

b)

A10

c)

A12