Course Objectives: CO3: Format and organize workbook elements, including themes, text rotation, conditional Estimated time to Complete:  20 minutes  Description: In this part of the exercises, we will: Check spelling on worksheet

Part 2:

Course Objectives:

CO3: Format and organize workbook elements, including themes, text rotation, conditional

Estimated time to Complete:  20 minutes 

Description:

In this part of the exercises, we will:

·        Check spelling on worksheet

·        Change print margins for the header.

·        Preview and print versions and sections of a worksheet.

Required Resources:

Access to Microsoft Excel.

Deliverable:

After completing the assignment, upload the spreadsheet to the Canvas module.

Setup:

Access to Microsoft Excel.

Lab Steps:

Checking Spelling 

1.     Open the Klapore Engineering Salary Report workbook.

2.     Click the range of cells starting at A1 so that the spell checker begins at the beginning of the worksheet.

3.     Click the Spelling button on the Review tab to run the spell checker and display the misspelled words in the Spelling dialog box.

4.     Apply the desired action to each misspelled word (if there are any).

5.     When the spell checker is finished, close the pop-up window.

Change the Worksheet’s Margins, Header, and Orientation 

1.     Click the Page Layout button on the status bar to view the worksheet in Page Layout view.

2.     Click the Margins button on the Page Layout tab to display the Margins gallery.

3.     Click the Narrow margin style to change the worksheet margins to the selected style.

4.     Click the Print Titles button in the Page Layout tab.  Select the Header/Footer tab.

5.     Select Custom Header.  In the center , type the worksheet header “Klapore Engineering”, and then press the OK button.

6.     Click the Orientation button on the Page Layout tab to display the Orientation gallery.

7.     Select Landscape as the orientation for the worksheet.

Printing the worksheet 

1. Click File on the ribbon to open Backstage view.

2. Click the Print menu option on the left-hand side to display the Print screen.

3. Click the No Scaling button and then select “Fit Sheet on One Page”.

4. Capture a screen shot and upload it to Canvas.

Printing a Section of the Worksheet 

1.  Select the range of Employee, Email Address, Dependents, and Hours Worked to print on the worksheet. 

2. Click File on the ribbon to open Backstage view. 

3. Click the Print to display the Print screen. 

4. Click “Print Active Sheets” in the Settings area on the Print screen to display a list of printing options.  

5. Click Print Selection to print the selected range. 

6. Capture a screen shot and upload it to Canvas. 

Displaying the Formulas in the Worksheet and Fit the Printout on One Page 

1.     1. Press CTRL+ACCENT MARK (`) to display the worksheet with formulas. 

2. Click the Page Setup Dialog Box Launcher on the Page Layout tab to display the Page Setup dialog box. 

3. If necessary, click the desired Orientation in the Page sheet to select it. 

4. If necessary, click Fit to option button in the Scaling area to select it 

5. Click the Print button to open the Print screen in Backstage view. Select the Print Selection button in the Settings area of the Print gallery and then click Print Active Sheets. 

6. Capture a screen shot and upload it to Canvas. 

After viewing and printing the formulas version, press CTRL+ACCENT MARK (`) to display the values version 

After viewing and printing the formulas version, press CTRL+ACCENT MARK (`) to display the values version 

Uploading completed worksheet 

1.     Save the workbook to your local drive.

2.     Upload the saved spreadsheet to Canvas.

Part 3:

Course Objectives:

CO3: Format and organize workbook elements, including themes, text rotation, conditional

Estimated time to Complete:  20 minutes 

Description:

Student will learn to:

Rotate text in a cell

Create a series of month names

Copy, paste, insert, and delete cells

Enter and format the system date

Required Resources:

Access to Microsoft Excel.

Deliverable:

After completing the assignment, upload the spreadsheet to the Canvas module.

Setup:

Access to Microsoft Excel.

Lab Steps:

Rotating Text in a Cell

1.     Create a new spreadsheet with the following data:

2. Type the month “January” in the cell B3.

3. On the Home tab in the Alignment group, click the Dialog Box Launcher to display the Format Cells dialog box.

4. Rotate the text to 45 degrees by rotating the indicator in the Orientation area to that point and to display a new orientation in the Degrees box

5. Click the OK button to rotate the text in the active cell and automatically increase the height of the current row to best fit the rotated text.

Using the Fill Handle to Create a Series of Month Names

1. Select the cell containing the month “January”. Drag the fill handle on the lower-right corner of the desired cell to the right to select the range to fill—do not release the mouse button.

2. Lift your finger or release the mouse button to create a month name series in the selected range.

Insert a Row

1.     Select the row for Salary.

2.     Right-click the row heading below where you want to insert a row to display the shortcut menu and the mini toolbar.

3.     Click Insert on the shortcut menu to insert a new row in the worksheet by shifting the selected row and all rows below it down one row.

4.     Enter the following data in the row below the row containing the Salary.

Indenting Row Titles

1.     Select the cells in the Expense section.

2.     Click the Increase Indent button on the Home tab to increase the indentation of the text in the selected cell.

 Enter and Format the System Date

1.     Select the cell to the right of the subtitle of the worksheet. Click the Insert Function button in the formula bar to display the Insert Function dialog box.

2.     Click the “Or select a category” arrow and then select “Date & Time” in the list to populate the “Select a function” list with date and time functions.

3.     Scroll down in the “Select a function list” and then click NOW to select the function.

4.     Click the OK button to close the Insert Function dialog box.

5.     Click the OK button to display the system date and time in the selected cell.

Uploading completed worksheet

Save the workbook to your local drive.

Upload the saved spreadsheet to Canvas.