 |
| Ads by BDS |
HOW TO OPEN THE EXCEL PROGRAM
1) Click on the “Icon” of Excel from the startup Program Menu Bar; or,
2) Click on the Excel Icon of the Taskbar; or
3) Click Start àAll Programs à Microsoft Office à Microsoft Office Excel 97/2000/XP.
HOW TO ENTER DATA INTO THE WORKSHEET
1) Place the pointer into the target cell
2) Type the required Data, then press ENTER or, press any arrow key.
HOW TO SAVE A NEW FILE (WORKSHEET)
1) Click on File Menu, then “Save” button (In short-cut: Ctrl + S or, Click on “Save” Icon)
2) Type a name in the “File Name” Box, then click “Save” button.
HOW TO EDIT A CELL-CONTENT
1) Place the cell pointer on the target cell where you typed data
2) Press F2 (Function Key)
3) Press Left-Arrow key to take pointer to the target word/words
4) Delete the wrong one by using DELETE / BACKSPACE Key, or Type the missing one.
5) Retype the Data if necessary
6) Press ENTER to finish the editing.
HOW TO DECLARE THE TABLE BOUNDERIES
1) Select the Table Area by using Shift key and Arrow keys, or by using the mouse
2) Click on the BORDERS Icon, then click on ALL BORDERS Button to declare all borders at a time.
3) Or, Right-click on the selected area, Click on Format Cells, then click on BORDER Button
4) Then select the appropriate Borders from the Dialogue Box, then click on OK
HOW TO REMOVE TABLE BORDERS
1) Select the area of the table from where borders would be removed
2) Right click on the selected area
3) Click on “Format Cells” button, then click on BORDER option
4) Remove the border from the Dialogue Box, the click OK.
HOW TO REMOVE GRID LINES FROM THE WORKSHEET
1) Click on TOOLS menu, OPTIONS button, then click on VIEW button
2) Remove “TICK Mark” from the “Gridlines” Box, then click OK.
HOW TO ADJUST COLUMN WIDTH WITH COLUMN CONTENT
1) Place the “Mouse Pointer” on the Right Border of Column Heading
2) Then press and hold down the “Left Button” of the Mouse and drag it to LEFT or RIGHT Order as required.
3) Then release the button to finish the task
HOW TO TAKE PRINT OF THE WORKSHEET
Firstly, select the range of the spreadsheet of which you want the print. To select the range of area to printed follow the steps:
1) Select or highlight the required area by Mouse or by the pressing Shift-Key and Arrow keys as necessary.
2) Click on “File” Menu, “Print Area”, then “Set Print Area”
Then declare command as below:
Process – 01:
*) Click on the “PRINT” Icon to print all pages/whole area at a time
*) Ctrl + P, then Enter
Process – 02:
1) Click on “FILE Menu”, then on “Print” (or in short-cut: “Ctrl + P”).
2) Press OK button or Press Enter to print all pages (whole selected area) at a time of the current document.
3) or, Select Pages Radio Button, set From: <page number> and To: <page number> then OK or press Enter to print range of pages only.
4) or, Click on “Selection” Radio Button, then OK or press Enter to print selected area only.
HOW TO ENTER FORMULA INTO THE WORKSHEET
* To create FORMULA like: “25 x 200 = 5000”
1) Place Cell Pointer on the target CELL where you want the result
2) Type =25*200, then press Enter.
* To create FORMULA like: “500 + 200 – 300 = 400”
1) Place Cell Pointer on the target CELL where you want the result
2) Type =500+200-300, then press Enter.
* To create FORMULA like: “D5 * E5 = (Result)”, (This is a Cell Reference Formula).
1) Place Cell Pointer on the target CELL where you want the result
2) Type =D5*E5, then press Enter. Or,
3) Type =, then place pointer on cell D5, type *, then place the pointer on cell E5. Press Enter.
HOW TO AUTOSUM THE NUMERIC DATA OF A COLUMN
1) Select all numeric data in the column with a BLANK cell below where result would be arrived.
2) Click on ‘AutoSum’ Button
HOW TO SUM THE NUMERIC DATA OF A COLUMN
1) Place Cell Pointer on the target CELL where you want the result
2) Type “=sum(<First Cell Address> : <Last Cell Address>)”, Press Enter.
HOW TO COPY THE CONTENT OF THE WORKSHEET
1) Select the content or select the range of contents
2) Press Ctrl + C (or, press COPY Icon, or click on “Edit” menu, then click on “Copy” button)
3) Place the cell pointer where you want to paste the copied contents
4) Press Ctrl + V (or, press PASTE Icon, or click on “Edit” menu, then click on “Paste” button)
HOW TO CUT (MOVE) THE CONTENT OF THE WORKSHEET
1) Select the content or select the range of contents
2) Press Ctrl + X (or, press CUT Icon, or click on “Edit” menu, then click on “CUT” button)
3) Place the cell pointer where you want to paste the cut/moved contents
4) Press Ctrl + V (or, press PASTE Icon, or click on “Edit” menu, then click on “Paste” button)
HOW TO EXPAND ROW HEIGHT OF THE SELECTED RANGE
1) Click and hold down the Left-Mouse button on the first ROW number on left
2) Drag the mouse pointer downward up to your requirements, then release the button
3) Right-click on the selected area
4) Click on “Row Height”
5) Enter the desired number into adjacent box, then click OK.
HOW TO EXPAND COLUMN WIDTH OF THE SELECTED RANGE
1) Click and hold down the Left-Mouse button on the first “COLUMN Heading” on the top
2) Drag the mouse pointer rightward up to your requirements, then release the button
3) Right-click on the selected area
4) Click on “Column Width”
5) Enter the desired number into adjacent box, then click OK.
HOW TO MAKE CENTER ALIGNED ACROSS THE SELECTION
1) Select the range from the first cell to last range
2) Right-click on the selected range
3) Click on “Format Cells”, then on “Alignment”
4) Click into the “Horizontal:” Box
5) Select “Center Across Selection”, then OK.
HOW TO SELECT ENTIRE WORKSHEET
** Click on the “First Cell” of the “Row Numbers” and “Column Numbers” (or, Simply press “Ctrl+A”)
HOW TO MAKE THE CONTENTS “CENTER ALIGNED” VERTICALLY
1) Select Entire Worksheet by pressing “Ctrl+A”
2) Right-click on the selection
3) Click “Format Cells”, “Alignment”, then “Vertical”
4) Select “CENTER” from the list, then OK.
HOW TO CHANGE FONTS (FONT TYPE, SIZE, APPEARNCE, COLOR, etc.) OF THE CONTENTS
Font Type - Arial, Century, Courier New, Times New Roman, Tahoma, etc.
Size - 10 pt., 12 pt., 16 pt., 24 pt., 36 pt., 48 pt., 72 pt., 120 pt., etc.
Appearance - Bold, Italic, Underline, Double underline, etc.
Color - Blue, Red, Yellow, Green, etc.
** Select the content of the worksheet first, then, perform the tasks as below:
1) Click on “Bold (Ctrl+B)”, “Italic (Ctrl+I)”, “Underline (Ctrl+U)”, etc. Icon as per requirements.
2) Set color from the “Font Color” button as per requirement.
3) Change the font type from the “Font” button
4) Change the font size from the “Font size” button
We can change all things from the “Font” Dialogue box (Click “Format” menu, “Cells”, the “Font” button) also. After appearing the font dialogue box, we can select the required items from there. To finish the task, press OK.
HOW TO INSERT NEW ROW INTO THE WORKSHEET
1) Select the range of the rows (number of rows) by clicking and dragging on the row numbers left of the worksheet
2) Right-click on the selection area, then click on the “Insert”.
HOW TO INSERT NEW COLUMN INTO THE WORKSHEET
1) Select the range of the columns (number of columns) by clicking and dragging on the column heading top of the worksheet
2) Right-click on the selection area, then click on the “Insert”.
HOW TO DELETE COLUMN(S) OF THE WORKSHEET
1) Select the range of the columns (number of columns) by clicking and dragging on the column heading top of the worksheet
2) Right-click on the selection area, then click on the “Delete”.
HOW TO DELETE ROW(S) OF THE WORKSHEET
1) Select the range of the rows (number of rows) by clicking and dragging on the row numbers left of the worksheet
2) Right-click on the selection area, then click on the “Delete”.
HOW TO INSERT NEW WORKSHEET INTO THE CURRENT WORKBOOK
** Click on “Insert” menu, then “Worksheet” button; or,
** Right-click on a sheet number, click on “Insert” from the dialogue box, then OK.
HOW TO DELETE A WORKSHEET FROM THE CURRENT WORKBOOK
1) Click on the “Worksheet Button” below of the running workbook which we want to delete
2) Click on “Edit” menu, then “Delete Sheet” (or, Simply right-click on the target sheet number below of the running workbook, then click “Delete” and click on “Delete” again).
3) For confirm deletion, click on “Delete” button.
HOW TO FILL NUMBERS AUTOMATICALLY IN THE COLUMN
1) Type 1 into the first cell
2) Select the whole column along with the first cell
3) Click “Edit” menu, click on “Fill”, then on “Series”
4) Type the “Step value” (1 or as per your demand), and “Stop Value” (as per your requirements), then click OK.
HOW TO SETUP THE PAGE FOR THE PRINTING WORKS
1) Click on “File” menu, “Page Setup”, then click on “Page” button.
2) Select “Paper size” from drop down list
3) Select “Portrait” (Default) or “Landscape” mode for printing mode
4) If you want the print in a single sheet for the larger one, select “Fit to” button and type 1 – 1 in the relevant boxes.
5) Click on “Margin” button to set margin of the page
6) Set margins (left, right, top and bottom) from the dialogue box
7) Select “Center on page” option for printing works (Horizontally and/or Vertically), then press OK.
INTRODUCTION TO THE USE OF FUNCTIONS:
IF function:
Format: =IF(logical_test,value_if_true,value_if_false)
Example: =IF(F5>=80 AND(F5<=89), “A”, “Other”)
=IF(AND(F5>=40,F5<=54),"D", IF(AND(F5>=55,F5<=64),"C", IF(AND(F5>=65,F5<=74),"B", IF(AND(F5>=75, F5<=84), "A", IF(AND(F5>=85, F5<=100), "A+",”F”)))))
That formula is for counting the grade of the examination of a school.
SUM function:
Format: 1) =SUM(v1,v2,v3,v4,………)
2) =SUM(F3:F20)
COUNT function:
Format: =COUNT(v1,v2,v3,v4,………)
=COUNT(A5:M10)
AVERAGE function:
Format: =AVG(v1,v2,v3,………..)
=AVG(A5:L20)
*** How to count Percentage?
1) = (Target No. * 100)/Total Number
Example: =(58*100)/589 (ENTER)
2) 12% is to be 0.12 (after formatting, it will be 12%)
*** How to divide numbers?
= Divisible number/Divider (ENTER)
Example: =580/25 (ENTER)
*** How to multiply numbers?
= Number1*Number2*Number3….(ENTER)
Example: =20*25*30 … (ENTER)
*** How to Add numbers?
= Number1+Number2+Number3 ….(ENTER)
Example: =580+250+350… (ENTER)
*** How to subtract numbers?
= Principle Number – Sub Number1- Sub Number2….(ENTER)
Example: =580-25-120 (ENTER)
No comments:
Post a Comment