Forwarded from M.S. Office, Excel, PowerPoint, Word
☝️🟢Step 1: - Click on Cell ‘I9’ and press ‘=’ this will activate the cell to use function and start typing ‘Vlookup’.
Forwarded from M.S. Office, Excel, PowerPoint, Word
✌️🟢Step 2: - After Typing ‘Vlookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟🟣Step 3: - Select ‘Lookup Value in Cell H9’ as given in the syntax.
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
Forwarded from M.S. Office, Excel, PowerPoint, Word
✌️✌️🟢Step 4: - After selecting ‘Lookup Value in cell H9’, Select ‘Table Array from Cell D9 to E19’ from which you want to find the results of ‘lookup value’.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟✌️🟣Step 5: - After selecting Table array please put coma (,) and the third field will reflect ‘Col_Index_Num’ which means from which column you want to find the results, Type number 2 here.
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Discount Percentage based on Sale Value and Discount Percentage is lying in second column that is why we typed 2 here).
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Discount Percentage based on Sale Value and Discount Percentage is lying in second column that is why we typed 2 here).
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