Font size
WorksheetsCIS110 FINAL EXAM
Total questions: 140
Worksheet time: 5hrs 32mins
The brains of a computer is a two-inch ceramic square with a silicon chip inside that is called the _______.
CPU
RAM
ROM
motherboard
The main circuit board in a computer is the ________________.
CPU
LED
ROM
Motherboard
______ memory is volatile and the contents ARE erased when the computer is turned off.
RAM
DROM
SROM
ROM
Older type monitors that were much larger and heavier were known as a ____________.
LCD
CRT
LED
MTV
A keyboard is an example of ______________ device.
a processing
an input
an output
a storage
If you are a serious gamer your computer will probably require a faster and more expensive _______________.
network card
blue tooth adapter
video card
sound card
____________ converts power from the wall outlet into the type of power that the computer can us.
Power Converter
Power Supply
Surge Protector
Power Changer
Flash drives can be used in either a PC or a Mac.
True
False
PC stands for ________________
Personal Computer
Power Computer
Private Computer
Pro Computer (Mac)
A _______________ is an electronic device that manipulates information with the ability to store, retrieve, and process data.
Browser
Modem
Computer
Router
Speakers are examples of ________________ devices.
Processing
Output
Storage
Input
The data processing cycle contains all of the following EXCEPT:
Output
Storage
Input
Booting
A computer that serves up information for other computers on a network is called a __________.
Tower
Server
Router
Laptop
______ memory is non-volatile and the contents are NOT erased when the computer is turned off.
DRAM
SRAM
ROM
RAM
____________ is a set of instructions that tell the computer what to do.
Software
Linux
Hardware
Excel
The most powerful and expensive type of computer is a ______________.
desktop
supercomputer
Apple Mac
mainframe
Connecting to a network through a wireless connection is called ____________.
magic
WiFi
blue tooth
ethernet
The Mac is a desktop computer that was developed by _____________.
Microsoft
IBM
Apple
To use a Flash drive you must insert it into a ___________________
USB Port
Storage Port
Video Port
HDMI Port
Before removing your flash drive you should:
restart the computer
shut down the computer
shut down the flash drive
disconnect/eject it
To close a window in Windows you should click on ________
Cloud computing means storing and accessing data via __________.
a client-server network
local hard drive
a peer-to-peer network
the Internet
Microsoft offers Cloud based applications that are Internet-only versions of ________.
Word
Excel
PowerPoint
All of the above
To rename a file in Windows you could _____________.
Go to Edit menu, choose Rename File, type new name
Right click on the file, choose Rename, type in new name
Double click on the file, type in new name
Left click on the file, choose Rename, type in new name
To delete a file on a Mac you can drag the file into the _________.
Address Bar
Trash
Garbage
Recycle Bin
OneDrive and Apple iCloud are primarily used for _________
creating word processing documents
creating spreadsheets
creating presentations
Cloud storage
On a Mac you can select all the files in a folder by typing ___________.
Command-A
Command-B
Command-X
Command-S
Internet Explorer, Mozilla Firefox, Google Chrome, and Safari are examples of _____
Web browsers
word processing software
network operating system
spreadsheet software
In the world of technology NOS stands for __________.
Novell Operating System
Network Operating System
NewGoogle Operating System
New Operating System

