Shared Flashcard Set

Details

Excel ch 1-3 review
josh
16
Computer Networking
Undergraduate 1
03/24/2011

Additional Computer Networking Flashcards

 


 

Cards

Term
Tables
Definition
Organize and store data within worksheets.
Term
Requirements document
Definition
includes a needs statement, source of data, summary of calculations, and any other special requirements for the worksheet, such as charting and Web support.
Term
Cell
Definition
Intersection of each column and row.
Term
Cell reference
Definition
A cell referred to by it s unique address.
Term
Gridlines
Definition
The horizontal and vertical lines on the worksheet itself.
Term
Formula Bar
Definition
As you type excel displays the entry in the
Term
fill handle
Definition
small black square located in the lower-right corner of the active cell.
Term
dollar sign
Definition
To specify an absolute reference in a formula, enter a(n) ____ before a column letter or a row number.
Term
IF(logical_test, value_if_true, value_if_false)
Definition
The general form of the IF function is ____.
Term
value_if_true
Definition
The ____ entry of the IF function is made up of two expressions and a comparison operator.
Term
Close
Definition
To quit Excel, click the ____ button on the title bar
Term
90º
Definition
Text in a cell can be rotated counterclockwise by entering a number between 1º and ____ in the Alignment sheet in the Format Cells dialog box.
Term
Nested IF
Definition
A ____ function is one in which the action taken for the true or false case includes yet another IF function.
Term
copy a cell, copy a range of cells,
create a series of numbers
Definition
You can use the fill handle to ____.
Term
pie
Definition
A(n) ____ chart is used to show the relationship of the parts to a whole.
Term
categories names
Definition
The entries that will identify the slices of a pie chart are called ____.
Supporting users have an ad free experience!