There are a number of methods for altering row height and column width using the mouse or menus. Width and height of a cell may not accommodate the data that you want to enter into a cell. You can enter dates in any of the standard date formats. This creates a line break within the cell. To place text on separate lines within the same cell, you press and hold the Alt key while you press the Enter key.
As you enter data, the entry appears in both the active cell and the formula bar. New data values are placed into the cell that is currently active in the worksheet. Date and time data are commonly recognized formats for date and time values. Number data is any numerical value that can be used in a mathematical calculation. Text data is a combination of letters, numbers, and some symbols that form words and sentences. Information entered into cells is categorized as either text, numbers, or dates and times. For example, you would need to know what problems you want to solve with the worksheet, what data you need, what calculations you need to enter, and what form the solution should take. To create a plan, you can use a planning analysis sheet, which includes a series of questions that help you think about the purpose of the worksheet. For larger worksheets that span several screens, you can move directly to a specific cell using the Go To dialog box or by typing a cell reference in the Name box.īefore you begin entering data in a worksheet, you should have a plan for the worksheet.
Use the mouse and keyboard to quickly navigate through an active worksheet. A workbook can have two kinds of sheets: worksheets and chart sheets. The name of the active workbook, Book1, appears in the title bar. By default, Excel starts with a blank workbook maximized to fill the Excel window. The Excel window contains many of the elements that you find in other Office 2010 programs, including a title bar, the Ribbon, scroll bars, and a status bar. You can also use Excel to store data, generate reports, and analyze data values using a variety of statistical tools. They can also be used to manage personal budgets and track household assets. Spreadsheets are often used in business for budgeting, inventory management, and decision making. A spreadsheet is a collection of text and numbers laid out in a rectangular grid. Tutorial 1: Getting Started with Excel Introducing ExcelĮxcel is a computer program used to create electronic versions of spreadsheets. Tutorial 4: Enhancing a Workbook with Charts and Graphs Tutorial 3: Working with Formulas and Functions Topic review for Microsoft Excel 2010 section of the New Perspectives on Microsoft Office 2010, First Course Textbook: Microsoft Excel 2010 Topic Review - Microsoft Excel 2010
0 kommentar(er)
