Question

Name the following. 1. Sunil wants to use the number system that has only two digits.  2. Raj wants to find how many cells in a spreadsheet contain number and not text.  3. RIA wants to present data in a pictorial form.​

Answer 1

Answer:

$\huge\bold\red{ANSWER :-}$

• However, if you try to combine text with numbers (or currencies/percentages/dates) directly in a cell in Google Sheets, you’ll notice the numbers loses any formatting, which will make the number harder to read or even less meaningful:

e.g. Total: 5250

e.g. Discount: 0.355

• You can use the TEXT function to fix this, and apply formatting to numbers that are displayed with text in a cell.

Answer 2

Answer:

However, if you try to combine text with numbers (or currencies/percentages/dates) directly in a cell in Google Sheets, you’ll notice the numbers loses any formatting, which will make the number harder to read or even less meaningful:

e.g. Total: 5250

e.g. Discount: 0.355

You can use the TEXT function to fix this, and apply formatting to numbers that are displayed with text in a cell.