CS285 Assign6
Enter a formula in cell D5 to calculate B5/B4 rounded to 4 decimal places. -
CORRECT ANSWER-You typed =Ro in cell D5, double-clicked ROUND in the
Formula AutoComplete list, typed =ROUND(B5/B4,4 in cell D5, and pressed Enter
Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total
value of the current leases by multiplying the current monthly rents by the remaining
months on each lease. Use the range names Rents and Leases. - CORRECT
ANSWER-You clicked cell B1, typed =SUMPRO in cell B1, double-clicked
SUMPRODUCT in the Formula AutoComplete list, typed
=SUMPRODUCT(Rents,Leases in cell B1, and pressed Enter.
Enter a formula in cell F2 using SUMIFS to calculate the total expense (use the
named range Cost) where the value in the Category named range is equal to the text
string "Office Expense" and the value in the SubCategory named range is equal to
the text string "Parking". - CORRECT ANSWER-You typed =SUMIF(Category in cell
F2. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked
the Logical button, clicked the Recently Used button, and clicked the Math & Trig
button. In the Math & Trig menu, you clicked the SUMIFS menu item. Inside the
Function Arguments dialog, you typed Cost in the Sum_range input, pressed the Tab
key, typed Category in the Criteria_range1 input, pressed the Tab key, typed Office
Expense in the Criteria1 input, pressed the Tab key, typed SubCategory in the
Criteria_range2 input, pressed the Tab key, typed Parking in the Criteria2 input, and
pressed the Enter key.
Enter a formula in the selected cell using SUMIF to calculate the total expenses for
the category Office Expense. Use the range name Category for the Range
argument, the text string "Office Expense" for the Criteria argument, and Cost for the
Sum_range argument. - CORRECT ANSWER-You typed in cell F2. In the Formulas
Ribbon Tab in the Function Library Ribbon Group, you clicked the Math & Trig
button. In the Math & Trig menu, you clicked the SUMIF menu item. Inside the
Function Arguments dialog, you typed Category in the Range input, pressed the Tab
key, typed Office Expense in the Criteria input, pressed the Tab key, typed Cost in
the Sum_range input, and pressed the Enter key.
Enter a formula in cell F2 using AVERAGEIF to calculate the average cost for the
category Computer Expense. Use the range name Category for the Range
argument, the text string "Computer Expense" for the Criteria argument, and Cost for
the Average_range argument. - CORRECT ANSWER-In the Formulas Ribbon Tab in
the Function Library Ribbon Group, you clicked the Math & Trig button, clicked the
Financial button, and clicked the More Functions button. In the More Functions menu
in the Statistical menu, you clicked the AVERAGEIF menu item. Inside the Function
Arguments dialog, you typed Category in the Range input, pressed the Tab key,
, typed Computer Expense in the Criteria input, pressed the Tab key, typed Cost in the
Average_range input, and pressed the Enter key.
Enter a formula in the selected cell using AVERAGEIFS to calculate the average
expense (use the named range Cost) where the value in the Category named range
is equal to the text string "Computer Expense" and the value in the SubCategory
named range is equal to the test string "Internet Access". - CORRECT ANSWER-In
the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More
Functions button. In the More Functions menu in the Statistical menu, you clicked
the AVERAGEIFS menu item. Inside the Function Arguments dialog, you typed Cost
in the Average_range input, pressed the Tab key, typed Category in the
Criteria_range1 input, pressed the Tab key, typed Computer Expense in the Criteria1
input, pressed the Tab key, typed SubCategory in the Criteria_range2 input, pressed
the Tab key, typed Internet Access in the Criteria2 input, and pressed the Enter key.
In cell F2, enter a formula using COUNTIF to count the number of cells in the range
named Cost that have a value less than 500. - CORRECT ANSWER-In the Formulas
Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions
button. In the More Functions menu in the Statistical menu, you clicked the
COUNTIF menu item. Inside the Function Arguments dialog, you typed Cost in the
Range input, pressed the Tab key, typed <500 in the Criteria input, and pressed the
Enter key.
In cell F2, enter a formula using COUNTIFS to count the number of rows where
values in the range named Cost have a value less than 500 and cells in the range
named Category have the value "Computer Expense". - CORRECT ANSWER-In the
Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More
Functions button. In the More Functions menu in the Statistical menu, you clicked
the COUNTIFS menu item. Inside the Function Arguments dialog, you typed Cost in
the Criteria_range1 input, pressed the Tab key, typed <500 in the Criteria1 input,
pressed the Tab key, typed Category in the Criteria_range2 input, pressed the Tab
key, typed Computer Expense in the Criteria2 input, and pressed the Enter key.
Enter a formula in cell G2 to find the middle value of the cell range D2:D14. -
CORRECT ANSWER-You typed =Median in cell G2, double-clicked MEDIAN in the
Formula AutoComplete list, selected the cell range D2:D14, and pressed Enter.
Enter a formula in cell E2 to calculate the absolute value of C2-D2. - CORRECT
ANSWER-You typed in cell E2, clicked cell E2, clicked the E2 Cell Input, typed =ABS
in cell E2, clicked the =ABS(C2-D2 view, double-clicked ABS in the Formula
AutoComplete list, typed =ABS(C2-D2 in cell E2, and pressed Enter.
Enter an array formula in cells G1:G3 to display the three mode values from the
range D2:D14. The results array has been selected for you. - CORRECT
Enter a formula in cell D5 to calculate B5/B4 rounded to 4 decimal places. -
CORRECT ANSWER-You typed =Ro in cell D5, double-clicked ROUND in the
Formula AutoComplete list, typed =ROUND(B5/B4,4 in cell D5, and pressed Enter
Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total
value of the current leases by multiplying the current monthly rents by the remaining
months on each lease. Use the range names Rents and Leases. - CORRECT
ANSWER-You clicked cell B1, typed =SUMPRO in cell B1, double-clicked
SUMPRODUCT in the Formula AutoComplete list, typed
=SUMPRODUCT(Rents,Leases in cell B1, and pressed Enter.
Enter a formula in cell F2 using SUMIFS to calculate the total expense (use the
named range Cost) where the value in the Category named range is equal to the text
string "Office Expense" and the value in the SubCategory named range is equal to
the text string "Parking". - CORRECT ANSWER-You typed =SUMIF(Category in cell
F2. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked
the Logical button, clicked the Recently Used button, and clicked the Math & Trig
button. In the Math & Trig menu, you clicked the SUMIFS menu item. Inside the
Function Arguments dialog, you typed Cost in the Sum_range input, pressed the Tab
key, typed Category in the Criteria_range1 input, pressed the Tab key, typed Office
Expense in the Criteria1 input, pressed the Tab key, typed SubCategory in the
Criteria_range2 input, pressed the Tab key, typed Parking in the Criteria2 input, and
pressed the Enter key.
Enter a formula in the selected cell using SUMIF to calculate the total expenses for
the category Office Expense. Use the range name Category for the Range
argument, the text string "Office Expense" for the Criteria argument, and Cost for the
Sum_range argument. - CORRECT ANSWER-You typed in cell F2. In the Formulas
Ribbon Tab in the Function Library Ribbon Group, you clicked the Math & Trig
button. In the Math & Trig menu, you clicked the SUMIF menu item. Inside the
Function Arguments dialog, you typed Category in the Range input, pressed the Tab
key, typed Office Expense in the Criteria input, pressed the Tab key, typed Cost in
the Sum_range input, and pressed the Enter key.
Enter a formula in cell F2 using AVERAGEIF to calculate the average cost for the
category Computer Expense. Use the range name Category for the Range
argument, the text string "Computer Expense" for the Criteria argument, and Cost for
the Average_range argument. - CORRECT ANSWER-In the Formulas Ribbon Tab in
the Function Library Ribbon Group, you clicked the Math & Trig button, clicked the
Financial button, and clicked the More Functions button. In the More Functions menu
in the Statistical menu, you clicked the AVERAGEIF menu item. Inside the Function
Arguments dialog, you typed Category in the Range input, pressed the Tab key,
, typed Computer Expense in the Criteria input, pressed the Tab key, typed Cost in the
Average_range input, and pressed the Enter key.
Enter a formula in the selected cell using AVERAGEIFS to calculate the average
expense (use the named range Cost) where the value in the Category named range
is equal to the text string "Computer Expense" and the value in the SubCategory
named range is equal to the test string "Internet Access". - CORRECT ANSWER-In
the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More
Functions button. In the More Functions menu in the Statistical menu, you clicked
the AVERAGEIFS menu item. Inside the Function Arguments dialog, you typed Cost
in the Average_range input, pressed the Tab key, typed Category in the
Criteria_range1 input, pressed the Tab key, typed Computer Expense in the Criteria1
input, pressed the Tab key, typed SubCategory in the Criteria_range2 input, pressed
the Tab key, typed Internet Access in the Criteria2 input, and pressed the Enter key.
In cell F2, enter a formula using COUNTIF to count the number of cells in the range
named Cost that have a value less than 500. - CORRECT ANSWER-In the Formulas
Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions
button. In the More Functions menu in the Statistical menu, you clicked the
COUNTIF menu item. Inside the Function Arguments dialog, you typed Cost in the
Range input, pressed the Tab key, typed <500 in the Criteria input, and pressed the
Enter key.
In cell F2, enter a formula using COUNTIFS to count the number of rows where
values in the range named Cost have a value less than 500 and cells in the range
named Category have the value "Computer Expense". - CORRECT ANSWER-In the
Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More
Functions button. In the More Functions menu in the Statistical menu, you clicked
the COUNTIFS menu item. Inside the Function Arguments dialog, you typed Cost in
the Criteria_range1 input, pressed the Tab key, typed <500 in the Criteria1 input,
pressed the Tab key, typed Category in the Criteria_range2 input, pressed the Tab
key, typed Computer Expense in the Criteria2 input, and pressed the Enter key.
Enter a formula in cell G2 to find the middle value of the cell range D2:D14. -
CORRECT ANSWER-You typed =Median in cell G2, double-clicked MEDIAN in the
Formula AutoComplete list, selected the cell range D2:D14, and pressed Enter.
Enter a formula in cell E2 to calculate the absolute value of C2-D2. - CORRECT
ANSWER-You typed in cell E2, clicked cell E2, clicked the E2 Cell Input, typed =ABS
in cell E2, clicked the =ABS(C2-D2 view, double-clicked ABS in the Formula
AutoComplete list, typed =ABS(C2-D2 in cell E2, and pressed Enter.
Enter an array formula in cells G1:G3 to display the three mode values from the
range D2:D14. The results array has been selected for you. - CORRECT
