Terms in this set (79)
some web pages are "invisible." that is, no search engine will return them in a query. Why do these pages exist?
all of the above
the main responsibilty of a crawler is to
build a list of tokens that are associated with each page
When picking additional sources you should choose
Enclosing search terms in quotes asks for pages with
the search terms in the exact order as written
When searching on Google, this is the same as using the AND keyword.
a primary source is
a person with direct knowledge
Who is in charge of the World Wide Web?
When should a researcher be skeptical of a primary source?
always; the researcher should verify the information from other sources
After finding the Web page you want, what is the next question you should ask yourself?
is the information authoritative?
the higher the ___ is, the closer to the top of the list a web page will be in the returned results of a search query.
___ in google search queries are interpreted as AND.
the main work of the ____ is to build an index.
if a web page meets all the authoritative rules given in this chapter, it can still contain ___ information.
____ is the keyboard shortcut for finding certain words on a webpage.
Control f or command f
Treating query terms as independent is almost ______ what you actually want.
Wikipedia is validated by ___.
wikipedia is not considered a ___ source.
Crawlers crawl less than _____ of the Web.
To find corroborating information on the Web, you should always _____ with another independent Web page.
text too wide to fit into a cell is truncated.
Cells in a spreadsheet are 10 characters wide
relative cell references change as associated values change
copy/paste will duplicate a formula, but it won't utilize relative and absolute cell references
the small box or handle in a selected cell's lower right corner is used to move the contents of a cell
a cell reference cannot contain a relative and an absolute reference at the same time
Column references in cell ranges must be typed using uppercase
To change a relative cell reference to an absolute reference, you should use the ampersand (&).
Spreadsheet columns can be hidden but rows cannot.
a spreadsheet can import any kind of data
Functions and column letters are _____ in formulas
not case sensitive
how many different ways are there to combine absolute and relative references to a single cell?
Respectively, rows and columns are designated with
numbers and letters
which of the following is a valid range of cells?
all of the above
which of the following is not a valid range of cells?
all of the above
how many cells are in the range B2:D7?
Spreadsheet formulas start with
which function would you use to change the color of certain cells based on the value stored inside of them?
which of the following is a completly relative cell reference?
If the formula =$B$3 * .062 is copied from cell B4 to B5, the result will be
If $G5 appeared in a formula, you'd know
the G is absolute and the 5 is relative
If a cell does not start with an equal sign then the cell contains
Cell entries are ____; that is, the computer will not consider any of their constituent parts.
Atomic or monolithic
the ___ statement finds the maximum value in column J for rows 3-7.
the __ statement finds the minimum value in row 8 for columns A-E.
a rectangular group of one or more cells is called a ____.
the small box in the lower right corner of a selected cell )or range of cells) is called the ___.
a ___ cell reference automatically transforms a formula when it is pasted or filled.
a ____ cell reference retains a reference to a fixed position when it is pasted or filled.
Data imported into a spreadsheet should generally be ___.
Tab elimitated aski
Using ____ automatically fills and increments values
___ are formulas built into a spreadsheet to make it easier to create calculations.
Use the ____ function to find the average of a range of cells
use the ____ function to find the largest of the numbers in a range of cells
a ___ is a range of cells filled with increments of a certain type of data.
the PMT () function returns a ___ because it's money you owe.
To change the formatting on a chart you should _______ on that item to access the appropriate menus
___ means "join letter sequences together."
in spreadsheets, names
are used for cells
all of the following are basic spreadsheet principles except
"explain everything" in a spreadsheet means
you should easily be able to tell what every cell means
allows you to display information in more than one way
to get the first characters in a cell you should use the
left () function
conditional formatting can change the
more than one of the above
defining names for a spreadsheet allows you to refer to cells
If you saw regHours in a spreadsheet formula you'd know it's a
whenever a cell is changed
AutoFiltering can only be used on
tables that have column headings
Whenever a value in a spreadsheet is changed
everything is recalculated
Spreadsheets are great for playing _____, that is, they are useful for putting together various possible scenarios.
____ are a good way to explain a spreadsheet formula.
____ allows for the application of interpretation to the data in a spreadsheet
___ information that is not currently needed is a good way to make a spreadsheet clear and easy to use.
a single cell or a related rectangular group of cells is called ____.
____ allow for programmatic manipulation and analysis of data in spreadsheets
when you ____ for a spreadsheet, you create a symbolic reference for a range of cells.
Name a range
a ____ is a named alternative to a spreadsheet based on different inputs.
the ___ is the interface for managing scenarios.
___ allows the selection of certain spreadsheet rows based on specified criteria.
YOU MIGHT ALSO LIKE...
cpsc extra chapters
CSCI169/ Ch 13
OTHER SETS BY THIS CREATOR
history final vocab
Econ test 2