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 --...