Skip to main content

SPREADSHEET PART-3

                                   EXCEL PART -3

In this blog I share you the following topics:

Printing a  Spreadsheet 

Addressing of Cell 

Manipulation of Cell
 

Printing a  Spreadsheet 

The simplest way to print any opened worksheet is to choose Print option from the Backstage view , click Print Preview. In Excel you can print partial or entire worksheet & workbooks one at a time or several at once .

Follow Steps:

Open the Worksheet that you want to print.
Click the File Tab and than choose Print Command or Alternatively Press CTRL+SHIFT+F12 Key .



 The Backstage View is Close by Pressing ESC Key.

       Option                                      Function 

Ignore Print Area                 Select this option if you want to ignore the print area you have selected.

Page (s) From:/To:               Select this option to print pages you wish to Print.

Collate                                  Select this option to collate multiple copies.

Pages Orientation                 Allows you to collate multiple copies. 

Page Size                              Allows you to select the paper size.

Margin                                 Allows you to set the margin of the pages .

Scaling                               Allow you to adjust the size of the work sheet . 


                      

Addressing of Cell 

In a spreadsheet there is a cell address bar where we find the exact location of a cell.

There are two type of Cell References :-

Relative 

By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. Relative references are especially convenient whenever you need to repeat the same calculation across multiple rows or columns.


Absolute 

There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.
An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both.
A Spreadsheet consists of rows and column and their intersection point is called CELL .
     
What is Cell?

A cell is a box where you can type or enter any type of  data i.e Alphabet, Numbers, Special Character etc.

Cell have two types of data:-

1.Constant Value: A constant value is data that you type directly into a cell it can be a number , time , currency etc. Constant Value can not change without edit it.


2.Formula:  A formula is a sequence of values, cell reference, names, functions or operators that produce a new val from the existing values.


  What are Column & Row ?

A column form the vertical lines of cells while rows form the horizontal lines of the cell .


                Total No. of Rows in a worksheet : 1048576

                Total No. of Column in a worksheet : A to XFD

Manipulation of Cells

The power of Excel lies in storing, manipulating & displaying data items. Before you can manipulate and display data you must enter it correctly.

Types of Data Entered in a Cell :

1.Text
2.Numerals 
3.Logical Values
4.Error 

                                   


TEXT : 

Text in a cell can include any combination of letters, numbers, and keyboard symbols.

  • A cell can contain upto 32000 characters.
  •  If Column width prevents in a text string from fitting visually in a cell , the display extends over neighboring cells.

Numerals :

Numerals contain all the decimal digits such as 0 to 9 on which you can do addition, subtraction, multiplication and other mathematical or statistical operations. Numeric calculations is most common thing which is done in excel 

Logical Value: 

You can enter the logical values namely, TRUE & FALSE into cell. Logical values are often used in writing conditional formulas.

Error : 

An error value is a distinct type of data . For Example, if a formula attempts to divide a number by zero , the result is the #DIV/ 0! Error Value.


Comments

Popular posts from this blog

DIFFERENT OPERATORS IN MS-EXCEL

                                    OPERATORS   Operators are used in formulas to execute operations on the values taken by formulas.  Excel use 4 types of operators : 1.Arithmetic Operators 2.Text Concatenation Operators  3.Comparison Operators  4.Reference Operators  www.ebeescorp.com Arithmetic Operators This operation will explained through example Example  Text Concatenation Operators   This operation will explained through example Example  Comparison Operators  To compare values you can create formulas using comparison operators. These operators return a TRUE or FALSE result depending how the formula evaluate the condition .Some common operator are as follow: Reference Operators  Reference operators enable you to combine absolute and relative references and na...

COMPUTER ABBREVIATIONS & SOME INVENTORS

ABBREVIATIONS EBEESCORP www.ebeescorp.com Inventors Of Computer Hardware  (1) Key board — Herman Hollerith, first keypunch device in 1930 (2) Transistor — John Bardeen, Walter Brattain & Wiliam Shockley (1947 - 1948) (3) RAM —        An Wang and Jay Forrester (1951) (4) Trackball — Tom Cranston and Fred Longstaff (1952) (5) Hard Disk — IBM , The IBM Model 350 Disk File (1956 ) (6) Integrated Circuit — Jack Kilby & Robert Noyce (1958) (7) Computer Mouse — Douglas Engelbart (1964) (8) Laser printer — Gary Stark weather at XEROX in (1969) (9) Floppy Disk — Alan Shugart & IBM( 1970) (10) Microprocessor — Faggin, Hoff&Mazor – Intel 4004 COMPUTER TRAINING CENTER 9717717164

CHARACTERISTICS OF A COMPUTER & CENTRAL PROCESSING UNIT (C.P.U)

Hello, Readers This Blog will help you understand the Characteristics of Computer & About C.P.U (Central Processing Unit ). Characteristic means Computer capabilities i.e Characteristics of Computer  1.Speed 2.Accuracy 3.Consistency 4. Data Storing Capability 5.Flexibility  A. Speed : A Computer is a very fast device .It can perform , in a few Second ,the amount of work that a human being can do in an entire year working round the clock .The speed of the computer is usually 2 to 4 GHz . A powerful computer is capable of performing  about 10 to 40 million arithmetic calculations in a second. or We can say that Computer speed is measured in   megahertz (MHz) or gigahertz (GHz). One Megahertz equals to one million ticks per second,one Gigahertz equals one billion ticks per second . B. Accuracy : The accuracy of a Computer is consistently high an the degree o accuracy of a particular task is 100% accurate.In  a every computer each and e...