Problem Solving in
Excel with verified
solutions
What does Formula -> Lookup & Reference do? -
answer Shows all formulas
If you type = and then click "Fx" in text box, what
happens? - answer It lets you know step by step to
inserting a formula
What does Formulas -> Trace Precedence do? -
answer Lets you look at which cells are referenced
in a specific formula
What does Formulas -> Trace dependence do? -
answer Lets you look at which formula is
referenced in another formula
How do you remove arrows in an error help? -
answer Formulas -> Remove Arrows
,How to paste formats - answer Copy cells. Paste ->
formats
Does paste formats do the same thing as format
painter? - answer Yes
How to paste solely formulas? - answer Paste ->
paste special -> formula
How to paste solely values and not formulas -
answer paste -> paste special -> values
What is paste -> multiply? - answer If you want
multiple cells to be multiplied by a single cell, you
can use this
How to paste multiply? - answer Paste -> Paste
Special -> multiply
What is paste transpose? - answer Switches rows
to columns, vice versa (you have to highlight what
you want to be switched)
How to paste transpose - answer Paste -> Paste
special -> Transpose
,Can you have spaces in a name range? - answer No
Can a name in a name range be used to create
another named range in the same worksheet? -
answer No
Where can you change or add in a name range? -
answer Cell box in top right (just type in there
what you want the named range to be - you have
to highlight the range), or formulas -> define name
How to delete name ranges - answer formula ->
define nameq
An example of how you use name ranges in a
formula - answer =sum([named range]). Ex:
=SUM(Hank)
When do you use subtotal? - answer To perform
dynamic calculations to a data set
How does subtotals work with filtering? - answer If
you filter, it will add only the filtered items
Does subtotal add in cells which have already been
subtotaled? - answer No
, What happens when you first type in =subtotal? -
answer It will ask what you want to subtotal: sum,
average, count, etc. and then the range.
What does IFERROR do? - answer Tells excel what
value to say if an eror happens
IFERROR function - answer =IFERROR (value, value
if error). Ex: =IFERROR(VLOOKUP(B3,B4:I5 [table
array],2,FALSE),"Data is not available"[what you
want the cell to say if the data is not available])
Is an IFERROR similar to IF? - answer Yes, the first
part says what value to put if an error does not
occur. The 2nd part says the value to put if an error
does occur.
What do you do if you have data is seperated by a
comma or an underscore? - answer You select the
data and click data -> text to columns. This will
allow you to delimit the file
What type of delimited file is underscore? - answer
Other, and type in _
Excel with verified
solutions
What does Formula -> Lookup & Reference do? -
answer Shows all formulas
If you type = and then click "Fx" in text box, what
happens? - answer It lets you know step by step to
inserting a formula
What does Formulas -> Trace Precedence do? -
answer Lets you look at which cells are referenced
in a specific formula
What does Formulas -> Trace dependence do? -
answer Lets you look at which formula is
referenced in another formula
How do you remove arrows in an error help? -
answer Formulas -> Remove Arrows
,How to paste formats - answer Copy cells. Paste ->
formats
Does paste formats do the same thing as format
painter? - answer Yes
How to paste solely formulas? - answer Paste ->
paste special -> formula
How to paste solely values and not formulas -
answer paste -> paste special -> values
What is paste -> multiply? - answer If you want
multiple cells to be multiplied by a single cell, you
can use this
How to paste multiply? - answer Paste -> Paste
Special -> multiply
What is paste transpose? - answer Switches rows
to columns, vice versa (you have to highlight what
you want to be switched)
How to paste transpose - answer Paste -> Paste
special -> Transpose
,Can you have spaces in a name range? - answer No
Can a name in a name range be used to create
another named range in the same worksheet? -
answer No
Where can you change or add in a name range? -
answer Cell box in top right (just type in there
what you want the named range to be - you have
to highlight the range), or formulas -> define name
How to delete name ranges - answer formula ->
define nameq
An example of how you use name ranges in a
formula - answer =sum([named range]). Ex:
=SUM(Hank)
When do you use subtotal? - answer To perform
dynamic calculations to a data set
How does subtotals work with filtering? - answer If
you filter, it will add only the filtered items
Does subtotal add in cells which have already been
subtotaled? - answer No
, What happens when you first type in =subtotal? -
answer It will ask what you want to subtotal: sum,
average, count, etc. and then the range.
What does IFERROR do? - answer Tells excel what
value to say if an eror happens
IFERROR function - answer =IFERROR (value, value
if error). Ex: =IFERROR(VLOOKUP(B3,B4:I5 [table
array],2,FALSE),"Data is not available"[what you
want the cell to say if the data is not available])
Is an IFERROR similar to IF? - answer Yes, the first
part says what value to put if an error does not
occur. The 2nd part says the value to put if an error
does occur.
What do you do if you have data is seperated by a
comma or an underscore? - answer You select the
data and click data -> text to columns. This will
allow you to delimit the file
What type of delimited file is underscore? - answer
Other, and type in _
