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.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 4.5CP

See similar textbooks

Similar questions

6. Create a table-valued function named fnDateRange, similar to the stored procedure of exercise 3. The function requires two parameters of data type date. Don’t validate the parameters. Return a result set that includes the InvoiceNumber, InvoiceDate, InvoiceTotal, and Balance for each invoice for which the InvoiceDate is within the date range. Invoke the function from within a SELECT statement to return those invoices with InvoiceDate between October 10 and October 20, 2019.
a) List the names (Fame and Lame) and SSN of all male employees (Sex='M). b) List the last name and SSN of employees who work on project 'City Tower', sorted by alphabetical order of last na c) Retrieve the average salary of all female employees (Sex='F'). d) List department names and the number of employees who work for each department. Sort by department name. e) Retrieve the names of employees who make at least $10,000 more than thé employee who is pald the least in
Alternative Assignment 2 Task: Create a protected user account database.using PHP and SQL Detail: Create a protected user account database where is security identify a user is allow them to access to the system (Home page), based on the following requirements: You suppose to implement secure registration form using regular expression and proper validation, login page with username and password-based authenticated using the following mandatory: Must allow the creation, deletion of user accounts Must provide a demonstration application that grants user access when provide a valid username/password pair The passwords must be protected. No administrator who has access to the underlying file system should be able to see clear text passwords (cryptographic hashing). The password file itself should be protected from tampering Reject any attempts to provide invalid data. Each user account required a validation Password must be protected using cryptography hashing such as md5, sha1,…
Data structure (please read the following bolded words !!!!!!) Write the code in C++ and provide a link for CPP File Please don't send a picture of the code, send the code as a text !! Write the code in C++ not C !! Problem: Create an employee Record Management system using linked listthat can perform the following operations:• Insert employee record• Delete employee record• Update employee record• Show employee• Search employee• Update salary The employee record should contain the following items• Name of Employee• ID of Employee• First day of work• Phone number of the employee• Address of the employee• Work hours• Salary Approach:With the basic knowledge of operations on Linked Lists like insertion, deletion of elementsin the Linked list, the employee record management system can be created. Below are thefunctionalities explained that are to be implemented:Check Record: It is a utility function of creating a record it checks before insertionthat the Record Already Exist or not. It…
5. Create a scalar-valued function named fnUnpaidInvoiceID that returns the InvoiceID of the earliest invoice with an unpaid balance. Test the function in the following SELECT statement: SELECT VendorName, InvoiceNumber, InvoiceDueDate, InvoiceTotal - CreditTotal - PaymentTotal AS Balance FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID WHERE InvoiceID = dbo.fnUnpaidInvoiceID();
A corporation reimburses its employees in the managerial cadre and above for their mobile phone subscription costs. The information is captured in the record structure below. Employee Number is a three-digit numerical key that is designated as the primary key. type describes a pre-paid or post-paid class of mobile service subscription. The expenses incurred by the employee at the end of each month are referred to as subscription charges.Type of mobile number: employee number designation Subscription\schargesImplement the file asa) an array of records (block size = 1) for a sample set of records.b) an array of pointers to records (assume that each pointer to a record is a linkedlist of two nodes, each representing a record. In other words, each block is a linkedlist of two nodes (block size = 2)).
Create a list that shows each department name, # of employees, maximum salary, minimum salary, total salary, and standard deviation of the salaries. EMP Table: Field --------------------------------------- EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO DEPT Table: Field ------------------------------- -------- -------------------------------------------------------------------- DEPTNO DNAME LOC
Question 16 Rk.Assume you are provided a file: course_registrations.csv with fields semester, year, studentID, courseID What Spark code would you use to read in this file, remove records with the years before 2010 and then provide a count of total enrollment for each year? Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
The Excel file Store and Regional Sales Database provides sales data for computers andperipherals showing the store identification number, sales region, item number, itemdescription, unit price, units sold, and month when the sales were made during the fourthquarter of last year. Modify the spreadsheet to calculate the total sales revenue for each of theeight stores as well as each of the three sales regions
Question 2: implement get_athletes() function and return a list of athletes* Requirement: the information for an athlete should include name, country,* picture path and the game name (column name: gamename) that the athlete will attend.* Hint: Use selecte statement for inner join* Reference: Week 2*/function get_athletes() { //implement your codes here // return $athletes;} ?>
Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. Use an anonymous block to call the function and output the result.
Create a spreadsheet tracking five different expenses for three months (separatecolumns for each month). Use functions at the bottom of each column to find the totalcost, average cost, lowest cost, and highest cost for each month. Use a function at thebottom of each column to count the number of expenses over $60. Use a heading forthe spreadsheet and column headings. Use formatting appropriately to enhance thespreadsheet.

SEE MORE QUESTIONS

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS