Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Exploring Excel fundamentals
CHAPTER 2
Exploring Excel fundamentals
Examining the Excel 2013 workspace ................15
Exploring file-management fundamentals............40
Importing and exporting files ......................61
Using the Help system.............................67
Recovering from crashes ...........................71
BEFORE you can get the feel of the controls, you need to know where they are and
what they do. This chapter discusses the essential commands, controls, tools, and
techniques you need to operate the Microsoft Excel 2013 machine.
Examining the Excel 2013 workspace
This section takes you on a tour of not only the dashboard of Excel 2010 but also the trunk
and the glove compartment. We might even slip on some gloves and take a peek under
the floor mats.
Facts about worksheets
Here are some tidbits of information about the grid called the worksheet , shown in
Figure 2-1:
Column letters range from A through XFD. (After column Z comes column AA, after
column ZZ comes column AAA, and so on, up to XFD.) Row numbers range from 1
through 1,048,576.
The currently selected cell is referred to as the active cell . When you select a range of
cells, only the cell in the top-left corner is considered the active cell. The reference of
the active cell appears in the Name box on the left end of the formula bar.
The headings for the columns and rows containing selected cells are highlighted,
making it easier to identify the location of selected cells.
With 16,000 columns and 1,048,576 rows, your worksheet contains more than 16
billion individual cells. Before you try to unravel the mysteries of the universe on a
single worksheet, however, remember that the number of cells you can use at one
time is limited by the amount of memory your computer has. Although Excel
allocates memory only to cells containing data, you might have trouble actually using all
the cells on one worksheet, no matter how much memory you have.
15
Search JabSto ::




Custom Search