Question description:
This user has given permission to use the problem statement for this
blog.
If I merged a multi-row, multi-column selection. Iand types some text into the merged cell and then unmerges it, what will happen to the text?
Solved by S. Y. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/08/2018 - 03:34
Welcome, Thanks for choosing Got It Pro-Excel.
Excelchat Expert
14/08/2018 - 03:36
If you merge cells, type text into the merged cells, unmerging the cells will push the text merged to the first cell of the initially merged range.
Excelchat Expert
14/08/2018 - 03:40
After Merge:
[Uploaded an Excel file]
Excelchat Expert
14/08/2018 - 03:40
After Unmerge:
[Uploaded an Excel file]
Excelchat Expert
14/08/2018 - 03:40
Hope this solves your problem.
Excelchat Expert
14/08/2018 - 03:40
If this does not solve the problem, kindly let us know. Thank you.
User
14/08/2018 - 03:46
no so nothing changes then right
User
14/08/2018 - 03:46
this is the questions
User
14/08/2018 - 03:46
Sarah has merged a multi-row, multi-column selection. If she types some text into the merged cell and then unmerges it, what will happen to the text?
User
14/08/2018 - 03:47
got it now
Excelchat Expert
14/08/2018 - 03:48
The text will be pushed to the first cell of the range merged.
Excelchat Expert
14/08/2018 - 03:48
I am happy you have understood this.
Excelchat Expert
14/08/2018 - 03:48
Is there any other question in regards to this?
User
14/08/2018 - 03:48
no but i have another questions
User
14/08/2018 - 03:48
1. By default, gridlines are enabled for View and disabled for Print.
2. By default, headings are disabled for View and enabled for Print.
User
14/08/2018 - 03:49
is both statements true?
Excelchat Expert
14/08/2018 - 03:50
No
Excelchat Expert
14/08/2018 - 03:50
The first one is true, while the second one is FALSE
User
14/08/2018 - 03:51
ok thanks i'm learning excel so i have a few questions
Excelchat Expert
14/08/2018 - 03:51
That is great.
User
14/08/2018 - 03:52
Which of the following is not an option in the Clear dropdown list of the Home tab in Excel 2010
User
14/08/2018 - 03:52
Clear Comments
B. Clear Contents
C. Clear Formats
D. Clear Hyperlinks
E. Clear Values
User
14/08/2018 - 03:52
Thanks for your help i' m taking notes as i ask theses questions
Excelchat Expert
14/08/2018 - 03:53
E. Clear Values
User
14/08/2018 - 03:54
The following figure shows the Alignment group in the Home tab. Looking at the horizontal and vertical alignment settings, and assuming that there is a text in the cell, where will it appear?
question Image
User
14/08/2018 - 03:54
wrong one sorry one minute
Excelchat Expert
14/08/2018 - 03:55
Okay.
User
14/08/2018 - 03:56
What would the name of the column next to column GXZ be?
User
14/08/2018 - 03:56
would it be?
User
14/08/2018 - 03:56
A. GXZA
B. GYZ
C. HAA
D. GY
E. GYA
User
14/08/2018 - 03:56
i say b is this correct
Excelchat Expert
14/08/2018 - 03:57
B. GYZ
Excelchat Expert
14/08/2018 - 03:57
Yeah, you are CORRECT
User
14/08/2018 - 03:57
yeahhh i'm getting just a few more
User
14/08/2018 - 03:58
How does Excel 2010 behave by default when String type data in a cell grows larger than the cell width?
User
14/08/2018 - 03:58
The new text automatically wraps to next line.
B. Excel doesn't allow any more typing in that cell.
C. The text that doesn't fit within the cell width is always hidden.
D. The text that doesn't fit within the cell width is hidden if the cell to the right contains data. Otherwise, it displays all of the text, as long as the cells to the right are empty.
E. The text that doesn't fit within the cell width is hidden and an ellipsis (three dots) is shown at the end of the text in that cell, to indicate that there's more text than is currently visible.
Excelchat Expert
14/08/2018 - 03:59
D. The text that doesn't fit within the cell width is hidden if the cell to the right contains data. Otherwise, it displays all of the text, as long as the cells to the right are empty.
User
14/08/2018 - 04:00
What happens when you double-click the bottom border of a selected cell or range of cells in a data region?
User
14/08/2018 - 04:00
i say a is this correct
Excelchat Expert
14/08/2018 - 04:02
Where are the options?
User
14/08/2018 - 04:02
sorry here they are
User
14/08/2018 - 04:02
A. Nothing happens.
B. The selection moves to the last cell of the current column of the sheet.
C. The Format Cells dialog box appears with the Border tab selected.
D. The contents of the current cell are copied to the cell below the current one.
E. The selection moves to the bottom edge of the current data region.
User
14/08/2018 - 04:05
hello are you there
Excelchat Expert
14/08/2018 - 04:07
E. The selection moves to the bottom edge of the current data region.
User
14/08/2018 - 04:08
ok thanks another one..
User
14/08/2018 - 04:08
Placing your mouse pointer on the divider line between column headers changes the cursor shape to a double-headed arrow. Double-clicking at this point will ___________.
User
14/08/2018 - 04:08
. hide the column to the left of the divider line
B. hide the column to the right of the divider line
C. resize the column to match the widest contents cell of the column
D. bring up the column width dialog box, to allow you to change the column size manually
E. hide the column headers
User
14/08/2018 - 04:08
i think d m i right
Excelchat Expert
14/08/2018 - 04:09
C. resize the column to match the widest contents cell of the column
User
14/08/2018 - 04:10
Excel's COS() function computes the cosine of the input angle, where the input angle should be in radians. How can you use this formula if your values are in degrees?
User
14/08/2018 - 04:10
Use the RADIANS() function on the input values.
B. Use the DEGREES() function on the input values.
C. There is no need for conversion. Excel 2010 can automatically determine whether a value is in degrees or radians.
D. The COSH() function can be used in this situation.
E. The COSINEANGLE() function can be used in this situation.
User
14/08/2018 - 04:11
Im lost on this but i say B am i correct or no
Excelchat Expert
14/08/2018 - 04:13
B. Use the DEGREES() function on the input values.
Excelchat Expert
14/08/2018 - 04:13
You are CORRECT
User
14/08/2018 - 04:14
Now How does Excel treat circular references?
User
14/08/2018 - 04:14
Excel 2010 automatically converts formulas with circular references to an absolute address scheme.
B. Excel 2010 allows circular references without any caveats.
C. Excel does not allow circular references.
D. Excel allows circular references, but it warns the user about them.
E. none of the above
User
14/08/2018 - 04:14
theses are some questions from a pre test
Excelchat Expert
14/08/2018 - 04:17
D. Excel allows circular references, but it warns the user about them.
Excelchat Expert
14/08/2018 - 04:29
Is there any other question?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.