Explain With The Use Of Examples How Data Can Be Manipulated To Aid Interpretation In Excel?

2 Answers

Anonymous Profile
Anonymous answered
The answer is things such as;
filter and advanced filters
the sorting process
goal seek
the actual data itself
macros
Anonymous Profile
Anonymous answered
To find the minimum, use the formula
=MIN(A1:B2)
where A1:B2 is the range of data to check

to find the maximum, use the formula
=MAX(A1:B2)

Formula auditing:
Tools-->Formula Auditing

Answer Question

Anonymous