Gregory has a large spreadsheet of data collected by many workers. Because so many

Question

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)
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 won’t work well on data with inconsistent capitalization.
The functions won’t work on ranges that have empty cells.

Answer 1

The limitation of using UPPER, LOWER, or PROPER to meet Gregory's request is:

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

These functions will transform the text but will require the result to be placed in a separate cell, leaving the original data unchanged unless the new data is copied and pasted back into the original cells.