CSCI Midterm
absolute cell reference
$C4$
How many cells are in the range B2:D7?
18
How many different ways are there to combine absolute and relative references to a single cell?
4
On startup, Excel displays a new blank
Workbook
Spreadsheet formulas start with
=
Conditional formatting
Allows you to display information in more than one way
Which of the following is a valid range of cells
D1:D3
Which of the following is completely relative cell reference?
J4
To get the first characters in a cell you should use the
LEFT () function
The function that retrieves and then displays the date and time from your computer is the:
NOW function
Spreadsheets are great for playing ___, that is, they are useful for putting together various possible senarios?
What if?
The type of cell reference that refers to cells by their fixed position in a worksheet is:
absolute
A cell surrounding by a black border and ready to recieve data is the:
active cell
In spreadsheets, names
are used for cells, are used for cell ranges, can contain an underscore
Cell entries are ____; that is, the computer will not consider any of their constituent parts.
atomic/monodithic
use the ___ function to find the average of a range of cells.
average
Functions and column letter are ___ in formulas
case sensitive if you put a $ in the formulas
Delimited cell entries mean
cell entrys that end with a certain character
Basic spreadsheet principles
clear and easy to use entries, clean layout, logical form.
__ are a good way to explain a spreadsheet formula
comments
____ means "join letter sequences together."
concatenate
What function would you use to change the color of certain cells based on the value stored inside of them?
conditional formatting
__ allows for the application of interpretation to the data in a spreadsheet
conditional formatting.
If the cell does not start with an equal sign then the cell contains
data
A shaded bar that provides a visuals cue about the value of a cell relative to other cells is a:
data bar
Whenever a value in a spreadsheet is changed
everything is recalculated
A spreadsheet can import any kind of data
false
Cells in a spreadsheet are 10 characters wide
false
Column references in cell ranges must be typed using uppercase
false
Copy/paste will duplicate a formula, but it won't utilize relative and absolute cell refrences
false
Text too wide to fit into a cell is truncated
false
The feature that generates and extends values into adjacent cells based on the values of selected cells is:
fill handle
The small box in the lower-right corner of a selected cell is called thw
fill handle
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:
filtering
___ allows the selection of certain spreadsheet rows based on specifiec criteria.
filtering
___ allow for programmatic manipulation and analysis of data in spreadsheets
formula
An excel window element that displays the value or formula contained in the active cell is the:
formula bar
The command that enables you to select one or more rows or columns and lock them into place is:
freeze panes
___ are formulas built into a spreadsheet to make it easier to create calculations.
functions
The default format that Excel applies to numbers is the:
general format
__ information that is not currently needed is a good way to make spreadsheet clear and easy to use.
hiding
When you ___ for spreadsheet, you create a symbolic reference for a range of cells.
name a range
An Excel window element that displays the name of the selected cell, table, chart, or object is the:
name box
The PMT () function returns a __ because it's money you owe
negative number
Respectively, rows and columns are designed with
numbers, letters
The excel command that enables you to specify rows and columns to repeat on each printed page is:
print titles
A rectangular group of one or more cells is called an
range
A single cell or a related rectangular group of cells is called a
range
A ___ cell reference automatically transforms a formula when it is pasted or filled
relative
To change the formatting on a chart a chart you should __ on that item to access the appropriate menus.
right click
The ___ is the interface for managing scenarios
scenario manage
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet
select all box
Using ___ automatically fills and increments values
series
Use the __ function to find with incremtns of a certain type of data
series fill
The label along the lower border of the workbook window that identify each worksheet are the:
sheet tabs
The process of arranging data in a specific order based on the value in each field is called:
sorting
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
sparklines
A worksheet where totals from other worksheets are displayed are summarized is a:
summary sheet
Defining names for a spreadsheet allows you to refer to cells
symbolically
Data imported into a spreadsheet should generally be
tab-delimited ACSII
A series of rows and columns with related data that is managed independently from other data is a:
table
AutoFiltering can only be used
tables that have column headings
Conditional formatting can change the
text color, text format, cell color
A cell reference cannot contain a relative and an absolute reference at the same time
true
Relative cell references change as associated values change
true
The small box or handle in a selected cell's lower-right corner is used to move the contents of the cell.
true
The data that displays in the Formula Bar is referred to as the:
underlying value
Spreadsheets recalculate
whenever a cell is changed
"Explain everything" in a spreadsheet means
you should easily be able to tell what every cell means