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