wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Computer Apps Exam 2019 Part I

Total questions: 60

Worksheet time: 30mins

Name
Class
Date
1.

Which of the following can you easily do in Powerpoint?

a)

duplicate a slide

b)

add a slide

c)

delete a slide

d)

all of the above

2.

You can animate all of the following EXCEPT what in Powerpoint?

a)

a chart

b)

an image

c)

a color

d)

a text placeholder

3.

The way each new slide appears on the screen is a:

a)

duplication

b)

animation

c)

transition

d)

none of these

4.

The first slide you see in Powerpoint is called the:

a)

Slide sorter slide

b)

title slide

c)

animation slide

d)

main slide

5.

Which sign represents multiplication in Excel?

a)

/

b)

-

c)

+

d)

*

6.

Which sign represents division in Excel?

a)

/

b)

-

c)

+

d)

*

7.

Which formula multiplies the value in cell D3 by F7 and then divides the product by the value in cell B20?

a)

=D3/F7/B20

b)

=D3*(F7/B20)

c)

=(D3*F7)/B220

d)

=F7/D3*B20

8.

Which will work when moving a range in Excel?

a)

highlight the column, move your mouse to the border of the range of cells and drag and drop them to the desired location

b)

highlight the column, press CUT on the HOME ribbon, and click the desired cells and drag and drop them to the desired location

c)

either of these will work!

d)

neither of these will work!

9.

To edit a cell in Excel:

a)

Click on the formula bar and type in the desired words or numbers

b)

go to the desired cell and press F2 to edit it

c)

either of these will work

d)

neither of these will work

10.

A function formula has _________ parts.

a)

2

b)

3

c)

4

d)

5

11.

Which formula multiplies B10 by 30?

a)

=B10/30

b)

=B10*30

c)

=B10+30

d)

=B10-30

12.

Which function will determine the largest or highest value?

a)

Min

b)

Max

c)

Sum

d)

Total

13.

If you were to subtract the value in cell A20 from B60, the formula would look like this:

a)

=B60/A20

b)

=A20-B60

c)

=B60-A20

d)

none of these is correct

14.

Which formula will divide the value in cell D8 by 8?

a)

=D8*8

b)

=(D8)8

c)

=D8/8

d)

none of these

15.

A resume should never include your:

a)

email address

b)

street address

c)

name

d)

driver's license number

16.

Which of the following is NOT an appropriate email to use on any business document, including a resume:

a)

lconte@ plps.org

b)

lori.conte@plps.org

c)

sweetiepie@plps.org

d)

all of these are appropriate

17.

In Excel, an example of a range would be:

a)

B20@B45

b)

B20?B45

c)

=B20:B45

d)

=B20+B45

18.

WIth the fill handle in Excel, you can easily copy:

a)

numbers

b)

months

c)

formulas

d)

all of these

19.

Which of the following are function formulas?

a)

=AVERAGE

b)

=MAXIMUM

c)

=MINIMUM

d)

all of these are function formulas

20.

In Excel, the cell that you are currently in and entering data or text in is called the _________________ cell.

a)

primary

b)

secondary

c)

function

d)

active

21.

In Word, when you change a document, you _______ it.

a)

delete

b)

modify or edit

c)

remove

d)

none of these

22.

What is the first line of text in a flyer called?

a)

signature line

b)

headline

c)

header

d)

heading

23.

When you type words continuously in Word without having to hit ENTER/RETURN at the end of every line, you are using:

a)

spell check

b)

drop and drag

c)

fill

d)

wordwrap

24.

Twelve complimentary colors for text, background, and links in a document are known as ________________________in Word.

a)

design schemes

b)

color schemes

c)

modification schemes

d)

none of these

25.

Parts of a business letter do NOT include:

a)

inside address

b)

headline

c)

complimentary close

d)

salutation

26.

Your high school transcript and report cards are included in your resume.

a)

TRUE

b)

FALSE

27.

The first slide in a Powerpoint presentation is called the:

a)

main slide

b)

slide sorter slide

c)

title slide

d)

none of these

28.

Can you change fonts and colors in a theme when you use Powerpoint?

a)

No, the themes are set with specific colors and won't change

b)

Sure, change the colors you would like!

29.

Google Slides will enable student to work collaboratively.

a)

TRUE

b)

FALSE

30.

There is more than one way in Powerpoint to advance a slide.

a)

TRUE

