Master the MOS Excel Practice Exam 2 with Voiceover || GMetrix Practice 2023 || Excel 365-2019

[@edbee816]

I passed the Microsoft Excel Associate (Office 2019) exam 900/1000 following this video and your part one. Thank you! Now on to the Expert!

[@TechRatedDev]

Rooting for you ★🚀

[@Inndusinsights]

bro. please share some tips as well, important formulas or something?

[@mariajosebajana7246]

2:52 navigate the cell - and deleted the only content leaving the empty cell 3:36 download worksheet, adjust the height of rows 4:43 create a table with headers from cell range- 5:52 insert a footer that displays todays date on the right and then return to normal view 7:45 import- located in- forder as a table on a new worksheet 9:35 remove the conditional formatting from- on the- 11:57 display the cost worksheet in the page layout view. Then insert a page break between- 12:54 use a built in excel feature to copy all the formatting of cell- 14:06 enter a formula in cell a29 that uses an excel function to return the average cost 15:02 include the total profit data on the flavor expenses income and profit chart 15:37 filter the profit worksheet to display only flavors with a cost that is above average 16:59 add the value new rates to the title property of the document 17:50 set cell- so that yhey will be only cells that print 18:45 save the rooms worksheet as a webpage name- to the gmetrix forlder 19:50 configure the heading row in the table row so that entries wider that the column wrap to multiple lines. 21:18 split the view of the sold worksheet so only rows- appear in the top pane and the remaining rows appear in the bottom pane 22:09 configure - so rows- remain visible as u scroll vertical 22:47 on the sold worksheet format the table so that every other row is shaded similar to the table on the vehicles 23:37 insert a function into cell- of the code column that extract the two leftmost letter of the vehicle style 28:05 apply a number format to display the number in columns- two decimal places with us dollar$ 29:21 change the configuration of the- chart so that displays the months on the x and the revenue y 31:15 add a row to the table that automatically calculate the total hours worked by all employees 31:42 add a function so that displays the word YES if the value in- is higher than 40 Oder wise display no 34:28 use a function to copy the name from cell- and format the name so that all letters are uppercase 35:48 create a 3d clustered column that shows the call time for friday by each salesperson

[@tashinamiller9097]

Your video helped me so much. I was able to score 885/1000! Thank you for this!

[@TechRatedDev]

Great job!

[@Inndusinsights]

wow, great , any important tips? im going to appear this month.

[@benlawson2810]

Complete lifesaver in preparing fr my excel MOS exam!! I give you all my thanks.

[@user-qt2ys7tm3q]

These videos have helped me immensely when preparing for my Excel MOS Exam! Thank you for making these!

[@TechRatedDev]

Great to hear!

[@epicgyroquest]

Awesome video.

[@pejamsle42]

Thank you so much, Do you still have MOS 201 expert practice test voice over?

[@stephaniemorris9143]

I am working on this today to prepare for the exam next week. Thank you so much!

[@TechRatedDev]

Best of luck Stephanie!

[@Inndusinsights]

how was it please share some tips , im going to appear this month.

[@gudtarz4087]

This friday I have my Mo-200 exam I hope to pass it

[@TechRatedDev]

Goodluck

[@Inndusinsights]

how was it bro? i m going to appear in this month, please let me know important points or formulas.

[@brookehopkins1908]

This was super helpful! Would you be bale to make videos for the expert practice exams on gmetrix?

[@TechRatedDev]

Yes Brooke, of course! I will try. Thanks.

[@Inndusinsights]

rest questions were quite easy except one or two .

[@TechRatedDev]

Okay

[@valerie.mccaffrey]

for the very last problem should you also select the Salesman column when making the chart? Taking my test tomorrow!

[@mamamtl]

I think it would be quicker to use Set Print Range instead of Print Titles in project 4 task 3.

[@TechRatedDev]

That's correct. That works too.

[@Juniperswim14]

Hello my friend, thank you so much for your videos, I want to take the exam but I don't get what is the difference between MOS exam 1 and the exam 2. Could you elaborate please?

[@TechRatedDev]

Holla. MOS 1 and MOS 2 are just two practice exams you can take before your exams. You’ll be lucky to find questions in either exam 1 or 2 in your main exam.

[@Juniperswim14]

@@TechRatedDev hey! Thank you so much for your help! I just passed the exam!!

[@ceppi2158]

goat

[@gung6770]

Can you do word and powerpoint?

[@TechRatedDev]

Okay

[@lourencocosta]

what is the acess code? Please :( They didn't give us the acess code at university

[@lourencocosta]

I can't find any link to the acess code

[@tyelston5945]

@@lourencocostayou have to buy the access code. there isn’t one access code to gmetrix, every access code is user specific.

[@RonaldoLuisFuentesEspejo-mg2ld]

Jajaja no te entendi ni verga pero gracias pase con 1000/1000

[@TechRatedDev]

Haha. Congrats