Calculate sales tax in cell e36 by multiplying the tax rate

Assignment Help Computer Network Security
Reference no: EM131067059

Project Description:

For this project, you will update a workbook. You will format grouped worksheets, set up validation rules, and create functions. Additionally, you will import a text file and XML data and manipulate the imported text. Finally, you will modify the document properties, insert comments, and mart the workbook as final.

Instructions

1. Open wake-final-Exam1.xlsx and save the workbook as Wake_LastName_FirstName.xlsx (Substituting your first and last name.)Make sure the Invoice sheet is active.

2. Unlock the following cells: E4, B14:E33, E35, E37

3. In cell E4 put in the date: 6/1/2018
Then put in the following:

B14: Insulation in walls and attic
D14: T
E14: 935.25

B15: Labor for
installationE15: 210

B16: Mud for wall texture
D16: T
E16: 57.84

4. Fix the subtotal in cell E34 to calculate sum the above cells (E14:E33)Set the tax
rate to 6.5% in cell E35

Calculate the sales tax in cell E36 by multiplying the tax rate by all items that are taxed. (Use a SUMIF to find all ‘T' items and sum the "Amount" column.)

Have the total amount show up in cell D2 (Make a cell reference to the total.)
Protect the worksheet so locked cells cannot be modified (Set the password to: Wak3Invoice), and make sure that
"Select locked cells" and "Select unlocked cells" is checked.

<hint> Please make sure you put in a ‘3' for the password.

5. Group the following worksheets (Qtr1, Qtr2, Qtr3, Qtr4).
Fill the contents AND formats for cell A1 across the worksheets.

While still grouped, AutoSum the Dept. Totals AND the Monthly Totals at the same time.

Lastly, fill the formatting from A2:E8 across the worksheets and auto adjust the column A width.

6. Ungroup the worksheets and on the Qtr1 worksheet only, and add the following data validations:

B3: D3
- Values need to be a decimal value less than or equal to 300,000

Add a Stop Error AlertTitle: Value Error

Error message: The value you entered was too high. Please check the value and re-enter. If you feel this value is correct, please contact your supervisor.

B6:D6 - Values need to be a whole number between 0 and 200,000Add an Input Message
Title: Enter Value
Input message: Please enter a value that is between 0 and 200,000. (Include the period)
Add a Warning
Error AlertTitle: Invalid Enter
Input message: The value you entered was too high. Are you sure the value is correct?

7. Change the value in cell D6 to 255,235. Accept the value as a correct entry.
Check to see if the values entered are correct. To do this, circle the invalid data.

8. In the Yearly Totals worksheet, create a 3D formula to calculate the totals for the yearChange the formatting to A
ccounting with 0 decimal places.

9. On the Stock Investments worksheet, pull in the current stock prices from finance.google.com.On the right side of the page, you will find the World markets section. Select that data to be imported into the worksheet.

Make sure you place it in the Stock Investments worksheet in cell A2.

10. Modify the connection you just made with the Connection name World_Markets.
Next make the connection update every 2 minutes and when the file opens.

Set the description to: World markets on finance.google.com

11. Download the Names.txt so import all of the customer names.
Import the text file.

Make sure you select that your data has headers, and that you want to start importing at row 2.

Select that you want to separate the data based on the
"Tab" AND "Space" delimitersPlace the data in cell B2 of the existing worksheet.

12. Use the CONCATENATE function to combine the first and last name with a space in-between.(Auto size the column to fit the largest name)

Use the flash fill to show ONLY the first initials for the first and last name.

13. In the properties, add the following:Title: Wake Workbooks
Tags: Invoice, Quarterly Totals, Investments
Add another author: Student

14. Save the workbook

15. Submit it to MyItLab

Reference no: EM131067059

Questions Cloud

Preceding summary for a plot : A cleric, who is also pursuing the carpenter's wife, climbs up to her window to woo her, the boarder farts in the cleric's face, and then the cleric burns the boarder's bottom with a red hot poker. Which of "The Canterbury Tales" has the preceding..
Anonymous middle english lyric poems begins : One of the most well known of the many anonymous Middle English lyric poems begins, "Sumer is icumen in" (or "Summer/Spring is a-coming in") and eventually remarks how the "bucke ferteth" (or the "buck farts").
How much of each ingredient will she need : how much of each ingredient will she need?
Name of the fourteenth-century welsh poet : What is the name of the fourteenth-century Welsh poet who wrote such passionate love poems as "Aubade", which, according to one translation, begins, "'O passing night, have pity', I said; / 'She is most lovely who shares my bed'. / But the brief n..
Calculate sales tax in cell e36 by multiplying the tax rate : On the Stock Investments worksheet, pull in the current stock prices from finance.google.com.On the right side of the page, you will find the World markets section. Select that data to be imported into the worksheet. Make sure you place it in the ..
Explain why the privatized social-services system : What purposes of control was Indiana's privatized social-services system created in the first place - how did the approach of IBM and ACS to bureaucratic control contribute to the col-lapse of the privatized system?
Life of arthur father uther pendragon : Who was the Welsh cleric who lived from ca. 1100 to 1155 and wrote "The Prophecies of Merlin", the poetic "Life of Merlin", and the "History of the Kings of Britain", which contains the earliest full account of King Arthur's life as well as some o..
Focus on disputes and issues that arise from areas of law : Assignment 3 then should focus on disputes and issues that arise from areas of law that are covered in this unit such cases that arise from laws such as tort, contract, consumer protection, business structures, company, property, intellectual prop..
Journalize the adjusting entry for uncollectible accounts : Refer to the Chart of Accounts for exact wording of account titles.

Reviews

Write a Review

Computer Network Security Questions & Answers

  An overview of wireless lan security - term paper

Computer Science or Information Technology deals with Wireless LAN Security. Wireless LAN Security is gaining importance in the recent times. This report talks about how vulnerable are wireless LAN networks without any security measures and also talk..

  Computer networks and security against hackers

This case study about a company named Magna International, a Canada based global supplier of automotive components, modules and systems. Along with the company analysis have been made in this assignment.

  New attack models

The Internet evolution is and is very fast and the Internet exposes the connected computers to attacks and the subsequent losses are in rise.

  Islamic Calligraphy

Islamic calligraphy or Arabic calligraphy is a primary form of art for Islamic visual expression and creativity.

  A comprehensive study about web-based email implementation

Conduct a comprehensive study about web-based email implementation in gmail. Optionally, you may use sniffer like wireshark or your choice to analyze the communication traffic.

  Retention policy and litigation hold notices

The purpose of this project is to provide you with an opportunity to create a document retention policy. You will also learn how to serve a litigation hold notice for an educational institute.

  Tools to enhance password protection

A report on Tools to enhance Password Protection.

  Analyse security procedures

Analyse security procedures

  Write a report on denial of service

Write a report on DENIAL OF SERVICE (DoS).

  Phising email

Phising email It is multipart, what are the two parts? The HTML part, is it inviting the recepient to click somewhere? What is the email proporting to do when the link is clicked?

  Express the shannon-hartley capacity theorem

Express the Shannon-Hartley capacity theorem in terms of where is the Energy/bit and is the psd of white noise.

  Modern symmetric encryption schemes

Pseudo-random generators, pseudo-random functions and pseudo-random permutations

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd