Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
32 Cards in this Set
- Front
- Back
|
sheet tab
|
the name of the worksheet appears on the sheet tab located at the bottom of the workbook
|
|
|
column heading
|
a column letter above the grid
|
|
|
row heading
|
a row letter on the left side of the grid
|
|
|
cell reference
|
cordinates of the intersection of a column and a row
|
|
|
active cell
|
is the one in which you enter data
|
|
|
gridlines
|
the horizontal and verticle lines on the workseheet
|
|
|
menu
|
is a list of commands that you can use to retrive, store, print, and manipulate the data on the worksheet
|
|
|
status bar
|
displays a brief description of the command selected
|
|
|
mode indicators
|
appears on the status bar in either ready or enter
|
|
|
range
|
series of 2 or more adjacent cells in a column or row or retangular group of cells
|
|
|
marquee
|
surrounds the proposed cells to do a function to with a moving border called a marquee
|
|
|
fill handle
|
small black square located in the lower right corner of the heavy border around the active cell
|
|
|
format
|
you format a worksheet to make emphasize certain entries and make the worksheet easier to read and understand
|
|
|
merging cells
|
creating a single cell by combining 2 or more selected cells
|
|
|
splitting a merged cell
|
splitting the merged cells to display the original cells
|
|
|
embedded chart
|
drawn onto the same worksheet as the data
|
|
|
default chart type
|
chart excel draws if you click finish which is the 2-D column chart
|
|
|
legend
|
defines columns and colors in chart in a small box to the side
|
|
|
count function
|
displays the number of non blank cells in a selected cell range
|
|
|
count nums funtion
|
displays the highest value in the selected range
|
|
|
order of operations
|
negitives, percentages, exponetations, multiplication, divisions, additions, subtractions
|
|
|
arguments
|
is the range ex:(D4:D12) is the argument
|
|
|
conditional formatting
|
formatting that appears only when the value in the cell meets the conditions that you specify
|
|
|
assumptions
|
values in cells that you can change to dermine new values of formulas
|
|
|
NOW function
|
returns the date and time in the format of mm/dd/yyyy hh:mm
|
|
|
absolute cell reference
|
$B$4 instructs excel to keep the cell refernce constant
|
|
|
VLOOKUP search argument
|
the value in the spreadsheet which is used to search the table for a particular value
|
|
|
VLOOKUP table range
|
the range in which the lookup table resides
|
|
|
VLOOKUP column number
|
the specified column where the resulting value is located
|
|
|
VLOOKUP function
|
searches the leftmost column of a table (called the table arguments) and returns the corresponding value from the specified column (table values)
|
|
|
VLOOKUP
|
=VLOOKUP(search argument, table, range, coulumn number)
|
|
|
for VLOOKUP to work correctly....?
|
the table arguments must be in ascending sequence
|
