BUAD FINAL EXAM Test Questions and Answers Graded A+
In cell B8, create a formula without using a = (1+B$12)×B14
function that multiplies the value in cell B7 by the = (1+B$12)×B15
value in cell B6 and then adds the value in B7. In = (1+B$12)×B16
this formula, use a mixed reference for cell B6 by
including an absolute reference to row 6. Copy Notice that cell B12 maintain its original format of
the formula from cell B8 to the range B9:B11 and B$12, while B13 changes to B14, B15 and B16.
then copy the formulas from the range B8:B11 to This because cell B12 is referenced using
the range C8:H11. - ANSWER -In cell B8 relative reference.
type =B7*B6+B7
Insert $ before row number 6 to lock the row so Change the zoom level for the worksheet to be
the formula always references the same row as 110% - ANSWER -Click the Zoom In
you copy the formula down or to the side - bottom in the view ribbon
B7*B$6+B7
Enter a formula using arithmetic operators and
In cell B13, create a formula using the parentheses in cell B14 that adds the monthly
VLOOKUP function that looks up the value from expenses in cells B9, B10, and B11, and then
cell A11 in the range A5:B7, returns the value in multiplies that result by 12. - ANSWER -
column 2, and specifies an exact match. Copy (B9+B10+B11)*12
the formula to cell E13. - ANSWER -
=VLOOKUP(A11,A5:B7,2)
Create a new conditional formatting rule that
formats the top 5 values in the range with a blue,
In cell B13, create a formula without a function accent 5 cell background color - ANSWER -
using absolute references that subtracts the conditional formatting
values of cells B5 and B7 from cell B6 and then new formatting rule
multiplies the result by cell B8. Copy the formula top __ values
from cell B13 to the range C13:H13. - format
ANSWER -=($B$6-$B$5 - $B$7)*$B$8 fill color
In cell B14, create a formula without using a copy the values and number formatting but not
function that adds 1 to the value in cell B12 and the underlying formulas - ANSWER -paste
then multiplies the result by the value in cell B13. special
Update the reference to cell B12, from a relative
reference to a mixed reference by making an
absolute reference to row 12. Copy the formula Create a calculated field in the sales pivottable,
from cell B14 to the range B15:B17 and then naming the field q1, that totals the values in the
copy the formulas from the range B14:B17 to the January, February, and March fields -
range C14:H17. - ANSWER -Enter ANSWER -Click cell where pivot table is->
(1+B$12)×B13 in cell B14. click the analyze ribbon in pivottable tools ->
fields, items, and states -> calculated field ->
When the formula is copied from B1 down to name it Q1-> double click january, type a plus
B17, the formulas will be: sign next to january and add february and march
= (1+B$12)×B13
1/7
, BUAD FINAL EXAM Test Questions and Answers Graded A+
Insert Word Art - ANSWER -In the current
In cell E4, create formula using the HLOOKUP worksheet, go to the Insert tab
function to determine the project staffing needs Then, on the extreme right, find Text section
for client EnergyPro Based on the project type in Then, click on it and then click on WordArt sub-
cell C4. Use range H3:K4 as the lookup table, section
and the staffing needs value listed in row 2 of the Then, select the 1st row, 3rd option from it
project staffing lookup table. Do not enter value
for optional range - ANSWER -1. click cell
2. formulas tab transpose data - ANSWER -copy
3. function library, then lookup paste (transpose)
4. drop down "lookup and reference"
5. HLOOKUP
6. C4, H3:K4, 2 Add the San Diego data series found in cells
A5:D8 to the chart - ANSWER -design tab
"select data"
In cell C4, enter formula using the RATE function click and drag cell range
to calculate the interest rate given the press ok
investement parameters in Scenario A. Function
arguments should include cell c6 as the nper
argument, cell c7 as the pmt argument,cell c3 as Add the IFERROR function to an existing
the pv argument and cell c8 as the fv. - formula. IN CELL C13 enter a formula using the
ANSWER -1. click cell IFERROR function that uses the existingg
2. formulas tab and insert VLOOKUP function in cell C13 as the value
3. look up rate function argument, and Invalid Job Title as the
4. enter values customized error message for the value_if_error
function argument - ANSWER -1. Click cell
C13
In cell J7, enter a formula using the INDEX 2. In the formula bar, click directly after the equal
function to find the value in row 15, column 3 of sign to place insertion point, then type IFERROR(
range A3:G17 - ANSWER -1. click cell in the formula bar
2. enter formula 3. In the formula bar, click to the right of the
3. index parenthesis to place the insertion point at the end
4. enter values(array: range) of the text and type, "Invalid Job Title") in the
formula bar.
4. Press ENTER
In cell D1, create formula using the MATCH
function that returns the location of the company
name of RELICO in cells B5:B18 - in cell d6, create a customized error alert using
ANSWER -1. click cell the stop style - ANSWER -click cell
2. enter formula data tab
3. enter values data validation
value:RELICO error alert
array: B5:B18 style: stop
match type:0 title
2/7
In cell B8, create a formula without using a = (1+B$12)×B14
function that multiplies the value in cell B7 by the = (1+B$12)×B15
value in cell B6 and then adds the value in B7. In = (1+B$12)×B16
this formula, use a mixed reference for cell B6 by
including an absolute reference to row 6. Copy Notice that cell B12 maintain its original format of
the formula from cell B8 to the range B9:B11 and B$12, while B13 changes to B14, B15 and B16.
then copy the formulas from the range B8:B11 to This because cell B12 is referenced using
the range C8:H11. - ANSWER -In cell B8 relative reference.
type =B7*B6+B7
Insert $ before row number 6 to lock the row so Change the zoom level for the worksheet to be
the formula always references the same row as 110% - ANSWER -Click the Zoom In
you copy the formula down or to the side - bottom in the view ribbon
B7*B$6+B7
Enter a formula using arithmetic operators and
In cell B13, create a formula using the parentheses in cell B14 that adds the monthly
VLOOKUP function that looks up the value from expenses in cells B9, B10, and B11, and then
cell A11 in the range A5:B7, returns the value in multiplies that result by 12. - ANSWER -
column 2, and specifies an exact match. Copy (B9+B10+B11)*12
the formula to cell E13. - ANSWER -
=VLOOKUP(A11,A5:B7,2)
Create a new conditional formatting rule that
formats the top 5 values in the range with a blue,
In cell B13, create a formula without a function accent 5 cell background color - ANSWER -
using absolute references that subtracts the conditional formatting
values of cells B5 and B7 from cell B6 and then new formatting rule
multiplies the result by cell B8. Copy the formula top __ values
from cell B13 to the range C13:H13. - format
ANSWER -=($B$6-$B$5 - $B$7)*$B$8 fill color
In cell B14, create a formula without using a copy the values and number formatting but not
function that adds 1 to the value in cell B12 and the underlying formulas - ANSWER -paste
then multiplies the result by the value in cell B13. special
Update the reference to cell B12, from a relative
reference to a mixed reference by making an
absolute reference to row 12. Copy the formula Create a calculated field in the sales pivottable,
from cell B14 to the range B15:B17 and then naming the field q1, that totals the values in the
copy the formulas from the range B14:B17 to the January, February, and March fields -
range C14:H17. - ANSWER -Enter ANSWER -Click cell where pivot table is->
(1+B$12)×B13 in cell B14. click the analyze ribbon in pivottable tools ->
fields, items, and states -> calculated field ->
When the formula is copied from B1 down to name it Q1-> double click january, type a plus
B17, the formulas will be: sign next to january and add february and march
= (1+B$12)×B13
1/7
, BUAD FINAL EXAM Test Questions and Answers Graded A+
Insert Word Art - ANSWER -In the current
In cell E4, create formula using the HLOOKUP worksheet, go to the Insert tab
function to determine the project staffing needs Then, on the extreme right, find Text section
for client EnergyPro Based on the project type in Then, click on it and then click on WordArt sub-
cell C4. Use range H3:K4 as the lookup table, section
and the staffing needs value listed in row 2 of the Then, select the 1st row, 3rd option from it
project staffing lookup table. Do not enter value
for optional range - ANSWER -1. click cell
2. formulas tab transpose data - ANSWER -copy
3. function library, then lookup paste (transpose)
4. drop down "lookup and reference"
5. HLOOKUP
6. C4, H3:K4, 2 Add the San Diego data series found in cells
A5:D8 to the chart - ANSWER -design tab
"select data"
In cell C4, enter formula using the RATE function click and drag cell range
to calculate the interest rate given the press ok
investement parameters in Scenario A. Function
arguments should include cell c6 as the nper
argument, cell c7 as the pmt argument,cell c3 as Add the IFERROR function to an existing
the pv argument and cell c8 as the fv. - formula. IN CELL C13 enter a formula using the
ANSWER -1. click cell IFERROR function that uses the existingg
2. formulas tab and insert VLOOKUP function in cell C13 as the value
3. look up rate function argument, and Invalid Job Title as the
4. enter values customized error message for the value_if_error
function argument - ANSWER -1. Click cell
C13
In cell J7, enter a formula using the INDEX 2. In the formula bar, click directly after the equal
function to find the value in row 15, column 3 of sign to place insertion point, then type IFERROR(
range A3:G17 - ANSWER -1. click cell in the formula bar
2. enter formula 3. In the formula bar, click to the right of the
3. index parenthesis to place the insertion point at the end
4. enter values(array: range) of the text and type, "Invalid Job Title") in the
formula bar.
4. Press ENTER
In cell D1, create formula using the MATCH
function that returns the location of the company
name of RELICO in cells B5:B18 - in cell d6, create a customized error alert using
ANSWER -1. click cell the stop style - ANSWER -click cell
2. enter formula data tab
3. enter values data validation
value:RELICO error alert
array: B5:B18 style: stop
match type:0 title
2/7
