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!
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!
