Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help! I will give thumbs up and review!! (Part 8 of 11) SUM - Totals one or more numbers in a range of cells.
Please help! I will give thumbs up and review!! (Part 8 of 11)
SUM - Totals one or more numbers in a range of cells. How To: Select a blank cell where you want the total to be. In that cell type =SLM([range of cells]] and then select the range of cells you wish to add together by clicking your mouse and dragging the curser across the applicable cells. Then hit Enter. Concatenate - Combines data from multiple cells How To: If you have a cell that contains a first name and another cell that contains a last name, you can combine those cells together and also include arbitrary strings of characters such as a spaces [ " "), or comma space [ ", ), or even whole words or phrases. Select the empty cell where you want the function to be stored > Click the Formula button [fx) on the Formula bar > In the Category dropdown list, select Text > In the Function area, select Concatenate, then click Enter > Select Text1 in the Concatenate dialog box, then either click a cell on the sheet or type some text > Select Text2 in the Concatenate dialog box, then either click a cell on the sheet or type some text > Repeat two previous steps as necessary, then click K. In this example, the text elements for a last name, a comma followed by a space, and a first name are combined to make the text string "Beverly. Martha." You have to add", " as Text2. If you wanted to combine the cells to say "Martha Beverly" Text2 needs to be "". Task Instructions: Use the Concatenate formula to combine the first and last names listed below into one cell per name. The first and last name should be separated by a spaceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started