What is the number format style? - A number with or without the comma separator and with
any number of decimal places. Negative numbers can be displayed with parentheses and/or red
What is the currency format style? - A number, the dollar sign immediately to the left of the
number, a comma for e...
BITM 215 Exam 1 Review Questions
Solved 100% with Certified Correct
Answers
What is the number format style? - ✔✔A number with or without the comma separator and with
any number of decimal places. Negative numbers can be displayed with parentheses and/or red
What is the currency format style? - ✔✔A number, the dollar sign immediately to the left of the
number, a comma for every three digits on the left side of the decimal point, and two digits to the
right of the decimal point. Negative values are preceded by a minus sign. Zero displays as $0.00
What is the accounting number format? - ✔✔A number, the dollar sign on the left side of the cell, a
comma for every three digits on the left side of the decimal point, and two digits to the right of the
decimal point. Negative values are enclosed in parentheses by default. Zero
displays as a dollar sign and a hyphen
What is the comma style? - ✔✔The Comma Style formats with a comma for every three digits on
the left side of the decimal point and displays two digits to the right of the decimal point
What is metadata? - ✔✔data or a set of data that describes a file or even other data
ex. author's name, the date a file was created or changed
What is page setup? - ✔✔deals with how a document will look before it is printed
What is formula AutoComplete? - ✔✔Displays a list of functions and range names that match
the character that you typed
What is range finder? - ✔✔highlights and color codes each cell as you type its address
, Does it matter the order you put formulas in for an equation? - ✔✔Yes, if the operations
have different priorities(PEMDAS) you have to put them in order of operations first, then left to
right
What is a relative reference? - ✔✔the default method of referring to a cell(A1, B2, C3)
when formulas are moved or copied and pasted, the formulas are adapted to their new relative position
What is an absolute reference? - ✔✔in a formula maintains that address when the formula is copied
- indicated by 2 dollars
ex. $A$1
What is a logical function? - ✔✔performs logical tests and returns the value of
tests includes logical operators for combined tests, such as AND, OR and NOT
What is the SUMPRODUCT function? - ✔✔calculates the sum of the product of several ranges,
it multiplies the cells identified in its array arguments and then its totals those individual products
ex. =SUMPRODUCT(A2:A14)
What is the difference between the =TODAY() and =NOW() function? - ✔✔=TODAY() prints just the
date
=NOW() prints the date and time
What are breakpoints? - ✔✔mark the boundaries between two or more components
What do PMT functions do? - ✔✔calculates loan payments for personal and business uses
What is the proper syntax for a PMT formula? - ✔✔=PMT rate, nper, pv, [fv],
[type]) rate: interest rate per period
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 KenAli. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
