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
--> Open WPS office app
--> 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
--> Row field, column field, data field
--> Then click and drag one by one field according to our recruitment
--> Finally click Export option
5. How to send a Email to other person i in gmail?
Answer: . 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.
6. What is data validation and share your screen?
Answer: Data validation is option which is use in MS Excel or creating drop-down list in the required cells it restrict other data from the list given/select.
7. What is sort and filter . show it?
Answer: Sort option in use MS Excel to arrange data from largest to smallest or smallest to largest and also assessing or descending order.
Filter option in use MS Excel to find out value or the text which we want to see.
8. What is conditional formatting, explain it?
Answer: Conditional formatting is one type of option in use MS Excel to Highlight the cells according to our recruitment.
9. What is the formula of Total, average and Percentage, Explain it?
Answer: All Formula
Excel Formula
1- Total = SUM(Range)
2- Average = Average (Range)
3- Percentage = Part/Whole
Math 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
10. Share your screen for explaining print option?
Answer:
Open the WPS Office app
Click the + Button, Spreadsheet, Blank sheet
Write some datas
Click the Tools button
Go to the File Tab
Click the print option
Then click print
Select Print service
Then Save the file & print
11. What is warp text and merge & center, show it?
Answer: Wrap text means
Warp text in use for long text to fit in the cells by creating a new line inside the cells without increasing the column width.
Merge text means
Merge this option in use in MS Excel for joining or mixing two or more cells.
Open the WPS Office
Click+ Button, Spreadsheet, Blank sheet
Write some datas
Go to the Home tab
click the wrap text & merge
12. What is google drive & show how to create a folder on it and upload a file?
Answer: Google drive is a pen drive or storage system we use the platform for create a folder & store our data & any time anywhere access our data from a gmail account.
Open the google drive
Click the + button
Create a folder
Click+ button
Click the upload option
Select any datas or file
and click upload option
Now the the file or data save from google drive
13. Share your screen to show all count formula?
Answer:
Open the WPS Office
Click the+ button, spreadsheet, blank sheet
Write some datas
Put the all count formula
Now you can see the result
14. Find out the values by putting VLOOKUP formula?
Answer:
Open the WPS Office
Click the + button, spreadsheet, Blank sheet
Write some datas or values
Put the Vlookup all formula & find out the result
15. Format the texts by using Font style, font size, font color, Border, fill colour in Ms Word.
Answer:
Open the Ms Word
Click the + button
Click the Doc
Click Blank sheet
Write some datas
Click tools button
Click the font style & change style
Click the font size & change size
Click the texts color & change colour
Click the border & set border type
Click the highlight color & fill colour in Ms Ward.
16. Tell the process about how to share the Excel file in WhatsApp Group?
Answer:
Open the WPS Office
Click the + button, spreadsheet, Blank sheet
Write some datas
Go to the tools button
Go to the file option
Click share as option
Click original file
Click save rename the file save
Click the WhatsApp option & share the file.
17. How to insert new column and new Row within a data, share your screen?
Answer: Insert column
Open the WPS Office
Click the + button, spreadsheet, Blank sheet
Write some datas
Click the Column which has insert column
Click the tools button
Go to the insert tab
Click the cells button
Click the column
Now you can see insert a column
Insert Row
Click the Row which has insert Row
Click the tools button
Go to the insert tab
Click the cells button
Click the Row
Now you can see insert a Row
18. What is process of insert a table in Ms Word?
Answer:
Open the WPS Office
Click the + button, Doc, Blank sheet
Go to the tools button
Go to the insert tab
Click table select table type
19. How to save a file in your Document?
Answer: Open the WPS Office
Click the + button, spreadsheet, blank sheet
Write some datas
Go to the tools button
Go to the file tab
Click save button & rename file & save
Now you can see the file is saved on your phone/computer/laptop
20. How to insert a new sheet and rename it in Ms Excel, Explain it?
Answer:
Open the Ms Word
Click the + button
Click the Spreadsheet
Now new window will open
Click the right corner + button
Now you can see insert a new sheet
Comments
Post a Comment