Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟🤟🟣Step 6: - After selecting ‘Col_Index_Num’ the fourth field will reflect ‘Range_lookup ‘ (1 for approximate match --> ‘True’ and 0 is for Exact Match --> ‘False’), will select 1 for Approximate Match now.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟✌️✌️🟣Step 7: - After selecting 1, close the brackets ‘)’ and press ‘Enter’ or ‘Tab’.
You can see the yellow highlighted Cell I9 Discount Percentage has come out of the Table A which is given in front of 100. but other results are not matching, because this is Approximate Match, and the system will find the lower nearest results based on approximation. As you can see in below examples: -
1. In front of 250 the percentage is 10% which is of 200.
2. In front of 650 the percentage is 30% which is of 600.
You can see the yellow highlighted Cell I9 Discount Percentage has come out of the Table A which is given in front of 100. but other results are not matching, because this is Approximate Match, and the system will find the lower nearest results based on approximation. As you can see in below examples: -
1. In front of 250 the percentage is 10% which is of 200.
2. In front of 650 the percentage is 30% which is of 600.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
Please like and subscribe my youtube channel so that I can come up with Lookup and Vlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like and subscribe my youtube channel so that I can come up with Lookup and Vlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
What is the intersection of a column and a row on a worksheet called ?
Anonymous Quiz
69%
Cell
11%
Value
14%
Address
6%
Column
Which function in Excel tells how many numeric entries are there ?
Anonymous Quiz
18%
SUM
66%
COUNT
8%
SUM
8%
CHKSUM
M.S. Office, Excel, PowerPoint, Word pinned «Which function in Excel tells how many numeric entries are there ?»
Question:-
Statistical calculations and preparation of tables can be done using?
Statistical calculations and preparation of tables can be done using?
Anonymous Quiz
5%
Adobe Photoshop
86%
Excel
8%
Powerpoint
2%
Notepad
Question:-
............. appear at the bottom of the Excel window.
............. appear at the bottom of the Excel window.
Anonymous Quiz
21%
Title bar
15%
Formula bar
56%
Worksheet tabs
8%
Name box
Dear Friends,
Please like and subscribe my youtube channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like and subscribe my youtube channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Hi Friends,
Shorty I will be sharing more videos/Questions/ Content of MS Office please try to do more practice and ask your questions.
Thank You
Shorty I will be sharing more videos/Questions/ Content of MS Office please try to do more practice and ask your questions.
Thank You
The process of arranging the items of a column in some sequence or order is known as :
Anonymous Quiz
24%
Arranging
22%
Autofill
45%
Sorting
8%
Filtering
What ud the value of the following MS Excel function?
=FLOOR (14,4)
=FLOOR (14,4)
Anonymous Quiz
29%
10
14%
13
35%
14
22%
12
Typed text visible in active cell and also in which location___?
Anonymous Quiz
60%
Formula bar
15%
Ribbon
20%
Title bar
5%
Scroll bar
🤔♦️➡️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.
➡️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
Dear Friends,
Please do practice and ask your doubts.
Thank You
Please do practice and ask your doubts.
Thank You
Statistical calculations and preparation of tables and graphs can be done using?
Anonymous Quiz
7%
Adobe Photoshop
82%
Excel
4%
Notepad
7%
Powerpoint
The ____ feature of MS Excel quickly completes a series of data?
Anonymous Quiz
23%
Auto Complete
60%
Auto Fill
7%
Fill Handle
10%
Sorting
Hi Friends,
Due to some personal issue not actively participating.
Will start shortly.
Thank You
Due to some personal issue not actively participating.
Will start shortly.
Thank You