Microsoft Excel 2019: Creating Worksheet & Chart - Objectives & Instructions, Assignments of Computer Science

Download Microsoft Excel 2019: Creating Worksheet & Chart - Objectives & Instructions and more Assignments Computer Science in PDF only on Docsity! lOMoARcPSD|3013804 lOMoARcPSD|3013804 Microsoft Excel 2019 Module 1: Creating a Worksheet and a Chart Objectives  Start an app  Identify the components of the Microsoft Office ribbon  Describe the Excel worksheet • Enter text and numbers  Use the Sum button to sum a range of cells  Enter a simple function  Copy the contents of a cell to a range of cells using the fill handle  Apply cell styles 3  Format cells in a worksheet  Create a pie chart  Change a worksheet name and sheet tab color  Change document properties  Preview and print a worksheet  Use the AutoCalculate area to display statistics  Correct errors on a worksheet  Use Microsoft Office Help Starting and Using Excel  What is Excel? - A powerful spreadsheet app that allows users to organize data, complete calculations, make decisions, graph data, develop professional-looking reports, publish organized data to the web, and access real-time data from websites  Four major parts: - Workbooks and worksheets - Charts - Tables - Web support 7  To Start Excel and Create a Blank Workbook - If necessary, scroll to display the Excel 2019 app on the Start menu - Click the Excel 2019 app to run the Excel app and display the Excel start screen - Click the Blank workbook thumbnail on the Excel start screen to create a blank Excel workbook in the Excel window  Excel Window - Worksheet - Scroll Bars - Status Bars - Ribbon - Mini Toolbar - Quick Access Toolbar lOMoARcPSD|3013804 - KeyTips - Formula Bar - Tell Me Box  To Display a Different Tab on the Ribbon - Click Insert on the ribbon to display the Insert tab - Click the View tab, click Page Layout tab, then click Insert tab Selecting a Cell  Make the cell active  Use the mouse  Use the arrow keys  Cell is active when a heavy border surrounds the cell Entering Text  To Enter the Worksheet Titles - Run Excel and create a blank workbook in the Excel window - Click the A1 to make the cell A1 the active cell - Type desired text - Click the ENTER button to complete the entry and enter the worksheet title - Click cell A2 to select it - Click the ENTER button to complete the entry and enter the worksheet subtitle 13  To Enter Column Titles - Click cell A3 and enter a column title - Press the RIGHT ARROW key to enter a column title and make the cell to the right the active cell - Repeat the previous steps until all column titles are entered. Click the Enter box after entering the last column title  To Enter Row Titles - Click cell A4 and enter a row title - Press the DOWN ARROW key to enter a row title and make the cell below the current cell the active cell - Repeat the previous steps until all row titles are entered Entering Numbers  In Excel, you can enter numbers in Excel to represent amounts  If a cell entry contains any other keyboard character, Excel interprets it as text and treats it accordingly  To Enter Numbers - Click cell B4 to select it - Type desired number and then press the RIGHT ARROW key to enter the data in the selected cell and make the cell to the right the active cell - Continue until all numbers are entered lOMoARcPSD|3013804 - Repeat the above steps to format other ranges  To Format Numbers in the Worksheet • Select the range of cells containing numbers to format - Click the desired format on the HOME tab to apply the format to the cells in the selected range  To Adjust the Column Width - Point to the boundary on the right side of the column of which you want to change the size to change the mouse pointer to a split double arrow - Double-click on the boundary to adjust the width of the column to the width of the largest item in the column  To Use the Name box to Select a Cell - Click the Name box in the formula bar and then type the cell reference of the cell you wish to select - Press the ENTER key to change the active cell in the Name box Adding a Pie Chart to the Worksheet  To Add a Pie Chart - Select the range for the pie chart - Click the “Insert Pie or Doughnut Chart” button on the INSERT tab to display the Insert Pie or Doughnut Chart gallery - Click the Insert Pie or Doughnut Chart gallery to insert the chart - Click the chart title to select it - Type a chart title and then press the ENTER key to change the title - Deselect the chart title  To Apply a Style to a Chart - Click the Chart Styles button to display the Chart Styles gallery - Click a style in the Chart Styles gallery to change the chart style to the desired style Changing the Sheet Tab Names and Colors  To Move a Chart to a New Sheet - Click the Move Chart button on the CHART TOOLS DESIGN tab - Click New sheet to select it and then type a title for the worksheet that will contain the chart - Click the OK button to move the chart to a new chart sheet with a new sheet tab name  To Change the Sheet Tab Name and Color - Double-click the sheet tab you wish to change in the lower-left corner of the window - Type a new name as the worksheet tab name - Right-click the sheet tab in the lower-left corner of the window to display a shortcut menu - Point to Tab Color in the Tab Color gallery - Click the desired color in the Theme Colors area to change the color of the tab Document Properties lOMoARcPSD|3013804  To Change Document Properties - Click File on the ribbon to open the Backstage view and then click the Info tab in the Backstage view to display the Info gallery - Click to the right of the property category to display a text box - If necessary, click the Properties button to display the Properties menu Printing a Worksheet  To Preview and Print a Worksheet in Landscape Orientation • In Backstage view, click the Print tab to display the Print screen • Verify that the printer listed on the Printer Status button will print a hard copy of the workbook. If necessary, click the Printer Status button to display a list of available printer options and then click the desired printer to change the currently selected printer • Click the Portrait Orientation button in the Settings area and then select Landscape Orientation to change the orientation of the page to landscape. • Click the No Scaling button and then select “Fit Sheet on One Page” to print the entire worksheet on one page • Click the Print button in the Print gallery to print the worksheet in landscape orientation on the currently selected printer • When the printer stops, retrieve the hard copy Viewing Automatic Calculations  To Use the AutoCalculate Area to Determine a Maximum - Select the range of which you wish to determine a maximum, and then right-click the status bar to display the Customize Status Bar shortcut menu - Click Maximum on the shortcut menu to display the Maximum value in the range in the AutoCalculate area of the status bar Correcting Errors  Correcting Errors after Entering Data into a Cell - If the entry is short, select the cell, retype the entry correctly - If the entry is long, use the EDIT mode using in-cell editing  Undoing the Last Cell Entry  Clearing a Cell or Range of Cells - To Clear Cell Entries Using the Fill Handle - To Clear Cell Entries Using the Shortcut Menu - To Clear Cell Entries Using the Delete Key - To Clear Cell Entries and Formatting Using the Clear Button • To Clear Formatting Using the Cell Styles Button  Clearing the Entire Worksheet - To Clear the Entire Worksheet a. Click the Select All button on the worksheet b. Click the Clear button and then click Clear all  To Obtain Help Using the Search Text Box - Click Help on the ribbon to display the Help tab - Click the Help button to display the Help panel lOMoARcPSD|3013804 - Type a word in the Search help box - Press Enter to display the search results - Click the Close button - Click Home on the ribbon to display the Home tab  To Obtain Help Using the Tell Me Box • - Type desired text in the Tell Me box and watch the search results appear  To Save a Workbook with a Different File Name - Click File on the ribbon to open Backstage view - Click Save As in Backstage view to display the Save As screen - Type the desired file name in the File name text box to replace the existing file name - Click the Save button  To Sign Out of a Microsoft Account - Click File on the ribbon to open Backstage view - Click Account to display the Account screen - Click the Sign out link - Click Yes - Click the Back button in the upper-left corner of Backstage view to return to the document - Click Close to close the workbook and exit Microsoft Excel. If prompted, click yes