Exam (elaborations)
BITM Exam 2 (Questions & Answers) Verified 100% Correct!!
- Course
- Institution
BITM Exam 2 (Questions & Answers) Verified 100% Correct!!
[Show more]
Content preview
Name: Score:72 Multiple choice questions
Term 1 of 72
DMIN
sums the values of cells in the field that meet the criteria
displays the smallest value in the field that meets the criteria
counts cells with values in the field (column) that meet the criteria
total number of payments over the life of the transaction
Definition 2 of 72
picture of a full or partial computer screen inserted as an object in a worksheet
database
error alert
hyperlink
screenshot
Definition 3 of 72
object created in VBA programming code for display in a workbook
userform
DAVERAGE
hyperlink
smart art
,Definition 4 of 72
interest rate for the time period
DMIN
rate
alt text
link
Term 5 of 72
mean absolute deviation (MAD)
summarizes the data and displays a result on the consolidated sheet
calculation that uses two excel functions, ABS and AVERAGE
application that runs in a window separate from excel
a programming language foe enhanced commands and features in excel
Term 6 of 72
DMAX
counts cells in the field that are not empty that meet the criteria
argument is the amount saved or invested each period
displays the smallest value in the field that meets the criteria
displays the largest value in the field that meets the criteria
, Term 7 of 72
nested function
function within a function
a choice in the record macro dialog box
function, service, or action for an oject
simple subtraction formula
Term 8 of 72
mark as final
function within a function
to set a read-only file property
payments or receipts
rules applied to data as it is entered
Definition 9 of 72
argument is the amount saved or invested each period
nper
pmt
button
.xltm
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 stuuviaa. 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.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75759 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now