Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/32

Click to flip

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