Dr Mo Final Exam 100% VERIFIED ANSWERS 2024/2025 CORRECT STUDY SET, Exams of Business Administration

Download Dr Mo Final Exam 100% VERIFIED ANSWERS 2024/2025 CORRECT STUDY SET and more Exams Business Administration in PDF only on Docsity!

Dr Mo Final Exam 100%

VERIFIED ANSWERS

2024/2025 CORRECT STUDY

SET

The approximate match lookup compares a lookup value to ranges of values, determining the range the lookup value falls within? True What is the correct order of arguments for the VLOOKUP function for an exact match? =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup=FALSE) The video gave you two important rules concerning VLOOKUPS: The 1st was that the data had to be in a vertical columns, and the 2nd was information that you know must be __________ of the data you want to lookup. Left Specify ________ as the range lookup value if you want an exact match and _________ for an approximate match. FALSE, TRUE Which of these is the proper syntax for a XLOOKUP function: XLOOKUP(Lookup value, lookup array, return array, [not_found]) Which of these would be a correct COUNTIF function? =COUNTIF(B5: B100, "Facebook")

The COUNTIF function makes no distinction between text values and numeric values unlike the COUNT function which does NOT count text values. True In this formula =SUMIF(C3:C12,14, E3:12), what does the range E:3:12 represent? Sum Range Which one of these calculates the sum of values in the range B1:B100, but only those cells whose value is less than 50: =SUMIF (B1:B100," <50") Use the COUNTIF, SUMIF, and AVERAGEIF functions for _________ a criteria argument. Excel also supports summary functions that allow for ________ criteria: COUNTIFS, SUMIFS, and AVERAGEIFS. single, multiple Which of these is the correct AVERAGEIF function? AVERAGEIF(A1:A100, "> 50") To test for multiple conditions, returning different values for each condition, you can __________ one IF function within the other? Nest The IFS function now provides an easier way of working with multiple IF conditions _________ nesting. Without The IFS function does not include a default value if all the conditions are false, but you can add a default condition. Which of the following is the correct form of a default condition? IFS(A1 <6, "Poor", A1 <10,"Average, A1> = 10, TRUE, 'Good")

The score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60. Which of these functions will you insert in the D2 cell so that it returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE? =OR(B2>=60, C2>=60) The score of a student inserted in the B2 cell is 65 and in the C2 cell is

75. Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells? =AND(B2>=70, C2>=80) The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. Which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed? =NOT(OR(B2>=60, C2>=60)) To hide the PivotTable Field list, right click on any cell of the pivot table, and select Hide Field List option from the context menu. True A single PivotTable can do the work of _________ but with more ease and flexibility. Multiple summary IF functions Edwin wants to insert a Pivot Chart to summarize raw data. Which of the following combination of clicks/selections/entries should he use to do this? Select Cell › Insert > PivotChart > OK Ingrid wants to change the name associated with a Pivot Chart in Excel. To do so, she right-clicks on the pivot table and then selects X from the popup menu. She then enters the new name for the Pivot Chart in the Name field in the window that appears and clicks: PivotTable Options Which of these is the default layout for a newly created PivotTable?

Compact Form To clear all the data from a PivotChart, click the PivotChart. Then on the Analyze tab, in the Data group, click Clear, and then click Clear All. True Which function below calculates the average of values for cells that match a specified criteria such as averaging the number of followers for "Twitter" posts? AVERAGEIF function Which function below is used to lookup data from a vertical lookup table? VLOOKUP function Which function below counts the number of cells that match a specific criteria, such as the number of cells containing the value "Facebook"? COUNTIF function Many financial functions deal with __________, which is direction of money to and from an individual or group. Cash flow A __________ cash flow, or cash inflow, represents money that is coming to an individual (cash received). A _________ cash flow, or cash outflow, represents money that is leaving the individual (cash spent). positive, negative if you borrow money by taking out a loan, the amount you borrow is a _________ flow to you but a __________ from the lender. Positive cash flow, negative cash flow Money you invest is a ___________ because you are spending money on the investment, but any returns from that investment back to you are ________

Negative cash flow, positive cash flow _________ refers to the current value of a loan or investment, whereas _________ references that loan or investment's value at a later date. Present value, Future Value If you take out a loan for $50,000, its present value is ________, and if you repay the entire loan, its future value is _______ $50,000, $ If you take out a loan for $56,000 from a lender, is this a positive or negative cash flow? Positive _______ is a money paid regularly by a company to its shareholders out of its profits Dividends __________ is the result of reinvesting interest, rather than paying it out, so that interest in the next period is then earned on the principal sum plus previously accumulated interest. Compound interest The cost of a loan to a individual or business is based on three factors. What are the factors? Principal, interest, time ________ is the amount for the loan, ______ is the amount added to the principal by the lender Principal, interest The PMT function determines the _______ made periodically to either repay a loan or reach an investment goal Size of payments Interest rate and payments do not have to use the same units False

In the function ,=PMT(H7,F7,B7), what does F7 refer to? Number of payments (nper) Excel financial functions automatically format calculated values as ________, and negative cash flows appear in a _______ font. Currency, red If your company borrows $500,000 at 6% annual interest to be repaid quarterly after a 5 year period, the Rate value in the PMT function would be: 1.5% If your company borrows $500,000 at 6% annual interest to be repaid quarterly after a 5 year period, how many payments (NPER) would you have over the 5 year period? 20 Use the FV function to calculate the loans value After a specified number of periods The difference between sales revenue and production expenses is known as: Gross Profit The RATE function is used primarily to: Calculate the return from investments What is the correct syntax for the RATE function? =RATE(Nper, Pmt, Pv) Tangible assets are companies _______. Non-cash assets Depreciation is part of the income statement in the _______ section Earnings

A _______ cell is one whose value depends on the values of other cells. A ________ cell is one whose value is used by other cells Dependent, Precedent The tracer arrow provides a visual clue to the source of an error. A ________ tracer indicates that an error has been received from the precedent cell or passed to the dependent cell. In this case, a ________ tracer arrow points to the source of the error Blue, red How can you correct an error such as the #NAME? error in a worksheet? Trace the cell precedents and dependents to find the source of the error Samira has a workbook containing many worksheets with interconnected formulas. What can she use to display the values of specified cells located throughout the workbook? Watch window What must you provide in the Series dialog box to extrapolate a series? Step Value, Type of series Which Excel dialog box do you use to fill a series based on extrapolation? Series dialog box Which arguments are required for the CUMIPMT function? Rate, Nper, PV