Excel Holden Sheet Quiz 1

Satisfactory Essays
Quiz
-------------------------------------------------
Top of Form Please Note: It is recommended that you save your response as you complete each question. |
Question 1 (2 points) Read the following two statements and determine whether they are correct or incorrect. A. For a given interest rate and cash flow - the longer the time period, the smaller the future value. B. For a given time period and cash flow - the higher the interest rate, the smaller the present value
Question 1 options: | A) | Both statements are incorrect | | B) | A is incorrect but B is correct | | C) | A is correct but B is incorrect | | D) | Both statements are correct |
Save
Question 2 (2 points) Would you be willing to receive $600 today in exchange for receiving $1000 in 7 periods, if your discount rate was 10% per period?
Question 2 options: | A) | Yes | | B) | No, the number of periods would have to be less than 5.36 | | C) | No, the interest rate would have to be less than 7.57% | | D) | There is not enough information to answer this question. |
Save
Question 3 (2 points) A single cash flow of $932.47 is available now (in period 0). For this cash flow, the appropriate discount rate per period is 3.9%. What is the period 4 future value of this single cash flow?
Question 3 options: | A) | $1086.67 | | B) | $1124.56 | | C) | $1156.24 | | D) | $1201.91 | | E) | $1216.65 |
Save
Question 4 (2 points) You will receive $800 in 3 periods and $1200 in 4 periods. How much are those two cash flows worth today, if your discount rate is 6% per period?
Question 4 options: | A) | $1475.67 | | B) | $1504.78 | | C) | $1568.90 | | D) | $1599.97 | | E) | $1622.21 |
Save
Question 5 (2 points) A single cash flow of $1673.48 will be received in 4 periods. For this cash flow, the appropriate discount rate per period is 7.8%. What is the present value of this single cash flow?
Question 5 options: | A) | $975.67 | |

