wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

CIS110 FINAL EXAM

Total questions: 140

Worksheet time: 5hrs 32mins

Name
Class
Date
1.

The brains of a computer is a two-inch ceramic square with a silicon chip inside that is called the _______.

a)

CPU

b)

RAM

c)

ROM

d)

motherboard

2.

The main circuit board in a computer is the ________________.

a)

CPU

b)

LED

c)

ROM

d)

Motherboard

3.

______ memory is volatile and the contents ARE erased when the computer is turned off.

a)

RAM

b)

DROM

c)

SROM

d)

ROM

4.

Older type monitors that were much larger and heavier were known as a ____________.

a)

LCD

b)

CRT

c)

LED

d)

MTV

5.

A keyboard is an example of ______________ device.

a)

a processing

b)

an input

c)

an output

d)

a storage

6.

If you are a serious gamer your computer will probably require a faster and more expensive _______________.

a)

network card

b)

blue tooth adapter

c)

video card

d)

sound card

7.

____________ converts power from the wall outlet into the type of power that the computer can us.

a)

Power Converter

b)

Power Supply

c)

Surge Protector

d)

Power Changer

8.

Flash drives can be used in either a PC or a Mac.

a)

True

b)

False

9.

PC stands for ________________

a)

Personal Computer

b)

Power Computer

c)

Private Computer

d)

Pro Computer (Mac)

10.

A _______________ is an electronic device that manipulates information with the ability to store, retrieve, and process data.

a)

Browser

b)

Modem

c)

Computer

d)

Router

11.

Speakers are examples of ________________ devices.

a)

Processing

b)

Output

c)

Storage

d)

Input

12.

The data processing cycle contains all of the following EXCEPT:

a)

Output

b)

Storage

c)

Input

d)

Booting

13.

A computer that serves up information for other computers on a network is called a __________.

a)

Tower

b)

Server

c)

Router

d)

Laptop

14.

______ memory is non-volatile and the contents are NOT erased when the computer is turned off.

a)

DRAM

b)

SRAM

c)

ROM

d)

RAM

15.

____________ is a set of instructions that tell the computer what to do.

a)

Software

b)

Linux

c)

Hardware

d)

Excel

16.

The most powerful and expensive type of computer is a ______________.

a)

desktop

b)

supercomputer

c)

Apple Mac

d)

mainframe

17.

Connecting to a network through a wireless connection is called ____________.

a)

magic

b)

WiFi

c)

blue tooth

d)

ethernet

18.

The Mac is a desktop computer that was developed by _____________.

a)

Microsoft

b)

IBM

c)

Apple

d)

Google

19.

To use a Flash drive you must insert it into a ___________________

a)

USB Port

b)

Storage Port

c)

Video Port

d)

HDMI Port

20.

Before removing your flash drive you should:

a)

restart the computer

b)

shut down the computer

c)

shut down the flash drive

d)

disconnect/eject it

21.

To close a window in Windows you should click on ________

a)
b)
c)
d)
22.

Cloud computing means storing and accessing data via __________.

a)

a client-server network

b)

local hard drive

c)

a peer-to-peer network

d)

the Internet

23.

Microsoft offers Cloud based applications that are Internet-only versions of ________.

a)

Word

b)

Excel

c)

PowerPoint

d)

All of the above

24.

To rename a file in Windows you could _____________.

a)

Go to Edit menu, choose Rename File, type new name

b)

Right click on the file, choose Rename, type in new name

c)

Double click on the file, type in new name

d)

Left click on the file, choose Rename, type in new name

25.

To delete a file on a Mac you can drag the file into the _________.

a)

Address Bar

b)

Trash

c)

Garbage

d)

Recycle Bin

26.

OneDrive and Apple iCloud are primarily used for _________

a)

creating word processing documents

b)

creating spreadsheets

c)

creating presentations

d)

Cloud storage

27.

On a Mac you can select all the files in a folder by typing ___________.

a)

Command-A

b)

Command-B

c)

Command-X

d)

Command-S

28.

Internet Explorer, Mozilla Firefox, Google Chrome, and Safari are examples of _____

a)

Web browsers

b)

word processing software

c)

network operating system

d)

