To analyze data from a survey, you use a spreadsheet to calculate the percent of students who prefer corn over broccoli or carrots. however, the results do not look like percentages. how can spreadsheet formatting options correct this?

A. By changing the addition sign to a multiplication sign

B. By changing the decimal to a percentage

C. By changing the percentage to a decimal

D. By changing the multiplication sign to a division sign

Question

Computers & Technology

Nolan Phillips

1 January, 10:26

To analyze data from a survey, you use a spreadsheet to calculate the percent of students who prefer corn over broccoli or carrots. however, the results do not look like percentages. how can spreadsheet formatting options correct this?

A. By changing the addition sign to a multiplication sign

B. By changing the decimal to a percentage

C. By changing the percentage to a decimal

D. By changing the multiplication sign to a division sign

+1

Answers (2)

Know the Answer?

Dante Hickman · Answer 1

By changing the decimal to a percentage APEX Verified

Lizeth Powell · Answer 2

By changing the decimal to a percentage

Explanation:

Since the requirement is to calculate the percentage of students about their preference in eating vegetables, we need to convert the given values to percentage only.

Option A: By changing the addition sign to a multiplication sign. This is invalid because, there is no addition and multiplication involved in converting to percentage

Option C: By changing the percentage to a decimal. The given data is not available in percentage so conversion is impossible.

Option D: By changing the multiplication sign to a division sign Multiplication and division are not going to be performed here, since we need only percentage.