subject
Computers and Technology, 18.03.2021 01:40 kat1191

Format spreadsheets effectively, and use the spreadsheets to analyze data. Be sure to hand in any spreadsheets, graphs, and calculations along with your responses to your teacher. 1. Read the following data regarding payroll deductions, and answer the questions that follow:
Lydia: $9.50/hour, worked 20 hours this pay period
Thomas: $12.50/hour, worked 40 hours this pay period
Bruce: $8.50/hour, worked 30 hours this pay period
a) Using a spreadsheet program, create a payroll spreadsheet with the information above. Be sure to include proper headings. (2 points)

b) Add a "Tax (%)" column. Apply a nested IF statement to the spreadsheet to determine the percentage of taxes that needs to be deducted. For someone who make $9.00 or less an hour, the rate is 5%. For someone who makes between $9.01 and $12.00 an hour, the rate is 6%. For someone who makes more than $12.01 an hour, the rate is 7%. (3 points)

c) Describe how you generated this column. (1 point)

2. Read the following data from Maria's personal monthly bank statement and answer the questions that follow:
Rent: $850
Groceries: $276.89
Public transportation: $45
Utilities: $135.24
Entertainment: $150.26
a) Enter Maria's data into a spreadsheet using a spreadsheet program. Be sure to include proper headings (2 points).

b) Maria would like an efficient way to analyze how she spent her money this month. Using the spreadsheet program, create a bar graph representation of her monthly expenses. Briefly describe how you create the bar graph (3 points).

c) Based on the bar graph representation, what is one thing you would recommend to Maria in the future? (1 point)

3. Read the following data from Wesley Publishing and answer the questions that follow:
Author: Henry Stratford; Author ID: 8945; Book sales: $2,862.26
Author: Carrie Berkshaw; Author ID: 4903; Book sales: $56,234.48
Author: Russel Owens; Author ID: 8321; Book sales: $9,245.67
Author: Finius Menken; Author ID: 7564; Book sales: $27,356.11
a) Enter Wesley Publishing's author revenue data into a profit-and-loss spreadsheet. Be sure to include proper headings. (1 point)

b) Now sort the authors by their ID number in descending order. (1 point)

c) Wesley Publishing earns 10% of each author's book sales. In order to efficiently calculate the company's profit, add a "Percentage" column and lock the cells so that it's standard for each entry. Briefly describe how you locked the cells. (2 points)

d) Add three more rows above row 1 and set up a lookup table to find the book sales total by searching the Author ID. Use Author ID 8321. Include the formula. (2 points)

e) Wesley Publishing has an office in England that would like the American office to share their data on profits. What steps should the American office take in order to determine the profits in pounds for the England office? (2 points)

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 17:40, pnhandley01
Consider the simple 3-station assembly line illustrated below, where the 2 machines at station 1 are parallel, i. e., the product only needs to go through one of the 2 machines before proceeding to station 2.what is the throughput time of this process?
Answers: 2
image
Computers and Technology, 23.06.2019 06:20, kiarakagni
What is a point-in-time measurement of system performance?
Answers: 3
image
Computers and Technology, 23.06.2019 15:30, jokerr6323
1. ask the user how many questions are in the quiz. 2. ask the user to enter the key (that is, the correct answers). there should be one answer for each question in the quiz, and each answer should be an integer. e. g., 34 7 13 100 81 3 9 10 321 12 might be the key for a 10-question quiz. you will need to store the key in an array. 3. ask the user to enter the answers for the quiz to be graded. there needs to be one answer for each question. note that these answers do not need to be stored; each answer can simply be compared to the key as it is entered. 4. when the user has entered all of the answers to be graded, print the number correct and the percent correct. 5. add a loop so that the user can grade any number of quizzes with a single key. after the results have been printed for each quiz, ask "grade another quiz? (y/n)." note: you only have one array (the key). you are not creating a new key for each set of quiz answers.
Answers: 3
image
Computers and Technology, 23.06.2019 18:00, taiyana74
Ramona enjoys her job because she is able to kids in an after school program. the work value ramona feels strongest about is a. leadership b. risk c. independence d. work with people select the best answer from the choices provided a b c d
Answers: 1
You know the right answer?
Format spreadsheets effectively, and use the spreadsheets to analyze data. Be sure to hand in any sp...

Questions in other subjects:

Konu
English, 07.04.2021 08:10
Konu
Mathematics, 07.04.2021 08:10