For example, in the earlier Excel picture, the sheet tabs at the bottom show "Sheet1," "Sheet2," and "Sheet3," with Sheet1 being the active worksheet.
#Microsoft excel spreadsheet example how to
How to tell if a worksheet is active?Īn active worksheet is the worksheet that is currently open.
Spreadsheets are also more dynamic with the data and can hide, show, and sort information to make processing lots of information easier. It would be impossible to calculate multiple numbers in a word processor and have the value of the calculation immediately appear. Why not use a word processor instead of a spreadsheet?Īlthough some uses above could be done in a word processor, spreadsheets have a considerable advantage over word processors when using numbers. The data is automatically entered in the selected cell where the mouse cursor is placed in the formula bar. To add additional data to a cell that already has data entered in it, follow the steps below. The data is automatically entered in the selected cell. Click in the formula bar, located between the Ribbon and all cells, where you want to start entering the additional data.Click the cell where you want to enter additional data.Start typing the data using your keyboard.Click the cell where you want to enter data.To enter data in a cell, follow the steps below. In a spreadsheet, data is entered in one or more cells. Spreadsheets can even be used to create tournament brackets and help track fantasy football stats. With the collected data, you can also find averages, high scores, and statistical data.
Spreadsheets can keep track of your favorite player stats or stats on the whole team. Great examples of spreadsheet lists include telephone, to-do, and grocery lists. Managing a list in a spreadsheet is a great example of data that does not contain numbers, but still can be used in a spreadsheet. Teachers can use spreadsheets to track students, calculate grades, and identify relevant data, such as high and low scores, missing tests, and students who are struggling. Formsįorm templates can be created to handle inventory, evaluations, performance reviews, quizzes, time sheets, patient information, and surveys. Spreadsheets are ideal for financial data, such as your checking account information, budgets, taxes, transactions, billing, invoices, receipts, forecasts, and any payment system. Below are some other popular uses of spreadsheets. Below is a list of spreadsheet programs used to create a spreadsheet.Īlthough spreadsheets are used with anything containing numbers, the uses of a spreadsheet are almost endless. Today, Microsoft Excel is a popular and widely used spreadsheet program, but there are also many alternatives.
However, most people only refer to the program as a spreadsheet program and the files it creates as spreadsheet files or worksheets. In other words, a spreadsheet and worksheet mean the same thing. What's often most confusing is that a worksheet is synonymous with a spreadsheet. A workbook can contain one or more different worksheets that are accessed through the tabs at the bottom of the worksheet your currently viewing. When you open Microsoft Excel (a spreadsheet program), you're opening a workbook. Difference between a workbook, worksheet, and spreadsheetīecause the terms spreadsheet, workbook, and worksheet are so similar, there often is confusion when trying to understand their differences. That value is subtracted from the check balance to give an available $361.00 in cell D8. These values are then added together to get the total of $162.00 in cell D6. In the above example, this spreadsheet is listing three different checks, the date, their description, and the value of each check. What did people use before spreadsheets?īelow is a basic example of what a Microsoft Excel spreadsheet looks like, with all the important features of a spreadsheet highlighted.
#Microsoft excel spreadsheet example download
0 kommentar(er)
