facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Free Excel Test – Concatenate, Convert Text to Columns & Remove Duplicates – Excel 2010

Concatenate Function, Convert Text to Columns & Remove Duplicates Excel Test

Free Online Microsoft Excel Test
Excel 2010 Training – Working with Data

* How to Use the Concatenate Function
* Convert Text to Columns
* Remove Duplicate Values

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Concatenate Function, Convert Text to Columns & Remove Duplicates Excel Test

Question 1 - Concatenate Function, Convert Text to Columns & Remove Duplicates Excel Test
1) Study the screenshot above.  Which of the formulas below will result in the values in the House Number column being joined to the value in the Street Name column when entered into cell C2 (Address 1 column). 
a) =CONCATENATE(A2,” “,B2)
b) =A2+B2
c) = CONCATENATE(A2, B2)
d) =CONCATENATE(A2)


Question 2 - Concatenate Function, Convert Text to Columns & Remove Duplicates Excel Test
2) Study the screenshot above.  Which function in Excel can you use to separate the names and surnames contained in column A (Name) so that each surname appears in the adjoining cell in column B (Surname)?
a) Use the Concatenate function to separate the names and surnames.
b) Use the Trim function to separate the names and surnames.
c) Use the Split Column function to separate the names and surnames.
d) Use the Text to Columns function to separate the names and surnames.


3) Which of the following is the best method for removing duplicate values in a worksheet?
a) Use the Highlight Cell Rules – Duplicate Values option to automatically delete duplicate entries on the worksheet.
b) Use the Find and Replace function to find and automatically replace duplicate entries on the worksheet.
c) Use the Remove Duplicates option in the Data Tools group to automatically delete duplicate entries on the worksheet.
d) All of the options above are correct.


4) Where on the Excel screen do you find the Concatenate function?
a) In the Data tools group under the Data tab on the Ribbon.
b) In the Function Library group under the Formula tab on the Ribbon.
c) In the Outline group under the Data tab on the Ribbon.
d) In the Function group under the Insert tab on the Ribbon.


5) Which of the following is NOT a valid delimiter that you can instruct Excel to use to separate text or other values into columns?
a) Space
b) Colon
c) Asterisk
d) All of the above are valid delimiters.


6) What is the purpose of inserting the blank quotation marks in the Concatenate function?
a) They connect different arguments in the formula together.
b) They are a separate argument that is used to insert blank spaces between values that are being joined together.
c) They are placeholders in the formula for where you are not sure which values need to be joint together.
d) They are used to insert quotation marks when concatenating text strings.


7) Where will you find the Convert Text to Columns Wizard?
a) Under the Home tab on the Ribbon, in the Cells group.
b) Under the Insert tab on the Ribbon, in the Data group.
c) Under the Data tab on the Ribbon, in the Data tools group.
d) By pressing the shortcut: Ctrl+W to launch the Wizard.


Question 8 - Concatenate Function, Convert Text to Columns & Remove Duplicates Excel Test
8) Study the screenshot above.  What will be the result if the contents of the selected cell in column C (circled in yellow) is copied and pasted as is into a different worksheet (i.e. without selecting a specific Paste option)?
a) The address 32A Basil Street will be pasted.
b) The concatenate formula will be pasted.
c) A blank cell will be pasted.
d) All of the above are incorrect.


9) Which of the following values CANNOT be joined together using concatenate?
a) Names and surnames.
b) Dialing codes and telephone numbers.
c) Currency symbols and numbers.
d) All of the above listed values can be joint together using CONCATENATE.


10) Stacy was working on a worksheet containing thousands of entries for her boss. She noticed that there were some people whose details were entered on the worksheet twice. She selected the Name column only and then clicked on Remove Duplicates.  Directly after doing this she realized it was a mistake as she had removed all people with the same first name instead of just the duplicates.  How can she restore the deleted entries?
a) She can click on the Undo button or use Ctrl+Z.
b) She cannot fix this. Hopefully she made a backup copy of the worksheet and can start over.
c) She can right-click and select Restore Duplicates.
d) She can click on the Paste button and select Paste Values.



* More from TestsTestsTests.com