We will begin to create a workbook that compiles some survey results related to participants' self-reported confidence using computer applications. Our survey was conducted by having surveyors ask volunteers to rank their comfort on six applications in two different categories.
Our worksheet will track the respondents' self-reported comfort with the various applications on a scale of one (least comfortable) to five (most comfortable). If the respondents had additional comments, our survey collectors transcribed their verbal responses. Instead of identifying the participants by name, we've assigned them a random number in our data. We've asked them to report their household income and we recorded the date of their response.
We will set up the worksheet, type the first two responses, and then, later in the workshop, we will copy and paste the remaining responses from another Excel workbook. After our data is complete, we will use some functions to calculate the average confidence level of our participants on the applications.
We could return to Backstage view to begin a new workbook, but we will begin this exercise by using a keyboard shortcut.
Step1. To open a new workbook, press:
NOTE for MacOS Users: To open a new workbook, press: Command key+n
Naming a Worksheet
Providing meaningful names for worksheets is a good practice. Sheet names can be up to 31 characters, and spaces are allowed. Certain symbols, such as the colon, slash, back slash, question mark, and asterisk, are not allowed.
Step1. To select the worksheet name, at the bottom of the screen,
Double-Click the Sheet1 worksheet tab
Step2. To name the worksheet, type:
NOTE: You can also color-code your worksheet tabs by right-clicking on the worksheet tab and pointing to Tab Color. A color palette will appear with several color choices.
Entering Column Headings
We will begin by entering column headings for our worksheet.
Step1. To enter the text in cell A1, type:
Date Tab key
Step2. To add the next label, in cell B1, type:
Participant Number Tab key
Step3. To add the next label, in cell C1, type:
Excel Tab key
Step4. To add the next label, in cell D1, type:
PowerPoint Tab key
Step5. To add the next label, in cell E1, type:
Word Tab key
Step6. To add the next label, in cell F1, type:
Gmail Tab key
Step7. To add the next label, in cell G1, type:
Skype Tab key
Step8. To add the next label, in cell H1, type:
NOTE: When using the Tab key to enter data horizontally, the Enter key will return the cursor to the beginning of the next row in the column where you previously started entering data. The Enter key will work in this manner unless you make an error and return to a previous cell to correct the error. In this case, the cursor will return to the cell in the next row of the column where the error was corrected.
Step9. To save the workbook, on the Quick Access Toolbar,
Step10. To browse for the desired location, in the Excel_TheBasics folder,
NOTE for MacOS Users: To browse for the location, Click On My Mac and choose a location from the Where drop-down menu.
Step11. To name the workbook, in the File name field, type:
Step12. To save the workbook, press:
Each row of data is a record in this spreadsheet, which relates to a particular survey response. We will begin entering the first response.
Step1. To navigate to cell A2, if necessary,
Click cell A2
Step2. To enter the first date, in cell A2 type:
1/6/2017 Tab key
Step3. Use the table below to enter the remaining data for the first response:
Step4. Use the table below to enter the entries for the second response:
Step5. Adjust the columns widths as necessary using one or more of the methods discussed earlier in the workshop.
Step6. Save the workbook.