question

RAND is an example of a ____ function.

answer

Logical

question

To create a series with a complex pattern, you use the ____ dialog box.

answer

Series

question

After you select a cell or range, a ____ appears in the lower-right corner of the selection

answer

fill handle

question

The ____ argument of the loan payment function is optional

answer

fv

question

Interest is calculated as either ____ interest or ____ interest.

answer

simple, compound

question

____ value is the amount that each numeric value in a series increases over the previous entry.

answer

step

question

When typing a function directly into a cell, you first type

answer

none of above

question

AutoFill can extend a series of ____.

answer

all of above

question

A logical function works with statements that are

answer

either true or false

question

Cell references that remain fixed when a formula is copied to a new location are called ___ references.

answer

absolute

question

rguments are not required for a function to return a value, but can be included to provide more control over how Excel calculates the returned value.

answer

optional

question

can extend a series of numbers, patterned text, and dates into an adjacent cell or range.

answer

Autofill

question

Every function begins with a set of rules, or ____, which specifies how the function should be written.

answer

syntax

question

The ____ function calculates the amount of a monthly loan payment.

answer

PMT

question

A(n) ____ operator is a symbol that indicates the relationship between two values

answer

comparrison

question

With ____ interest, the interest is applied not only to the principal but also to any accrued interest.

answer

compound

question

____ copies content and formats from a cell or range into an adjacent cell or range.

answer

autofill

question

All of the following are date and/or time functions supported by Excel EXCEPT ____.

answer

HOLIDAY

question

A chart ____ formats an entire chart at once.

answer

style

question

For the following questions, state what would be, in general, the most appropriate chart type to use. You want to demonstrate how car sales have changed over five years at three different area dealerships. You want the categories to be viewed from left to right and the values from bottom to top.

answer

colum chart

question

This chapter introduced the concepts of data label, data marker, data series, and data source. For each of the following questions, consider a hypothetical pie chart and its associated worksheet. Choose the concept shown by each question. The text "27%" placed over one of the pie slices

answer

data label

question

When a chart has only one data series, the chart legend is

answer

the same as the chart title

question

charts are typically used when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals

answer

line

question

A column chart and a line chart placed in a single graph is an example of a(n) ____ chart.

answer

combination

question

___ chart titles and legends in the chart area means placing them on top of the chart.

answer

overlaying

question

This chapter introduced the concepts of data label, data marker, data series, and data source. For each of the following questions, consider a hypothetical pie chart and its associated worksheet. Choose the concept shown by each question.

answer

data marker

question

You modify a chart by clicking the ____ tab on the Ribbon, then clicking ____ in the Data group.

answer

chart tools design, select data

question

____ are lines that extend the values of major or minor tick marks across the plot area of a chart

answer

gridlines

question

Each chart you create is inserted as a(n

answer

both a and b

question

When you select a chart, all of the following tabs appear on the Ribbon EXCEPT

answer

embedq

question

Chart layouts are available on the ____ tab in the ____ group.

answer

chart tools desigs, chart layouts

question

A ____ chart displays its values vertically; a ____ chart displays them horizontally.

answer

column, bar

question

A ____ is text for an individual data marker.

answer

data label

question

A sparkline contains ____.

answer

neither a nor b

question

To add text to a numeric value when creating a custom format, surround the desired text with

answer

" "

question

The Mosaic Web browser was released in

answer

1993

question

In Internet Explorer, you can find Back and Forward buttons to the left of the ____.

answer

address bar

question

Using Windows Live Mail, you can send email to ____.

answer

anyone in the world who has an email adress

question

ou are "learning the ropes" about using different functions when writing and replying to emails. In the questions below, select the answer that best describes the appropriate course of action. Howard sent you an email with a good idea for a widget. You want to respond. You also want to bring Terry, who has experience with widgets, into the conversation.

answer

reply with cc to Tery

question

The world of the Internet can be overwhelming. You take some time to break it down in your mind, understanding the community and its players. For each of the following questions, look at the organizations, businesses, or individuals listed, and then determine what they represent as a whole. Your grandfather checking email, students conducting research at the school computer lab, a consumer buying a product on eBay

answer

User

question

To use Windows Live Mail, you need

answer

all of the above

question

A ____ is a small text file that is stored on your hard drive by a Web server to identify return visitors and their preferences.

answer

cookie

question

____ allow you to display multiple Web pages in the same browser window.

answer

tabs

question

____ email recipients are not visible to each other.

answer

bcc

question

A Wi-Fi ____ is a location with a direct Internet connection and a wireless access point that allows users to connect wirelessly to the Internet.

answer

hotspot

question

____ are companies that manage and distribute Web-based software services to customers over the Internet.

answer

ASPs

question

There are widely varied types of online communication and online writing—each with their own special purpose. Knowing what category of information you're trying to find on the Web will help you make more efficient and effective use of your time. In each of the following questions, give the answer that best describes the item listed in the question. A Web site that lets you read the weekly musings of a distant beachcomber whose work and discoveries you find fascinating

answer

a blog

question

Referring to the text in this chapter, CPO stands for

answer

cheif privacy officer

question

The best protection against many dot cons is _

answer

common sense

question

The ____ Act implements regulations for unsolicited email messages.

answer

none of the above

question

Many organizations and institutions publish guidelines for behavior called ____.

answer

codes of conduct

question

You study a series of real-life issues to determine what kind of security and/or privacy threat you are facing. You have found an interesting calendar program at a Web site and downloaded it to help you stay organized. However, within a couple days of installing the program, your computer starts behaving oddly. Strange popups appear, the home page of your Internet browser has been switched, and the system is running sluggishly. You likely have installed a _

answer

trojan horse

question

____ refers to following a predesignated procedure to remove yourself from marketing lists.

answer

opting out

question

is an act of malicious destruction to a computer or computer resource.

answer

computer sabatoge

question

____ emails are directly targeted to a specific individual, usually in order to steal intellectual property.

answer

spear phishing

question

____ devices are designed to withstand much more physical abuse than conventional devices.

answer

ruggidized

question

You study a series of real-life issues to determine what kind of security and/or privacy threat you are facing. You live in a 20-unit apartment building. You notice that your wireless Internet seems to run more slowly many evenings, after your neighbors have come home from work. It is possible you are being subjected to

answer

wifi piggy back

question

Sitting at your home and using somebody else's Wi-Fi hotspot to access the Internet without their knowledge would be considered ____.

answer

wifi piggy back

question

A(n) ____ creates a barrier between a computer or network and the Internet in order to protect against unauthorized access.

answer

firewall

question

You study a series of real-life issues to determine what kind of security and/or privacy threat you are facing. A relative of yours is in junior high school and has been subjected to a lot of bullying via text messages and social networking sites. You want to help, so you start to read up on the state laws and school rules that deal with

answer

online harasment

question

ymantec's MessageLabs recently estimated that more than ____ percent of all email messages is spam.

answer

90

question

It would take a computer program ____ to crack a five-character password.

answer

less than a minute

question

A document with a(n) ____ guarantees that the document was indeed sent by a specific individual and that it hasn't been tampered with after it was sent.

answer

digit signiture

question

Buying a product on eBay and then never receiving it is an example of ___

answer

online fraud auction

question

FDE stands for ____.

answer

full desk encryption

question

Encryption turns data into a form known as a ____.

answer

cipher

Computer test 3 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards