wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

COMP 3 Final Exam

Total questions: 44

Worksheet time: 2hrs 12mins

Name
Class
Date
1.

A PowerPoint feature that is a section where text and/or graphics are entered.

a)

Title Holder

b)

Subtitle Holder

c)

Title Bar

d)

Thumbnail slide

2.

A section in PowerPoint that displays a snapshot of each slide.

a)

Title Holder

b)

Subtitle holder

c)

Title Bar

d)

Thumbnail slide

3.

It is area where text and graphics are entered for a presentation.

a)

Title Bar

b)

File Bar

c)

Status Bar

d)

Work Area

4.

It is a robust application that allows you to combine text, graphics, and predesigned backgrounds to create professional presentations.

a)

MS Office

b)

MS Word

c)

MS Powerpoint

d)

MS Excel

5.

It provides a quick means to execute commands.

a)

Windows 10

b)

Windows Features

c)

Windows Tools

d)

Windows Commands

6.

It’s a way to present a PowerPoint where file displays the slide show on a monitor or computer-projected large screen.

a)

On-screen slide show

b)

Web Pages

c)

Overhead transparency

d)

Handouts

7.

It’s a way to present a PowerPoint where file can print two to nine mini slides per page.

a)

On-screen slide show

b)

Web Pages

c)

Overhead transparency

d)

Handouts

8.

Slides that are unformatted and have no color scheme.

a)

Handouts

b)

Design

c)

Blank

d)

Webpages

9.

It is the main editing view in MS PowerPoint that user used to write and design their presentation.

a)

Slide show

b)

Reading view

c)

Normal view

d)

Slide sorter view

10.

It is an exclusive view of your slides in thumbnail form.

a)

Slide show

b)

Reading view

c)

Normal view

d)

Slide sorter view

11.

Visual effects that a user can see when moving from one slide to the next.

a)

Animation

b)

Slide show

c)

Timing

d)

Transition

12.

It displays group of related commands within tabs.

a)

Ribbon

b)

Thumbnail

c)

Status Bar

d)

Title Bar

13.

Displays several view modes for slide.

a)

Thumbnail slide

b)

Title placeholder

c)

Subtitle placeholder

d)

View option

14.

A year where a user-friendly internet interface was created.

a)

1986

b)

1991

c)

1992

d)

1995

15.

A year where 4G network is introduced.

a)

2007

b)

2009

c)

2010

d)

2020

16.

The year where email was introduced.

a)

1970

b)

1971

c)

1972

d)

1973

17.

This is where the first user-friendly internet interface is developed.

a)

University of Minnesota

b)

University of Nevada

c)

Massachusetts Institute of Technology

d)

Harvard University

18.

A spreadsheet windows feature that displays the active cell location.

a)

Title Bar

b)

File Tab

c)

Name Box

d)

Status Bar

19.

A spreadsheet feature that is identified by its first and last cell address, separated by a colon.

a)

Cell

b)

Range

c)

Ribbon

d)

Worksheet

20.

A  spreadsheet navigation method that moves the cursor to cell A1

a)

Ctrl + Tab

b)

Ctrl + Pg Up

c)

Ctrl + End

d)

Ctrl + Home

21.

A spreadsheet navigation method that is used move around the spreadsheet to view columns and rows not currently visible.

a)

Mouse pointer

b)

Arrow keys

c)

Enter

d)

Scroll bars

22.

A chart tool that allows you to change your chart type, layout, and style.

a)

Chart Tab

b)

Design Ribbon

c)

Format Ribbon

d)

Chart title

23.

It is a feature in Excel that allows you to place records in order alphabetically or numerically.

a)

Auto Filter

b)

Custom Filter

c)

Sorting

d)

Chart

24.

It is an Excel feature that allows you to keep row or column titles on the screen while you scroll through long lists on a worksheet.

a)

Freeze panes

b)

Scroll Bar

c)

Sorting

d)

Page break

25.

An additional feature in excel that makes it easy to trace, modify, and understand which figures make up a formula.

a)

Display formulas

b)

Help and Tutorials

c)

Range finder

d)

Named ranges

26.

It is the most common math operation performed in Excel.

a)

Subtraction

b)

Multiplication

c)

Division

d)

Addition

27.

A mouse pointer style that will select a single cell to enter data, retype data or delete text from the selected cell and is useful for selecting a range of cells.

a)

White plus sign

b)

White arrow

c)

Black plus sign

d)

Pointer

28.

A mouse pointer style that activates the fill handle of the selected cell and will fill the adjoining cells with some type of series, depending on the type of data.

a)

White plus sign

b)

White arrow

c)

Black plus sign

d)

Pointer

29.

A function in excel that sums all values and divides by the total number of values.

a)

Sum

b)

Average

c)

Maximum

d)

Minimum

30.

An excel additional feature that allows you to view and quickly locate data that meet specific criteria.

a)

Auto Filter

b)

Custom Filter

c)

Auto Fill

d)

Range Finder

31.

It is a presentation application that enables an individual from any technical level to create a dynamic and professional-looking presentation.

(a)  

32.

It is a worldwide/global system of interconnected computer networks.

(a)  

33.

What is TCP/IP acronym stands for?

(a)  

34.

What is the syntax for the function Payment (PMT)

(a)  

35.

It is information that prints at the top or bottom of each page in the printout.

(a)  

36.

An excel additional feature that occurs when data cannot fit on one page during printing or preview.

(a)  

37.

A program that manipulates numerical data and text

(a)  

38.

What is the syntax for average?

(a)  

39.

The old for internet is (a)   .

40.

It is a is criminal activity that either targets or uses a computer, a computer network or a networked device.

(a)  

41.

Enumeration:

Give the 8 basic steps for creating a formula.

(Separate your answer using comma or any other symbol)

4 lines
42.

Enumeration:

Give the Mathematical order of hierarchy that MS excel follows.

(Separate your answer using comma or any other symbol)

4 lines
43.

Enumeration:

Give at least 6 spreadsheet navigation method.

(Separate your answer using comma or any other symbol)

4 lines
44.

Enumeration:

Give at least 5 types of cybercrime.

(Separate your answer using comma or any other symbol)

4 lines