types of data you enter in MS Excel

How to Entering Data in Cell.

Whenever you enter in excel you are given a blank file (Workbook) containing one worksheet. The worksheet is the combination of multiple cells (In each worksheet there are multiple rows and columns, intersect, areas ‘frows and columns create a rectangular each rectangular zone is called a cell) we will enter data under different cells.

Source:-https://advanceexcelxp.blogspot.in

Types of data you can enter in Excel.

An Excel workbook can hold any number of worksheets, and each worksheet is made up 0 more than 17 billion cells. A cell can hold

  • Numerical values
  • Text
  • Date & Time
  • A formula that returns a value, logical value or text.

The text is any combination of letters, numbers, and spaces. By default, a text is automatically left aligned in a However, Numbers, and Dates are right aligned.

A worksheet Can also hold charts, diagrams, pictures, buttons, and Other Objects. These Objects contained in cells. Rather, they reside on the worksheet draw layer, which is an invisible layer on each worksheet.

Moving around a Worksheet.

At the opening interface excel provides you a default workbook name book1. When you want to place your cursor or activate a cell in order to insert, edit or format the cells, there are ways to help you.
You can use:

  • Mouse
  • Keyboard
  • Name box on the formula bar and Go To Dialog box

Navigating with your keyboard

You can use the standard navigational keys on your keyboard to move around a worksheet. These keys work just as you’d expect: The down arrow moves the active cell down one row, the right arrow moves it one column to the right, and so on. PgUp and PgDn move the active cell up or down one full window. (The actual a number of rows moved depends on the number of rows displayed in the window.

Source:http://www.thecompanyrocks.com

Navigating with your mouse.

To change the active cell by using a mouse, click another cell; it the active cell. If the cell that you want to activate isn’ t visible in workbook window; you Can use scrollbars to scroll the window in any direction. To scroll one cell, click either arrow on the scrollbar. To scroll through a complete screen. click either side of the scrollbar’s scroll box, You also can drag the scroll box for faster scrolling.

press Ctrl while you use the mouse wheel to zoom the worksheet. if you prefer to use the mouse wheel to zoom the worksheet without Ctrl. office ButtonExcel Options and select the Advanced section. Place a checkmark next to the Zoom on Roll with IntelliMouse check box.

Using the scrollbars or scrolling with your doesn’t change the Etive cell. It simply scrolls the worksheet. To change the active cell. you must dick a cell after smiling.

If your mouse has a wheel on it. you can use the mouse wheel to scroll vertically. Also, if you click the wheel and move the mouse in that direction. the worksheet scroll automatically in that direction. The more you move the mouse, faster the scrolling.

Name box on the formula bar and GO to the Dialogue box

Source: www.advanceexcelxp.blogspot.in

GO TO

Source: https://advanceexcelxp.blogspot.in

 

Cell Box 

Source:-https://advanceexcelxp.blogspot.in

Different components of Ms Excel worksheet

Previous article

How to customize data format alignment,number grouping

Next article

You may also like

Comments

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

More in Excel