Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how do i format each of these cells - In cell F4 write an Excel formula (use cell references whenever possible) which can be copied
how do i format each of these cells
- In cell F4 write an Excel formula (use cell references whenever possible) which can be copied down into cells F5:F9 that calculates the weighted score of Mary Keck's test values. The weights of each test are given in row 2. So her final weighted score will be a sum of each score multiplied by the weight of that score as follows: Verbal SAT score (680) * Verbal SAT score weight (20\%) + Math SAT score (670) * Math SAT score weight (40%)+ SCI SAT II score (580) * SCI SAT II score weight (40\%). This formula should be copied down the column to calculate the scores for the other applicants. - Write a formula in cell C10 that will calculate the average value of the entire applicant group's Verbal SAT scores. Copy the formula across to cells D10:F10 to calculate the average for each of the corresponding score categories. - Write a formula in cell C11 that will calculate the lowest score received by an applicant on the Verbal SATs. Copy the formula across to cells D11:F11 to determine the lowest score for the corresponding category. - Write a formula in cell C12 that will calculate the highest score received by an applicant on the Verbal SATs. Copy the formula across to cells D12:F12 to determine the highest score for the corresponding category. Summarize the information by application type (Regular, Transfer). Write a formula in cell C15 that will determine the number of students that are transfer students. Write the formula so that it may be copied down the column to determine the number of Regular applicants. - Write a formula in cell D15 to calculate the Average Verbal scores for each type (T/R) of student application. Write the formula so that it may be copied down the column and across the row into cells D15:F16 to calculate the average for regular student's Verbal SAT and then for each student category Math SAT etc Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started