answersLogoWhite

0

=SUM(A1:A12)*.065 [assumes A1:A12 contains the purchased items and the tax rate is 6.5%]

User Avatar

Wiki User

15y ago

What else can I help you with?

Continue Learning about Math & Arithmetic

In Microsoft Excel how do you use a formula to calculate the percentage of use of a set of symbols?

In A1, put the total number of symbols.In B1, put the number of symbols used.In C1, enter the formula =A1/B1Format C1 for percent and observe the answer.


How do you Compute for the linear meter of the fence?

To compute the linear meter of a fence, measure the total length of the area you want to enclose. This involves adding together the lengths of all the sides of the fence. If the area is rectangular, use the formula: linear meters = 2 × (length + width). For irregular shapes, sum the lengths of each side individually to get the total linear meters required.


What was Erin's average speed for the entire trip?

To calculate Erin's average speed for the entire trip, you'll need the total distance traveled and the total time taken. The average speed can be found using the formula: average speed = total distance / total time. If you provide the specific distance and time values, I can help you compute the average speed.


How do you work out the percentage out of a group of numbers in excel?

Assuming you want the percentage of the total, and that the numbers are organized in a column: you first calculate the total at the bottom of a column of numbers. Then, in the next column, you put a formula that divides the number by the total. (It helps to press F4 for the total - that way, its cell reference won't change when you copy the formula down.) Then you select the range and give it a percentage format. This will automatically multiply it by 100 for display purposes; for this reason, I didn't include the "*100" in the formula.


How do cashiers use math?

Cashiers have to make checks, count money, pay bills by cash, calculate the total of the payments, weigh items, and compute and record the total transactions.

Related Questions

What happens when you change a number within a sum formula in Microsoft Excel?

It can change a total that the formula results in.


Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.


What is the formula to find a GPA in Microsoft Excel?

Put total hours taken in cell A1.Put the total of all grade points in B1.Enter the following formula in C1: =B1/A1.Format C1 to display two decimal points.Observe your GPA in C1.


In Microsoft Excel how do you use a formula to calculate the percentage of use of a set of symbols?

In A1, put the total number of symbols.In B1, put the number of symbols used.In C1, enter the formula =A1/B1Format C1 for percent and observe the answer.


Which formula in excel can i use to find the total cost of items?

The "Sum" formula works best.


How many cells are in Microsoft Excel 2007?

There are 16,384 columns (A - XFD) and 1,048,576 rows, for a total of 17,179,869,184 cells per worksheet in Excel 2007.


How many cell's in Microsoft excel 2007?

There are 16,384 columns (A - XFD) and 1,048,576 rows, for a total of 17,179,869,184 cells per worksheet in Excel 2007.


What is the formula for Net Operating Margin in Excel?

=(total revenue- total expenditures)/revenue. you get a percentage.


What of these in Microsoft excel should be used to determine the total value of a column containing average monthly sales for a sales department?

To determine the total value of a column containing average monthly sales in Microsoft Excel, you should use the SUM function. This function adds up all the values in the specified range of cells. For example, if your average monthly sales are in column B from rows 1 to 12, you would use the formula =SUM(B1:B12). This will provide you with the total sales for that period.


What is the Excel formula to calculate the total of values in cells d7 through e20?

=SUM(D7:E20)


How many characters can be typed into an Office 2007 cell?

In Microsoft Excel 2007, Total number of characters that a cell can contain is 32,767 characters. Source: Microsoft Office Website Check related link..


Why are brackets necessary when calculating the total cost of an item in Excel?

It depends on your formula, but you may need them to change the order of operations.