Exam (elaborations)
MISY 5325 QUESTIONS AND ANSWERS FULLY SOLVED
- Course
- Institution
Exam of 5 pages for the course MISY at MISY (MISY 5325)
[Show more]
Content preview
MISY 5325fill handle - answer The small black square in the lower right corner of a selected cell
The fill handle is used to - answer copy and paste data
True or False: The fill handle is the least efficient way to copy and paste a formula from
one cell to a range of cells - answer False
It is the most efficient way
True or False: Merge and Center function must be performed one row at a time. -
answer True
How can you adjust the width of the column to the width of the largest item in the
column - answer double click on column border
True or False: In order to select the range that is not a continuous range, you must use
the control key - answer True
Steps to move the chart to the new worksheet - answer under the Design tab
click the Move Chart icon
the Move Chart dialog-box will pop up
Select the New Sheet
True or False: If you move a chart correctly you will see the cell background behind the
chart. - answer False
True or False: All formulas in Excel start with a equal sign - answer True
True or False: According to the Priority Rule in Excel, the Addition and Subtraction will
be executed before the Division and Multiplication. - answerFalse
True or False: Any calculation placed inside the parenthesis will be executed first -
answerTrue
Instead of typing the cell reference you can use what method - answerclinking method
If you copy a cell containing a formula and paste the formula into another cell, the
formula will be changed accordingly, depending on how many rows or columns you
have moved. This is called - answerrelative reference
, True or False: Format Painter button will copy the data (not the format) to another cell. -
answerFalse
True or False: The Common Button will format will format all numbers with two decimal
places and have a 1000 comma separator - answerTrue
With this function, the format of the cells will be changed automatically when the data in
such cells meet the condition. - answerconditional formatting
To display the worksheet with formulas, press - answerCTRL + `
True or False: A System Date formula will display the current date and time every time
we open the work sheet - answerTrue
What is the System Date formula? - answer=NOW()
What type of cell references are the following?
1. $A$1
2. A1
3. A$1
4. $A1 - answer1. Absolute reference
2. Relative cell reference
3. Mixed reference
4. Mixed reference
What is the IF function syntax? - answer=if(logic test, value 1 is test is true, value 2 if
the test is false)
True or False: A argument in the IF function can be numeric, text, or cell reference. -
answerTrue
True or False: An argument in text in the IF function, does not need to be placed within
quotation marks. - answerFalse
True or False: The IF function can contain an inner loop - answerTrue
Give example of inner loop in IF function. - answer=if(A1>=90, "A", if(A1>=80, "B",
if(A1>=70, "C", if(A1>=60, "D", "F"))))
True or False: You can press F5 to make a cell reference absolute - answerFalse
True or False: The result of adding margin and cost of goods sold is always equal to
100%. - answerTrue
Gross margin - answerthe profit made directly from selling products before subtracting
all expenses
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 julianah420. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72042 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now