Test for CIS 110
When saving a workbook in Excel 2016 in an XML file format the default file extension is _______________.
.xlsx
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
The data processing cycle contains all of the following EXCEPT:
Booting
In PowerPoint 2016 you can go into Backstage view by clicking on the ___________ tab on the Ribbon.
File
You can add a video to a PowerPoint presentation by going to the _________ tab on the Ribbon.
Insert
Speakers are examples of ________________ devices.
Output
In PowerPoint 2016 presentations are saved as a ______________ file type (file extension).
PPTX
Files created in PowerPoint 2016 are called _______________.
Presentation
To delete a file on a Mac you can drag the file into the ____________.
Trash
A PowerPoint presentation can contain videos.
True
Files created in PowerPoint 2016 can be saved to OneDrive.
True
Flash drives can be used in either a PC or a Mac.
True
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
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
Microsoft offers Cloud based applications that are Internet-only versions of ________.
Word, Excel, PowerPoint
When creating a strong password it is a good idea to include
at least 6, no personal information, uppercase letters, lower case letters, numbers, special characters.
Internet speeds on desktop devices are generally measured in _______.
Megabits per second
3G and 4G 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
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
SMTP is the standard protocol is used for ___________ emails across the Internet.
Sending
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
The most powerful and expensive type of computer is a ____________.
Supercomputer
By default, when you save a document in Word 2016 it will be saved with a file extension of ________.
.docx
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
In Word 2016 the Legal page size is
8.5' x 14'
____________ is a benefit of using OneDrive with MS Word 2016.
Access your files anywhere Back up your files Share files
When sending an email you should _____________.
Always identify yourself Include a subject line Be concise
The web site http://www.sdsu.edu is probably for __________________.
An Educational Institution
74.125.28.177 is an example of _____________.
An IP Address
A keyboard is an example of ______________ device.
An input
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
In Excel 2016 a range of cells beginning with cell C5 and going to cell E9 is defined as _____________.
C5:E9
The Chromebook runs what operating system?
Chrome OS
On a Mac you can select all the files in a folder by typing _______________.
Command-A
To copy and paste text within Word 2016 (or any other application) you can use _______________.
Ctrl-C to Copy and Ctrl-V to Paste
The intersection of column D and row 6 is a cell with a cell address of ____________.
D6
_______ 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
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
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
It is possible to change the width of columns but the height of a row cannot be changed.
False
Text that is underlined with a blue wavy line has a spelling problem.
False
The POP3 email protocol is used to send emails to a remote server.
False
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 Outlook, when you receive an email it is stored in the ___________ folder
Inbox
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.
In Word 2016 you can change the margins by going to the ___________ menu (tab).
Layout
Fedora is a distribution of what operating system?
Linux
Word 2016 ________________ is a predesigned document you can use to create a new document quickly.
Templet
Cloud computing means storing and accessing data via ___________.
The Internet
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
If you are a serious gamer your computer will probably require a faster and more expensive ________.
Video card.
A ___________ is a made up of related text, images, and other resources.
Website
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 ______________.
c. File. Save as....
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.
In Excel 2016 all formulas and functions must begin with __________ when you enter them.
=
The brains of a computer is a 2-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
OneDrive and Apple iCloud are primarily used for __________.
Cloud storage
When you open a PowerPoint 2016 presentation created in an older version of PowerPoint it will be opened in _____________ mode.
Compatibility
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 change the Theme used in your presentation in PowerPoint 2016 you should go to the ________ tab in the ribbon.
Design
Which type of Internet connection is the slowest?
Dial-up
You cannot save Excel 2016 workbooks to OneDrive.
False
Which of the following is NOT a print layout available in PowerPoint 2016.
Half Page Slides
In Word 2016 the Find and Replace options are found on the ______________ menu (tab).
Home
In Word 2016 you can insert automatic page numbering on either the top of bottom of the page by going to the ___________ menu (tab).
Insert
____________ is the default web browser for Mac computers and iOS devices.
Safari
_______________ is a set of instructions that tell the computer what to do.
Software
In PowerPoint 2016 transitions are divided into 3 categories. Which is the following is NOT one of them?
Static
Use Google to find the answer to the following question: "Who sang the song Build Me Up Buttercup in 1968"?
The Foundations
In Outlook Email you can add attachments from you OneDrive folder.
True
In PowerPoint 2016 transitions refer to what happens between slides in a presentation.
True
In PowerPoint 2016 you can add notes to each of your slides that can assist you when presenting your presentation.
True
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
In PowerPoint 2016 you can rearrange the slides after it has been completed.
True
In Word 2016 you there are several predefined page sizes.
True
One way to organize your presentation is to separate the slides into sections.
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 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
Internet Explorer, Mozilla Firefox, Google Chrome, and Safari are examples of __________.
Web Browsers
Connecting to a network through a wireless connection is called _________.
WiFi
An example of a client-server network operating system is _______________.
Windows Server
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
To connect to the Internet from your home you must do it through _____________.
an ISP
Before removing your flash drive you should:
disconnect/eject it.
In PowerPoint 2016 a Presentation consists of a series of _____________________.
slides
