Exam 8: Excel: Creating a Worksheet and an Embedded Chart

When you open an Excel file, the application name (Microsoft Excel)is displayed on a selected button on the taskbar. If you point to this button, the file name also appears in a(n)__________.

Critical Thinking Questions Case 1-2 Anita is new to Microsoft Office Excel 2007. As she uses the application, she is beginning to see that it offers many features designed to make her use of Excel very easy. Which of the following features would be helpful to Anita if she wants to see the impact of a particular gallery choice on her worksheet, but she is nervous about actually applying the feature from the outset?

While creating an Excel worksheet, several decisions will determine the appearance and characteristics of the finished worksheet. List and explain the general guidelines you should follow as you create a worksheet.

Figure 1-1 In the accompanying figure, the __________ identifies the colors assigned to each bar in the chart on a worksheet.

A file name can have a maximum of 255 characters, including spaces. The only characters not allowed are the __________.

The opposite of cell merging is cell __________, which is done by selecting a merged cell and clicking the Merge and Center button.

Press the SPACEBAR to clear a cell.

Figure 1-2 In the accompanying figure, the __________ tab is called the primary tab of the Ribbon.

Which key on the keyboard toggles between Insert mode and Overtype mode?

You can activate Excel Help by clicking the __________ button.

Figure 1-2 To the right of the sheet tabs at the bottom of the screen, as shown in the accompanying figure, is the tab split box, which can be dragged to increase or decrease the view of the sheet tabs.

Critical Thinking Questions Case 1-1 Perry has recently expanded his business from a sole proprietorship to include two new employees he has hired. As a result of this expansion, he is considering carefully how to save the workbooks that he and his employees will create, and what storage media would be the best for the workbooks. Which of the following storage media is the best choice for Perry and his team if they decide that they will not need to share their workbooks across the team and they will not need to transport their projects to other locations?

Figure 1-4 In the accompanying figure, when a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color.

Dividing a cell into more than one cell is called __________.

Figure 1-1 In the figure, the intersection of row 1 and column A is referred to as a(n)__________, which is the basic unit into which data is entered.

A letter above the worksheet grid, also called the row heading , identifies each column.

The number of worksheets that a workbook can contain is __________.

Critical Thinking Questions Case 1-1 Perry has recently expanded his business from a sole proprietorship to include two new employees he has hired. As a result of this expansion, he is considering carefully how to save the workbooks that he and his employees will create, and what storage media would be the best for the workbooks. Perry decides that he will need to have access to particular workbooks on a variety of computers in the office. As a result, which of the following storage media is a good choice for him?