BIOS 350 / BIOS/350 / BIOS350 Week 4 Midterm exam
(2016)
Complete
course guide available here – http://class-tutor.com/downloads/bios-350-bios350-bios350-week-4-midterm-exam-2016/
HOMEWORK Description
BIOS 350 / BIOS/350 /
BIOS350 Week 4 Midterm exam (2016)
1. (TCO 5) Excel’s multiple
worksheet abilities can do all of the following EXCEPT:
2. (TCO 5) In Excel, which
of the following would you perform to group adjacent worksheets?
3. (TCO 5) If the active
cell is in column A, but not in row 1, when you click the Split command, the
worksheet will appear in two ________ panes
4. (TCO 5) In Excel, which
of the following is NOT a method for removing a split window?
5. (TCO 5) Which of the
following functions do NOT work with 3D formulas?
6. (TCO 5) Before you can
create an external reference you must first __________.
7. (TCO 5) Which of the
following is the proper use of a 3D formula?
8. (TCO 6) When creating a
range for the substitution values in a one-variable data table, it is best to
arrange them in a(n) ________ orientation.
9. (TCO 6) A two-variable
data table returns ________ result(s) for each combination of two variables
10. (TCO 6) Which What-If Analysis tool would be best at determining how
much you can borrow for a car loan while paying only $350 a month?
11. (TCO 6) The Goal Seek
command is located in the ________ command on the Data tab
12. (TCO 6) Before creating
a scenario with Scenario Manager, it is important to know which cells contain
the variables you want changed and the:
13. (TCO 6) Where is Solver
located if it is already loaded onto Excel?
14. (TCO 6) Which of the
following commands cannot be used on a constraint in the Solver Parameters
dialog box?
15. (TCO 6) The maximum
number of scenarios Scenario Manager can handle is:
Комментариев нет:
Отправить комментарий