Free Printable Office Productivity Final Exam

1.

Which is NOT a type of chart?

a)

bar

b)

axis

c)

pie

d)

column

2.

Which programs can you use to calculate spreadsheets?

a)

Microsoft publisher & Google docs

b)

Google sheets & Microsoft word

c)

Google sheets & Microsoft Excel

d)

Microsoft excel & Google slides

3.

Formulas start with which symbol?

a)

%

b)

=

c)

-

d)

(

4.

In a database, what is one piece of information called?

a)

Field

b)

Record

c)

Table

d)

Entry

5.

Chloe is creating a database for several customers. What is the data type for the field total sales?

a)

Yes/No

b)

Data

c)

Number

d)

Currency

6.

Alice has started a new business. She needs to provide a monthly update to her customers. What is MOST APPROPRIATE?

a)

Newsletter

b)

Letterhead

c)

Flyer

d)

Brochure

7.

Your teacher has asked you to relocate the picture on page one to page two where it relates to the topic. What design principle is NOT being utilized?

a)

Balance

b)

Proximity

c)

Alignment

d)

Repetition

8.

Brenda has started a new business. She needs away to give her contact information. What is MOST APPROPRIATE?

a)

Business card

b)

Newsletter

c)

Flyer

d)

Brochure

9.

Avery has started a new business. She needs a design for the top of her letter. What is MOST APPROPRIATE?

a)

Business card

b)

Letterhead

c)

Flyer

d)

Brochure

10.

Brenda advertises in magazines that targets college graduates. What is her target audience?

a)

Age

b)

Education

c)

Interests

d)

Group membership

11.

Brenda advertises in magazines that targets athletes. What is her target audience?

a)

Age

b)

Education

c)

Interests

d)

Group membership

12.

Bill needs to design an invitation to the FBLA Awards Luncheon. What type of computer program would he MOST LIKELY use?

a)

Desktop Publishing

b)

Multimedia

c)

Spreadsheet

d)

Virtual Reality

13.

Which function can an accounting department use in Cell A2 that will result in the current date?

a)

Count

b)

Count A

c)

Days360

d)

Now

14.

Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?

a)

X-axis

b)

Y-axis

c)

Legend

d)

Chart title

15.

Observe the given image and choose the correct answer.

a)

Scatter Chart

b)

Pie Chart

c)

Radar Chart

16.

In __________ tab Chart button is available.

a)

File

b)

Illustratoins

c)

Design

d)

Insert

17.

Identify this chart.

a)

Pie

b)

Line

c)

Bar

d)

Column

18.

Identify this chart.

a)

Line

b)

Bar

c)

Column

d)

Pie

19.

Identify this chart.

a)

Column

b)

Bar

c)

Line

d)

Pie

20.

Tells you what each part of the chart represents.

a)

Legend

b)

Vertical axis

c)

Horizontal axis

d)

Chart title

21.

a)

BAR

b)

LINE

c)

STOCK

d)

COMBO

22.

Fernanda wants to calculate the number of days between two dates. What function would she used?

a)

=NOW360

b)

=Date

c)

=Date360

d)

=DAYS360

23.

Jennifer is creating a database for several customers. How will she list the Customer ID?

a)

Yes/No

b)

Data

c)

Number

d)

Currency

24.

A manager has requested a list of all products over $100 and in size “Large”. How would this information be retrieved?

a)

Sort Ascending

b)

Sort Descending

c)

Filter

d)

Find

25.

Your boss has required all products from lowest price to highest. How would this information be retrieved?

a)

Sort Ascending

b)

Sort Descending

c)

Filter

d)

Find

26.

A one-page document used to advertise about a one time, upcoming event is called a:

a)

brochure

b)

letterhead

c)

business card

d)

flyer

27.

Which is NOT a spreadsheet function?

a)

MIN

b)

ADD

c)

MAX

d)

SUM

28.

You started a business and need something you can hand out to help people remember you and your business. What is this publication called?

a)

business card

b)

newsletter

c)

brochure

d)

business letter

29.

Which is NOT a type of chart?

a)

bar

b)

axis

c)

pie

d)

column

30.

In PowerPoint you create:

a)

slide shows

b)

documents

c)

spreadsheets

d)

none of the above

31.

In Excel you create:

a)

spreadsheets

b)

documents

c)

slide shows

d)

none of the above

32.

What software program is this?

a)

Power Point

b)

Excel

c)

Word

d)

One Note

33.

What software program is this?

a)

Word

b)

Excel

c)

Power Point

d)

Outlook

34.

What software program is this?

a)

Word
Word

b)

Excel

c)

One Note

d)

Power Point

35.

Outlook

a)

b)

c)

d)

36.

NAME THE ICON

a)

BOLD

b)

ITALIC

c)

CENTER

d)

UNDERLINE

37.

Chase wants to total all values in a column, what function would he use

a)

=DATE

b)

=MAX

c)

=SUM

d)

=IF

38.

Lillian wants to write a function that returns the lowest number in a series of numbers. What function would she use?

a)

=SUM

b)

=LOW

c)

=MIN

d)

=AVERAGE

39.

Riley wants to calculate days based on the current date. What function would he use to for the CURRENT date?

a)

=DATE

b)

=MAX

c)

=NOW

d)

=IF

40.

Fernanda wants to calculate the number of days between two dates. What function would she used?

a)

=NOW360

b)

=Date

c)

=Date360

d)

=DAYS360

41.

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

42.

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

43.

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

a)

table

b)

query

c)

form

d)

field

44.

In a database, the rows are also known as

a)

fields

b)

records

c)

tables

d)

forms

45.

What software do you use to make databases?

a)

Access

b)

Excel

c)

PowerPoint

d)

Word

46.

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

a)

Table

b)

Report

c)

Query

d)

Form

47.

In a Table, a column is known as a ...

a)

Record

b)

Garden

c)

Field

d)

Stage

48.

Records in a table can be updated any time.

a)

True

b)

False

49.

One example of a database would be ...

a)

grocery list

b)

stamp collection

c)

movie collection

d)

cell phone contact list

50.

An organized collection of information about a subject is a ...

a)

database

b)

table

c)

file

d)

record

Office Productivity Final Exam

Total questions: 50

Worksheet time: 57mins

Similar Resources on Wayground