Posts

Digital Literacy

Digital Literacy 1. How to download file from Gmail?  Answer:   -> open gmail app  -> go to inbox  -> open the gmail which has attechment  -> now click the download option on the            file which you want to download.  -> now the file is saved to your phone /     computer / laptop.  2. What is formula for Vlookup?  Answer: VLOOKUP - Vertical lookup  = vlookup(lookup value, table array, column index number, range lookup)  3. What is the formula of countif?  Answer: Count (condition) = countif(range,criteria)  4. What is pivot table and explain how to do it?  Answer: Pivot table is a systematic table which counts all data like sum, average, counts and many more.     We can change row data to column and also column data to row.     We can summarise large mount of dates into small spce.    Steps to create a pivot table  --...

Aptitude (Math) All Formula

Aptitude (Math) All Formula   1:                  SUM of the Numbers  Average = -------------------------------------                         Number of Values                             Situation-1  2: Percentage = Part / Whole × 100                            Situation-2           = Part / 100 × Whole, 20% of 450  3: Simple interest              PTR 1. SI = ---------              100  2. SI = Amount - Principal,. A-P   3. A = P + SI                SI × 100  4. R = ----------------                   PT         ...

Aptitude Test-1

  Aptitude Test-1   1. Question: Multiply 38.639×2.08.                         Answer: 38.639                × 2.08              ----------------               309112               00000             77278            -------------------             80.36912 Answer is : 80.36912  2. Question: Divide 2747÷ 16 Answer:                         16| 2747 |171.6875                   | 16      |               --------------------                     114         ...

All Formula of MS Excel

      All Formula of MS Excel       1- Total = SUM(Range)   2- Average = Average (Range)   3- Percentage = Part/Whole      1- Count (Number) = count(range)   2- Count ( Number and texts) = counta(range)  3- Count (Blank cells) = countblank (range)  4- Count (condition) = countif(range,criteria)          1-VLOOKUP - Vertical lookup  = vlookup(lookup value, table array, column index number, range lookup)

What is Pivot Table ?

  What is Pivot Table ?       Pivot table is a systematic table which counts all data like sum, average, counts and many more.     We can change row date to column and also column dates to row.     We can summarise large mount of dates into small spce.     Steps to create a pivot table  --> Open WPS office app + Ss Bs  --> Write some datas  --> Now select all datas  --> Then go to insert tab  --> Then click pivot table  --> Then click ( done ) option  --> Now new window will open  --> You can see 3 fields  --> Then click and drag one by one field according to our recruitment  --> Finally click Export option  

Aptitude Skype Questions And Answers

  Aptitude Skype Questions And Answers 1. Question: What are Natural Numbers ? Answer: A Natural number is a whole number  that we use for counting. They have an order that we learn when we are very young. one, two, three Example: Sometimes called counting numbers are 1,2,3,4 and so on. The numbers that we count with 1,2,3,4........................ 2. Question: What are Even numbers ? Give example. Answer: Any number that can be exactly divided by 2 is called as an even number. even numbers always end up with the last digit as 0,2,4,6 or 8  some examples of even numbers are 2,4,6,8,10,12,14,16 3. Question: What are Odd Numbers ? Give Examples. Answer: A whole number that is not able to be divided two into two equal whole numbers.  Example: The numbers 1,3,5 and 7 are odd numbers. 4. Question: What are Prime Numbers ? Give Examples. Answer: Prime numbers are those numbers which are divided for itself. Prime numbers are the numbers that have only two factor, that are,...

How to send gmail and download attach file

How to send gmail and download attach file How to send an email to gmail? . Open the gmail app . click on compose option . now new window will open  . now write the Email id of the receipant . now write subject line in subject box . then write letter / text on body of the email . then click attach file option to attach any file / documents . now finally click the send option. . now the email will be sent to that person.   How to download file from gmail ? -> open gmail app -> go to inbox -> open the gmail which has attechment -> now click the download option on the file which you want to download. -> now the file is saved to your phone / computer / laptop.