CS285 Assignment 6 – Solved Questions and Answers (Updated 2025 Edition)

CS285 Assignment 6 – Solved Questions and Answers
(Updated 2025 Edition)

1. enter a formula in cell D5 to calculate B5/B4 rounded to 4 decimal places.
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




2. 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.
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.




3. 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".
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.

, 4. 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.
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.




5. 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.
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.




6. 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".
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,