Questions about the MOS Excel Specialist exam (2016 version)

azygos

New Member
Joined
Jun 7, 2019
Messages
1
I am planning to take this exam and I already did a practice test, which was okay but some of the questions confused me. I hope someone can help me.

But first, is it allowed to use keyboard shortcuts on the exam? Does Certiport's software only look at the end solution, or do I need to do the right steps with my mouse to get all of the points?

Secondly, please look at some of these questions because I really am not sure if I understand what they want from me.


Question 1

The question was "Change the formatting in C11 to display the column heading on 2 lines. The column heading was on C4, so I don't know why they mentioned cell C11? " I know of only two ways to display text on 2 lines in Excel, and that is the manual way using alt+Enter, and by wrapping the text. But them telling me of a cell (C11) to modify a column's (C) heading - I don't uderstand what they want and how I should do it. Does anyone know what they meant? The C column has a textual heading and dates filled out, if that helps.

Question 2

"Configure the worksheet so Row 11 and Columns A and B are always visible." Do I only need to freeze rows up to 11 and columns A and B? I doubt they wanted me to do some window-splitting magic and only freeze row 11, right?

Thank you!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top