Its for excel experts. Do as directeda) Open an excel workbook and maintain record of an online company.b) Create the following fields:Customer IDNameContact NoShipping CityOrder IDPriceDelivery ChargesDiscountTotal BillCouponsc) Enter 05 records.d) Create a function for calculation of delivery charges as per following criteria:Shipping CityRawalpindiLahoreCharges275400KarachiOthers600500e) Create a function for field "Discount" such that if the "Price" is >3000 rupees and"Delivery Charges" exceeds 200 rupees, 25% discount will be applicable to total cost.f) Create a function for field "Total Bill" as follow:Total bill= (Delivery Charges + Price) - Discountg) Create a function for field "Coupon" and display "Yes" for customers who either have"Total bill" > 5000 or “Discount" = 0.

Creating Your initial program Every stand out player must begin somewhere. during this chapter,…

Do as directed a) Open an excel workbook and maintain record of an online company. b) Create the following fields: Customer ID Name Contact No Shipping City Order ID Price Delivery Charges Discount Total Bill Coupons c) Enter 05 records. d) Create a function for calculation of delivery charges as per following criteria: Shipping City Rawalpindi Lahore Karachi Others Charges 275 400 600 500 e) Create a function for field "Discount" such that if the "Price" is >3000 rupees and "Delivery Charges" exceeds 200 rupees, 25% discount will be applicable to total cost. f) Create a function for field "Total Bill" as follow: Total bill= (Delivery Charges + Price) - Discount g) Create a function for field "Coupon" and display "Yes" for customers who either have "Total bill" > 5000 or "Discount" = 0.

Do as directed a) Open an excel workbook and maintain record of an online company. b) Create the following fields: Customer ID Name Contact No Shipping City Order ID Price Delivery Charges Discount Total Bill Coupons c) Enter 05 records. d) Create a function for calculation of delivery charges as per following criteria: Shipping City Rawalpindi Lahore Karachi Others Charges 275 400 600 500 e) Create a function for field "Discount" such that if the "Price" is >3000 rupees and "Delivery Charges" exceeds 200 rupees, 25% discount will be applicable to total cost. f) Create a function for field "Total Bill" as follow: Total bill= (Delivery Charges + Price) - Discount g) Create a function for field "Coupon" and display "Yes" for customers who either have "Total bill" > 5000 or "Discount" = 0.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Choose which tab in Excel these belongs. Page Home Insert Draw Formulas Data Review View Layout Draw with Touch Queries Scatter Print Area Merge & Center Clear Workbook Statistics Freeze Panes Pie Show Formulas
Write a SQL statement that will add the below row to the Task table.TaskID Description Duration StartDate TeamMemberID4 Implementemailnotifications2
questionnn
17 Correct and detailed answer will be Upvoted else downvoted. Thank you!
® Check totalCost's value Expected: 26 Your value: zero
In Excel, what does it mean if a cell is filled with hashtags?
What filter will you use in Excel if you want to execute more than two criteria at the same time?
Please write by hand. Not in excell please. NOT IN EXCELL PLEASE
Which of the following chart types is used for comparisons among items or comparisons over time? Column Combo Line Pie
What would be missing line of code
Question in below picture
Option+Explanation