Question 1: Financial Functions- Future Valae of Meney (s polnts) Using some of the functions provided at the end of the exam, calculate the following 1) A sum of $5,000 is invested for 5 years at 5% annual interest. A) What is the future value ot tuan money? B) If interest is compounded quarterly (4, (), what is the future value of that money? 2) How many years will it take to have a future value of money of around $7000 ? Fill out 1) Set cell: 2) To value: 3) By changing cell: Question 2: Qormulas, Absolute \& Ralative Roferencis, and iy statrment (10 peiati) be dragged to F13. will be dragged to G13. 3) Formula 3 represents the \% Profit. It is the ratio formula then will be dragged oo the of the Cost Columan The forms in the table. 5) Formula 5 represents the Average. It is the calculate the average of yeeping of thro hing the current clothing line, 11 , whe 10000 , the mals 6 represents a decision of keeping of throwning the curtens Question 3: Querying a Table and Data Extraction (10 points) We need your help to complete the missing parts of this worksheet for company X shareholders 1) Formula 1 represents the Grade for each person. The Grade depends on the % of Share the person achieved. Use the table on the right to extract the Grade for each fund raiser. 2) Formula 2 and 3 represent the average Experience for Full Time members and average Share for Part Time members. Use one database and one statistical function to calculate them. (Notice the criterion in the figure above). - Formula 2: - Formula 3. 3) Formula 4 represents the number of people who have Grade A that is shown in column F. 4) Using Advanced Filtering query, we want to extract the records for those who are either: full time with over 7 years of experience, or part time with 4 and above years of experience. Where and what's the criteria you would write for that, in the upper area of the worksheet. Question 4: Charts (7 points) Below you have a Sheet of the Sales Totals and Averaees for aim. 1) What is the cel. range nighlighted to draw this chart? 2) What is the type of this Chart? 3) Do you think the numbers of Phones Sold have a positive impact on Sales Totals? Why? 4) What does the R2 value on the curve tell you? 5) If you want to predict the Sales Totals if the number of Phones Sold was 150, what would you do? Question 5: Multiple Choice (5 points) 1) A is created by performing a set of steps and recording the steps as they are performed. a) Procedure b) Macro c) Table d) Function in C3 will be: a) =A2SAS1 b) =B1SAS2 c) =B35A51 d) =B2SAS1 3) ensures that users do not ehange values by mistake that are important to the worksheet. a) Cell Protection b) Formula Checker c) Range Finder d) Cell Validation 4) Cell SDS is an example of a cell reference that is: a) Row Absolute, Column Relative c) Row Absolute, Column Absolute b) Row Relative, Column Absolute d) Row Relative, Column Relative 5) are a visual filter used to make PivotCharts and PivotTables easier to understand. a) Markers b) Trendlines c) Slicers d) Charters (ov). The its of for end of the period and 2 for the beginining of the perion Question 1: Financial Functions- Future Valae of Meney (s polnts) Using some of the functions provided at the end of the exam, calculate the following 1) A sum of $5,000 is invested for 5 years at 5% annual interest. A) What is the future value ot tuan money? B) If interest is compounded quarterly (4, (), what is the future value of that money? 2) How many years will it take to have a future value of money of around $7000 ? Fill out 1) Set cell: 2) To value: 3) By changing cell: Question 2: Qormulas, Absolute \& Ralative Roferencis, and iy statrment (10 peiati) be dragged to F13. will be dragged to G13. 3) Formula 3 represents the \% Profit. It is the ratio formula then will be dragged oo the of the Cost Columan The forms in the table. 5) Formula 5 represents the Average. It is the calculate the average of yeeping of thro hing the current clothing line, 11 , whe 10000 , the mals 6 represents a decision of keeping of throwning the curtens Question 3: Querying a Table and Data Extraction (10 points) We need your help to complete the missing parts of this worksheet for company X shareholders 1) Formula 1 represents the Grade for each person. The Grade depends on the % of Share the person achieved. Use the table on the right to extract the Grade for each fund raiser. 2) Formula 2 and 3 represent the average Experience for Full Time members and average Share for Part Time members. Use one database and one statistical function to calculate them. (Notice the criterion in the figure above). - Formula 2: - Formula 3. 3) Formula 4 represents the number of people who have Grade A that is shown in column F. 4) Using Advanced Filtering query, we want to extract the records for those who are either: full time with over 7 years of experience, or part time with 4 and above years of experience. Where and what's the criteria you would write for that, in the upper area of the worksheet. Question 4: Charts (7 points) Below you have a Sheet of the Sales Totals and Averaees for aim. 1) What is the cel. range nighlighted to draw this chart? 2) What is the type of this Chart? 3) Do you think the numbers of Phones Sold have a positive impact on Sales Totals? Why? 4) What does the R2 value on the curve tell you? 5) If you want to predict the Sales Totals if the number of Phones Sold was 150, what would you do? Question 5: Multiple Choice (5 points) 1) A is created by performing a set of steps and recording the steps as they are performed. a) Procedure b) Macro c) Table d) Function in C3 will be: a) =A2SAS1 b) =B1SAS2 c) =B35A51 d) =B2SAS1 3) ensures that users do not ehange values by mistake that are important to the worksheet. a) Cell Protection b) Formula Checker c) Range Finder d) Cell Validation 4) Cell SDS is an example of a cell reference that is: a) Row Absolute, Column Relative c) Row Absolute, Column Absolute b) Row Relative, Column Absolute d) Row Relative, Column Relative 5) are a visual filter used to make PivotCharts and PivotTables easier to understand. a) Markers b) Trendlines c) Slicers d) Charters (ov). The its of for end of the period and 2 for the beginining of the perion