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