Please help! I will give thumbs up and review!! (Part 8 of 11) ...

60.1K

Verified Solution

Question

Finance

Please help! I will give thumbs up and review!! (Part 8 of 11)

image 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 space

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students