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.

What will be an ideal response?


While creating an Excel worksheet, you need to make several decisions that will determine the appearance and characteristics of the finished worksheet.
1. Select titles and subtitles for the worksheet. Follow the less is more guideline. The less text in the titles and subtitles, the more impact the titles and subtitles will have. Use the fewest words possible to specify the information presented in the worksheet to the intended audience.
2. Determine the contents for rows and columns. Rows typically contain information that is analogous to items in a list, such as the fundraising techniques used by an organization. Columns typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet, such as the locations in which the organization operates. Row headings and column headings are usually placed in alphabetical sequence, unless an alternative order is recommended in the requirements document.
3. Determine the calculations that are needed. You can decide to total data in a variety of ways, such as across rows or in columns. You also can include a grand total.
4. Determine where to save the workbook. You can store a workbook permanently, or save it, on a variety of storage media including a hard disk, USB flash drive, CD, or DVD. You also can indicate a specific location on the storage media for saving the workbook.
5. Identify how to format various elements of the worksheet. The overall appearance of a worksheet significantly affects its ability to communicate clearly. Examples of how you can modify the appearance, or format, of text include changing its shape, size, color, and position on the worksheet.
6. Decide on the type of chart needed. Excel can create many different types of charts, such as cylinder charts and pie charts. Each type of chart relays a different message about the data in the worksheet. Choose a type of chart that relays the message that you want to convey.
7. Establish where to position and how to format the chart. The position and format of the chart should command the attention of the intended audience. If possible, position the chart so that it prints with the worksheet data on a single page.
8. Choose a name for the worksheet. Each worksheet in a workbook should be named to clarify its purpose. A good worksheet name is succinct, unique to the workbook, and meaningful to any user of the workbook.
9. Determine the best method for distributing the workbook. Workbooks and worksheets can be distributed on paper or electronically. The decision regarding how to distribute workbooks and worksheets greatly depends on your intended audience. For example, a worksheet may be printed for inclusion in a report, or a workbook may be distributed using e-mail if the recipient intends to update the workbook.

Computer Science & Information Technology

You might also like to view...

Linux provides three types of semaphore facilities in the kernel: binary semaphores, counting semaphores, and __________

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

You want to use only one name, funct1, from name space MyNamespace. The directive #include “MyNamespace” has been places at the top of the file. You will call this function a large number of times in a block. Which of the following will make only the name funct1 available only in that block (not outside the block)?

a) Place using namespace std; just after your #include directives. b) Place using namespace MyNamespace; just after your other #include directives. c) Place using namespace MyNamespace; just inside the block where you want to use funct1. d) Place using MyNamespace::func1; just inside the block where you want to use funct1. e) Place #include “MyNamespace” at the top of the file where you are using the name func1.

Computer Science & Information Technology

Which is not true of Windows XP mode?

a. The computer must be running Windows 7 Professional, Enterprise, or Ultimate. b. The computer hardware must be capable of virtualization. c. The BIOS must support virtualization. d. An application installed in Windows XP only appears in the Windows XP Start menu, and not the Windows 7 Start menu.

Computer Science & Information Technology

JavaFX animations use a container called ____, which allows the developer to position objects that are rendered in the order of the node.

A. Anchor Pane B. StackPane C. Timeline D. Group

Computer Science & Information Technology