Discussion Board Unit 4
Introduction to Computers
A. Questions for weekly discussions and conversations.
1. What features or functions of Excel do you feel will likely be most useful to you in helping you achieve your career goals?
I believe Excel will be useful when using it with organizing, tracking expenses, inputting data, and storing information. These different uses will be successful when using them towards my business. I believe the Excel Spreadsheet will be most useful to me. This function will be useful to track the financial data pertaining to the business.
2. What are some of the applications where you can envision using Excel in your personal life?
I can use Excel for making lists for chores, books, dvds, and inventory on household belongings. I can also use Excel with budgeting bills, keeping ...view middle of the document...
This function is more useful than Visicalc. It makes it easier for you to pull up the spreadsheet and change numbers and it automatically changes the sum of the equation.
B. Required discussion board assignment.
What is the difference between a workbook and a worksheet?
An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. An Excel workbook is one or more spreadsheets that are separated by tabs on the bottom of the Excel window.
Why would you want to use separate worksheets when using Excel? Please give 2 examples.
Using separate worksheets allows you to organize data. First example, the first spreadsheet can be your business sales data, the second spreadsheet can contain inventory data, and the third spreadsheets can contain the expenses. You can flip back in forth from these spreadsheets to organize information.
Another example is that you can work on each spreadsheet by just clicking on the different tabs. This makes it much easier so that you don’t have to open new windows.
Please research and find the method for creating an Excel formula that references information on the first work sheet from the second worksheet.
I was able to research and find 2 formulas that you can use to reference worksheet to worksheet.
First formula: =SUM(Sheet1!A1:B10)
Second formula: =index(sheet2!$A$1:$A$100,match(A2,sheet2!$B$1:$B$100))
Can you think of a specific personal or business application that would require only one spreadsheet?
There are many applications that use only one spreadsheet. One in particular would be a balance sheet. A balance sheet is used to track assets and liabilities. This spreadsheet also tracks fixed assets and equity. This spreadsheet is used for budgets and finances.