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;
34 Cards in this Set
- Front
- Back
|
What is located above the column title to the left of the formula function that shows the cell that is currently activated?
|
NAMEBOX
|
|
|
what is called a separator?
|
Comma
|
|
|
What is the default pointer in excel, for word specific?
|
A White Cross
|
|
|
what do you always start a formula with? otherwise it would be treated as what?
|
An Equal Sign/ Alpha Numeric's
|
|
|
How do i write an IF Statement?
|
=IF(logical test,result if true, then result if its false)
i.e.- =IF(h8="A",5%*G8,6%*G8) |
|
|
How do i write a sum function?
|
=SUM(B12:H12)
|
|
|
How do i write a sum function using data from 2 or more worksheets?
|
=SUM(Cell range from sheet one, click on sheet 2 and select cells then)
* and press enter then excel will take you back to sheet 1 |
|
|
What does the exclamation mark represent?
|
It is the divider
It separates the name of the sheet away from the cell in reference. |
|
|
How to write a count if statement?
|
=CountIF( range, Critieria)
i.e.- =CountIF( A3:L22,5) =CountIF( A3:L22,">5") |
|
|
In which statement do i have to put quotation marks around greater than, equal to and less than statements?
|
Only In the COUNTER IF
|
|
|
What is the only time to use quotations when writing an IF statement?
|
Only Around Alphabetic Characters
("A","B","C","ERROR") |
|
|
How do i write a function to find the minimum of a set of ranges?
|
=MIN(range)
|
|
|
How do i write a function to find the maximum of a set of range?
|
=MAX(Range)
|
|
|
What is absolute cell referencing? What symbol is used?
|
Is when you use the dollar sign to establish a common denominator. It keeps the fill handler from adding 1 to the cell of that equation.
|
|
|
True or False do you have to put a $ in front of both the letter and number in absolute cell referencing?
|
False, because it will never try to change the letter
|
|
|
Can you have a function inside of a function?
|
Yes
|
|
|
What order does your information have to be in to make up a table?
|
Ascending Order- column 1 has to be ascending
|
|
|
How do you write a VLOOKUP equation?
|
=VLookup(Target cell,Table Range, Column #)
|
|
|
What does VLOOKUP stand for?
|
Vertical Lookup
|
|
|
How do i write a mid function?
|
=MID(target cell, starting postion, # of characters to extract)
i.e.- c15 = 1602 =MID(C15,2,2) that gives you 60 |
|
|
What do you have to create to use VLookup?
|
A TABLE
|
|
|
Break down the steps of Vlookup
|
For Vlookup there has to be at least 2 columns first find the cell that i need analyzed, then highlight the entire range, then out of each column do i want the information pulled from.
|
|
|
What Axis is for depth?
|
Z- it is to make your graph 3 deminsional
|
|
|
What is a leader line?
|
when pies slices are to small to be labeled you the leader line will draw a line to connect the data of the pie to the slice.
|
|
|
How do you get the value invested?
|
The number on hand * Cost per Item
|
|
|
How to you use auto sum?
|
Highlight the range of cells including the cell you want the answer to appear in, then click on auto sum button.
|
|
|
What exactly is a Circular Reference Error?
|
Is putting the formula in the range of the formula
|
|
|
How do you sort?
|
1. select everything
2) Home Ribbon 2) Data Ribbon 3) Sub-Cat Editing 3) Sub-Cat Sort&Filter 4. Select Type of Sort you Want |
|
|
How will Excel sort?
|
Excel will always sort by the first column in the range unless you click custom sort and specify deferently
|
|
|
To see the Fill Handler what do you have to do?
|
select a cell
|
|
|
Greater Than
|
>
|
|
|
Less Than
|
<
|
|
|
Not Equal
|
< >
|
|
|
Given : =Sum(c5:c9, Sheet2!J5:J8)
Rewrite if the worksheet title was changed to Blue |
=Sum(C5:C9,"Blue!"J5:J8)
|
