GMetrix Practice Exam 2 Training Excel Expert 365 MO-211

SUBSCRIBE to get the next learning videos
GMetrix Excel Expert 365 MOS - 211 :
1. Practice Exam 1 Training
• GMetrix Practice Exam ...
2. Practice Exam 2 Training
• GMetrix Practice Exam ...
3. Practice Exam 3 Training
• GMetrix Practice Exam ...
4. Skill Review 1 Training
• GMetrix Skill Review 1...
5. Skill Review 2 Training
• GMetrix Skill Review 2...
HOW TO PASS EXCEL JOB TEST (Part 1).
FORMULAS COMBINE VLOOKUP + LEFT, RIGHT, MID, IF(OR), SUMIF
• HOW TO PASS EXCEL JOB ...
HOW TO PASS EXCEL JOB TEST (Part 2).
VLOOKUP+LEFT, MID, IF+VLOOKUP, DATEDIF, SUMIF
• SOAL & JAWABAN TES BUM...
DOWNLOAD, INSTALL & CREATE BARCODE / IDAutomation IN EXCEL
• DOWNLOAD, INSTALL & CR...
bit.ly/IDAutom...
TUTORIAL TO CREATE DATA RECAP IN EXCEL
• TUTORIAL MEMBUAT REKAP...
bit.ly/IDAutom...
4 Tricks Set The Size Rows & Columns In Excel
• 4 Trik Mengatur Ukuran...
How to create invoice/receipt (Excel No Coding)
• HOW TO CREATE INVOICE/...
Excel Tricks How to faster add rows in cells
• Excel Tricks How to in...
8 TRICKS TO CREATE SEQUENCE NUMBERS IN MS.EXCEL 2021 / 365
• 8 TRICKS TO CREATE SEQ...
I will upload the next learning video.
Please wait for my next video.
Thank you for watching my videos.
Like, Subscribe, Comment, Share All my videos @EvaWahyuni-Learn-IT
#exceltricks #excel #exceltutorial #excel365 #excelfunctions #exceltips #excelformula #vlookup #hlookup #videoyoutube #microsoft #microsoftexcel #informationtechnology #microsoftoffice365 #microsoftoffice #ifformula #iffunction #rumusif

[@bexsigmatech]

Project 3, Task 2 is wrong as the selection for conditional format must start from cell A3.

[@EvaWahyuni-Learn-IT]

@bexsigmatech Previously I had tried starting the selection from cell A3 but the results were wrong in that system. Please check at the 13:46 minute, the final third grade project results have all been corrected (checklist). Thanks

[@kimijones8710]

For Project 2 Task 1, shouldn't Adult Annual Pass (US $) be formatted as an area chart instead of a column chart? This is very helpful, thank you for posting.

[@EvaWahyuni-Learn-IT]

Hi @kimijones8710 Yes, you are right, I answered incorrectly according to the question, but the answer desired by the GMetrix system turned out to be a column chart. it was corrected (checklist) at the end of project 2

[@merykassis]

How can I do a practice exam myself?

[@EvaWahyuni-Learn-IT]

@merykassis Watch and wait for my next learning videos. For Gmetrix, you could contact the Microsoft team.

[@merykassis]

I mean, practicing a test needs purchase or is it free?

[@merykassis]

I watched your videos and now I need to practice a test before the real one

[@EvaWahyuni-Learn-IT]

@@merykassis Purchase order, GMetrix is not free.

[@mushfiqsuleymanli9064]

Be careful!!! you did mistake on the project 3 task 2

[@EvaWahyuni-Learn-IT]

@mushfiqsuleymanli9064 Yes, you are right, the results were not as expected. However, that is the answer the system wants, if the Feedback from "Grade Project" is checked, it means it is correct

[@mushfiqsuleymanli9064]

@@EvaWahyuni-Learn-IT thx, I sent you a e-mail can u answer it?

[@EvaWahyuni-Learn-IT]

@@mushfiqsuleymanli9064 Previously I tried the correct method, but in the GMetrix system it turned out to be incorrect. Thank you for your attention, Sir

[@WronaMW]

You are right. To fix the error: instead of selecting whole A column at the beginning, select only range of cells from A3.