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 is a set of three blank worksheets; such as when you create a new excel file. You can add more worksheets into a workbook. A workbook is a new excel document, while a new worksheets exists within a workbook.
4. What and where is the Microsoft Office button and what is the Backstage view? I’m assuming that this is asking how you get to the Microsoft Office applications; which would be found by clicking on Start, selecting all programs, selecting Microsoft Office, and finally selecting your program; in this case Excel. The Backstage view is where you can manage your files and data about them. Such as creating, saving, and inspecting for hidden metadata or personal information.
5. What and where is the Quick Access Toolbar?
The Quick Access Toolbar is at the top of the Excel window. It is designed to give you an easy way to execute the commands used most often. Such as Save, Undo, and Redo commands; you can customize it to include other tools that will be more useful to you such as print preview, open, and quick print.
6. Describe the Ribbon.
There are three basic components of the Ribbon; Tabs, Groups and Commands. Tabs are across...
Please join StudyMode to read the full document