spreadsheet software

29.

In the world of technology NOS stands for __________.

a)

Novell Operating System

b)

Network Operating System

c)

NewGoogle Operating System

d)

New Operating System

30.

a)

Dock

b)

Desktop

c)

Address Line

d)

Status Bar

31.

What operating system would you find running on an Apple iPad?

a)

Windows

b)

Android

c)

Apple iOS

d)

Mac OS X

32.

Fedora is a distribution of what operating system?

a)

Linux

b)

Windows

c)

Mac OS

d)

Android

33.

An example of a peer-to-peer network operating system is _______

a)

AppleShare

b)

Windows Server

c)

Banyan Vines

d)

Novell Netware

34.

An example of a client-server network operating system is __________.

a)

AppleShare

b)

Windows for Workgroups

c)

Windows Server

d)

LANtastic

35.

What year was Windows 10 released?

a)

2012

b)

2010

c)

2000

d)

2015

36.

What year was Mac OS X (El Capitan version) released?

a)

2012

b)

2000

c)

2010

d)

2015

37.

The Chromebook runs what operating system?

a)

Chrome OS

b)

Windows 10

c)

Linux

d)

Mac OS X

38.

To minimize a window on a Mac you should click on the ____________________.

a)
b)
c)
d)
39.

To delete a file in Windows you can drag the file into the __________.

a)

Trash

b)

Address Bar

c)

Recycle Bin

d)

Garbage

40.

To maximize a window in Windows you should click on __________.

a)
b)
c)
d)
41.

Internet speeds on desktop devices are generally measured in ____________.

a)

Bytes per second

b)

Kikobytes per second

c)

Megabytes per second

d)

Megabits per second

42.

____________ is the default web browser for Mac computers and iOS devices.

a)

Internet Explorer

b)

Google Chrome

c)

Safari

d)

Mozilla Firefox

43.

The primary piece of hardware needed to connect your computer to the internet is a _______________.

a)

Router

b)

USB drive

c)

Modem

d)

Satellite dish

44.

_____________ is the probably the best browser for PCs and is the default web browser for many Android devices

a)

Safari

b)

Google Chrome

c)

Mozilla Firefox

d)

Microsoft Explorer

45.

When your computer is connected to the Internet it is said to be __________________.

a)

Offline

b)

Live

c)

Ready

d)

Online

46.

The most popular and widely used search engine is _______________.

a)

Google

b)

Bing

c)

Yahoo

d)

Dogpatch

47.

In order to connect multiple computers to the Internet or to connect through a WiFi network you will need a ___________.

a)

Local DNS

b)

Internet splitter

c)

WiFi antenna

d)

Router

48.

You should do regular backups of your computer in case you have to reformat your hard drive. This will prevent permanent loss of personal information.

a)

True

b)

False

49.

A ___________ is a made up of related text, images, and other resources.

a)

Website

b)

Modem

c)

DNS

d)

IP Address

50.

The Internet is a global network of billions of computers.

a)

True

b)

False

51.

It is a good idea to have at least two different antivirus programs installed on your computer.

a)

True

b)

False

52.

_______ converts an IP address to a URL and vice versa.

a)

WWW

b)

FTP

c)

DNS

d)

HTTP

53.

Use Google to find the answer to the following question: "Who sang the song Build Me Up Buttercup in 1968"?

a)

The Foundations

b)

The Box Tops

c)

The Beatles

d)

Lobo

54.

When creating a strong password it is a good idea to include

a)

at least 6 characters

b)

no personal information

c)

upper case letters, lower case letters, numbers, special characters

d)

all of the above

55.

he web site http://www.sdsu.edu is probably for __________________.

a)

a Part of the U.S. Military

b)

an Educational institution

c)

a Non-profit organization

d)

a Government agency

56.

Which type of Internet connection is the slowest?

a)

Satellite

b)

DSL

c)

Cable

d)

Dial-up

57.

To connect to the Internet from your home you must do it through _____________.

a)

the US Government

b)

a WWW

c)

a DNS

d)

an ISP

58.

Private browsing is a way to browse the Internet for sensitive or private information. It is available in _______________.

a)

Mozilla Firefox

b)

Safari

c)

