Computer Lessons

 MS-Excel  (IF FUNCTION) YouTube video link:  https://youtu.be/RW9tC36SLuw If is used to give condition. As we say in Hindi, "अगर ऐसा होता तो यह होता वरना ये होता।", same as happens when we apply IF Function. It's syntax is: if(<condition>, True Statement, False Statement) Above statement means that if a condition given is True, than result will be whatever has been written in true, else the result will be whatever has been written in false place.  e.g. if(A1>500, "Yes", "No") In the above case if number entered in cell A1 is more than 500 than the cell in which formula has been given will reflect Yes, if it is less than 500 than it will result in No.  For understanding operators, how they function you watch our MS-Excel OPERATORS YouTube video:  https://youtu.be/s4qmKemxTMw Multiple IF Function When we have to apply more than one condition than we use multiple IF function. In this, at place of False statement we write another if with a true a

How to use Whatsapp on your Computer? Most of us know that we can use Whatsapp on mobile only. In this blog I would like to share how to use Whatsapp on Computer. For using Whatsapp on Computer we should have  1. Mobile with Whatsapp installed. 2. Computer with Internet facility. 3. Browser installed on Computer (normally all computers have it). We have to open our preferred browser, you can use any Google Chrome, Microsoft Edge, Torch, etc.  Here in the address bar you have to type:  web.whatsapp.com  Once you entered this a page would appear  with QR Code  as given below: In computer following instructions appear: Once you follow the above instructions properly you can see your mobile groups and contacts on computer on left side and in right side you can see your chat.  It makes easy for you to get your data downloaded on computer or sending any computer file to your contacts.  You can send following things as attachments: 1. Create Room: With this option you can create a room for a

Cut, Copy and Paste (Files and Folders) You all must be aware of Cut (Ctrl + x), Copy  (Ctrl + c)  & Paste   (Ctrl + v)   commands and probably would have used it several times in Word, Excel, or any other application.  Normally copying and pasting is not a typical task. But in case of files and folders one should know how to select files & how to paste them after copying.  Selection: For selecting more than one file we can use shift and control key along with mouse. Suppose in a folder in which we have to select more than one file and they are in sequence than we can click on first file and than keeping Shift Key pressed can click on the last file to be selected. This will select all the files in between. After that we can use Cut/ Copy command. When files are in sequence we can also use our keyboard to select the files. Click on the first file and use down or up arrow key for selecting the other files.  In case these files are in random order than keeping Control key (Ctrl) 

  How to use Google Translate Though it is easy to use Google Translate, I still thought of writing a blog on it.  So, first we should have a internet connection and chrome or any browser installed on it where we can open Google Translate. What we have to do is to first select the text which we want to get translated. Than we will open Google translate in the browser. It will appear as: Here we have to paste or type the copied text where Enter text is written. But before that we have to select the language which we want to translate and also the language in which we want the translation to be. As in above case the language to be entered is English and in which it would be translated is Hindi.  As we can see that how translation is done here in above example. It is easy to get the things translated from English to Hindi. But if we want to translate some Hindi matter into English than we have to type it in Hindi Indic Font. It should be installed to your computer it is easily available o

Wildcard Characters in Excel (*, ?, ~) Asterisk (*), Question Mark (?), Tilde (~) A wildcard character is a special character which is used in Excel formulas to find matching text. It is used in functions where criteria's are used. Such functions are: AVERAGEIF, AVERAGEIFS COUNTIF, COUNTIFS SUMIF, SUMIFS VLOOKUP, HLOOKUP MATCH SEARCH ? is used for finding 1 character * is used for any number of characters. ~ is used for special character.  Example wildcard usage Usage Behavior Will match ? Any one character "A", "B", "c", "z", etc. ?? Any two characters "AA", "AZ", "zz", etc. ??? Any three characters "Jet", "AAA", "ccc", etc. * Any characters "apple", "APPLE", "A100", etc. *th Ends in

MS-Excel  (Sum, Average, Count) When we select the number of cells to be applied with the formula of SUM/ AVERAGE/ COUNT in the lower right we can see all the three written. SUM SUM:  Sum is used to do addition of the values in the selected cells, the values should be numbers. If by mistake there is a symbol or alphabet written it will still give you sum of those cells which are having numbers. To apply SUM formula there are three methods: 1. Go to the cell where you want to apply SUM formula here write the formula as given below: @sum(starting cell : ending cell) eg: @sum(a1:a5)   will result in 2. Select the cells you want the sum of and press Alt + + (i.e. press symbol of Plus with alt) and you will get the sum just below the last number selected. You can use this vertically and horizontally both.  (a)   (b)  (a) Selecting like this (b) after pressing Alt + + Selecting this  after pressing Alt + + 3. In this method we simply use symbol of + and write as  + a1+a2+a3+a4+a5   in the ce

  Tables in MS-Word (Part - 3) (Borders & Shading) Page Borders In Borders and Shading second tab is Page Border . In borders tab we give borders to lines of paragraph and table lines, whereas in Page Border we give border to whole page. Here also we can select that where we want to give lines and where we don't want to. Line selection can be done under preview section i.e. - top, bottom, left and right border lines.  Box, shadow, 3-D are same as in Border. Style- In this we choose the style of line that will appear as border. For example if we choose below given style and press ok it will appear like this.  Color: In this we can choose different types of color which we want to give to border. But when we choose art in border than the colors of art won't change, they remain as they are shown in the art. Width: In this we define the width of the border. Art: In this there are different kinds of artistic borders which can be applied. They have their own colors which can'