Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Financial Markets

Authors: Keith Pilbeam

2nd Edition

1403948356, 978-1403948359

More Books

Students also viewed these Finance questions

Question

Complexity of linear search is O ( n ) . Your answer: True False

Answered: 1 week ago