True or False: According to the Priority Rule in Excel, the Addition and Subtraction will
be executed before the Division and Multiplication. - ️️False
Steps to move the chart to the new worksheet - ️️under the Design tab
click the Move Chart icon
the Move Chart dialog-box will pop up
...
MISY 5325
True or False: According to the Priority Rule in Excel, the Addition and Subtraction will
be executed before the Division and Multiplication. - ✔️✔️False
Steps to move the chart to the new worksheet - ✔️✔️under the Design tab
click the Move Chart icon
the Move Chart dialog-box will pop up
Select the New Sheet
How can you adjust the width of the column to the width of the largest item in the
column - ✔️✔️double click on column border
The fill handle is used to - ✔️✔️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 - ✔️✔️False
It is the most efficient way
True or False: Merge and Center function must be performed one row at a time. -
✔️✔️True
True or False: In order to select the range that is not a continuous range, you must use
the control key - ✔️✔️True
fill handle - ✔️✔️The small black square in the lower right corner of a selected cell
True or False: If you move a chart correctly you will see the cell background behind the
chart. - ✔️✔️False
True or False: All formulas in Excel start with a equal sign - ✔️✔️True
True or False: Any calculation placed inside the parenthesis will be executed first -
✔️✔️True
Instead of typing the cell reference you can use what method - ✔️✔️clinking 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 - ✔️✔️relative reference
True or False: Format Painter button will copy the data (not the format) to another cell. -
✔️✔️False
True or False: The Common Button will format will format all numbers with two decimal
places and have a 1000 comma separator - ✔️✔️True
With this function, the format of the cells will be changed automatically when the data in
such cells meet the condition. - ✔️✔️conditional formatting
To display the worksheet with formulas, press - ✔️✔️CTRL + `
True or False: A System Date formula will display the current date and time every time
we open the work sheet - ✔️✔️True
What is the System Date formula? - ✔️✔️=NOW()
What type of cell references are the following?
1. $A$1
2. A1
3. A$1
4. $A1 - ✔️✔️1. Absolute reference
2. Relative cell reference
3. Mixed reference
4. Mixed reference
What is the IF function syntax? - ✔️✔️=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. -
✔️✔️True
True or False: The IF function can contain an inner loop - ✔️✔️True
Give example of inner loop in IF function. - ✔️✔️=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 - ✔️✔️False
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 ACADEMICMATERIALS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