You May Also Find These Documents Helpful

  • Powerful Essays

    Excel Quiz

    • 2074 Words
    • 9 Pages

    How to Create an Interactive Quiz in Excel http://college.cengage.com/accounting/resources/instructors/air/fall_2006... Creating Interactive Quizzes in Excel J.A. (Jim) Connell University of Montevallo Michael E. Stephens College of Business Station 6551 Montevallo, AL 35115 Elizabeth Mulig USF St. Petersburg 140 Seventh Avenue South St. Petersburg Florida 33701-5016 727-553-4154 mulig@stpt.usf.edu Introduction Have you ever received a spreadsheet file that asked you questions and then…

    • 2074 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    Excel Chapter 1

    • 4708 Words
    • 19 Pages

    Exploring Microsoft Office 2010 Volume 1 Excel Chapter 1 Testbank 1) A spreadsheet A) is the core of a slide presentation. B) is an electronic file that is used to write text and graphics on the web. C) is an electronic file that contains a grid of columns and rows for related data. D) is another word for a letter written on a computer. Answer: C Diff: 1 Reference: Introduction to Spreadsheets Objective: 1 AppChap: Excel 1: Introduction to Excel 2) A spreadsheet PROGRAM is defined…

    • 4708 Words
    • 19 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3. I found that the MS Excel assignment in week 4, to create an Excel spread sheet, was very helpful to me because I can use this information in my career field. Organizing meetings and balancing a budget is just a couple of many ways I can use Excel as an employee. I can also apply the Excel spread sheet to my everyday life like creating a chore list for my kids and using it to organize my…

    • 79 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Excel Assignment 1

    • 1242 Words
    • 5 Pages

    ------------------------------------------------- Excel Assignment #1 Exercise 1: Student Grade Book (expected time – less than 45 minutes) Please download the spreadsheet Excel Assignment 1.xlsx from Blackboard. Click on worksheet E1 (you may be in Worksheet E1 by default). This spreadsheet keeps track of students’ grades. There are two exams – Exams 1 and Exam 2. Please do the following: (a) Find the total weighted score for the semester based on Exam 1 and Exam 2 and their respective weights. (i.e., Exam 1 * Weight 1 + Exam 2 *…

    • 1242 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    Performance Appraisal Assignment Enclosure: Excel Sheet for Rough Work (In Mail) Submitted by: Group: 10 Kumar Gauraw (15) Ajay Gupta (37) Rajumoni Saikia(48) Tarakeswar Das(49) Question: How will you use Different methods to assess her performance? Answer: Graphic Rating Scale Graphic rating scales are one of the most common methods of performance appraisal. Graphic rating scales require an evaluator to indicate on a scale the degree to which an employee demonstrates…

    • 875 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    cÖ‡R±: MS Excel e¨envi K‡i djvdj ˆZix MS Excel e¨envi K‡i eZ©gv‡b cÖPwjZ †MÖwWs c×wZ‡Z cix¶vi djvdj ˆZix| MS Excel e¨envi K‡i GBP.Gm.wm cix¶vi djvdj ˆZix Ki‡Z n‡e| GBP.Gm.wm cix¶vi ছাত্র/ছাত্রীদের 6wU wel‡q Ask MÖnb Ki‡Z nq, Zvi g‡a¨ 1wU welq AwZwi³ ev PZz_© welq wnmv‡e cix¶v w`‡Z n‡e| bZzb †MÖwWs c×wZ‡Z PZz_© wel‡qi b¤^i djvd‡ji Dci cÖfve ‡d‡j| cÖwZwU wel‡q Avevi cÖ_g I wØZxq cত্র bv‡g `ywU Ask _vK‡e| A_©vr, PZz_© welqmn cix¶v_©x‡K †gvU 12wU wel‡q AskMÖnb Ki‡Z nq| cÖwZwU wel‡qi…

    • 1149 Words
    • 5 Pages
    Powerful Essays
  • Better Essays

    Quiz 1

    • 1430 Words
    • 6 Pages

    ADM 3346 X COST ACCOUNTING Spring/Summer 2012 Quiz No. 1 Solutions . . . . . . . / 16 marks NAME: __________________________________________ STUDENT #: ________________________ Statement of Academic Integrity: The School of Management does not condone academic fraud, an act by a student that may result in a false academic evaluation of that student or of another student. Without limiting the generality of this definition, academic fraud occurs when a student commits any of the following offences:…

    • 1430 Words
    • 6 Pages
    Better Essays
  • Good Essays

    Quiz 1

    • 681 Words
    • 3 Pages

    Quiz 1 Each question is worth 2 points. Submit through your assignment folder by 11:59 PM EDT on September 7th. I know I don’t need to remind anyone that UMUC’s academic integrity policies. We are all adults. We know that we shortchange only ourselves if we aren’t honest. This quiz needs to be completed without help from others. The work submitted must be your own. What is the level of measure for each of the following: Final grades in this class ____Ratio_________________ Weights of newborn…

    • 681 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Quiz 1

    • 589 Words
    • 8 Pages

    Quiz 1 Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) An educated scientific guess is a A) theory. B) hypothesis. C) either of these D) neither of these 1) 2) The synthesis of a large collection of information that contains well-tested and verified hypotheses about certain aspects of the world is known as a scientific A) theory. B) law or principle. C) hypothesis. D) fact. E)…

    • 589 Words
    • 8 Pages
    Good Essays
  • Good Essays

    Quiz 1

    • 497 Words
    • 2 Pages

    CHAPTER 1 QUIZ 1. "Critical Thinking is another name for logic." True False 2. In the broadest sense, _______________, is just any matter that is in dispute, in doubt, or simply "up for Review". LOGIC CRITICAL THINKING AN ISSUE PREMISE 3. Learning how to distinguish between good and bad arguments makes one a better global citizen. True False 4. Premises and conclusions are the same kind of statements. True False 5. Good reasoning is…

    • 497 Words
    • 2 Pages
    Good Essays