wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Office Automation Test

Total questions: 70

Worksheet time: 20mins

Name
Class
Date
1.

The function of the ______ is to display the current file's name and the name of the currently opened office program.

a)

States bar

b)

Ribbon

c)

Quick Access toolbar

d)

Title bar

2.

You can used the _______ command to wrap the text within a cell.

a)

`Auto Complete

b)

Wrap text

c)

Formatting

d)

Header row

3.

A formula can contain:

a)

Number

b)

Operator

c)

Text

d)

All of these

4.

You can perform large and complex calculation in a fraction of a second using:

a)

Power point

b)

Word

c)

Excel

d)

Calculation

5.

______ function returns the current date and time in the active cell.

a)

COUNT()

b)

NOW()

c)

AVERAGE()

d)

TODAY()

6.

Presentation are made up of one or more ______

a)

Image

b)

Animation

c)

Pages

d)

Slide

7.

Short Key for copy

a)

Ctrl+X

b)

Ctrl+C

c)

Ctrl+V

d)

Ctrl+N

8.

Short Key for paste

a)

Ctrl+X

b)

Ctrl+C

c)

Ctrl+V

d)

Ctrl+N

9.

Short Key for cut

a)

Ctrl+X

b)

Ctrl+C

c)

Ctrl+V

d)

Ctrl+N

10.

Short Key for undo

a)

Ctrl+Z

b)

Ctrl+Y

c)

Ctrl+V

d)

Ctrl+N

11.

Short Key for redo

a)

Ctrl+Z

b)

Ctrl+Y

c)

Ctrl+V

d)

Ctrl+N

12.

Short Key for new document

a)

Ctrl+Z

b)

Ctrl+Y

c)

Ctrl+V

d)

Ctrl+N

13.

Short Key for right alignment

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+U

14.

Short Key for underline

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+U

15.

Short Key for bold

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+B

16.

Short Key for center alignment

a)

Ctrl+R

b)

Ctrl+L

c)

Ctrl+E

d)

Ctrl+C

17.

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

18.

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

19.

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

a)

Taskbar

b)

Title bar

c)

Menu bar

d)

Tool box

20.

In Microsoft Windows, the ........ is under the title bar.

a)

Taskbar

b)

Tool box

c)

Title bar

d)

Menu bar

21.

The ......... is an element of an operating system located at the bottom of the screen.

a)

Taskbar

b)

Menu bar

c)

Title bar

d)

Tool box

22.

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

a)

Save

b)

Save and replace

c)

Save as

d)

New file

23.

To print a document.....

a)

Select the Print command and then select ok

b)

Select the Ready Printer command and then select OK

c)

Type Print and then press Enter

d)

None of these

24.

To apply center alignment to a paragraph we can press

a)

Ctrl + S

b)

Ctrl + C

c)

Ctrl + C + A

d)

Ctrl + E

25.

We can insert a page number at

a)

Header

b)

Footer

c)

Both A and B

d)

None

26.

We can remove / hide border of a shape by selecting …

a)

No Line

b)

No Outline

c)

White Line

d)

No Border

27.

We can remove / hide border of a table by selecting …

a)

No Line

b)

No Outline

c)

White Line

d)

No Border

28.

What is the main difference between the "Save" and "Save As" commands?

a)

"Save As" saves a copy of the file with a new name. "Save" is used to save changes to the file.

b)

"Save" is found in Backstage view, while "Save As" is only found on the Quick Access Toolbar.

c)

"Save As" is used simply to save changes to the file.

d)

None, there is no difference in how these commands function.

29.

What is the best application to create a slideshow presentation?

a)

Access

b)

Excel

c)

PowerPoint

d)

Word

30.

What is the best application to keep track of inventory for a store?

a)

PowerPoint

b)

Word

c)

Excel

d)

Access

31.

Short key for find

a)

Ctrl+Y

b)

Ctrl+F

c)

Ctrl+H

d)

Ctrl+Z

32.

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

a)

Power point

b)

Word

c)

Table

d)

Format

33.

To draw your own table, select

a)

Table > Insert

b)

Insert > Table > Insert Table

c)

Insert > Table

d)

Insert > Table > Draw Table

34.

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

a)

Ctrl + V

b)

Ctrl + B

c)

Ctrl + C

d)

Ctrl + A

35.

.......... gives you the ability to share your presentation with others in real time on the web.

a)

Word

b)

PowerPoint

c)

Excel

d)

Spreadsheet

36.

Shortcut key to start a presentation from the beginning is

a)

F1

b)

F2

c)

F5

d)

F7

37.

Shortcut key for End the presentation is

a)

ESC

b)

Shift

c)

Control

d)

Enter

38.

Shortcut key to print the document

a)

Ctrl + L

b)

Ctrl + P

c)

Ctrl + S

d)

Ctrl + I

39.

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

a)

Slide Show

b)

Normal

c)

Slide sorter

d)

Views

40.

Which of these refers to a paper printout?

a)

Soft copy

b)

Hard copy

c)

PDF

d)

Print preview

41.

Which of the following is the default view of Microsoft Window?

a)

Read Mode

b)

Web Layout

c)

Print Layout

d)

No Layout

42.

______ function returns the current date and time in the active cell.

a)

cOUNT

b)

Average

c)

Now

d)

Todey

43.

Which of the following command is used to add more than an animation to an object?

a)

New animation

b)

Exit Animation

c)

Apply animation

d)

Add animation

44.
In MS Word you create:
a)
spreadsheets
b)
documents
c)
presentations
d)
none of the above
45.
What tab do you click on to add a picture?
a)
File
b)
Home
c)
Insert
d)
Design
46.

An animation effect that occurs when a presentation moves from slide to slide in Slide Show view.

a)

ANIMATION

b)

SLIDE SHOW

c)

TRANSITION

47.
The default view in PowerPoint is 
a)
Normal View
b)
Reading View
c)
Slide Sorter View
d)
Slide Show View
48.

What is called an icon?

a)

Small picture buttons that represent commands, programs, files or folders.

b)

Bar that is located at the top of window.

c)

Where different files are kept.

d)

The data and information on the computer are stored.

49.
What is the computer "desktop"?
a)
clickable images that start various programs
b)
not a laptop
c)
the main screen you see after you log into your computer
d)
the space on top of a desk
50.
What is the start menu?
a)
the main gateway to your computer's programs and settings
b)
the main screen you see after you turn
c)
clickable images that open various programs
d)
the menu I order off of when I go out to eat
51.

Tick the Functions of a Database

a)

Updating

b)

Sorting

c)

Editing

d)

All of These

52.

A computerized record keeping system is called as

a)

Communication system

b)

Database management System(DBMS)

c)

Networking System

53.

Student's Roll no is an example of

a)

Primary Key

b)

Secondary Key

54.

Access can import a table of data from Excel.

a)

True

b)

False

55.

A unique identifier used in creating a table that assures there will be no duplicate data.

a)

Primary Key

b)

Query

c)

Data Type

d)

Secondary Key

56.

The easiest way to create forms in Ms Access is to use the ..

a)

Import option

b)

SQL

c)

Form Wizard

d)

Relationship builder

57.

Fields in database are similar to _________ in tables.

a)

Rows

b)

Columns

c)

Cells

d)

Values

58.

Ms-Access is a ___________ database

a)

Flat File

b)

Relational

c)

Object Oriented

d)

Flat

59.

What you understand by data redundancy?

a)

Assurance of the accuracy of data

b)

Duplicate values in database

c)

Security of Data

d)

None of these

60.

Which view of table is used to insert a field name in table.

a)

Date sheet

b)

Design

c)

Database

d)

all of the above

61.

The default extension of Ms-Access file is __________

a)

.acccdb

b)

.accdb

c)

.abccd

d)

.acbdc

62.

Which option is used to display the data in printable format in MS-Access?

a)

Report

b)

Query

c)

Datesheet

d)

Relationship

63.

Which key is used to define relationship between 2 tables?

a)

Candidate key

b)

Composite key

c)

Primary key

d)

Secondary key

64.
A ___________ is designed to "ask" a question of the database and returns only a subset of data
a)
Query
b)
Form
c)
Table
d)
Record
65.
The table view that displays data in rows and columns is called the
a)
datasheet view
b)
design view
c)
form view
d)
report view
66.
The ___________ displays all objects in a database
a)
object view
b)
property sheet
c)
navigation pane
d)
home tab
67.
The default data type assigned to a primary key is ________________.
a)
autonumber
b)
text
c)
number
d)
integer
68.
Which Application program saves data automatically as it is entered?
a)
MS Word
b)
PowerPoint
c)
MS Access
d)
MS Excel
69.

What can queries do? ( Choose any 3 )

a)

Filter

b)

Calculate

c)

Sort

d)

All of These

70.

The bar where information appears as you input data is called ______________.

a)

file bar

b)

help bar

c)

window bar

d)

formula bar

Similar Resources on Wayground

QUIZ FINALS 101TEN

70 questions

QUIZ FINALS 101TEN

quiz

Worksheet

•

University

ID and Access Management

70 questions

ID and Access Management

quiz

Worksheet

•

10th Grade - University

Computer Organization and Architecture Test 1

70 questions

Computer Organization and Architecture Test 1

quiz

Worksheet

•

University

CS_1

65 questions

CS_1

quiz

Worksheet

•

University

Test-PrimerParcialInfomáticaEnfermería

68 questions

Test-PrimerParcialInfomáticaEnfermería

quiz

Worksheet

•

University

Cambridge - IGCSE - Computer Science - Input Devices

66 questions

Cambridge - IGCSE - Computer Science - Input Devices

quiz

Worksheet

•

11th Grade - Professi...

H446 Section 1: Components of a computer

71 questions

H446 Section 1: Components of a computer

quiz

Worksheet

•

11th Grade - University

Java

65 questions

Java

quiz

Worksheet

•

University