Skip to main content
Aliexpress WW
Aliexpress WW

A Beginner's Guide to The Excel 2000 Window

Introduction

Microsoft Excel 2000 is a spreadsheet application in the Microsoft Office suite. A spreadsheet is an accounting program for the computer. Spreadsheets are primarily used to work with numbers, much like Microsoft Word is used to work with text. Spreadsheets calculate and analyze information by using mathematical formulas.

The Excel window

When you open Excel, many items you see are standard in most Windows 95 or 98 programs. A few things are specific to Excel 2000.
Excel Window

Toolbars

Toolbars can be customized and offer a series of commonly used Excel features.

Column headings

Each Excel spreadsheet has 256 columns.

Row headings

Each spreadsheet has 65,536 rows.

Name box

This shows the address and name of the current selection.

Formula bar

This displays the current entry (as you are typing or editing) or the contents of the current cell.

Cell

A cell is the intersection of a column and row. Each cell has a cell address. In the image above, the cell address of the selected cell is A1. The heavy border around the selected cell is called the cell pointer.

Navigation buttons

These allow you to easily move to another worksheet in an Excel workbook.

Sheet tabs

These allow you to move around a workbook easily.

The Excel workbook

When you open Microsoft Excel, a workbook automatically shows in the workspace.

Important terms:

  • workbook is made up of three worksheets.
  • The worksheets are labeled Sheet1, Sheet2, and Sheet3.
  • Each Excel worksheet is made up of columns and rows.
  • In order to access a worksheet, click on the tab that says Sheet#.

To change the number of worksheets:

  • Choose ToolsactionOptions.
  • In the Options dialog box, click the General tab.
  • Click the spin box controls (up and down arrows) to change the number of worksheets in a new workbook.
Excel Workbook

The cell

The Excel worksheet is made up of columns and rows. When these columns and rows intersect, they form little boxes called cells.

Important terms:

  • Each cell has a unique cell addresscomposed of a cell's column and row.
  • The active cell is the cell that receives the data or command you give it.
  • A darkened border, called the cell pointer, identifies it.
Cell Pointer

Moving the cell pointer

  • To activate any cell, click the cell.
  • To move the pointer one cell to the left, right, up, or down, use the keyboard arrow keys.
  • To see other areas of the worksheet, use the scroll bars. To scroll large distances, hold the Shift key while dragging the scroll bar.

Some frequently used keyboard commands:

Page Down: Moves down one screen
Page Up: Moves up one screen
Home: Moves to column A in the current row
Ctrl+Home: Moves to cell A1

Challenge!

  • Use the horizontal and vertical scroll bars to explore the Excel worksheet.
  • Explore using Page UpPage DownHome, and Ctrl+Home.
  • To see other areas of the worksheet, use the scroll bars. To scroll large distances, hold the Shift key while dragging the scroll bar.

Comments

Popular posts from this blog

The Advanced Guide to Colours In Graphic Design

The power of color Color plays a vital role in  design  and  everyday life . It can draw your eye to an image. Sometimes it can trigger an emotional response. It can even communicate something important without using words at all. So how do we know which colors look good together and which ones don't? The answer is simple:  Color theory . Artists and designers have followed  color theory  for centuries, but anyone can learn more about it. It can help you feel confident in many different situations, whether it's  choosing colors for a design  or  putting together the perfect outfit . With a little insight, you'll be looking at color in a whole new way. Color basics Let's start at the beginning with a refresher on the basics. Remember learning about  primary and secondary colors  in school? Then you already have some knowledge of color theory. Secondary colors  are created by combining two  primary colors...

The Ultimate Cheat Sheet On Making Basic Adjustments In Image Editting

Introduction Image editing is all about adjusting your images to make them look better. We're going to talk about some of the most  basic image adjustments , along with some common problems to watch out for when making these changes. The adjustments we'll cover in this lesson include: Cropping : If you want to remove parts of an image, you can  crop  it. You can think of cropping as using a pair of scissors to  cut out  the parts you no longer want. Resizing : If you want to make an image smaller or larger, you can  resize  it. However, keep in mind that making an image larger than its original size generally does not look good. Rotating : If you want to change the  orientation  of an image, you can  rotate  it to the left or right. Optional : If you'd like to follow along, you can download some or all of our  example images . Just click any of the images below to open a full-sized version. Then right-click the full-si...

The Ultimate Glossary of Terms About Typography In Graphic Design

What is typography? Typography is everywhere we look. It's in the books we read, on the websites we visit, even in everyday life—on street signs, bumper stickers, and product packaging. But what exactly is typography? Simply put, typography is the style or appearance of text . It can also refer to the art of working with text—something you probably do all the time if you create documents or other projects for work, school, or yourself. Common types of fonts Typography can be an intimidating subject, but it doesn't have to be. You only need to know a little to make a big difference in the stuff you do every day. So let's get started. First, some common types of fonts  and what you need to know about them. Serif fonts Serif fonts have little strokes called  serifs attached to the main part of the letter. Because of their classic look, they're a good choice for more  traditional projects . They're also common in print publications, like magazines an...