To sort data in an Excel worksheet, you must first ________ the range to a table

Match the following terms to their meanings:

I. Pie chart II. Chart III. Line chart IV. Column chart V. Named range A. Displays comparison among related numbers B. A graphical representation of data C. A range that has been given a name to make it easier to use cells in calculations D. Displays the percentages of parts to a whole E. Best displays trends over time

“To subtract one number from another, take the twos complement of the subtrahend and add it to the minuend” is the _________ rule.

Fill in the blank(s) with the appropriate word(s).