Google Chrome

d)

It is available in all of the above

59.

74.125.28.177 is an example of _____________.

a)

www

b)

HTTP

c)

an IP Address

d)

DSL

60.

3G and 4G are are measures of Internet speed on __________.

a)

Mobile phones

b)

Apple desktops

c)

Windows desktops

d)

Cable connections

61.

When you schedule a meeting with 3 other people they will automatically be invited by sending an email to them with an attachment.

a)

True

b)

False

62.

SMTP is the standard protocol is used for ___________ emails across the Internet.

a)

receiving

b)

storing

c)

all of the above

d)

sending

63.

When sending an email you should _____________.

a)

always identify yourself

b)

include a subject line

c)

be concise

d)

All of the above

64.

You receive an email and notice that it was sent to 3 people other than you. You would like to reply to the email and have everyone receive the reply. You should choose

a)

Reply

b)

Reply All

c)

Forward

d)

none of the above

65.

The POP3 email protocol is used to send emails to a remote server

a)

True

b)

False

66.

In Outlook, if you type an email but do not send it, the email will be stored in the ___________ folder. You are able to go back later and send it.

a)

Saved Items

b)

Deleted Items

c)

Drafts

d)

To be Sent Items

67.

When you delete an email in Outlook it is moved into the ____________ folder.

a)

Deleted Items

b)

Drafts

c)

Garbage

d)

Trash Bin

68.

In Outlook you wish to delete a file from the Inbox. This could be done by by pointing at the document in the Summary Pane and clicking on the ________ button

a)
b)
c)
d)
69.

Your instructor sends an email that includes everyone in the class on the TO: line. You wish to respond to the email but only want your instructor to get your response (and no one else in the class). You should ___________ to create that response.

a)

Reply All

b)

Reply

c)

Forward

d)

None of the above

70.

In Outlook, when you receive an email it is stored in the ___________ folder

a)

Inbox

b)

Sent Items

c)

Drafts

d)

Received Items

71.

A user must be in your contacts before you can add them to a user group in Outlook.

a)

True

b)

False

72.

When communicating online, either through messaging or email, you should avoid using sarcasm

a)

True

b)

False

73.

You have a word document that you would to share with your friend in California. You could send them a copy of the document by adding it as ________ to an email and send it to them.

a)

an Add-on

b)

an Appendage

c)

an Addition

d)

an Attachment

74.

In Outlook, you have the following email in your inbox. The subject line contains _____________.

a)

David Lockwood

b)

Sampson Community College will be implementing the ne...

c)

Thu 1:21 PM

d)

none of the above

75.

In Outlook you can create a block of text that includes your name, job title, phone number, and email address that will automatically included at the bottom of all emails you send out by creating a ________________ file.

a)

ID

b)

Signature

c)

Attachment

d)

Personal

76.

In Gmail, to create a new email message you should click on ___________.

a)

Start

b)

Compose

c)

New

d)

none of the above

77.

You wish to make an email message in your Inbox stay at the top of your messages. You should point at the email message and click on the _______ button.

a)
b)
c)
d)
78.

You need to have a Google account to be able to use Gmail.

a)

True

b)

False

79.

The Calendar in Outlook allows three kinds of events: Appointments, Meetings, and All-day Events.

a)

True

b)

False

80.

In Outlook Email you can add attachment from your OneDrive folder.

a)

True

b)

False

81.

In Word 2016 if you find a word in your document with a red wavy line under it, what does it mean?

a)

it is a misspelled word

b)

it is the wrong tense of a verb

c)

it has created a grammatical error

d)

another word in the thesaurus is recommended

82.

By default, when you save a document in Word 2016 it will be saved with a file extension of ___________.

a)

.pdf

b)

.docx

c)

.doc

d)

.word

83.

You can create a list like the one below by selecting the names of the schools and clicking on _____________.

a)
b)
c)
d)
84.

In Word 2016 the Legal page size is

a)

8.5' x 11'

b)

8.27' x 11.69'

c)

7.15' x 10.5'

d)

8.5' x 14'

85.

When doing a research paper in Word 2016 you can insert citations and Works Cited in the ________ menu (tab).

a)

Insert

b)

Layout