b)

FALSE

31.

You can insert videos into a Google Slides presentation, but not into Microsoft Powerpoint.

a)

TRUE

b)

FALSE

32.

You can print out slides in Google Slides and Powerpoint.

a)

TRUE

b)

FALSE

33.

When one slide moves off of the screen and another enters, this is known as a:

a)

animation

b)

transition

c)

presentation

d)

none of these

34.

Google Slides and Microsoft Powerpoint have the same template designs.

a)

TRUE

b)

FALSE

35.

You can animate graphics, text and pictures in both Powerpoint and Google Slides.

a)

TRUE

b)

FALSE

36.

You can print out each slide individually on a page or you can print out several slides on one page in Powerpoint and Slides.

a)

TRUE

b)

FALSE

37.

Microsoft Powerpoint has more features than Google Slides.

a)

TRUE

b)

FALSE

38.

You cannot delete slides in slide sorter view.

a)

TRUE

b)

FALSE

39.

Which of the following are part of animation in Powerpoint?

a)

exit

b)

entrance

c)

emphasis

d)

all of these are part of animation in Powerpoint

40.

Which of the following have pre-made templates that can assist you in creating a presentation?

a)

Google Slides

b)

Powerpoint

c)

both Google Slides and Powerpoint

d)

neither Google Slides or Powerpoint

41.

You can do the following in an Excel spreadsheet:

a)

rotate text

b)

insert pictures/images

c)

change the amount of decimal places in a number

d)

all of these can be done in Excel

42.

How do you select cells in Microsoft Excel?

a)

use the "point-and-click" method

b)

type a cell reference in the "Name" box and hit enter

c)

either use the "point-and-click" method or type a cell reference in the "Name" box

d)

select Cell-select Cell

43.

Which formula will add the numbers in cells A3, B3, and C3?

a)

=sum(A3:C3)

b)

=A3+B3+C3

c)

both of these formulas will work

d)

neither of these will work

44.

Which formula will add the sums A15 through A30?

a)

=sum(A15:A30)

b)

=sumA15:A30

c)

=sum(A15+A30)

d)

none of these

45.

Microsoft Excel, Word and Powerpoint will work together if you choose to use them together.

a)

TRUE

b)

FALSE

46.

When there is an error in Excel, the program will tell you about it!

a)

TRUE

b)

FALSE

47.

The "point-and-click" method lets you:

a)

type a cell reference in the name box

b)

click on a cell to select it

c)

delete a cell

d)

insert an image

48.

Which of the following can you do in Excel, Word and Powerpoint?

a)

rotate text

b)

color text

c)

underline text

d)

all of these can be done in Excel, Word and Powerpoint

49.

In a formula in Excel, which is performed FIRST?

a)

the item to the left

b)

the item to the right

c)

the item in parentheses

d)

the item that is last

50.

Worksheets can be inserted into your Excel Workbook.

a)

TRUE

b)

FALSE

51.

When working with image/pictures in Word, Excel and Powerpoint, you can use picture styles and artistic effects to change the picture and recolor it.

a)

TRUE

b)

FALSE

52.

Which of the following are in a function formula?

a)

the equals sign

b)

the function name

c)

the argument

d)

all of these are in a function formula

53.

You cannot edit the chart type in Excel after you have already created the chart.

a)

TRUE

b)

FALSE

54.

A ____________________ shows a collection of _________________ that combine to form a workbook.

a)

worksheet, spreadsheets

b)

spreadsheet; worksheets

c)

cell; columns

d)

cell; rows

55.

A picture representation of data is called a ______________.

a)

worksheet

b)

spreadsheet

c)

image

d)

chart

56.

You can delete or add worksheets in an Excel workbook.

a)

TRUE

b)

FALSE

57.

In Excel, what should you do to print a section of your spreadsheet?

a)

File-Print

b)

File-Print Area-Set Print Area and then File-Print

c)

Hit PRTSCRN

d)

none of these is correct

58.

=D7:G7 is called a:

a)

column

b)

row

c)

merged cell

d)

range

59.

To merge cells in Excel:

a)

highlight the cells you want to merge over and select the"Merge Cells" button

b)

you cannot merge cells in Excel spreadsheets

c)

select File-Merge cells

d)

none of these

60.

Which determines the best width for a column or the best height for a row in Excel?

a)

Merge cells

b)

automerge

c)

autofit

d)

bestwidth