The first guideline of setting up effective spreadsheets is to:

A) make them visually interesting

B) focus on form

C) avoid explanations that clutter the spreadsheet

D) explain all processes 

The Advanced Filter feature includes a:

A) List range

B) Criteria range

C) Copy to option

D) All of the above 

What symbol is used to denote absolute cell references?

A) equal sign (=)

B) dollar sign ($)

C) percent sign (%)

D) tilde (~) 

The IF function specifies a(n):

A) action on true outcome

B) condition

C) action on false outcome

D) all of the above 

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:

A) manually inspect all formulas on the spreadsheet

B) do not hide columns in the spreadsheet

C) always use absolute cell references in all formulas

D) apply names in the spreadsheet 

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

A) LETTER()

B) INDEX()

C) LEFT()

D) IF() 7 

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

A) value

B) name

C) literal

D) range id 

The Scenario Manager window is accessed via the:

A) Tools menu

B) File menu

C) Edit menu

D) Formulas menu 

What method is used to access subsets of information?

A) logging

B) conditional formatting

C) sorting

D) filtering

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

Use the File menu to insert comments in Excel.

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

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

A formula reference begins with:

A) f()

B) a cell reference

C) any number

D) the equals sign (=) 

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

A) date copy

B) auto-increment

C) conditional fill

D) series fill 5 

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

A) formulas

B) functions

C) tables

D) formatting 

The main purpose of a spreadsheet is to:

A) display numerical results

B) process numerical data

C) organize factual data

D) graphically present data 

Because there are two dimensions in spreadsheets—columns and rows—there are actually two ways a formula can be relative. 

The fill handle can be used to copy values but not formulas. 

Tables from a Web page can be pasted into a spreadsheet. 

Functions and column letters in a spreadsheet are not case sensitive. 

Logical operators can be combined and grouped using:

A) parentheses

B) curly brackets

C) square brackets

D) plus and minus 

The query processor processes an AND query by:

A) crawling

B) intersecting

C) removing duplicates

D) using a GUI 

One example of descriptive text is anchor text, which is:

A) a textual description of a picture

B) a phrase within <title> tags

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

D) included within a <meta…> tag 

) A search engine consists partly of a:

A) link and a crawler

B) snoop and a bull's-eye

C) crawler and a query processor

D) spider and a web 

Crawlers consider descriptive text when adding the page’s URL to the index. 

Most information available at the library is also available online. 

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