1 Exampromax - Stuvia US
IS 101 Final UNR Reed Questions and Answers
100% Correct Answers Already Graded A+
Q: What is the easiest way to determine the address of a cell?
Ans: Name Box
Q: Where can you look to determine if a cell value or a calculation?
Ans: Formula Bar
Q: The cell that is outlined in green is referred to as?
Exampromax - Stuvia US
Ans: Active Cell
Q: Does a number format change the value of a cell in any way?
Ans: No. Only changes the format of that cell
Q: How do you signify to Excel that youre beginning a formula?
Ans: Equal Sign
Q: What dictates the way in which formulas will be solved?
Ans: Order of operations
Q: What will occur after dragging =B6+B7 two cells to the right?
Ans: =D6+D7
Q: What will occur after dragging =B6+B7 three cells down?
Ans: =B9+B10
Q: Why does the formula change when dragged in any direction?
, 2 Exampromax - Stuvia US
Ans: Relative referencing
Q: What is a function?
Ans: A Predefined formula
Q: What are 4 ways to insert a function?
Ans: Insert function button, formula tab > choose function category > choose
function, home tab > editing > choose function, type =, name of func, arguments
Q: What is syntax?
Ans: Equal sign, name of function, open parentheses, arguments, close
parentheses
Exampromax - Stuvia US
Q: What kind of reference is $A$5 and what does it do?
Ans: Absolute reference, Keeps the column or row from changing
Q: What is an example of a logical operator?
Ans: =, >, <, >=, <=, <>
Q: What is A4:B15 referred to as?
Ans: Range
Q: When I assign the name "wolf pack" to the range A4:B15 what did I
create?
Ans: Range name
Q: Which function helps determine the payment on a loan?
Ans: PMT
Q: In PMT what is the most important thing to remember about your rate?
Ans: When using APR that value needs to be divided by 12 if making monthly
payments or 4 for quarterly
IS 101 Final UNR Reed Questions and Answers
100% Correct Answers Already Graded A+
Q: What is the easiest way to determine the address of a cell?
Ans: Name Box
Q: Where can you look to determine if a cell value or a calculation?
Ans: Formula Bar
Q: The cell that is outlined in green is referred to as?
Exampromax - Stuvia US
Ans: Active Cell
Q: Does a number format change the value of a cell in any way?
Ans: No. Only changes the format of that cell
Q: How do you signify to Excel that youre beginning a formula?
Ans: Equal Sign
Q: What dictates the way in which formulas will be solved?
Ans: Order of operations
Q: What will occur after dragging =B6+B7 two cells to the right?
Ans: =D6+D7
Q: What will occur after dragging =B6+B7 three cells down?
Ans: =B9+B10
Q: Why does the formula change when dragged in any direction?
, 2 Exampromax - Stuvia US
Ans: Relative referencing
Q: What is a function?
Ans: A Predefined formula
Q: What are 4 ways to insert a function?
Ans: Insert function button, formula tab > choose function category > choose
function, home tab > editing > choose function, type =, name of func, arguments
Q: What is syntax?
Ans: Equal sign, name of function, open parentheses, arguments, close
parentheses
Exampromax - Stuvia US
Q: What kind of reference is $A$5 and what does it do?
Ans: Absolute reference, Keeps the column or row from changing
Q: What is an example of a logical operator?
Ans: =, >, <, >=, <=, <>
Q: What is A4:B15 referred to as?
Ans: Range
Q: When I assign the name "wolf pack" to the range A4:B15 what did I
create?
Ans: Range name
Q: Which function helps determine the payment on a loan?
Ans: PMT
Q: In PMT what is the most important thing to remember about your rate?
Ans: When using APR that value needs to be divided by 12 if making monthly
payments or 4 for quarterly
