42:23 Task 3. The task asked for descending order but didn't specify which column. So is it wrong if we sort it by descending based on 1st column (e.g. the national park column)?
Yes, you need Microsoft Excel 365 to do the Test/Exam on MOS Excel (Microsoft 365 Apps) or you can upgrade to Office 2021. Upgrading to Microsoft 365 or Office 2021 will give you full access to all the features and resources needed to complete all the tasks. Ensure you purchase a genuine office license.
In the Microsoft Office Specialist (MOS) exam, you generally don't need to manually save each project after completing a task. The exam platform typically autosaves your work as you progress. When you click on the SUBMIT PROJECT Button, it saves your work and moves to the next project. However, it’s a good idea to follow any specific instructions given during the exam. If a task instructs you to save the project, make sure to do so.. After you complete the tasks for a project, you will submit the project and start the next project. The RESTART PROJECT Button closes and reopens the current project without saving your changes. You can use these features to display status indicators on the task tab and in the Exam Summary: (i)MARK COMPLETE Displays ✅to indicate that the task is complete. (ii)MARK FOR REVIEW Displays 🚩to indicate that you want to review the task before you finish the exam. The EXAM SUMMARY opens after you submit the final project. You can revisit tasks and make changes until you finish the exam. Select FINISH EXAM to submit your answers, stop the exam timer, and move to the feedback stage of the exam. You cannot change your answers after you finish the exam.• Select DISPLAY SCORE REPORT to exit Feedback Mode and display your exam results.
@@matthewalo8309 thank you sir. Actually this morning was my exam and sadly I'm not pass the exam (500+/700). I'm so frustrating like a angry wolverine and I want to retake the exam later. I will never give up 😤
@@asrafulnazrin4943 You’ve got this, and I believe in you. You’ve shown a lot of strength and commitment so far, and I’m confident you can overcome this hurdle. Let’s turn this experience into a stepping stone towards your next success. If you need help with studying and preparation, I am available to assist. Here are the links to other Practice Test Videos to help you in your preparation: PRACTICE EXAM 2: ruclips.net/video/lYmjnfwFPcE/видео.html PRACTICE EXAM 3: ruclips.net/video/0zEZLJtGYFs/видео.html SKILL REVIEW 1: ruclips.net/video/ON6pARlIJis/видео.html Ensure you watch the video repeatedly and pay close attention to the details. All the best!
My students are getting 940 out of 1000 in mos365... Even though they are doing in correct way, they are loosing marks. Mainly from manage sheets and workbook section... Can you pls help sir
It's remarkable that your students are scoring high. Given that your students are consistently scoring scoring 940 out of 1000 is a clear indication that your students have a strong grasp of Excel but may be missing out on few key details in the "Manage Sheets and Workbook" Section. The "Manage Sheets and Workbook" section can be tricky, and even small mistakes or missed details can lead to lost points. Here are some specific tips to help your students avoid losing marks: (1) Correct Sheet Naming and Reordering: ✔Ensure that sheets are named exactly as required, including proper capitalization, spacing, and punctuation. ✔When reordering sheets, students should double-check the sequence to ensure it matches the instructions exactly. (2) Managing Workbook Views: ✔Hiding/Unhiding Sheets: Students should practice hiding and unhiding sheets without affecting the overall structure of the workbook. ✔Freezing Panes: They should know how to freeze and unfreeze rows and columns correctly, making sure that the correct panes are frozen as required in the exam. (3) Workbook Protection: ✔Password Protection: If the exam asks for workbook protection, ensure that they practise both protecting and unprotecting sheets and workbooks. ✔Setting Permissions: They should be familiar with setting permissions for specific users or for different levels of access (e.g., allowing edits only in certain cells). (4) Navigating Workbooks: ✔Encourage them to use the "Go To" feature or the "Name Box" for quickly jumping to specific cells, ranges, or named ranges. This can help reduce errors when managing large workbooks. (5) Managing Workbook Properties: ✔Editing Document Properties: Students should be comfortable with accessing and editing workbook properties like title, author, and tags, as these are often required in the exam. (6) Regular Practice in Simulated Environments: ✔Timed Practice: Simulate exam conditions by timing their practice sessions. This will help them manage their time better and avoid small mistakes made under pressure. (7) Attention to Detail: ✔Reviewing Work: Encourage students to review their tasks, especially after making changes to sheets or workbooks, to ensure they have followed the instructions exactly. By focusing on these areas, your students should be able to close the smalls gaps that are preventing them from achieving a perfect score in their MOS Excel exam. I wish them all the best!
I want to thank you Mr. Alo for these videos on the MOS 210 exam. I just passed my exam today and it was all thanks to your teachings.
Congratulations! I'm so happy the videos helped, and you passed your exam.
sir thank you always for the video may god bless you
tj
SIR thankyou
from your student
thank you for sharing and teaching
👍
My pleasure
My pleasure
Love it!!!!!!!!!!!!!!!!!!
Thank you so much! I'm really glad you enjoyed the video.
made me pass my exam with a 1000
Thank you Matthew Alo, Its really helpful and Kindly , How do we get the test online to get certification MO 210 ?
I'm glad you found it helpful. Kindly email yemlarisglobal1@gmail.com and you will be guided.
Thank you for video , but in minute 28:04 you have change the angle of storage while the question not include the text
Thank you
42:23 Task 3. The task asked for descending order but didn't specify which column. So is it wrong if we sort it by descending based on 1st column (e.g. the national park column)?
Do you need excel Microsoft 365 in order to do the test? I still have office 2016 and am thinking of upgrading to Microsoft 365.
Yes, you need Microsoft Excel 365 to do the Test/Exam on MOS Excel (Microsoft 365 Apps) or you can upgrade to Office 2021. Upgrading to Microsoft 365 or Office 2021 will give you full access to all the features and resources needed to complete all the tasks. Ensure you purchase a genuine office license.
Hello, where can I find these files to practice as well?
Hi sir, Do we need to save the project after we complete the task for each project in the exam?
In the Microsoft Office Specialist (MOS) exam, you generally don't need to manually save each project after completing a task. The exam platform typically autosaves your work as you progress.
When you click on the SUBMIT PROJECT Button, it saves your work and moves to the next project. However, it’s a good idea to follow any specific instructions given during the exam. If a task instructs you to save the project, make sure to do so.. After you complete the tasks for a project, you will submit the project and start the next project.
The RESTART PROJECT Button closes and reopens the current project without saving your changes.
You can use these features to display status indicators on the task tab and in the Exam Summary:
(i)MARK COMPLETE Displays ✅to indicate that the task is complete.
(ii)MARK FOR REVIEW Displays 🚩to indicate that you want to review the task before you finish the exam.
The EXAM SUMMARY opens after you submit the final project. You can revisit tasks and make changes until you finish the exam.
Select FINISH EXAM to submit your answers, stop the exam timer, and move to the feedback stage of the exam. You cannot change your answers after you finish the exam.•
Select DISPLAY SCORE REPORT to exit Feedback Mode and display your exam results.
@@matthewalo8309 thank you sir. Actually this morning was my exam and sadly I'm not pass the exam (500+/700). I'm so frustrating like a angry wolverine and I want to retake the exam later. I will never give up 😤
@@asrafulnazrin4943 You’ve got this, and I believe in you. You’ve shown a lot of strength and commitment so far, and I’m confident you can overcome this hurdle. Let’s turn this experience into a stepping stone towards your next success.
If you need help with studying and preparation, I am available to assist.
Here are the links to other Practice Test Videos to help you in your preparation:
PRACTICE EXAM 2: ruclips.net/video/lYmjnfwFPcE/видео.html
PRACTICE EXAM 3: ruclips.net/video/0zEZLJtGYFs/видео.html
SKILL REVIEW 1: ruclips.net/video/ON6pARlIJis/видео.html
Ensure you watch the video repeatedly and pay close attention to the details.
All the best!
@@matthewalo8309 Thank you sir. I appreciate it.
Done
Stop repeating the sentences of the tasks please ;) Keep on sharing, great job 👍👍
it is a good habit to read task at least two time for better understanding
Thanks for the comments.
@@armaghankhan3938, thanks for the response.
My students are getting 940 out of 1000 in mos365... Even though they are doing in correct way, they are loosing marks. Mainly from manage sheets and workbook section... Can you pls help sir
It's remarkable that your students are scoring high. Given that your students are consistently scoring scoring 940 out of 1000 is a clear indication that your students have a strong grasp of Excel but may be missing out on few key details in the "Manage Sheets and Workbook" Section.
The "Manage Sheets and Workbook" section can be tricky, and even small mistakes or missed details can lead to lost points.
Here are some specific tips to help your students avoid losing marks:
(1) Correct Sheet Naming and Reordering:
✔Ensure that sheets are named exactly as required, including proper capitalization, spacing, and punctuation.
✔When reordering sheets, students should double-check the sequence to ensure it matches the instructions exactly.
(2) Managing Workbook Views:
✔Hiding/Unhiding Sheets: Students should practice hiding and unhiding sheets without affecting the overall structure of the workbook.
✔Freezing Panes: They should know how to freeze and unfreeze rows and columns correctly, making sure that the correct panes are frozen as required in the exam.
(3) Workbook Protection:
✔Password Protection: If the exam asks for workbook protection, ensure that they practise both protecting and unprotecting sheets and workbooks.
✔Setting Permissions: They should be familiar with setting permissions for specific users or for different levels of access (e.g., allowing edits only in certain cells).
(4) Navigating Workbooks:
✔Encourage them to use the "Go To" feature or the "Name Box" for quickly jumping to specific cells, ranges, or named ranges. This can help reduce errors when managing large workbooks.
(5) Managing Workbook Properties:
✔Editing Document Properties: Students should be comfortable with accessing and editing workbook properties like title, author, and tags, as these are often required in the exam.
(6) Regular Practice in Simulated Environments:
✔Timed Practice: Simulate exam conditions by timing their practice sessions. This will help them manage their time better and avoid small mistakes made under pressure.
(7) Attention to Detail:
✔Reviewing Work: Encourage students to review their tasks, especially after making changes to sheets or workbooks, to ensure they have followed the instructions exactly.
By focusing on these areas, your students should be able to close the smalls gaps that are preventing them from achieving a perfect score in their MOS Excel exam.
I wish them all the best!
Thank you sir for your valuable reply
🎉
Hello, do you mind sharing the files for the training? @matthewAlo