Excel Worksheet
Chapter 1 Questions
1. Identify some new features in the 2010 version of Excel.
Some new features include sparklines and slicers, and improvements to PivotTables and other existing features can help you to discover patterns or trends in your data that can lead to more-informed decisions.
2. Why would you use conditional formatting?
Conditional formatting features reflect graphically the values for salespersons and customers relatives to each other. It is used as a comparison tool such as in the example of sales by salesperson worksheet, to compare and see which one did better or worse in various criteria.
3. Explain the difference between a worksheet and a workbook.
A worksheet is a grid of rows and columns in which you may enter the information. You can create additional worksheets within a workbook. A workbook …show more content…
What is the Page Layout view?
Page Layout view show page margins at the top, sides, and bottom of the worksheet including space between worksheets. It can help you make adjustments to the worksheet before you print, in order to add headers, footers, and make further technical adjustments.
9. What is the quickest way to get help while in Excel?
The quickest way to get help while in Excel is to press the F1 function key, or click the blue and white question mark to open Excel 2010s help window. In this window, that does not require internet connection, and you just need to continue by searching and responding to questions to find the technique in order to create what you need.
10. What are the key accounting topics addressed in the text that relate to your learning Excel?
Some of the key accounting topics that utilize Excel by building worksheets include: formulas, functions, and features to analyze financial statements, calculate depreciation, create depreciation schedules, create loan and bond amortization schedules, and to create cash flow budgets. Excel can be used to simplify and organize all components for a business accounting
1. Identify some new features in the 2010 version of Excel.
Some new features include sparklines and slicers, and improvements to PivotTables and other existing features can help you to discover patterns or trends in your data that can lead to more-informed decisions.
2. Why would you use conditional formatting?
Conditional formatting features reflect graphically the values for salespersons and customers relatives to each other. It is used as a comparison tool such as in the example of sales by salesperson worksheet, to compare and see which one did better or worse in various criteria.
3. Explain the difference between a worksheet and a workbook.
A worksheet is a grid of rows and columns in which you may enter the information. You can create additional worksheets within a workbook. A workbook …show more content…
What is the Page Layout view?
Page Layout view show page margins at the top, sides, and bottom of the worksheet including space between worksheets. It can help you make adjustments to the worksheet before you print, in order to add headers, footers, and make further technical adjustments.
9. What is the quickest way to get help while in Excel?
The quickest way to get help while in Excel is to press the F1 function key, or click the blue and white question mark to open Excel 2010s help window. In this window, that does not require internet connection, and you just need to continue by searching and responding to questions to find the technique in order to create what you need.
10. What are the key accounting topics addressed in the text that relate to your learning Excel?
Some of the key accounting topics that utilize Excel by building worksheets include: formulas, functions, and features to analyze financial statements, calculate depreciation, create depreciation schedules, create loan and bond amortization schedules, and to create cash flow budgets. Excel can be used to simplify and organize all components for a business accounting