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:

  • A 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 Up, Page Down, Home, 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.
Labels:

Comments

Post a Comment

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...
Post a Comment
Read more

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...
3 comments
Read more

Layout And Composition In Graphic Design: It's Not as Difficult as You Think

What is composition? In many ways, layout and composition are the  building blocks  of design. They give your work structure and make it easier to navigate, from the margins on the sides to the content in between. Why is composition so important? In short, it's the  way your content is arranged . It doesn't matter if you're working with text, images, or elements in a graphic; without a thoughtful, well-composed layout, your work would basically fall apart. Five basic principles The key to mastering layout and composition is to  think like a designer . Luckily, it's easier than it sounds. There are  five basic principles  that can help you transform your work and sharpen your eye for design. Keep them in mind during your next project, and look for ways to apply them. Proximity Proximity is all about using  visual space  to show  relationships  in your content. In practice, it's pretty simple—all you have to do is make su...
Post a Comment
Read more