Spread Sheets Tools

Question 1

Remove blank cells how ?

Answer 1

Highlight all cells -click Data- create filter, filter by condition- select is empty.

Question 2

How to transpose data ?

Answer 2

Copy data- paste spatial transpose.

Question 3

Get rid of extra spaces in the values?

Answer 3

Highlight data-click on Data- select Data clean up- trim white spaces.

Question 4

Change text lower upper case and proper case?

Answer 4

Select Data- use extension- select choice.

Question 5

How to delete formatting?

Answer 5

Select range -select format-conditional formatting.( there is a lot of choices one can use on the format tool.

Question 6

How to remove duplicates?

Answer 6

Select Data- remove duplicates.

Question 7

Date format consistency

Answer 7

Select column- format- choose date.

Question 8

Split tool( use tool to separate string by a delimiter.

Answer 8

Highlight column- Data- split text to string.

Question 9

How many tools have I learned ?

Answer 9

Select and remove blank cells =filters.
Transpose data.
Get rid of extra white spaces.
Change text.
Delete formatting.
Use conditional format.
Remove duplicates.
Date format.
Split.