Complete forms
Excel Instructions using Excel: 1. Enter the appropriate numbers/formulas in the shaded (gtay) cells. An asterisk ) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign () and can consist of any of the following clements: Operators such as + (for addition), (for subtraction), * (for multiplication), and/ (for division) Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SU 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow theses teps: Move thc cell pointer to the cell that vou want to hold thc formul Type an equals sign () to signal the fact that the cell contains a formula. Type the formula, then press Enter 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5-26.475. The template will display and hold 26.48, not 26.475. There is no need to usc Excel's rounding function EXCEPTION: Continuing Payroll Problems A & B: CHAPTER 2 When calculating over-time rate for weekly salary, round regular rate to TWO decimals BEFORE calculating overtime rate Rounding can be accomplished by using Number function (using arrows) on Excel Home menu or by entering the formula (Round(Weekly/40,2)*1.5 (where "Weekly" entered as either the weekly pay or cell reference.) Failure to use the ROUND function will cause the OT rate to be incorrect of your file. You can save 5. Remember to save your work. sav You can save the file to the current name, or you may want to keep multiple versions of your work by saving cach successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Excel End of Chapter_Problems_Your_ Name.xlsx To save under a diffcrent namc, follow thesc steps: en saving your workbook, Excel overwrites the previous copy r work at any time. Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook Enter the new filenamc in the Filc name box Click Save Excel Instructions using Excel: 1. Enter the appropriate numbers/formulas in the shaded (gtay) cells. An asterisk ) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign () and can consist of any of the following clements: Operators such as + (for addition), (for subtraction), * (for multiplication), and/ (for division) Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SU 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow theses teps: Move thc cell pointer to the cell that vou want to hold thc formul Type an equals sign () to signal the fact that the cell contains a formula. Type the formula, then press Enter 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5-26.475. The template will display and hold 26.48, not 26.475. There is no need to usc Excel's rounding function EXCEPTION: Continuing Payroll Problems A & B: CHAPTER 2 When calculating over-time rate for weekly salary, round regular rate to TWO decimals BEFORE calculating overtime rate Rounding can be accomplished by using Number function (using arrows) on Excel Home menu or by entering the formula (Round(Weekly/40,2)*1.5 (where "Weekly" entered as either the weekly pay or cell reference.) Failure to use the ROUND function will cause the OT rate to be incorrect of your file. You can save 5. Remember to save your work. sav You can save the file to the current name, or you may want to keep multiple versions of your work by saving cach successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Excel End of Chapter_Problems_Your_ Name.xlsx To save under a diffcrent namc, follow thesc steps: en saving your workbook, Excel overwrites the previous copy r work at any time. Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook Enter the new filenamc in the Filc name box Click Save
