In cell F7, create a formula that calculates the salary for Joan Dickinson. Her salary is calculated by adding her base salary (cell B7) to her total bonus (cell E7). (Hint: Do not use the SUM function.) To calculate the salary for all of the employees, copy the formula you created and the formatting in cell F7 into the range F8:F10. Kelly wants to view employees’ bonuses as a percentage of their base salary. In cell G7, enter a formula without using a function that divides Joan’s total bonus (cell E7) by her base salary (cell B7)

In cell F7, create a formula that calculates the salary for Joan Dickinson. Her salary is calculated by adding her base salary (cell B7) to her total bonus (cell E7). (Hint: Do not use the SUM function.) To calculate the salary for all of the employees, copy the formula you created and the formatting in cell F7 into the range F8:F10. Kelly wants to view employees’ bonuses as a percentage of their base salary. In cell G7, enter a formula without using a function that divides Joan’s total bonus (cell E7) by her base salary (cell B7)

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 2.11CP

See similar textbooks

Similar questions

Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.
All employees with one or more years of service are eligible for a bonus. Pay Grade 1 employees receive $3,000 (cell U2), Pay Grade 2 employees receive $6,000 (cell U3), and Pay Grade 3 employees receive $8,000 (cell U4). In the Bonus column, use the IFS function to calculate the bonus. For employees in pay grades over 3, there is no bonus. (HINT: the AND function is used in the logical test within the IFS function because you have to test if the years of service >=1 AND each specific pay grade)
Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a subject. The stored procedure takes in 2 parameters, percentDiscount (DECIMAL(8,2)) and subject (VARCHAR(120)). Using these parameters, the stored procedure computes the discount for the book cost and stores it in the FINAL_PRICE field. For example, the following stored procedure call: call sp_apply_discount(0.15, 'Database');would compute 15% percent discount from the book cost in the Database subject category and store it in the FINAL_PRICE column as depicted in this image:
In cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using ProposedProjects[Project Type] as the range and cell I2 as the criteria. Fill the range J3:J5 with the formula in cell J2. In cell K2, enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the sum_range. Fill the range K3:K5 with the formula in cell K2. In cell L2, enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the average_range. Fill the range L3:L5 with the formula in cell L2.
Lael is constantly looking for students who are interested in running for office in student organisations. In cell M2, insert the following formula, which uses a nested IF function and structural references to assess if a student has already been elected to office in a student group, and if not, whether that student fits the conditions to run in the future: If the Elected column value equals the string "Yes," the formula should display Elected as the text. Otherwise, the formula should check if the value in the Finance Certified column is equal to the word "Yes" and return the text Yes if it is and No if it is not. What is the formula that should be entered into Excel?
In cell G10, insert a formula using the PMT function using the monthly interest rate (cell G6), the loan period in months (cell G8), and the loan amount (cell G4) to calculate the monthly payment for the 10 Years scenario.
The population of the five most populous Australian cities at the last three census is recorded in the following cell. Piot a side- by-side bar chart to show the change in the populations, The chart should be grouped by each city and show each census in different colours. The legend should explain the colours for the census. Your plot should include an appropriate title. In [ J: cities - ['sydney', Melbourne', 'Brisbane', Perth', 'Adelaide') Pop_2016 - (4321535,4196198,2054614,1874578,11656321 Pop_2011 - [3908642,3707530,1874427,1627576,11039791 Pop_2006 - [3641422,3371888,1676389,1256035,10407191 In [ ]:
The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…
Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise.
You are given a list of courses that are currently available in Oxford College that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate or masters students. Write a python program that creates a dictionary from the above list where the keys will be each department name (CSE,EEE,MAT for the above example) and their values will be a dictionary of two keys - Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively. Sample Input - No need to take input ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510'] Sample Output: (You just have to print the resultant dictionary. No need to follow the pattern below) { 'CSE':{ 'Undergraduate':['CSE110','CSE111'], 'Graduate':['CSE520','CSE650'] },…
Split the MR_X and MR_y into training set and test set. You should use the num training variable to extract the data from MR_X and MR_y. Extract the first 'num_training' samples as training data, and extract the rest as test data. Name them as: MR_train_X and MR_train_y for the training set MR_test_X and MR_test_y for the test set
This dataset “Birthweight_reduced_kg_R" contains information on new born babies and their parents. In the following a description of each variable is given: Name Variable Baby number Length of baby (cm) Weight of baby (kg) headcirumference Head Circumference ID length Birthweight Gestation Gestation (weeks) smoker Mother smokes 1 = smoker 0 = non-smoker motherage Maternal age Number of cigarettes smoked per day by mother mnocig Mothers height (cm) Mothers pre-pregnancy weight (kg) Father's age mheight mppwt fage Father's years in education Number of cigarettes smoked per day by father fedyrs fnocig Father's height (kg) Low birth weight, 0 = No and 1 = yes Mother over 35, 0 = No and 1 = yes fheight lowbwt mage35 Task 1: Load the csv file into Python environment and get the required columns to be used as x and y. Task 2: Use correlation coefficient to find and discuss the following: 1. Relationship between maternal height and baby length. 2. Relationship between mother's pre-pregnancy…