Computer Final Exam
By default, when you save a document in Word 2016 it will be saved with a file extension of ___________.
.docx
When saving a workbook in Excel 2016 in an XML file format the default file extension is _______________.
.xlsx
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?
12
In Word 2016 the setting of Wide margins would include ______________.
2" left margin
What year was Mac OS X (El Capitan version) released?
2015
What year was Windows 10 released?
2015
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?
31
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
In Word 2016 the Legal page size is
8.5' x 14'
In Excel 2016 all formulas and functions must begin with __________ when you enter them.
=
_______ converts an IP address to a URL and vice versa.
DNS
When you delete an email in Outlook it is moved into the ____________ folder.
Deleted Items
Which type of Internet connection is the slowest?
Dial-up
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.
Drafts
In Outlook, when you receive an email it is stored in the ___________ folder
Inbox
In Word 2016 you can insert automatic page numbering on either the top or bottom of the page by going to the __________ menu (tab).
Insert
In Word 2016 you can change the margins by going to the ____________ menu (tab).
Layout
Fedora is a distribution of what operating system?
Linux
Internet speeds on desktop devices are generally measured in ____________.
Megabits per second
3G and 4G are are measures of Internet speed on __________.
Mobile phones
The primary piece of hardware needed to connect your computer to the internet is a _______________.
Modem
The main circuit board in a computer is the ________________.
Motherboard
Private browsing is a way to browse the Internet for sensitive or private information. It is available in _______________.
Mozilla Firefox, Safari, Google Chrome
In the world of technology NOS stands for __________.
Network Operating System
When your computer is connected to the Internet it is said to be __________________.
Online
Speakers are examples of ________________ devices.
Output
PC stands for ________________
Personal Computer
____________ converts power from the wall outlet into the type of power that the computer can us.
Power Supply
______ memory is volatile and the contents ARE erased when the computer is turned off.
RAM
______ memory is non-volatile and the contents are NOT erased when the computer is turned off.
ROM
To delete a file in Windows you can drag the file into the __________.
Recycle Bin
When doing a research paper in Word 2016 you can insert citations and Works Cited in the ________ menu (tab).
References
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
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 All
You can run a spelling/grammar check on your entire document by going to the ___________ menu (tab) and choosing Spelling & Grammar.
Review
To rename a file in Windows you could _____________.
Right click on the file, choose Rename, type in new name
In order to connect multiple computers to the Internet or to connect through a WiFi network you will need a ___________.
Router
____________ is the default web browser for Mac computers and iOS devices.
Safari
A computer that serves up information for other computers on a network is called a __________.
Server
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.
Signature
____________ is a set of instructions that tell the computer what to do.
Software
Use Google to find the answer to the following question: "Who sang the song Build Me Up Buttercup in 1968"?
The Foundations
To delete a file on a Mac you can drag the file into the _________.
Trash
Flash drives can be used in either a PC or a Mac.
True
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
In Outlook Email you can add attachment from your OneDrive folder.
True
In Word 2016 you there are several predefined page sizes.
True
The Calendar in Outlook allows three kinds of events: Appointments, Meetings, and All-day Events.
True
The Internet is a global network of billions of computers.
True
When communicating online, either through messaging or email, you should avoid using sarcasm.
True
When you schedule a meeting with 3 other people they will automatically be invited by sending an email to them with an attachment.
True
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
You can find a synonym for a word by using the Thesaurus in Word 2016.
True
You can save a word document in PDF format by going to File, Export and choose Create Adobe PDF.
True
You need to have a Google account to be able to use Gmail.
True
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
To use a Flash drive you must insert it into a ___________________
USB Port
Internet Explorer, Mozilla Firefox, Google Chrome, and Safari are examples of _____
Web browsers
A ___________ is a made up of related text, images, and other resources.
Website
Connecting to a network through a wireless connection is called ____________.
WiFi
An example of a client-server network operating system is __________.
Windows Server
Microsoft offers Cloud based applications that are Internet-only versions of ________.
Word, Excel, and PowerPoint
When sending an email you should _____________.
always identify yourself, include a subject line, be concise
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 Attachment
The web site http://www.sdsu.edu is probably for __________________.
an Educational institution
74.125.28.177 is an example of _____________.
an IP Address
To connect to the Internet from your home you must do it through _____________.
an ISP
A keyboard is an example of ______________ device.
an input
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
In Excel 2016 you wish to insert a new row between the current row 5 and row 6. You should ________________.
click on row header of row 6 and click 'Insert' in the Cells section of the Home tab.
Before removing your flash drive you should:
disconnect/eject it
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
SMTP is the standard protocol is used for ___________ emails across the Internet.
storing, sending, receiving
The most powerful and expensive type of computer is a ______________.
supercomputer
Word 2016 ______________ is a predesigned document you can use to create a new document quickly.
template
Cloud computing means storing and accessing data via __________.
the Internet
If you are a serious gamer your computer will probably require a faster and more expensive _______________.
video card
On a Mac you can select all the files in a folder by typing ___________.
Command-A
In Gmail, to create a new email message you should click on ___________.
Compose
A _______________ is an electronic device that manipulates information with the ability to store, retrieve, and process data.
Computer
To copy and paste text within Word 2016 (or any other application) you can use _____________________.
Ctrl-C to Copy and Ctrl-V to Paste
_____________ is a benefit of using OneDrive with MS Word 2016.
Access your files anywhere, Back up your files, Share files
The Mac is a desktop computer that was developed by _____________.
Apple
What operating system would you find running on an Apple iPad?
Apple iOS
An example of a peer-to-peer network operating system is _______
AppleShare
The data processing cycle contains all of the following EXCEPT:
Booting
The brains of a computer is a two-inch ceramic square with a silicon chip inside that is called the _______.
CPU
Older type monitors that were much larger and heavier were known as a ____________.
CRT
The Chromebook runs what operating system?
Chrome OS
OneDrive and Apple iCloud are primarily used for _________
Cloud storage
A user must be in your contacts before you can add them to a user group in Outlook.
False
In Excel 2016 the Autosave feature saves you document for you every 5 minutes by default.
False
It is a good idea to have at least two different antivirus programs installed on your computer.
False
Text that is underlined with a blue wavy line has spelling problem.
False
The POP3 email protocol is used to send emails to a remote server.
False
You cannot save Excel 2016 workbooks to OneDrive.
False
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 as....
The most popular and widely used search engine is _______________.
_____________ is the probably the best browser for PCs and is the default web browser for many Android devices
Google Chrome
In Word 2016 the Find and Replace options are found on the ______________ menu (tab).
Home
