You created a PivotTable to summarize commissions earned by employees in each department. What is the default summary statistic for the commissions field when you add it to the PivotTable?
A. Count
B. Min
C. Average
D. Sum
Answer: D. Sum
Learn More :
CGS
- The original mortgage loan was for $300,000 with a 5% APR for 30 years. You want to calculate the interest on the last monthly payment at the end of the 15th year. What value should be referenced for the per argument in the IPMT function? Hint: Number of payment periods in a year is 12.
- You workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out, Available if it is still readily available, or Limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out. What function would produce the same results as =OR(B1="Available", B1="Limited")?
- The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should you use to extract just 12?
- Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester. Which function should you use?
- When you are performing an advanced filter, where do you enter the rage for the dataset?
- A local police office wants to create a rule that if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or if that person has two or more speeding violations on record, the officer will fine the speeder the higher of $200 or $50 for each mile over the speed limit. Otherwise, the fine is $45. The speed limit is entered in cell B5, the person's speed is entered in cell B10, and the person's number of previous tickets is entered in cell B11. What function derives the correct answer?
- What function would you use to calculate the total (i.e., cumulative) interest paid for the first year of a mortgage?
- A worksheet contains the times in which runners completed a race, with the times organized from fastest to slowest. You will use the MATCH function to identify what place a runner came in given a time of 4:05 (four minutes and five seconds). Which argument should contain the specific runner's time?
- What function would you use to calculate the total number of periods in a loan or investment?
- A workbook contains a list of members in the Computer Club. You want to identify the number of students who are freshmen who are Information Systems majors. Without filtering the dataset, what function should you use?
- Calculates the number of periods for an investment or loan given a fixed rate, period payment, and present value.
- What is the function that returns the RELATIVE position of a value? Index, Match, HLOOKUP or VLOOKUP ?
- Why would you nest MATCH in an INDEX function?
- Which of the following is not an argument in a Database function?
- What's the purpose of an Excel What-if scenario?
- Why would you put a negative sign in many financial functions?
- T or F: The INDEX function results the position of a value.
- T or F: The arguments of an INDEX function are array, row_num, and column_num.
- T or F: Advanced filtering will not copy results to a new location.
- True or False: The RATE function returns periodic rate for an investment or loan.
- True or False: The MONTH function would return 25 when used on a cell containing August 25, 2018.
- True or False: You need the same number of logical tests as outcomes in a nested IF function.
- Where would you setup the two substitution values in a two-variable data table?
- What is a benefit of using a range name in Excel?
- Which tool is most effective when comparing the impact of various combinations of interest rates and down payments on a mortgage?
If the answers is incorrect or not given, you can answer the above question in the comment box. If the answers is incorrect or not given, you can answer the above question in the comment box.