C. use formatting options to identify plain numbers as currency
By using formatting options to identify the numbers as currency, Rocco can ensure that his spreadsheet displays the results in dollars while still allowing SUM functions to be performed.
Rocco wants to create a spreadsheet that tracks how many dollars he spends on clothes each month. How can he most easily make sure his spreadsheet shows the results in dollars, while allowing SUM functions to still be performed? (1 point)
A. type “$” before the number in each cell
B. make sure each cell contains decimals and two digits, e.g. “31.00”
C. use formatting options to identify plain numbers as currency
D. type the data into the formula bar instead of the cell
1 answer
1 answer