c)

References

d)

Review

86.

The orientation of the page below is portrait

a)

True

b)

False

87.

In Word 2016 the setting of Wide margins would include ______________.

a)

3" left margin

b)

0.5" left margin

c)

2" left margin

d)

1" left margin

88.

To change the color of your text in Word 2016 you should select the text and click the ________ button

a)
b)
c)
d)
89.

Word 2016 ______________ is a predesigned document you can use to create a new document quickly.

a)

design

b)

backstage

c)

copy

d)

template

90.

In Word 2016 you can change the margins by going to the ____________ menu (tab).

a)

Design

b)

View

c)

File

d)

Layout

91.

You have typed the line below. Note the location of the insertion point. If you strike the Backspace key what will be deleted?

a)

letter p

b)

entire line

c)

letter s

d)

entire word Sampson

92.

To copy and paste text within Word 2016 (or any other application) you can use _____________________.

a)

Ctrl-X to Copy and Ctrl-P to Paste

b)

Ctrl-C to Copy and Ctrl-V to Paste

c)

Ctrl-X to Copy and Ctrl-V to Paste

d)

Ctrl-C to Copy and Ctrl-P to Paste

93.

You can find a synonym for a word by using the Thesaurus in Word 2016.

a)

True

b)

False

94.

Text that is underlined with a blue wavy line has spelling problem.

a)

True

b)

False

95.

_____________ is a benefit of using OneDrive with MS Word 2016.

a)

Access your files anywhere

b)

Back up your files

c)

Share files

d)

All of the above

96.

In Word 2016 the Find and Replace options are found on the ______________ menu (tab).

a)

Design

b)

Edit

c)

Home

d)

File

97.

You can run a spelling/grammar check on your entire document by going to the ___________ menu (tab) and choosing Spelling & Grammar.

a)

Design

b)

View

c)

Review

d)

Home

98.

You can save a word document in PDF format by going to File, Export and choose Create Adobe PDF.

a)

True

b)

False

99.

In Word 2016 you can insert automatic page numbering on either the top or bottom of the page by going to the __________ menu (tab).

a)

Format

b)

Home

c)

Page Layout

d)

Insert

100.

In Word 2016 you there are several predefined page sizes.

a)

True

b)

False

101.

In Excel 2016 a range of cells beginning with cell C5 and going to cell E9 is defined as _____________.

a)

C5-E9

b)

C5 E9

c)

C5:E9

d)

none of the above

102.

To increase the number of decimal places displayed in a number you can click on button below in the blue box.

a)

True

b)

False

103.

In Excel 2016 you can select a range of cells and hit the DELETE key on the keyboard and Excel will delete the content of the cells but leave the cells where they are.

a)

True

b)

False

104.

It is possible to change the width of columns but the height of a row cannot be changed.

a)

True

b)

False

105.

To center the contents of a range of cell vertically you should click on the ____________ button.

a)
b)
c)
d)
106.

Cell A1 contains the number 12 and cell B1 contains the number 6. If you go to cell C1 and type in the formula =A1*B1 the resulting answer displayed would be ________

a)

72

b)

18

c)

2

d)

6

107.

To change the fill or background color for a range of cells you should click on the _______________ button.

a)
b)
c)
d)
108.

In Excel 2016 you have a workbook that has already been saved to your flash drive. You wish to save it to a new folder on your OneDrive account. You should go to ______________.

a)

File, Save

b)

File, Move

c)

File, Copy

d)

File. Save as....

109.

To add a new worksheet to your current workbook you should click _________________.

a)
b)
c)
d)
110.

You are working in a worksheet pictured below. You click in cell A7 and enter the function =SUM(A2:A5). What would your answer be?

a)

36

b)

31

c)

40

d)

none of the above

111.

You can delete an entire column and it's contents by clicking on the column heading, then click on 'Delete' button in the Cells section in the ribbon in the Home tab.

a)

True

b)

False

112.

In Excel 2016 which button on the status bar would you click to go into Page Break View?

a)
b)
c)
d)

none of the above

113.

In Excel 2016 you wish to insert a new row between the current row 5 and row 6. You should ________________.

a)

click on any cell in row 5 and hit the Insert key on the keyboard

