wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Level 7 - Office Productivity Lesson 5

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


=

a)

Equal to

b)

Division

c)

Exponentiation

d)

Subtraction

2.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


/

a)

Equal to

b)

Division

c)

Exponentiation

d)

Subtraction

3.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


^

a)

Equal to

b)

Division

c)

Exponentiation

d)

Subtraction

4.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


-

a)

Equal to

b)

Division

c)

Exponentiation

d)

Subtraction

5.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


&

a)

Concatenation

b)

Greater than

c)

Addition

d)

Less than

6.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


>

a)

Concatenation

b)

Greater than

c)

Addition

d)

Less than

7.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


+

a)

Multiplication

b)

Not equal to

c)

Addition

d)

Less than

8.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


<

a)

Multiplication

b)

Not equal to

c)

Addition

d)

Less than

9.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


*

a)

Multiplication

b)

Not equal to

c)

Addition

d)

Less than

10.

There are shortcut keys you can do in a Microsoft Word that let you do common tasks faster. Can you tell what tasks the shortcut key below do?


<>

a)

Multiplication

b)

Not equal to

c)

Addition

d)

Less than

11.

Which function in Excel should you use to accomplish the following:


You want to get an idea which country has the densest population in a square mile of territory a worksheet national populations

a)

Average

b)

Min

c)

Count

d)

Sum

12.

Which function in Excel should you use to accomplish the following:


You want to find cheapest brand from a worksheet about burgers of all popular fast food chains.

a)

Average

b)

Min

c)

Count

d)

Sum

13.

Which function in Excel should you use to accomplish the following:


You want to determine how many students passed the final exam from a worksheet about exam results.

a)

Average

b)

Min

c)

Count

d)

Sum

14.

Which function in Excel should you use to accomplish the following:


You want to find out how many tons of garbage are produced by a province from a worksheet about garbage collection in different municipalities.

a)

Average

b)

Min

c)

Count

d)

Sum

15.

Which function in Excel should you use to accomplish the following:


You want to know the tallest player from a worksheet about a basketball league.

a)

Max

b)

Min

c)

Count

d)

Sum

16.

Which function in Excel should you use to accomplish the following:


You want to find the shortest flight available from a worksheet about an airline's international destinations.

a)

Max

b)

Min

c)

Count

d)

Sum

17.

Which function in Excel should you use to accomplish the following:


You want to know the total number of canned goods from a worksheet about food donations that a charitable Organization has gathered.

a)

Max

b)

Min

c)

Count

d)

Sum

18.

Which function in Excel should you use to accomplish the following:


You want to determine the number of registered voters from an electoral worksheet.

a)

Max

b)

Min

c)

Count

d)

Sum

19.

Which function in Excel should you use to accomplish the following:


You want to know what the fastest animal is from a worksheet about the movement speed of different animals.

a)

Max

b)

Average

c)

Count

d)

Sum

20.

Which function in Excel should you use to accomplish the following:


You want to get the standard price per kilo of rice from a worksheet about rice prices in different markets in the region.

a)

Max

b)

Average

c)

Count

d)

Sum