Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cover sheet Instructions Data Call ID 14255 75852 65213 58621 23652 96325 85612 36542 85621 Date 12/6/21 12/6/21 12/7/21 12/7/21 12/8/21 12/8/21 12/9/21 Type of

image text in transcribed
image text in transcribed
Cover sheet Instructions Data Call ID 14255 75852 65213 58621 23652 96325 85612 36542 85621 Date 12/6/21 12/6/21 12/7/21 12/7/21 12/8/21 12/8/21 12/9/21 Type of Call Customer Complaint Delivery enquiry Website problem Payment enquiry Payment enquiry Customer Complaint Customer Complaint Description Sent wrong size Wanted to know expected delivery date Can't choose the size on website Payment blocked Money not taken from account Goods damaged Sent wrong colour Action Taken New order despatched - emailed returns label None needed Details sent to website team Details sent to accounts team Details sent to accounts team New order despatched - emailed returns label New order despatched . emailed returns label Cover sheet Instructions Data COMP 1021 - Business Computer Applications Excel Assignment #1 Please remember to save your workbook as: COMP1021_Firstname_Lastname(studentNumber)A1. Instructions: 1. Add the following details in the appropriate columns on row 9. Use the drop-downs in columns C and E. 12/15/21 Payment enquiry Late interest penalty Late interest reversed 2. Add the following details in the appropriate columns on row 10. Use the drop-downs in columns C and E. 12/15/21 Customer Complaint Defective materials Refund monies to customer's account 3. Edit the description in cell D7 to the following and adjust the width of the column D so that the new description shows. Description Goods damaged - has already sent for repair and waiting to hear back on the timing 4. Change the date in cell B8 to 2021-12-20 and then copy and paste the new date to cells B9 and B10. You can try the short-cut keys CTRL + C to copy and CTRL + V to paste

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Oracle9i Database Administration

Authors: Sam R. Alapati

1st Edition

1590590228, 978-1590590225

More Books

Students also viewed these Databases questions