CIS 101 FINAL EXAM
1. Category of options that allows you to arrange text boxes on a slide 2. Category of options that allows you to add actions to objects 3. Category of options that allows you to invite others to edit your presentation
1. Drawing 2. Links 3. Share
Identify the letter of the choice that best matches the phrase or definition. a. range b. Name box c. cell pointer d. cell address e. status bar 1. Provides a brief description of the active command or task in progress. 2. Identified by the coordinates of the intersecting column and row.
1. E 2. D
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?
100
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
5
Office Web Apps are versions of all of the following EXCEPT ____.
Access
To remove red eye from a digital image, you would use software such as ____.
Adobe photoshop Pg. 140
Excel recognizes an entry as a value if it is a number or it begins with ____.
All of the above
From ____, you can open a document in the full Office application if the application in installed on the computer you are using. a. SkyDrive b. Outlook.com c. Microsoft.com d. All of the above
All of the above
Which of the following items can you import into a presentation? a. photographs b. numerical data c. text d. All of the above
All of the above
____ operators perform mathematical calculations such as adding and subtracting.
Arithmetic
The CPU is composed of the control unit and the ____ unit.
Arithmetic logic
Clicking the ____ button sums the adjacent cell range above or to the left.
Auto Sum
Match each of the following subsystems to the term used by or function of that subsystem. I. ROM II. Clock Speed III. RAM IV. quad-core processor V. hyperthreading
B.D.A.E.C A. Volatile storage B. Permanent storage C. Simultaneous execution of more than one instruction D. Determine how fast the CPU is E. a CPU with 4 cores
Match each of the following terms to its definition: I. system software II. application software III. vertical market software IV. commercial software V. software suite
B.E.D.C.A a. bundled group of software b. runs the computer c. another term for proprietary software d. designed for a specific industry e. used to do tasks
The capability of current devices to use earlier standards is known as ____.
Backward Capability
A(n) ____ version is an application that is still under development.
Beta Pg. 146
The control unit is one component of the ____.
CPU
Which of the following is NOT a type of UTP cable you would use in a wired Ethernet network?
Cat7B
A client/Server network is an example of ____ administration.
Central
Using ____ computing, you can take advantage of Microsoft Office Web apps to do your work in a virtual environment.
Cloud
____ computing allows you to store data, files, and application on the web and access and manipulate these files and applications from any device connected to the internet.
Cloud Pg. 142
____ is the type of RAM memory used most often in today's computers.
DDR3
In most current systems, ____ is the type of RAM used.
DDR3 pg. 230
In the PowerPoint Web App, the Themes category of options is available on the ____ tab
DESIGN
Themes are found on the ____ tab.
DESIGN
In the PowerPoint Web App, the ____ option includes a presentation in a blog on a Web site.
Embed
EULA stands for ____.
End Use License Agreement Pg. 147
Microsoft's spreadsheet software is called ____.
Excel
A named range can begin with a letter or number.
FALSE
Accessing data from the hard drive to send to the CPU is faster than accessing data from the RAM.
FALSE
All web-page software is free
FALSE
An Excel 2013 workbook has the file extension .xml.
FALSE
Application software helps run the computer and coordinate instructions with the hardware.
FALSE
Arguments are Excel's built-in formulas.
FALSE
Blackboard is an example of gaming software.
FALSE
In a database, a table can be defined as a data category.
FALSE
The Quick Access toolbar is only visible when the HOME tab is active.
FALSE
Unauthorized use of protected work (such as downloading a photo or a song from the Web) is known as copyright LAW, and can lead to legal action.
FALSE
WEP is a stronger form of security than WPA.
FALSE
An Office Web App includes all of the features and functions included with the full Office version of its associated application.
FALSE (Cloud 2)
Using the Annotation option in the PowerPoint Web App, you can add comments.
FALSE (Text/Comment) (Insert Tab)
REFERENCE operators compare values for the purpose of true/false results.
FALSE Comparison
Using your mobile devices to make purchases is more risky thank making purchases with your computer on the web.
FALSE Pg. 125
When using multiple monitors, you must have multiple video cards.
FALSE Pg.243-244
SLIDE SHOW view displays thumbnails of all slides; use this view to rearrange and add special effects to your slides.
FALSE Slide Sorter
A selection box has a(n) SOLID line border and sizing handles that appear around the placeholder, indicating that it is selected and ready to accept text.
FALSE dash
When you are signed in to Office and click the ____ tab in any Office 2013 application, you see a list of the files that you have used recently on your current computer and on any other connected device.
FILE
____ is an exception to copyright and permits the public to use copyrighted material for certain purposes without obtaining prior consent from the owner.
Fair Use
Desktop computer systems are less reliable than laptop computers.
False p. 225
Which transmission medium transmits data the fastest?
Fiber-optic cable
In the PowerPoint Web App, the ____ category of options allows you to change the color of selected text.
Font
A(n) ____ is an equation in a worksheet.
Formula
To speed up the display of graphics, a(n) ____ is installed on some video cards.
GPU
A ____ is a network located in your residence that connects to all your digital devices.
HAN
In the PowerPoint Web App, the Clipboard, Delete, and Slides categories of options are available on the ____ tab.
HOME
The New Slide button is in the Slides group on the ____ tab.
HOME
Public places where you can wirelessly connect to the Internet are known as ____.
Hot Spots
____ provides high-speed information processing by enabling a new set of instructions to start before the previous set is finished.
Hyperthreading
In the PowerPoint Web App, the Comments and Illustrations categories of options are available on the ____ tab.
INSERT
Which of the following is NOT an example of a general productivity software application?
Image editing
In the PowerPoint Web App, the ____ category of options allows you to add pictures from screen shots.
Images
The processor market for desktop and laptop computers is dominated by ____.
Intel
In the PowerPoint Web App, the ____ category of options allows you to add actions to objects
Links
Microsoft accounts were previously referred to as a Windows ____.
Live ID
CASE-BASED CRITICAL THINKING As he hovers over each choice, Tom sees his slide change automatically. What Tom is experiencing is called ____.
Live Preview
When you use a public computer, you will be required to enter the password associated with your ____ account to access files you have saved on Windows SkyDrive.
Microsoft
The rule of thumb that predicts that CPU capacity will double every 2 years is called ____ Law.
Moore's
____ Law predicts that the capacity of a CPU will double every 2 years.
Moore's
A computer ____ is two or more computers connected using software and hardware so that they can communicate with each other.
Network
Client/server networks are controlled by a central server that runs specialized software called a(n)
Network operating system (NOS)
The ____ view can be found among the View Shortcuts buttons.
Normal Reading View Slide Sorter Notes Page
The default view that PowerPoint opens is called ____ view.
Normal View
Where are the View Shortcuts buttons located?
On the status bar
Which of the following views has no View Shortcuts button?
Outline View
In the PowerPoint Web App, the ____ category of options allows you to add bullets and change text direction.
Paragraph
A(n) ____ network is one where each computer can communicate directly with the others, rather than having a separate device exercise central control over the entire network.
Peer-to-peer
____ software helps you manage e-mail, contacts, calendars, and tasks in the same application.
Personal Information Manager
In the accompanying figure, the text "Click to add title" is the title ____.
Placeholder
Which dialog box do you use to embed fonts?
PowerPoint Options
Which of the following is NOT an optical disc format? a. Rewritable (RW) b. Read-erasable (RE) c. Read-only (ROM) d. Recordable (R)
Read-erasable (RE)
____ are devices that transfer packets of data between two or more networks.
Router
Sophisticated networks generally use which of the following hardware devices to ease the flow of data through the network.
Routers and switches
____ is an online storage and file sharing service from Microsoft.
SkyDrive
You can obtain software through ____, in which a vendor hosts the software online over the Internet and you do not have to install it on your computer.
Software as a Service
____ drives run with no noise and very little heat, and require very little power.
Solid-State
Which of the following is NOT used to classify networks architectures?
Speed of the network
____ sound is a type of audio system where the listener hears the sound as if it were coming from all directions.
Surround Sound
The term ____ means that when you add, change, or delete files on one computer, the same files on your other devices are also updated.
Synced
____ software helps run the computer and coordinates instructions between other software and the hardware devices.
System
A text book and a digital image are both examples of objects.
TRUE
Considering the delivery location of your presentation is part of the PLANNING process.
TRUE
Desktop publishing software enables you to create newsletter and annual reports.
TRUE
Handouts are pages of your presentation that you print and distribute to your audience.
TRUE
If you embed fonts in your presentation, you will not have to worry about the availability of those fonts on other computers.
TRUE
It is possible to collaborate on a presentation with a group of people using the Internet.
TRUE
Limiting your signal range does not help increase wireless network security.
TRUE
Most computers today come with Ethernet adapters already installed.
TRUE
One of the ways to change your view of the worksheet window is by using the VIEW tab on the RIBBON
TRUE
OpenOffice.org is an example of open source software.
TRUE
Sharing files is a benefit of a network.
TRUE
The Internet is a WAN.
TRUE
The use of multiple cores on one CPU chip allows the execution of two or more sets of instructions at the same time.
TRUE
Wireless network connections are slower than wire broadband connections.
TRUE
Wizards are step-by-step guides for performing complicated tasks in application software.
TRUE
You can switch between views using the commands in the Presentation Views group on the VIEW tab.
TRUE
You can use a name range instead of a cell address in a formula.
TRUE
You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.
TRUE
When you use SkyDrive to share files, you and others can work with just one version of a file that you both can update.
TRUE (Cloud 10)
When you access SkyDrive from Internet Explorer, you can do more file management tasks, including renaming and moving files.
TRUE (Cloud 8)
Coordinated colors and styles used in a document are known as themes.
TRUE Pg. 127
Optical discs store data using tiny pits and lands.
TRUE Pg. 235
There are ____ levels of cache memory.
Three
____ is the actual speed of data transfer that is achieved and is always less than or equal to the data transfer rate.
Throughput
Normal view is divided into two panes, the Slide pane and the ____ pane.
Thumbnails
The pane on the left-hand in the accompanying figure is the ____ pane.
Thumbnails
RAM is an example of ____ storage.
Volatile
A network that spans a large physical distance is called a ____.
WAN
Microsoft Office 365 is an example of a(n) ____ productivity suite.
Web-based Pg. 126
WPA stands for ____.
Wi-Fi Protected Access
To move one screen to the left press ____.
[Alt][Page Up]
To quickly jump to the last cell in a worksheet press ____.
[Ctrl][End]
The Excel operator for exponent is ____.
^
You can use the ____ key(s) on the keyboard to navigate a worksheet.
arrow
Running the Disk Cleanup utility is a quick way to ____.
clear out unnecessary files
A(n) ____ can be used to insert text or objects such as clip art, tables, or charts.
content placeholder
Blackboard is an example of ____ software.
course management
You can change, or ____, the contents of an active cell at any time.
edit
CASE-BASED CRITICAL THINKING Mary wants to make sure that her family and friends do not need to have to have the same fonts installed on their computers in order to view the recipes properly. She decides to ____.
embed the fonts
All of the following are extra precautions you can take to secure a wireless network EXCEPT ____.
enable SSID broadcast
All of the following are part of the machine cycle EXCEPT. a. encode b. fetch c. execute d. store
encode
When using a spreadsheet, the expression =D8-D17 is called a ____.
formula
A(n) ____ software installation copies all the most commonly used files and programs from the distribution disc to your computer's hard drive.
full
A(n) ____ is a built-in formula that uses arguments to calculate information.
function
When using a spreadsheet, SUM in the expression =SUM(B10:B16), is called a(n) ____.
function
Referring to the accompanying figure, the page on the left is showing a(n) ____ page.
handout
When you embed fonts, the size of your presentation ____.
increaces
____ is any idea or creation of the human mind.
intellectual property
A peer-to-peer (P2P) network is an example of ____ administration.
local
Running Disk Defragmenter utility will ____.
make the hard drive work more efficiently
When referring to hard drives, access time is measured in ____.
milliseconds
The primary view that is used to write, edit, and design a presentation is ____ view.
normal
After you enter text in a placeholder, the placeholder becomes a text ____.
object
Using a network without the network owner's permission is known as ____.
piggybacking
If you illegally install software on your computer, you are committing software ____.
piracy
Possible paper orientations for printing a worksheet are landscape and ____.
portrait
You would use ____ software to create a slide show.
presentation
Another name for commercial software is ____ software.
priprietary
All of the following are types of multimedia and entertainment software EXCEPT? a. productivity software b. gaming software c. digital audio software d. drawing software
productivity software
Wireless network devices use ____ to communicate with each other.
radio waves
A(n) ____ moves over the spinning platters to retrieve data from the hard disk.
read/write heads pg. 234
A Live Preview of the theme appears on the slide each time you pass your pointer over different theme thumbnails, and a(n) ____ identifies the theme names.
screen tip
You can use ____ to move around in a document that is too large to fit on the screen at once.
scroll bars
A ____ uses electric memory and has no motors or moving parts.
solid-state drive
Traditional databases are organized into fields, records, and ____.
tables Pg. 130
The Ribbon is made up of the following elements: ____.
tabs buttons groups
You can use predesigned, formatted files called ____ to create new worksheets quickly.
templates
Software designed for real estate agents is an example of ____ software.
vertical market
Dreamweaver is an example of ____ software.
web page design
The appropriate software to use for creating research paper is ____ software.
word processing
In Excel, a worksheet is contained in a file called a ____.
workbook