Coquitlam College Calculating the Tax Paid and Total for Cameras Excel Worksheets
Help me study for my Computer Science class. I’m stuck and don’t understand.
Create 2 Excel worksheets inside same workbook( Name it 5A) for attached pictures.
Add the data from text file(data.txt) .You must use Data import feature of Excel .
(How to import data in excel?? – Watch this video — https://www.youtube.com/watch?time_continue=107&v=V6AR_Hi7p5Q&feature=emb_logo)
Data file is attached as text file. Adjust the formula for the column Total so that it shows the multiplication of the price and the quantity. Try to emulate the colors and layout of the spreadsheet.
Please convert it to range( not table) before making any changes .
1) Complete relative reference first
2) Complete absolute reference. (using same data. Please copy the sheet and rename it)