Question: these are sub questions you giys already solved first 4 (5) [0.5 marks ] Compute the TotalPrice ( column I) = Quantity (column F) *

these are sub questions you giys already solved first 4

(5) [0.5 marks ] Compute the TotalPrice ( column I) = Quantity (column F) * (Transport Cost (B27) + UnitPrice (column G) + VAT (column H)) (6) [0.25 marks] Change Number Format of QrderDate (column A) to Short Date. Format UnitPrice (G) and TotalPrice (I) to AED Currency format with 1 decimal place. (7) [0.25 marks] Compute Avg Cost (cell B28) based on TotalPrice (column I). Find the Max Qty (cell B29) based on the maximum value of Quantity (column F). (8) [0.5 marks] Rename Sales-Section sheet by changing Section to your IT Section. Change Your Name in cell B30 to your name and add your ID as a comment to cell B30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

intro to lab excel (1) [0.5 marks] Determine the City (column C) based on Region (column B) using the IF condition IF Region is equal to "West", then City is "Abu Dhabj", Otherwise City is "Dubai"....

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

To be solved by DKetan. Using Chapter 7 of your text as a reference, define a standard cost and explain what constitutes the components of a standard cost. Describe the advantages and disadvantages...

now//You are asked to price some options on KYC stock. KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent,...

Divvy Bikes Background Information: Divvy is a bicycle sharing system in the City of Chicago and two adjacent suburbs that is operated by Motivate for the City of Chicago Department of...

Task06 Answer ALL the parts with complete solutions Consider a two-period small open endowment economy populated by a large number of households with preferences described by the lifetime utility...

October 9, 20- The first payroll in October covered the two workweeks that ended or September 26 and October 3. This payroll transaction has been entered for you in the payroll register, the...

Thank u guys:) This is the reference pages but the questions are the last 3 pictures . . . . Craft - Mason Wage rate VET $29.00 Hours worked 50 hours per week for 20 weeks and 40 hours per week for...

2.1 THE GENERATORS' PRIMARY RESPONSIBILITIES It is solely the generator's responsibility to determine if it generates or manages solid waste, and it is solely the generator's responsibility to...

Utilizing the text book,pages 264-278. In paragraph (1) Identify one country that has a current and excessive Trade Surplus. Identify the products that are responsible for the Trade Surplus, you may...

The City of Columbia is trying to attract a new manufacturing business to the area. It has offered to install and operate a water pumping plant to provide service to the proposed plant site. This...

State the biological importance of photosynthesis.

if a US recession occurred without any change in interest rates identify the part of the MNC valuation equation that would most likely be affected the domestic cash flow would likely be blank as a...

Find an example of hyperbole associated with Beowulf's sword. Highlight evidence in the text and use the annotation tool to explain how the passages you've chosen propel the plot forward.

What are negative messages? (Objective 1)

Welcome. You are the president of the Tri-City Industrial Foundation.You have been successful in getting Little Toy Machines, a toy manufacturer, to relocate to your community. This factory will...

What are two important advantages of using the indirect plan for bad news messages? (Objectives 2 and 3)