Loading
Get Excel Tutorial: Basic Formula Writing, Round Function, And Vlookup Function
How it works
-
Open form follow the instructions
-
Easily sign the form with your finger
-
Send filled & signed form or save
How to fill out the Excel tutorial: Basic formula writing, ROUND function, and VLOOKUP function online
This guide provides a comprehensive step-by-step approach to completing the Excel tutorial focused on basic formula writing, the ROUND function, and VLOOKUP function. Designed for users of all experience levels, this guide aims to support your understanding and application of essential Excel functions.
Follow the steps to accurately complete the Excel tutorial.
- Press the ‘Get Form’ button to access the form and open it within your chosen editor.
- Rename the SonnyCoffeeShop worksheet to incorporate your username, ensuring that the document reflects your personalized identity.
- Enter the data for the coffee purchases in the specified cells, such as the quantity of coffee and the original price per pound. Ensure you include the discount specified in cell E5.
- Use the formula `=E5*D7` in cell E7 to calculate the discount amount for the first coffee. Remember to utilize the cell reference E5 for accurate calculations.
- Apply the ROUND function to the discount formula. Edit the formula in cell E7 to `=ROUND(E5*D7, 2)` to ensure it reflects up to two decimal places.
- Calculate the sale price of the coffee in cell F7 by subtracting the discount from the original price with the formula `=D7-E7`.
- In cell G7, determine the total price for the quantity purchased using the formula `=C7*F7`.
- Use the handle in cell G7 to drag the formulas down, ensuring that calculations apply to additional rows as needed.
- For each coffee purchase, ensure that the total price is also rounded to the nearest penny if required.
- Lastly, save the changes made to the form, and utilize options to download, print, or share the completed tutorial as needed.
Begin completing your Excel tutorial online to enhance your formula-writing skills today!
Round a number up by using the ROUNDUP function. It works just the same as ROUND, except that it always rounds a number up. For example, if you want to round 3.2 up to zero decimal places: =ROUNDUP(3.2,0) which equals 4.
Industry-leading security and compliance
US Legal Forms protects your data by complying with industry-specific security standards.
-
In businnes since 199725+ years providing professional legal documents.
-
Accredited businessGuarantees that a business meets BBB accreditation standards in the US and Canada.
-
Secured by BraintreeValidated Level 1 PCI DSS compliant payment gateway that accepts most major credit and debit card brands from across the globe.