![]() Use column headings to identify variables and survey questions.Back up your file! Setting up a data entry template.Edit cell content in the Formula bar area, press Enter.Move to the cell in which you want to enter information (numerical or text), type it in, press Enter or arrow keys to move to next cell.Data Entry and Organization Entering data To select nonadjacent cells, hold down the Ctrl key and then click on the cells you want.To select an entire column or row, click on the row or column heading (number or letter).To select (highlight) a range of cells, click a cell and drag the mouse pointer, or use Shift and the arrow key.To change an active cell, use the arrow and Page Up and Page Down keys, click on a new cell, or drag the scroll bars.To move worksheets within a file, click on the worksheet tab and drag to new location.To insert a new worksheet, click on Insert menu, then Worksheet to delete worksheet, click on Edit, Delete Sheet.To color code a worksheet tab, right click on tab, select Tab color.To name a worksheet, double-click on Sheet (#) at tab and type in name.Option 3: Double click on Excel icon on desktop.Double click on Blank Workbook under General tab. Navigating an Excel Worksheet Starting a new Excel file It contains various buttons to perform different functions which can be executed on left mouse button click. The Tool Bar is directly below the Menu bar and displays the menu. To select an option, highlight the item on the drop-down menu and press Enter. You can use the up and down arrow keys to move up and down the drop-down menu. You can now use the left and right arrow keys on your keyboard to move left and right across the Menu bar options. Point with your mouse to a menu option and click the left mouse button. You use the menu to give instructions to the software. ![]() The menu begins with the word File and continues with the following: Edit, View, Insert, Format, Tools, Data, Window, and Help. The Menu Bar is directly below the Title bar and displays the menu. Each box, located in both a column and a row, is called a cell. By default, Excel will open a blank workbook that contains three worksheets (spreadsheets). At the top of your screen, you should see 'Microsoft Excel - Book1' or a similar name. On the Title bar, Microsoft Excel displays the name of the workbook you are currently using. Working Basics The Title Bar is located at the very top of the screen.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |