Exam (elaborations)
OMGT 3223 Test 2 Questions with Correct Answers
- Course
- Institution
OMGT 3223 Test 2 Questions with Correct Answers
[Show more]
Content preview
OMGT 3223 Test 2 Questions withCorrect Answers
True - Answer-(T/F): You have to be careful in excel when building a formula beginning
with a negative
True - Answer-(T/F): In excel, when beginning a formula with a negative, we have to put
it in parenthesis so that excel takes the quantity
(-1)^2 + 1
Copying with relative addressing - Answer-In excel, a number can be copy and pasted
by clicking and dragging from the right corner. The formula will adjust and the row
references will update. This is called:
Copying with absolute referencing - Answer-Sometimes when we copy formulas, we
don't want the address to change, we would then use:
Inserting a dollar sign into the formula in front of the columns
=$B9+$C9 - Answer-We tell excel to copy with absolute referencing only changing the
rows and keeping the columns the same by:
True - Answer-(T/F): In copying with absolute referencing, the rows can change, while
the columns don't and vice versa
Inserting a dollar sign into the formula in front of the rows
=B$9+C$9 - Answer-We tell excel to copy with absolute referencing only changing the
columns and keeping the rows the same by:
The column change - Answer-In this formula:
=B$9+C$9
if I copy this formula down one row and over one column, what will be affected?
True - Answer-(T/F): We can mix absolute and relative addressing depending upon the
models that we might want to build
Moving the dollar sign in the formula
=B$9+$C9 - Answer-How can we mix absolute and relative addressing in an excel
formula?
Row fixed for first term
Column fixed for next term - Answer-Analyze this excel formula:
=B$9+$C9
F4 key - Answer-One of the hot signs available to insert the dollar sign
, The row reference (second 9) will update
The column won't change
=B$9+$C10 - Answer-What happens if I copy this formula down one row?
=B$9+$C9
The column reference (B) will update
The row won't change
=C$9+$C9 - Answer-What happens if I copy this formula one column to the right?
=B$9+$C9
We get 2 changes
B will change to C and second 9 will change to 10
=C$9+$C10 - Answer-What happens if I copy this formula over one column and down
one row?
=B$9+$C9
Of - Answer-The ______ function in excel allows you to build models that do alternative
calculations
-if a mathematical condition is satisfied, they'll do one calculation
-not satisfied, they'll do a different calculation
IF(logical_test, [value_if_true], [value_if_false]) - Answer-an if statement formula
If C3 is greater than 50, make the value 1, if not, make the value 0 - Answer-Put this
formula into words:
=if(C3>50,1,0)
If C3 is greater than or equal to 50, make the value 1, if not, make the value 0 - Answer-
Put this formula into words:
=if(C3>=50,1,0)
Will return the value 0 as a substitute for the true condition - Answer-If the true value in
an if statement is missing(like the user forgot to write it in):
=if(C3>=50,,0)
What will excel do?
Substitute that individual value for writing in "FALSE" - Answer-If you forget to put in a
comma indicating that there is a false condition(and the condition IS false)
=if(C3>=50,)
what will excel do?
Is C3 greater than 50? If so, put a 1: No its not
Then I would proceed to the false condition
Is D3 greater than 60? No
So I should get the value 0 - Answer-C3=50, D3=60
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller lectknancy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now