BA Chapter 2

If you want to add the cells A10 through A20 and then multiply that total by 5%, which formula below would be correct? A. =SUM(A10:A20)*.05 B. =SUM(A10:A20 X .05) C. =SUM(A10:A20)X5% D. =SUM(A10:A20)(%5)

A. =SUM(A10:A20)*.05

When one wishes to select the largest number from a set of data, one should use which function? A. Count B. Max C. Min D. If

B. Max

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return? A. The price for the product in column A if the exact product number corresponding to A25 can be found, or the price for the closest product if the exact product number can't be found. B. The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not. C. The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not. D. None of the above

B. The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.

In a VLOOKUP formula, what does the argument columnindexnumber mean? A. This is the secret INDEX number that each column in an Excel worksheet has. B. This is the number of the column within the selected table_array where the lookup result is located. C. This is a numerical representation of the letters at the top of a worksheet. For example, A = 1, B = 2, etc. D. This is numbers you assign to columns in your worksheet

B. This is the number of the column within the selected table_array where the lookup result is located.

What is the syntax of Vlook up in excel? a) =VLOOKUP (value, table, colindex, [rangelookup]) b) VLOOKUP (value, table, colindex, [rangelookup]) c) =VLOOKUP (table, colindex ,value, [rangelookup]) d) =VLOOKUP (table,value, [rangelookup], colindex)

a) =VLOOKUP (value, table, colindex, [rangelookup])

MEAN function is used for? a) To calculate the average of the column b) To calculate middle value of the column c) To calculate lowest value d) To calculate sum of the columns

a) To calculate the average of the column

What is the main function of fill color? a) To fill color in the current selected fields b) To fill color in the previous selected fields c) To fill color in the next column d) To fill color in the entire sheet

a) To fill color in the current selected fields

Column index (col_index) serves what purpose in the Vlook up formula? a) is the column number in the table_array from which the matching value should be returned b) is the column number in the whole table from which the matching value should be returned c) is the column number in the table_array from which the matching value should be stored d) is the column number in the whole table from which the matching value should be stored

a) is the column number in the table_array from which the matching value should be returned

Clicking on the button fx is generally used for? a) showing up formatting menu b) entering the values for formulas like median, vlookup etc c) wrapping the word d) making columns align together

b) entering the values for formulas like median, vlookup etc

How do you make all the columns uniform? a) By using T bar b) By inserting uniform text c) By formatting and adjusting column width d) By applying filter to columns

c) By formatting and adjusting column width

RAND function: To make the value as static so that it does not change when we click anywhere in the excel sheet, what is the best method? a) use simple paste b) use Transpose c) copy and paste as values d) use inverse

c) copy and paste as values

Which special character is used to lock a particular value in excel so that it remains constant in the sumproduct function? a) # b) * c) & d) $

d) $

RAND function is used for? a) returns a random number that is greater than or equal to 0 b) returns a random number that is always less than 1 c) returns a random number that is less than or equal to 0 or greater than 1 d) returns a random number that is greater than or equal to 0 and less than 1

d) returns a random number that is greater than or equal to 0 and less than 1

What is the main function of Vlook up? a) searches for a number equal to or greater than the value of another number in different sheet b) searches for values in the entire sheet randomly c) searches for values based upon index numbers d) searches for values in a column or row of a spreadsheet list or table

d) searches for values in a column or row of a spreadsheet list or table