MISY 5325 Exam Study Guide with Complete Solutions
3 views 0 purchase
Course
MISY 5325
Institution
MISY 5325
MISY 5325 Exam Study Guide with
Complete Solutions
fill 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 ce...
True or False: According to the Priority Rule in Excel, the Addition and Subtraction will
be executed before the Division and Multiplication. - Answer✔✔-False
True or False: Any calculation placed inside the parenthesis will be executed first -
Answer✔✔-True
Instead of typing the cell reference you can use what method - Answer✔✔-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 - Answer✔✔-relative reference
True or False: Format Painter button will copy the data (not the format) to another cell. -
Answer✔✔-False
True or False: The Common Button will format will format all numbers with two decimal
places and have a 1000 comma separator - Answer✔✔-True
With this function, the format of the cells will be changed automatically when the data in
such cells meet the condition. - Answer✔✔-conditional formatting
To display the worksheet with formulas, press - Answer✔✔-CTRL + `
True or False: A System Date formula will display the current date and time every time
we open the work sheet - Answer✔✔-True
What is the System Date formula? - Answer✔✔-=NOW()
What type of cell references are the following?
2/7
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 EmillyCharlotte. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.