You are the manager of a Best Buy and you would like to see how much profit you made from your store over the past three months. Below is a worksheet which shows the 'Total Sales' in October 2019, November 2019, and December 2019. A 1 2 October 2019 3 November 2019 4 December 2019 2019 TOTAL SALES 5 B DVD Sales 516 439 400 C CD Sales 355 750 751 1355 1856 D Record Sales 50 60 70 180 E TOTAL SALES Write a formula for cell E2 using the SUM function to calculate the TOTAL (DVD Sales, CD Sales, and Record Sales) for October 2019. When creating the formula, keep in mind that it will be copied to cells E3, E4, and E5 without modification. Now that you have written à formula for E2, write the formulas for E3, E4, and E5.

You are the manager of a Best Buy and you would like to see how much profit you made from your store over the past three months. Below is a worksheet which shows the 'Total Sales' in October 2019, November 2019, and December 2019. A 1 2 October 2019 3 November 2019 4 December 2019 2019 TOTAL SALES 5 B DVD Sales 516 439 400 C CD Sales 355 750 751 1355 1856 D Record Sales 50 60 70 180 E TOTAL SALES Write a formula for cell E2 using the SUM function to calculate the TOTAL (DVD Sales, CD Sales, and Record Sales) for October 2019. When creating the formula, keep in mind that it will be copied to cells E3, E4, and E5 without modification. Now that you have written à formula for E2, write the formulas for E3, E4, and E5.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 2.9CP

See similar textbooks

Similar questions

Product_id Product_name Category Mfg_date Exp_Dte Product_price 01 Dairy Milk Choclate Junk 2,Aug, 2019 2aug, 2020 80 02 Lipton Tea Bags Not junk 2,jan 2019 2, jan 2020 160 03 Kurkure junk 2, april 2919 2, april, 2021 30 04 Shezan Juice Junk 3,Aug, 2019 3,aug, 2020 30 06 Olpers Milk Not junk 3,april, 2018 3,april, 2020 350 Canteen_table 1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”. Change colum name of product_price to unit_price. Display products manufactured between 1, jan 2019 to 1, May 2019. Display count of only junk food items in canteen_table with alias name as “junk Food Count”. Display Count Of both Junk food and not junk food products whose count is greater then 1.
Please see the attached and assist with below question. Using the “Aggregates” worksheet, complete all formulas.
- The HR department needs a report to display employee information as shown from the job_history table. The months worked is the number of months from the start date to the end date. Only list those employees whose months worked is an even number. Order by months worked descending
Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component. Make each entry match the values shown in the following table. TABLE P8.53 UPDATES FOR THE DETAILRENTAL TABLE RENT_NUM VID_NUM DETAIL_RETURNDATE 1001 34342 02-MAR-18 10:00am 1001 61353 03-MAR-18 11:30am 1002 59237 04-MAR-18 03:30pm 1003 54325 09-MAR-18 04:00pm 1003 61369 09-MAR-18 04:00pm 1003 61388 09-MAR-18 04:00pm 1004 44392 07-MAR-18 09:00am 1004 34367 07-MAR-18 09:00am 1004 34341 07-MAR-18 09:00am 1005 34342 05-MAR-18 12:30pm 1005 44397 05-MAR-18 12:30pm 1006 34366 04-MAR-18 10:15pm 1006 61367 1007 34368 1008 34369 05-MAR-18 09:30pm 1009 54324 1001 34366 02-MAR-18 10:00am
List all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading Item Total in the output.
To set up a Pivot Table with years listed horizontally as shown above, the Year field should be dragged into the following Pivot Area: Group of answer choices COLUMNS ROWS VALUES FILTERS
Count the number of different professors names.
Q9) find the least expensive priceQ10) List the UNIQUE v_code of vendors that provide productsQ11) find the most expensive priceQ12) List the number of products by vendor with the average price, include only the rows withaverage price below 10.00Q13) List all vendor rows (including the ones that have no matching products) and all matchingproduct rows
Q2) how many vendors provide productQ3) how many products each vendor providesQ4) ?How many vendors (unique vendors) have products with price < 10Q5) increase the product price 10% if the orginal price is leass than 50
1. Use the following table to answer the questions below: Table name: Products Column Data Type Length Constraint Role Name Stores the ID of a product P ID P_Name Primary key Number Stores the name of a Varchar2 25 product P_entryDate Stores the entry date of a product Date Cannot be null P_Expiry Stores the expiry date of a product Date P_Еxpiry date should be greater than P_entryDate P_Price Stores the price of a product Number 3,2 Cannot be null a. Write a SQL query that displays the mumber of products that will expire in the year 2021 b. Write in SQL a query that displays the ids of the most expensive products c. Create a view named ProductDetails' to hold all the details of products whose names start with 'DELL' and their prices are between 200 and 500 Omani Rials
Q6) how much is the total customer balance ? Q7) what is the minimum price for each sale code? Q8) List the product description, price, vendor code, name, contact, area code and phone foreach product Ordered by P_PRICE
Table name: Products Column Role Data Type Length Constraint Name P ID Stores the ID of a product Number 8. Primary key P Name Stores the name of a product Varchar2 25 P_entryDate Stores the entry date of a product Stores the expiry date of a product Date Cannot be null P_Expiry P Expiry date should be greater than P entryDate Date P Price Stores the price of a product Number 3,2 Cannot be null a) Write in SQL a command that creates the table Products according to the above description (2 marks). b) Write in SQL a statement that adds to the table Products a new column named supplierID of type Number(5). This column should be defined as a foreign key that relates the table Products to the table Supplier (1.5 marks). c) Write in SQL a query that lists all the details of products arranged in descending order according to the entry date (1.5 marks).