FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?

A	Table[Auction Items(Total Sale)]
B	Auction Item (Total Sale)
C	Auction Item [#Totals]
D	#Totals[Total Sale]

Explanation:

Detailed explanation-1: -which of the following procedures is not a way to sort a table by the contents of one column? click an autofilter button in the total row.

Detailed explanation-2: -There is no difference between an AutoFiltered range of records in a list and a table. A table maintains its sort order after you close and then open it again. A table given a title enables its field names to be used in formulas in place of cell references.

Detailed explanation-3: -To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50.

Detailed explanation-4: -Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative? You want to preserve the integrity of any cells referenced by formulas in the macro.

There is 1 question to complete.