Property tax was the first tax levied in the state of Washington and its collection accounts for about 30% of Washingtonâs total state and local revenue. It continues to be the most important revenue source for public schools, fire protection, libraries, parks and recreation, and other special-purpose districts.
Using the Name tool, you can define a constant, such as a tax rate, that you frequently use in Excel formulas. Go to Insert | Name | Define and type a nameTaxRate, for example. In the Refers to area, type the constant value and click on OK. For a 7 percent tax rate, you would enter 0.07. Now you can write a formula like =SalePrice*TaxRate and Excel will use the constant value you defined for TaxRate.
Knowing how to use Excelâs variables gives you the ability to make your formulas â and by extension the spreadsheets containing those formulas â much easier to understand. For example, the formula â=A1*B1 + C2â is cryptic, while âSlope*X + Y_Interceptâ is recognizable as the equation of a line. Excel documentation refers to variables as âNames,â so when you want to create and manage Excel variables, you use the commands in the Defined Name group, such as âName Manager.â.