Examlex
Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this.
-You tell Jane that if she ____,then she can easily add and delete product records,change the values of fields in records,sort the records in a different order,determine subtotals for numeric fields,display records that meet comparison criteria,and analyze data using database functions.
Q14: As shown in the accompanying figure, the
Q17: You should hold down the _ key
Q18: If sales reach a certain amount by
Q27: Which of the following is the path
Q30: When Excel recognizes that you entered a
Q43: The spell checker examines the formulas in
Q54: To erase an entire entry in a
Q81: The arithmetic operator, ^, directs Excel to
Q111: A(n) _ reference is a formula that
Q112: Which of the following keys toggles between