1. |
You clicked cell F6, typed =F4-F5 in cell F6, and pressed Enter. |

2. |
You clicked cell D2, typed =B6 in cell D2, and pressed Enter. |

3. |
You clicked cell D2, pressed the F4 keyboard shortcut, and dragged the Fill Handle tool. |

4. |
You selected the cell range B15:D16, clicked cell B13, clicked cell B8, typed = in cell B8, clicked the Salaries tab, clicked the Salaries tab, and clicked cell B7. |

5. |
In the Formulas Ribbon Tab in the Defined Names Ribbon Group, you clicked the Create from Selection button. Inside the Create from Selection dialog, you clicked the OK button. |

6. |
You clicked cell B7, clicked the Smart Tag Button. In the Formula Error menu, you clicked the Update Formula to Include Cells menu item. |

7. |
In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Show Formulas button. |

8. |
In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Show Formulas button. |

9. |
In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Trace Dependents button. |

10. |
In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Trace Precedents button. |

11. |
In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Remove Arrows button. |

12. |
In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Average menu item. You pressed Enter. |

13. |
Inside the Function Arguments dialog, you clicked the Count Value1 Formula Input collapsible input. You clicked cell E2, selected the cell range E2:E14. Inside the Function Arguments dialog, you clicked the Collapsed Mode Input collapsible input. Inside the Function Arguments dialog, you clicked the OK button. |

14. |
Inside the Function Arguments dialog, you clicked the Counta Value1 Formula Input collapsible input. You clicked cell D2, selected the cell range D2:D14. Inside the Function Arguments dialog, you clicked the Collapsed Mode Input collapsible input. Inside the Function Arguments dialog, you clicked the OK button. |

15. |
Inside the Function Arguments dialog, you clicked the Countblank Range Formula Input collapsible input. You clicked cell D2, selected the cell range D2:D14. Inside the Function Arguments dialog, you clicked the Collapsed Mode Input collapsible input. Inside the Function Arguments dialog, you keydowned the Countblank Range Formula Input collapsible input. |

16. |
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Min menu item. You pressed Enter. |

17. |
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Max menu item. You pressed Enter. |

18. |
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time button. In the Date & Time menu, you clicked the TODAY menu item. Inside the Function Arguments dialog, you clicked the OK button. |

19. |
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time button. In the Date & Time menu, you clicked the NOW menu item. Inside the Function Arguments dialog, you clicked the OK button. |

20. |
Inside the Function Arguments dialog, you clicked the close dialog button, typed B4/12 in the Pmt Rate Formula Input, typed B4 in the Pmt Nper Formula Input, typed B2/12 in the Pmt Rate Formula Input, typed "-B2" in the Pmt Pv Formula Input, typed B3/12 in the Pmt Rate Formula Input, and clicked the OK button. |

21. |
… |

22. |
In the Lookup & Reference menu, you clicked the VLOOKUP menu item. Inside the Function Arguments dialog, you typed A3 in the Vlookup Lookup Value Formula Input, typed 2 in the Vlookup Col Index Num Formula Input, typed Abbreviation in the Vlookup Table Array Formula Input, typed false in the Vlookup Range Lookup Formula Input, and clicked the OK button. |

25. |
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 ROUNDDOWN menu item. Inside the Function Arguments dialog, you typed B5/B4 in the Rounddown Number Formula Input, typed 4 in the Rounddown Num Digits Formula Input, and keydowned the Rounddown Num Digits Formula Input collapsible input. |

23. |
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 ROUND menu item. Inside the Function Arguments dialog, you typed B5/B4 in the Round Number Formula Input, typed 4 in the Round Num Digits Formula Input, and clicked the OK button. |

26. |
In the Math & Trig menu, you clicked the SUMIF menu item. Inside the Function Arguments dialog, you typed Category in the Sumif Range Formula Input, typed Office Expense in the Sumif Criteria Formula Input, typed Cost in the Sumif Sumrange Formula Input, and keydowned the Sumif Sumrange Formula Input collapsible input. |

24. |
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 ROUNDUP menu item. Inside the Function Arguments dialog, you typed B5/B4 in the Roundup Number Formula Input, typed 4 in the Roundup Num Digits Formula Input, and clicked the OK button. |

27. |
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 SUMPRODUCT menu item. Inside the Function Arguments dialog, you typed Rents in the Sumproduct Array1 Formula Input, typed Leases in the Sumproduct Array2 Formula Input, and clicked the OK button. |

# CIS 150 Exam07- Excel Chapter 2 (2016v1)

### Share This

## Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price