Question

Select the correct answer.

Jane has a small stationary shop. She prefers to maintain a separate spreadsheet for purchases made with cash. Last week many people brought items by paying in cash. Jane entered all the cash values in a spreadsheet but she forgot to enter the dollar symbol beside each amount. Which is the quickest way to enter the symbol beside each number?

A right click the cells with the numeric data and then format the cell

B left click the cells the numeric data and then format the cells

C type the dollar symbol in each cell

D right click the default format and then format the cell

Answer 1

She should choose option A

right click the cells with the numeric data and then format the cell

Step-by-step explanation:

To add currency symbol or dollar symbol, with amount in the table. The easiest way is given below:

1. Select all cell that need to be updated
2. Right click on the cell after selection
3. Choose "Format cell" option from drop down
4. A pop up window opens, Choose currency button
5. Select Dollar sign from drop down list.
6. Apply on selected cell.

This process will help her to add currency symbols that she required with ease and she does not required a long process such as, adding symbol of dollar manually with each entry. Using these steps the symbol with added automatically by single click.