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.
For example, if you record a command, such as clicking the AutoSum button to insert a formula that adds a range of cells, Excel records the formula by using R1C1 style, not A1 style, references. You can turn the R1C1 reference style on or off by setting or clearing the R1C1 reference style check box under the Working with formulas section in the Formulas category of the Options dialog box.