b)

click on row header of row 6 and click 'Insert' in the Cells section of the Home tab

c)

click on row header of row 5 and click 'Insert' in the Cells section of the Home tab.

d)

click in any cell on row 6 and hit the Insert key on the keyboard

114.

In Excel 2016 all formulas and functions must begin with __________ when you enter them.

a)

#

b)

&

c)

=

d)

%

115.

When saving a workbook in Excel 2016 in an XML file format the default file extension is _______________.

a)

.xls

b)

.xlst

c)

.xlsx

d)

.xlm

116.

In Excel 2016 (or Word 2016, Access 2016, or PowerPoint 2016) you can go into Backstage view by clicking on the File menu (tab).

a)

True

b)

False

117.

You cannot save Excel 2016 workbooks to OneDrive.

a)

True

b)

False

118.

The intersection of column D and row 6 is a cell with a cell address of ____________

a)

D:6

b)

6:D

c)

D6

d)

6D

119.

You are working in a worksheet pictured below. You click in cell A7 and enter the function =MAX(A2:A6). What would your answer be?

a)

6

b)

12

c)

5

d)

8

120.

In Excel 2016 the Autosave feature saves you document for you every 5 minutes by default.

a)

True

b)

False

121.

Files created in PowerPoint 2016 are called _______________.

a)

Spreadsheets

b)

Databases

c)

Presentation

d)

Documents

122.

Files created in PowerPoint 2016 can be saved to OneDrive.

a)

True

b)

False

123.

In PowerPoint 2016 you can go into Backstage view by clicking on the ___________ tab on the Ribbon

a)

File

b)

Home

c)

Design

d)

Insert

124.

When you open a PowerPoint 2016 presentation created in an older version of PowerPoint it will be opened in _____________ mode.

a)

Previous Version

b)

Edit

c)

Compatibility

d)

Read Only

125.

In PowerPoint 2016 presentations are saved as a ______________ file type (file extension).

a)

PPTX

b)

XLSX

c)

PPT

d)

PWPT

126.

In PowerPoint 2016 you can convert documents created in older versions to PowerPoint 2016 file format by going to Backstage view and choosing Convert.

a)

True

b)

False

127.

In PowerPoint 2016 a Presentation consists of a series of _____________________.

a)

panes

b)

screens

c)

slides

d)

pages

128.

A PowerPoint presentation can contain videos.

a)

True

b)

False

129.

You can add a video to a PowerPoint presentation by going to the _________ tab on the Ribbon.

a)

Home

b)

Layout

c)

Design

d)

Insert

130.

In PowerPoint 2016 transitions refer to what happens between slides in a presentation.

a)

True

b)

False

131.

In PowerPoint 2016 transitions are divided into 3 categories. Which is the following is NOT one of them?

a)

Subtle

b)

Static

c)

Dynamic

d)

Exciting

132.

In PowerPoint 2016 you can enter slide sorter view by clicking on ___________ from the status bar at bottom of screen.

a)
b)
c)
d)
133.

In PowerPoint 2016 you can start your presentation from the beginning by clicking on ______ on the Quick Access Toolbar.

a)
b)
c)
d)
134.

In the picture the area in the blue box is known as the _________________ in a PowerPoint 2016 presentation.

a)

Slide Pane

b)

Ruler

c)

Slide View Options

d)

Slide Navigation Pane

135.

In PowerPoint 2016 you can rearrange the slides after it has been completed.

a)

True

b)

False

136.

One way to organize your presentation is to separate the slides into sections.

a)

True

b)

False

137.

Which of the following is NOT a print layout available in PowerPoint 2016.

a)

Half Page Slides

b)

Note Pages

c)

Full Page Slides

d)

Handouts

138.

To change the Theme used in your presentation in PowerPoint 2016 you should go to the ________ tab in the ribbon.

a)

Insert

b)

Home

c)

Format

d)

Design

139.

When running a presentation in PowerPoint 2016 you can advance to the next slide with a Mouse Click or by setting a automatic timer for each slide.

a)

True

b)

False

140.

In PowerPoint 2016 you can add notes to each of your slides that can assist you when presenting your presentation

a)

True

b)

False