Dock
Desktop
Address Line
Status Bar
What operating system would you find running on an Apple iPad?
Windows
Android
Apple iOS
Mac OS X
Fedora is a distribution of what operating system?
Linux
Windows
Mac OS
Android
An example of a peer-to-peer network operating system is _______
AppleShare
Windows Server
Banyan Vines
Novell Netware
An example of a client-server network operating system is __________.
AppleShare
Windows for Workgroups
Windows Server
LANtastic
What year was Windows 10 released?
2012
2010
2000
2015
What year was Mac OS X (El Capitan version) released?
2012
2000
2010
2015
The Chromebook runs what operating system?
Chrome OS
Windows 10
Linux
Mac OS X
To minimize a window on a Mac you should click on the ____________________.
To delete a file in Windows you can drag the file into the __________.
Trash
Address Bar
Recycle Bin
Garbage
To maximize a window in Windows you should click on __________.
Internet speeds on desktop devices are generally measured in ____________.
Bytes per second
Kikobytes per second
Megabytes per second
Megabits per second
____________ is the default web browser for Mac computers and iOS devices.
Internet Explorer
Google Chrome
Safari
Mozilla Firefox
The primary piece of hardware needed to connect your computer to the internet is a _______________.
Router
USB drive
Modem
Satellite dish
_____________ is the probably the best browser for PCs and is the default web browser for many Android devices
Safari
Google Chrome
Mozilla Firefox
Microsoft Explorer
When your computer is connected to the Internet it is said to be __________________.
Offline
Live
Ready
Online
The most popular and widely used search engine is _______________.
Bing
Yahoo
Dogpatch
In order to connect multiple computers to the Internet or to connect through a WiFi network you will need a ___________.
Local DNS
Internet splitter
WiFi antenna
Router
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.
True
False
A ___________ is a made up of related text, images, and other resources.
Website
Modem
DNS
IP Address
The Internet is a global network of billions of computers.
True
False
It is a good idea to have at least two different antivirus programs installed on your computer.
True
False
_______ converts an IP address to a URL and vice versa.
WWW
FTP
DNS
HTTP
Use Google to find the answer to the following question: "Who sang the song Build Me Up Buttercup in 1968"?
The Foundations
The Box Tops
The Beatles
Lobo
When creating a strong password it is a good idea to include
at least 6 characters
no personal information
upper case letters, lower case letters, numbers, special characters
all of the above
he web site http://www.sdsu.edu is probably for __________________.
a Part of the U.S. Military
an Educational institution
a Non-profit organization
a Government agency
Which type of Internet connection is the slowest?
Satellite
DSL
Cable
Dial-up
To connect to the Internet from your home you must do it through _____________.
the US Government
a WWW
a DNS
an ISP
Private browsing is a way to browse the Internet for sensitive or private information. It is available in _______________.
Mozilla Firefox
Safari
Google Chrome
It is available in all of the above
74.125.28.177 is an example of _____________.
www
HTTP
an IP Address
DSL
3G and 4G are are measures of Internet speed on __________.
Mobile phones
Apple desktops
Windows desktops
Cable connections
When you schedule a meeting with 3 other people they will automatically be invited by sending an email to them with an attachment.
True
False
SMTP is the standard protocol is used for ___________ emails across the Internet.
receiving
storing
all of the above
sending
When sending an email you should _____________.
always identify yourself
include a subject line
be concise
All of the above
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
Reply
Reply All
Forward
none of the above
The POP3 email protocol is used to send emails to a remote server
True
False
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.
Saved Items
Deleted Items
Drafts
To be Sent Items
When you delete an email in Outlook it is moved into the ____________ folder.
Deleted Items
Drafts
Garbage
Trash Bin
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
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.
Reply All
Reply
Forward
None of the above
In Outlook, when you receive an email it is stored in the ___________ folder
Inbox
Sent Items
Drafts
Received Items
A user must be in your contacts before you can add them to a user group in Outlook.
True
False
When communicating online, either through messaging or email, you should avoid using sarcasm
True
False
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.
an Add-on
an Appendage
an Addition
an Attachment
In Outlook, you have the following email in your inbox. The subject line contains _____________.
David Lockwood
Sampson Community College will be implementing the ne...
Thu 1:21 PM
none of the above
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.
ID
Signature
Attachment
Personal
In Gmail, to create a new email message you should click on ___________.
Start
Compose
New
none of the above
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.
You need to have a Google account to be able to use Gmail.
True
False
The Calendar in Outlook allows three kinds of events: Appointments, Meetings, and All-day Events.
True
False
In Outlook Email you can add attachment from your OneDrive folder.
True
False
In Word 2016 if you find a word in your document with a red wavy line under it, what does it mean?
it is a misspelled word
it is the wrong tense of a verb
it has created a grammatical error
another word in the thesaurus is recommended
By default, when you save a document in Word 2016 it will be saved with a file extension of ___________.
.docx
.doc
.word
You can create a list like the one below by selecting the names of the schools and clicking on _____________.
In Word 2016 the Legal page size is
8.5' x 11'
8.27' x 11.69'
7.15' x 10.5'
8.5' x 14'
When doing a research paper in Word 2016 you can insert citations and Works Cited in the ________ menu (tab).
Insert
Layout
References
Review
The orientation of the page below is portrait
True
False
In Word 2016 the setting of Wide margins would include ______________.
3" left margin
0.5" left margin
2" left margin
1" left margin
To change the color of your text in Word 2016 you should select the text and click the ________ button
Word 2016 ______________ is a predesigned document you can use to create a new document quickly.
design
backstage
copy
template
In Word 2016 you can change the margins by going to the ____________ menu (tab).
Design
View
File
Layout
You have typed the line below. Note the location of the insertion point. If you strike the Backspace key what will be deleted?
letter p
entire line
letter s
entire word Sampson
To copy and paste text within Word 2016 (or any other application) you can use _____________________.
Ctrl-X to Copy and Ctrl-P to Paste
Ctrl-C to Copy and Ctrl-V to Paste
Ctrl-X to Copy and Ctrl-V to Paste
Ctrl-C to Copy and Ctrl-P to Paste
You can find a synonym for a word by using the Thesaurus in Word 2016.
True
False
Text that is underlined with a blue wavy line has spelling problem.
True
False
_____________ is a benefit of using OneDrive with MS Word 2016.
Access your files anywhere
Back up your files
Share files
All of the above
In Word 2016 the Find and Replace options are found on the ______________ menu (tab).
Design
Edit
Home
File
You can run a spelling/grammar check on your entire document by going to the ___________ menu (tab) and choosing Spelling & Grammar.
Design
View
Review
Home
You can save a word document in PDF format by going to File, Export and choose Create Adobe PDF.
True
False
In Word 2016 you can insert automatic page numbering on either the top or bottom of the page by going to the __________ menu (tab).
Format
Home
Page Layout
Insert
In Word 2016 you there are several predefined page sizes.
True
False
In Excel 2016 a range of cells beginning with cell C5 and going to cell E9 is defined as _____________.
C5-E9
C5 E9
C5:E9
none of the above
To increase the number of decimal places displayed in a number you can click on button below in the blue box.
True
False
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.
True
False
It is possible to change the width of columns but the height of a row cannot be changed.
True
False
To center the contents of a range of cell vertically you should click on the ____________ button.
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 ________
72
18
2
6
To change the fill or background color for a range of cells you should click on the _______________ button.
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 ______________.
File, Save
File, Move
File, Copy
File. Save as....
To add a new worksheet to your current workbook you should click _________________.
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?
36
31
40
none of the above
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.
True
False
In Excel 2016 which button on the status bar would you click to go into Page Break View?
none of the above
In Excel 2016 you wish to insert a new row between the current row 5 and row 6. You should ________________.
click on any cell in row 5 and hit the Insert key on the keyboard
click on row header of row 6 and click 'Insert' in the Cells section of the Home tab
click on row header of row 5 and click 'Insert' in the Cells section of the Home tab.
click in any cell on row 6 and hit the Insert key on the keyboard
In Excel 2016 all formulas and functions must begin with __________ when you enter them.
#
&
=
%
When saving a workbook in Excel 2016 in an XML file format the default file extension is _______________.
.xls
.xlst
.xlsx
.xlm
In Excel 2016 (or Word 2016, Access 2016, or PowerPoint 2016) you can go into Backstage view by clicking on the File menu (tab).
True
False
You cannot save Excel 2016 workbooks to OneDrive.
True
False
The intersection of column D and row 6 is a cell with a cell address of ____________
D:6
6:D
D6
6D
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?
6
12
5
8
In Excel 2016 the Autosave feature saves you document for you every 5 minutes by default.
True
False
Files created in PowerPoint 2016 are called _______________.
Spreadsheets
Databases
Presentation
Documents
Files created in PowerPoint 2016 can be saved to OneDrive.
True
False
In PowerPoint 2016 you can go into Backstage view by clicking on the ___________ tab on the Ribbon
File
Home
Design
Insert
When you open a PowerPoint 2016 presentation created in an older version of PowerPoint it will be opened in _____________ mode.
Previous Version
Edit
Compatibility
Read Only
In PowerPoint 2016 presentations are saved as a ______________ file type (file extension).
PPTX
XLSX
PPT
PWPT
In PowerPoint 2016 you can convert documents created in older versions to PowerPoint 2016 file format by going to Backstage view and choosing Convert.
True
False
In PowerPoint 2016 a Presentation consists of a series of _____________________.
panes
screens
slides
pages
A PowerPoint presentation can contain videos.
True
False
You can add a video to a PowerPoint presentation by going to the _________ tab on the Ribbon.
Home
Layout
Design
Insert
In PowerPoint 2016 transitions refer to what happens between slides in a presentation.
True
False
In PowerPoint 2016 transitions are divided into 3 categories. Which is the following is NOT one of them?
Subtle
Static
Dynamic
Exciting
In PowerPoint 2016 you can enter slide sorter view by clicking on ___________ from the status bar at bottom of screen.
In PowerPoint 2016 you can start your presentation from the beginning by clicking on ______ on the Quick Access Toolbar.
In the picture the area in the blue box is known as the _________________ in a PowerPoint 2016 presentation.
Slide Pane
Ruler
Slide View Options
Slide Navigation Pane
In PowerPoint 2016 you can rearrange the slides after it has been completed.
True
False
One way to organize your presentation is to separate the slides into sections.
True
False
Which of the following is NOT a print layout available in PowerPoint 2016.
Half Page Slides
Note Pages
Full Page Slides
Handouts
To change the Theme used in your presentation in PowerPoint 2016 you should go to the ________ tab in the ribbon.
Insert
Home
Format
Design
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.
True
False
In PowerPoint 2016 you can add notes to each of your slides that can assist you when presenting your presentation
True
False
