Dear Friends,
Please like, subscribe and join my YouTube and telegram channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like, subscribe and join my YouTube and telegram channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Dear Friends,
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
Dear Friends,
I am doing my best to share the content on Excel in this group and requesting you all to please do more and more practice and ask your doubts in chat box.
Further I am also working on MS Word content as per demand from group members, shortly I will share the details.
Please do practice and like and subscribe the Telegram and YouTube Chennal.
Thank You
I am doing my best to share the content on Excel in this group and requesting you all to please do more and more practice and ask your doubts in chat box.
Further I am also working on MS Word content as per demand from group members, shortly I will share the details.
Please do practice and like and subscribe the Telegram and YouTube Chennal.
Thank You
Hlookup will help you to find the data from which side ?
Anonymous Quiz
40%
Left to Right
24%
Right to Left
29%
Top to Bottom
7%
Bottom to top
What should be a correct formula for sum in excel ?
Anonymous Quiz
67%
=Sum(B3:B9)
23%
=Sum(B3+B9)
7%
Sum(B3:B9)
3%
=Add(B3:B9)
Which Button allows you to copy cell formats from one cell to another?
Anonymous Quiz
17%
Enter
24%
Auto-fit
52%
Format Painter
7%
Esc
*Question of the day*
Question: - Which function we can use to find out the 2nd position from the bottom?
Options: -
Question: - Which function we can use to find out the 2nd position from the bottom?
Options: -
Anonymous Quiz
20%
Max
35%
Min
33%
Small
12%
Large
M.S. Office, Excel, PowerPoint, Word pinned «*Question of the day*
Question: - Which function we can use to find out the 2nd position from the bottom?
Options: -»
Question: - Which function we can use to find out the 2nd position from the bottom?
Options: -»
An Excel Workbook is a collection of....
?
?
Anonymous Quiz
10%
Workbooks
80%
Worksheets
4%
Charts
6%
Formulas
M.S. Office, Excel, PowerPoint, Word pinned «An Excel Workbook is a collection of....
?»
?»
What is the intersection of a column and a row in a worksheet called?
Anonymous Quiz
9%
Column
8%
Value
12%
Address
71%
Cell
Question : -
Which function in Excel checks whether a condition is true or not ?
Which function in Excel checks whether a condition is true or not ?
Anonymous Quiz
8%
SUM
12%
COUNT
74%
IF
6%
AVERAGE
Which function in Excel tells how many numeric entries are there ?
Anonymous Quiz
16%
NUM
58%
COUNT
11%
SUM
14%
CHECKNUM
What is the difference between SUMIF and SUMIFS?
Anonymous Quiz
10%
Both are same.
7%
No difference.
16%
SUMIF and SUMIFS are for single condition.
67%
SUMIF is for single condition and SUMIFS for Multiple Condition.
The software which contains rows and columns is called:-
Anonymous Quiz
74%
Spreadsheet
11%
Word
10%
Database
6%
None of th above
Forwarded from M.S. Office, Excel, PowerPoint, Word
Question: - What is Paste in Excel?
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Shortcut key to do following functions in Excel.
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Forwarded from M.S. Office, Excel, PowerPoint, Word
Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -