4 posts shown.
Thank you so much!!!!!!👍 It turns out I’ve been doing everything completely wrong from the very beginning because I totally misinterpreted the assignment—specifically regarding how to set the prices—so naturally, I couldn't get the sales tax to balance properly either... now I am going to dive deep into the tax codes and spend a little more quality time mastering Microsoft Excel.. thank you ever so much! 🙂
I am truly grateful for all the helpful responses and the effort you have put in 🙂
. Unfortunately, I am still feeling a bit stumped regarding how to integrate a sales tax column into my price list when I am pulling data from several different retailers—I simply cannot seem to figure out how to calculate the sales tax for every single one of those prices within a single column. To make things easier, I am going to provide the entire, complete assignment right here (though I have already managed to tackle the loan portion, so thank you ever so much for that!), and if anyone feels inclined to solve the whole thing, I would be incredibly thankful! Furthermore, if you could kindly explain exactly how to utilize those absolute cell references, it would be a lifesaver. Here is the prompt:
Search online for prices from three different US retailers for a Dell laptop (any model)
On the first worksheet, create a table featuring these prices from the various retailers; use the retailer names for the rows, and use columns for the cash price and the warranty price;
In the final row, calculate the average price across all the retailers
Format the table however you like, making sure to use colors, fonts, and borders
Create a chart that illustrates the price comparison between the different retailers
Add a column to the table that calculates the sales tax on the prices (set at 23%) by using a cell with an absolute reference for the tax rate
Using the Conditional Formatting tool, set it so that any amounts less than $1667 are displayed with a bold font on a yellow background
On a second worksheet titled "Loan," calculate the monthly payment for a loan amount of $6667 over 2 years at an annual interest rate of 5%
I believe I understand everything except for that sales tax part, where to place it, how to handle absolute cells, and that specific task involving USD from a previous assignment=(
I have already visited that link, but I must admit I am still feeling quite lost, as I haven't quite managed to uncover any actual solutions for the issues mentioned above 😢. Thank you all regardless... however, if anyone could possibly lend me a hand, I would be immensely grateful, as this has become rather urgent and I am simply struggling to find the right guidance online
.
I would love to jump in and add my thoughts to this discussion here!😁
So, I find myself in need of a little bit of guidance regarding Microsoft Excel for the following tasks:
-Please display the total price for each item converted into USD, ensuring that you use a cell containing an absolute reference for the exchange rate calculation.
-Add a new column to the table that calculates the sales tax on the prices (set at 23%), making sure to use a cell with an absolute reference for the tax rate.
-On a separate worksheet titled "Loan," please calculate the monthly installment for a loan amount of $6667 over a period of 2 years with an annual interest rate of 5%.
This is actually for one of my college courses, and while I am certain these are likely the most elementary functions imaginable, I must admit I am feeling quite lost on how to actually execute them! I currently have a spreadsheet filled with various computer prices, and now I am tasked with completing everything listed above. If anyone could kindly walk me through this process step-by-step, I would be immensely grateful, as I am a complete novice when it comes to Microsoft Excel... thank you all so very much in advance! 🙂
Oh, and one more quick thing—could someone explain how one goes about renaming a worksheet?