Microsoft Office Tutorials and References
In Depth Information
With a solid understanding of the requirements document, an understanding of
the necessary decisions, and a sketch of the worksheet, the next step is to use Excel to
create the worksheet.
For an introduction to
instruction about how to
perform basic Windows
tasks, read the office
and Windows chapter
at the beginning of
this topic, where you
can learn how to resize
windows, change screen
folders, move and rename
les, use Windows Help,
and much more.
In this chapter, you will learn how to create and use the workbook shown in
Figure 3 – 1. The following roadmap identies general activities you will perform as
you progress through this chapter:
1. ENTER the HEADINGS and DATA in the worksheet.
2. ENTER FORMULAS and FUNCTIONS in the worksheet.
3. CREATE SPARKLINE CHARTS in a range of cells.
4. FORMAT the WORKSHEET .
5. CREATE a COLUMN CHART on a separate chart sheet.
6. CHANGE VIEWS of the worksheet.
7. ASK WHAT - IF QUESTIONS .
At the beginning of step instructions throughout the chapter, you will see an
abbreviated form of this roadmap. The abbreviated roadmap uses colors to indicate
chapter progress: gray means the chapter is beyond that activity, blue means the
task being shown is covered in that activity, and black means that activity is yet to be
covered. For example, the following abbreviated roadmap indicates the chapter would
be showing a task in the CREATE SPARKLINE CHARTS activity.
The Ribbon and
Excel may change how the
groups and buttons within
the groups appear on the
ribbon, depending on the
computer’s screen resolution.
Thus, your ribbon may look
different from the ones in
this topic if you are using a
screen resolution other than
1366 3 768.
1 ENTER HEADINGS & DATA | 2 ENTER FORMULAS & FUNCTIONS | 3 CREATE SPARKLINE CHARTS
4 FORMAT WORKSHEET | 5 CREATE COLUMN CHART | 6 CHANGE VIEWS | 7 ASK WHAT - IF QUESTIONS
Use the abbreviated roadmap as a progress guide while you read or step through
the instructions in this chapter.
One of the few
Windows 7 and
Windows 8 occurs in
the steps to run Excel.
If you are using
Windows 7, click
the Start button,
type Excel in the
and les’ box, click
Excel 2013, and then,
if necessary, maximize
the Excel window. For
detailed steps to run
Excel in Windows 7,
refer to the office and
Windows chapter at the
beginning of this topic.
For a summary of the
steps, refer to the Quick
Reference located at the
back of this topic.
To Run Excel and Create a Blank Workbook
If you are using a computer to step through the project in this chapter and
you want your screens to match the gures in this topic, you should change your
screen’s resolution to 1366 768. For information about how to change a computer’s
resolution, refer to the office and Windows chapter at the beginning of this topic.
The following steps, which assume Windows 8 is running, use the Start screen
or the search box to run Excel based on a typical installation. You may need to ask
your instructor how to run Excel on your computer. For a detailed example of the
procedure summarized below, refer to the office and Windows chapter.
Scroll the Start screen for an Excel 2013 tile. If your Start screen contains an Excel 2013
tile, tap or click it to run Excel and then proceed to Step 5; if the Start screen does not
contain the Excel 2013 tile, proceed to the next step to search for the Excel app.
Swipe in from the right edge of the screen or point to the upper-right corner of the
screen to display the Charms bar and then tap or click the Search charm on the Charms
bar to display the Search menu.
Type Excel as the search text in the Search box and watch the search results
appear in the Apps list.