Test bsis Exam #1 Questions with correct answers
True or false. The following table is used to look up information on a specific
product. The Product ID is entered into cell B2 and the information is returned in
the shaded box. To return the information for the Product named in B2, the
formula in cell C5 would be =LOOKUP($B$2,$A$14:$F$44,3,FALSE) - ✔✔False
VLOOKUP assumes that the first column of the table is - ✔✔Sorted in ascending
order
The formula = SUMIF(B2:B10, ">0", C2:C10) for a particular cell will find: - ✔✔The
sum of all of the values in the range C2:C10 if the corresponding value in the
range B2:B10 is greater than zero.
The following table is used to look up information on a specific product. The
Product ID is entered into cell B2 and the information is returned in the shaded
box. There are several formulas in the table. How could you look at the cells that
are linked to cell B2? - ✔✔Select "Trace Dependents" in the Formula Auditing
Group on the Formulas tab.
Using the following table, which formula is used for counting cells where the
"Salary" value is less than $40,000? - ✔✔=COUNTIF(D2:D17,"<40000")
True or false. Using only "VLOOKUP" to transfer the Rank1 name from VData tab
into the "Individual Sales" table in the Table1 tab, the formula would be
=VLOOKUP(A4,VData!$B$2:$C$11,2,FALSE). - ✔✔True
In a make-versus-buy decision, companies have to decide whether they should
manufacture a product or outsource its production to another firm. - ✔✔True
, What Excel formula could be used to perform the following computation?
B5*B17 + C5*C17 + D5*D17 + B6*B18 + C6*C18 + D6*D18 + E6*E18 + B7*B19 +
C7*C19 + D7*D19 + E7*E19 ? - ✔✔=SUMPRODUCT(B5:E7,B17:E19)
The following table is used to look up information on a specific product. The
Product ID is entered into cell B2 and the information is returned in the shaded
box. What would be generated by Excel if you select "Trace Dependents" in the
Formula Auditing Group on the Formulas tab? - ✔✔DEPENDENTS IS STRAIGHT
DOWN LINE
For the following table, which Excel formula determines the number of "Quantity"
cells that have a value greater than 10? - ✔✔=COUNTIF(D2:D8,">10")
Which of the following is a logical function that will add values in multiple ranges
that meet multiple criteria? - ✔✔SUMIF
The process of changing the values in cells to see how those changes affect the
outcome of formulas on a worksheet is called: - ✔✔What-If Analysis
An Excel function that searches values in a table array arranged in columns is the
______________ function. - ✔✔VLOOKUP
Which of the following is NOT possible with VLOOKUP? - ✔✔look up values
located in a column to the left of the column that contains the lookup value
True or false. The following table is used to look up information on a specific
product. The Product ID is entered into cell B2 and the information is returned in
the shaded box. To return the information for the Product named in B2, the
formula in cell C5 would be =LOOKUP($B$2,$A$14:$F$44,3,FALSE) - ✔✔False
VLOOKUP assumes that the first column of the table is - ✔✔Sorted in ascending
order
The formula = SUMIF(B2:B10, ">0", C2:C10) for a particular cell will find: - ✔✔The
sum of all of the values in the range C2:C10 if the corresponding value in the
range B2:B10 is greater than zero.
The following table is used to look up information on a specific product. The
Product ID is entered into cell B2 and the information is returned in the shaded
box. There are several formulas in the table. How could you look at the cells that
are linked to cell B2? - ✔✔Select "Trace Dependents" in the Formula Auditing
Group on the Formulas tab.
Using the following table, which formula is used for counting cells where the
"Salary" value is less than $40,000? - ✔✔=COUNTIF(D2:D17,"<40000")
True or false. Using only "VLOOKUP" to transfer the Rank1 name from VData tab
into the "Individual Sales" table in the Table1 tab, the formula would be
=VLOOKUP(A4,VData!$B$2:$C$11,2,FALSE). - ✔✔True
In a make-versus-buy decision, companies have to decide whether they should
manufacture a product or outsource its production to another firm. - ✔✔True
, What Excel formula could be used to perform the following computation?
B5*B17 + C5*C17 + D5*D17 + B6*B18 + C6*C18 + D6*D18 + E6*E18 + B7*B19 +
C7*C19 + D7*D19 + E7*E19 ? - ✔✔=SUMPRODUCT(B5:E7,B17:E19)
The following table is used to look up information on a specific product. The
Product ID is entered into cell B2 and the information is returned in the shaded
box. What would be generated by Excel if you select "Trace Dependents" in the
Formula Auditing Group on the Formulas tab? - ✔✔DEPENDENTS IS STRAIGHT
DOWN LINE
For the following table, which Excel formula determines the number of "Quantity"
cells that have a value greater than 10? - ✔✔=COUNTIF(D2:D8,">10")
Which of the following is a logical function that will add values in multiple ranges
that meet multiple criteria? - ✔✔SUMIF
The process of changing the values in cells to see how those changes affect the
outcome of formulas on a worksheet is called: - ✔✔What-If Analysis
An Excel function that searches values in a table array arranged in columns is the
______________ function. - ✔✔VLOOKUP
Which of the following is NOT possible with VLOOKUP? - ✔✔look up values
located in a column to the left of the column that contains the lookup value
