CPSC 110 Test 2

to reduce the chance of messing up range specifications, and minimize the likelihood that errors will creep in when columns and rows are added later

apply names in the spreadsheet

an example of conditional formatting is

applying a font color, e.g., green, to value over 500

spreadsheets are used primarily in

business

spreadsheets

can be sorted by any column

the basic unit of a spreadsheet is a

cell

we can see spreadsheet results graphically be creating

charts

A search engine consists partly of a

crawler an a query processor

what symbol is used to denote absolute cell references

dollar sign

If quotes surround the search phrase, "human powered flight," the search would find pages associated with the

exact phrase human powered flight

Data can be copied from one cell to another, but formulas cannot

false

a text file is the same thing as a tab-delimited file

false

excel provides automatic currency conversion with no need to write special formulas

false

in a spreadsheet, names can only be applied to cell references, not individual cells

false

summary information should be placed at the top of a spreadsheet

false

the fill handle can be used to copy values but nor formulas

false

use the file menu to insert comments in excel

false

you cannot mix absolute and relative references in the same cell reference

false

what method is used to access subsets of information

filtering

Logical operators can be combined and grouped using

parentheses

The main purpose of a spreadsheet is to

process numerical data

Most information available at the library is also available online.

False

Never accept information on the Web as authoritative

False

the IF function specifies a

action on true outcome, condition, action on false outcome

A search using the logical operator OR requires

one of the words to be found on the page

Identify a method used to find authoritative information

Choose information from respected organizations

As the query processor is putting together the it list, the URLs found by the intersecting process are sorted by their page ranking, lowest to highest, and returned to the user in that order.

False

Even though you trust an organization, you should be cautious about the content of its Web site.

False

It is not advisable to perform a site search to find information.

False

Of the following: Good Advanced Search, "I'm feeling Lucky" page, Bing, or a site search, which is preferred for its control?

Google Advanced Search

the function that returns the specified number of characters from the start of a text string is

LEFT()

Crawlers consider descriptive test when adding the page's URL to the index.

True

For a word to describe a page, the word doesn't actually have to be on the page

True

Formulas, which begin with an equal sign, define the value for the entry based on the value of other entries

True

It is usually acceptable to write queries in the form, (cherry OR grape OR lime) AND banana, using uppercase letters for the logical operators and parentheses to make the associations clear

True

Libraries in general provide many online resources that are well organized and trustworthy

True

No group is responsible for organizing information on the Web.

True

A Google search results include a snippet for each Web page in the list, What is a snippet?

a preview of what might be on the page

the first guideline of setting up effective spreadsheets is to

focus on form

Which of the following is used for computing common, summary applications in a spreadsheet?

functions

One example of descriptive text is anchor text, which is

highlighted link text, specified inside <a...> tags, describing the page to which it links

In a Web search, a match to a query is known as a:

hit

Suppose cell B4 has an entry. If the data in cell A4 is too wide to fit in the cell, it

is truncated

the advanced filter feature includes a

list range, criteria range, copy to option

A word or phrase applied to a cell or range of cells is called its

name

place descriptive information

on the top and left

A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a

series fill

A weakness of Wikipedia is that

the content is not validated by experts

a formula reference begins with

the equals sign

the scenario manager window is accessed via the

tools menu

"what if" analysis is a spreadsheet tool that temporarily recomputes entries based on alternative cell values

true

In a spreadsheet, conditional formatting allows you to specify a format for cells that meet certain criteria

true

because there are two dimensions in spreadsheets-columns and rows-there are actually two ways a formula can be relative

true

by default, a formula in a spreadsheet will automatically recalculate if the value contained in any of the formula's cell references change

true

conditional formatting is used to format a range of cells; each cell is formatted depending on the value in the cel

true

filtering is a process (especially in spreadsheets) for selecting) items based on one or more criteria

true

flexibility is an important characteristic of a spreadsheet

true

fonts should be clear in a spreadsheet, and possibly differentiated for headings and data

true

functions and column letters in a spreadsheet are not case sensitive

true

tables from a web page can be pasted into a spreadsheet

true