Question

Gregory has a large spreadsheet of data collected by many workers. Because so many people worked on it, capitalization is inconsistent, and some cells are empty. Gregory asks an Excel expert if he can just apply a function to change the data directly in his spreadsheet to a uniform capitalization theme. What is the limitation of using UPPER, LOWER, or PROPER to meet his request?

(1 point)
Responses

These functions create new data, they don’t change the existing data.

These functions create new data, they don’t change the existing data.

These functions can’t easily be applied to large amounts of data.

These functions can’t easily be applied to large amounts of data.

These functions won’t work well on data with inconsistent capitalization.

These functions won’t work well on data with inconsistent capitalization.

The functions won’t work on ranges that have empty cells.

The functions won’t work on ranges that have empty cells.

Answer 1

These functions create new data, they don’t change the existing data.