Daily Microsoft Office Quiz
Quiz 5. Which function in Excel checks whether a condition is true or not ? For more, visit here: https://bit.ly/Technical_Portal
Quiz 5. Which function in Excel checks whether a condition is true or not ? For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
6%
A. SUM
8%
B. COUNT
83%
C. IF
3%
D. AVERAGE
👍5
VLOOKUP MASTERY
Hello everyone! We all know how to use the Vlookup function in Excel right? A vlookup function contains only one criteria. But sometimes we need more criteria included into a Vlookup function to get the required results. Though it is so easy to include multiple criteria into a Vlookup function, because of lack of the knowledge of correctly using it, we face problems in doing it.
So here in this series, you’ll know the important tips and tricks of Vlookup and other lookup functions in a simple way including the practical.
What are you waiting for? Get set & learn! Don’t forget to share your opinion!
https://www.youtube.com/watch?v=bVh5R_iCSJU&list=PLEpT0yTBCR7w6sfuQ1bX82tgtpWdCN4Ix&index=3
.
.
.
.
#technicalportal #PowerQuery #ExcelCourse #MsExcel #exceltraining #selflearning #Pivot #pivottables #learnexcel #DataAnalytics #dataanalysis #VLOOKUP #XLOOKUP #excelformulas
Hello everyone! We all know how to use the Vlookup function in Excel right? A vlookup function contains only one criteria. But sometimes we need more criteria included into a Vlookup function to get the required results. Though it is so easy to include multiple criteria into a Vlookup function, because of lack of the knowledge of correctly using it, we face problems in doing it.
So here in this series, you’ll know the important tips and tricks of Vlookup and other lookup functions in a simple way including the practical.
What are you waiting for? Get set & learn! Don’t forget to share your opinion!
https://www.youtube.com/watch?v=bVh5R_iCSJU&list=PLEpT0yTBCR7w6sfuQ1bX82tgtpWdCN4Ix&index=3
.
.
.
.
#technicalportal #PowerQuery #ExcelCourse #MsExcel #exceltraining #selflearning #Pivot #pivottables #learnexcel #DataAnalytics #dataanalysis #VLOOKUP #XLOOKUP #excelformulas
👍4❤1
*VBA & Automated Short Codes*
Do you want to learn Excel VBA and want to get deep knowledge about it from scratch? Here is the solution to learn it!
And interesting part is you'll get all Data-files absolutely for *FREE*!
🔶 Microsoft Excel VBA Series
👉 https://www.youtube.com/watch?v=zeL1dCYsAEI&list=PLEpT0yTBCR7zVJ3Zsv36VLA_hfyf-RA7j&index=1&t=2s
🔶 Microsoft Excel Short Codes of Macro & VBA
👉 https://www.youtube.com/watch?v=Bm86g0VXEXM&list=PLEpT0yTBCR7z3FRWpE3BgxJjL1QaPECna&index=1
.
.
.
.
#technicalportal #PowerQuery #ExcelCourse #MsExcel #exceltraining #selflearning #Pivot #pivottables #learnexcel #DataAnalytics #dataanalysis #VLOOKUP #XLOOKUP #excelformulas
Do you want to learn Excel VBA and want to get deep knowledge about it from scratch? Here is the solution to learn it!
And interesting part is you'll get all Data-files absolutely for *FREE*!
🔶 Microsoft Excel VBA Series
👉 https://www.youtube.com/watch?v=zeL1dCYsAEI&list=PLEpT0yTBCR7zVJ3Zsv36VLA_hfyf-RA7j&index=1&t=2s
🔶 Microsoft Excel Short Codes of Macro & VBA
👉 https://www.youtube.com/watch?v=Bm86g0VXEXM&list=PLEpT0yTBCR7z3FRWpE3BgxJjL1QaPECna&index=1
.
.
.
.
#technicalportal #PowerQuery #ExcelCourse #MsExcel #exceltraining #selflearning #Pivot #pivottables #learnexcel #DataAnalytics #dataanalysis #VLOOKUP #XLOOKUP #excelformulas
👍7❤3
Daily Microsoft Office Quiz
Quiz 5. How do you change the column width to fit the contents? For more, visit here: https://bit.ly/Technical_Portal
Quiz 5. How do you change the column width to fit the contents? For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
17%
A. Single-click the boundary to the left of the column heading.
70%
B. Double-click the boundary to the right of the column heading.
14%
C. Press ALT and single-click anywhere in the column.
👍3❤2
Daily Microsoft Office Quiz
Quiz 7. The Greater Than sign (>) is an example of _____ operator. For more, visit here: https://bit.ly/Technical_Portal
Quiz 7. The Greater Than sign (>) is an example of _____ operator. For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
19%
A. Arithmetic
31%
B. Logical
31%
C. Conditional
19%
D. Greater
👏2
Daily Microsoft Office Quiz
Quiz 8. The process of arranging the items of a column in some sequence or order is known as : For more, visit here: https://bit.ly/Technical_Portal
Quiz 8. The process of arranging the items of a column in some sequence or order is known as : For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
18%
A. Arranging
18%
B. Auto-Fill
53%
C. Sorting
10%
D. Filtering
👍3
|| ANNOUNCEMENT ||
Learn VBA, Dashboards, Pivot Table, Chart, Functions, Formulas and many more in Microsoft Excel.
Hello everyone.
Do you want all Microsoft Excel and Microsoft Office Package tutorial under one shelter?
Here is the solution. Here you can Learn Excel VBA, Dashboards,Pivot Table, Chart, Functions, Formulas and many more, which are already uploaded.
And many more videos are already in queue.
So why waiting?
Some Popular Playlists from this channel is,
🔶 Microsoft Excel Pivot Table & Dashboard
👉 https://bit.ly/PivotTable_Dashboard
.
🔶 Microsoft Excel Financial Analysis Series
👉 https://bit.ly/ExcelFinancial_Analysis
.
🔶 Microsoft Excel "LOOKUP" Series
👉 https://bit.ly/ExcelLookup_Series
.
🔶 Microsoft Excel Short Codes of Macro & VBA
👉 https://bit.ly/VBA_ShortCodes
.
🔶 Microsoft Excel VBA Series
👉 https://bit.ly/LearnVBA_series
.
🔶 Microsoft Excel Miscellaneous Series
👉 https://bit.ly/ExcelMiscellaneous
#TechnicalPortal
#MicrosoftExcelSoftware
#PivotTable
Learn VBA, Dashboards, Pivot Table, Chart, Functions, Formulas and many more in Microsoft Excel.
Hello everyone.
Do you want all Microsoft Excel and Microsoft Office Package tutorial under one shelter?
Here is the solution. Here you can Learn Excel VBA, Dashboards,Pivot Table, Chart, Functions, Formulas and many more, which are already uploaded.
And many more videos are already in queue.
So why waiting?
Some Popular Playlists from this channel is,
🔶 Microsoft Excel Pivot Table & Dashboard
👉 https://bit.ly/PivotTable_Dashboard
.
🔶 Microsoft Excel Financial Analysis Series
👉 https://bit.ly/ExcelFinancial_Analysis
.
🔶 Microsoft Excel "LOOKUP" Series
👉 https://bit.ly/ExcelLookup_Series
.
🔶 Microsoft Excel Short Codes of Macro & VBA
👉 https://bit.ly/VBA_ShortCodes
.
🔶 Microsoft Excel VBA Series
👉 https://bit.ly/LearnVBA_series
.
🔶 Microsoft Excel Miscellaneous Series
👉 https://bit.ly/ExcelMiscellaneous
#TechnicalPortal
#MicrosoftExcelSoftware
#PivotTable
👍28❤2🔥2👏1
Daily Microsoft Office Quiz
Quiz 9. The ____ feature of MS Excel quickly completes a series of data. For more, visit here: https://bit.ly/Technical_Portal
Quiz 9. The ____ feature of MS Excel quickly completes a series of data. For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
16%
A. Auto Complete
66%
B. Auto Fill
10%
C. Fill Handel
8%
D. Sorting
👍6❤2👏2
Daily Microsoft Office Quiz
Quiz 10. What is the keyboard shortcut key to lock cell references in a formula? For more, visit here: https://bit.ly/Technical_Portal
Quiz 10. What is the keyboard shortcut key to lock cell references in a formula? For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
16%
A. ALT
22%
B. F2
50%
C. F4
11%
D. CTRL
👍9❤6😢3👎2🔥2🤩1
Daily Microsoft Office Quiz
Quiz 11. You can complete a cell entry by pressing: . For more, visit here: https://bit.ly/Technical_Portal
Quiz 11. You can complete a cell entry by pressing: . For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
44%
A. Enter
10%
B. Tab
15%
C. Shift + Tab
28%
D. All of the above
4%
E. None of the above
👍9👏1
Daily Microsoft Office Quiz
Quiz 13. A_______ is a group of cells that form a rectangle on the screen. . For more, visit here: https://bit.ly/Technical_Portal
Quiz 13. A_______ is a group of cells that form a rectangle on the screen. . For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
11%
A. Label
12%
B. Workbook
33%
C. Worksheet
17%
D. Column
27%
E. Range
👍7❤2👏2
Daily Microsoft Office Quiz
Quiz 14. How you can identify that a range is active? . For more, visit here: https://bit.ly/Technical_Portal
Quiz 14. How you can identify that a range is active? . For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
50%
A. It is highlighted on the screen.
30%
B. It has a marquee around it.
16%
C. The data changes to Bold to let me know it's active.
4%
D. I'm psychic & I just Know
👍7👏2❤1
Daily Microsoft Office Quiz
Quiz 15. An example of a range address: . For more, visit here: https://bit.ly/Technical_Portal
Quiz 15. An example of a range address: . For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
72%
A. A1:B3
11%
B. A1;B3
8%
C. A1-B3
5%
D. A1=B3
4%
E. A1*B3
👍23❤8👏4😱3👎1
Daily Microsoft Office Quiz
Quiz 16. When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________... . For more, visit here: https://bit.ly/Technical_Portal
Quiz 16. When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________... . For more, visit here: https://bit.ly/Technical_Portal
Anonymous Quiz
32%
A. Cell Selector
16%
B. Cell Cross
27%
C. Selection Pointer
25%
D. Range Selector
👍65❤23👎6👏6😱6🔥5🤨4