![microsoft word create header with name and page number microsoft word create header with name and page number](https://i.ytimg.com/vi/eFT5vsrMDrM/maxresdefault.jpg)
Enter a formula to find TOTALS, AVERAGE, HIGHEST, and LOWEST values. Enter a formula to find %Change for the first item where % Change = Change / Last year. Enter a formula to find Change for the first item where Change = This Year – Last year.
![microsoft word create header with name and page number microsoft word create header with name and page number](https://www.lifewire.com/thmb/eD1IHyZQn6oK72QGcdVqCeOVQIw=/2134x1224/filters:no_upscale():max_bytes(150000):strip_icc()/004-microsoft-word-add-page-numbers-4159584-c5cdf75330344fb1a57a7cc65ef742c1.jpg)
Set the column widths as follows: Column A: 18, Column B, C, D, E: 10. Create Footer with Date in the left section and Time in the right section. Create a Header that includes Your Name in the left section, Page Number in the center section, and Your ID Number in the right section. Align all column title labels horizontally and vertically at the center. Format numeric data to include commas and two decimal places. Enter formula to find TOTALS, AVERAGE, HIEGHEST, LOWEST and COUNT values. Copy the formula to the remaining employees. Enter the formula to find QUARTERLY SALARY for the first employee where QUARTERLY SALARY = BASE SALARY + COMMISSION. Enter the formula to find COMMISSION for the first employee. Set the column widths as follows: Column A: 5, Column B: 18, Columns C & D: 13, Columns E & F: 14. Center the worksheet vertically and horizontally on the page. Create Footer with Page Number in the center section. Create a Header that includes Your Name in the left section, Date in the center section, and Your ID number in the right section. Set the columns labels alignments appropriately. Enter a formula to find Total Price for the first item. Enter a formula to find Sales Tax for the first Item.
![microsoft word create header with name and page number microsoft word create header with name and page number](https://i1.wp.com/www.myofficetricks.com/wp-content/uploads/2019/07/071019_0732_HowtoSetthe3.png)
Enter a formula to find Sales Price for the first item. Format column F to include $ sign and 2 decimal places. After entering the data, insert a new row between rows 2 & 3. Align all column labels horizontally and vertically at the center. Set the column widths as Columns A, B: 9 Columns C& D: 11. Create the worksheet shown above in Sheet1 and rename it as Coral. Delete the worksheets: Sheet2 and Sheet3. Saving and excel file.Įxercise 2 W Using Formulas W Header and FootersĮxercise 3 W Number, Commas and Decimal numeric formats W Working with Formulas ( Maximum, Minimum, Average, Count andĮxercise 5 W Working with the IF StatementĮxercise 7 W Working with the Count If and Sum If StatementsĮxercise 9 W Absolute Cell Referencing W Working with the Vertical Lookup FunctionĮxercise 10 W Working with the Horizontal Lookup Function.ġ. Previewing Worksheet Center the worksheet horizontally and vertically on the page. Fonts, Alignment, Warp Text, Text Orientation, Border and Shading. Inserting, Deleting and Renaming Worksheets.
![microsoft word create header with name and page number microsoft word create header with name and page number](https://media.gcflearnfree.org/content/567451878d7fa90eb4ddc8c6_12_18_2015/header_create_type.png)
Microsoft Excel Exercise 1 W Introduction to Excel files, Worksheets, Rows, Columns, Row/Column W W W W W W W W W W W For example, the upper-left cell of a worksheet is A1. Each cell have its own Cell references, which are the combination of column letter and row number. The initial number of sheets in a workbook, which can be changed by the user is 16. The Excel worksheet can contain as many as 256 sheets, labeled Sheet1 through Sheet256. The Excel worksheet contains 256 columns that extend across the worksheet, lettered A through Z, AA through AZ, BA through BZ, and continuing to IA through IZ. The Excel worksheet contains 16,384 rows that extend down the worksheet, numbered 1 through 16384. The intersection of a row and column is a rectangular area called a cell. The workbook consists of grids and columns. The Excel screen is devoted to the display of the workbook. It performs numerous functions and formulas to assist you in your projects.
Microsoft word create header with name and page number professional#
Microsoft Excel Microsoft Excel allows you to create professional spreadsheets and charts.