Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
- 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions