All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc