Microsoft Excel 2003 Exam 2

25 Questions  I  By Ichintu
Please take the quiz to rate it.

Microsoft Excel 2003 Exam 2
INSTRUCTIONS: 1. Read all questions CAREFULLY! 2. Attempt ALL questions. 3. Total time allotted is 1. 5 hours.

  
Changes are done, please start the quiz.


Questions and Answers Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  To create a template, you simply save an Excel workbook as a template file using the __________ command.
A.
B.
C.
D.
2.  Which of the following Solver reports is used primarily in science and engineering environments?
A.
B.
C.
D.
3.  The Set Target Cell box in the Solver parameters dialog box must contain the cell reference for the __________ cell.
A.
B.
C.
D.
4.  In the 3-D cell reference, 'E:\Business\[Sales.xls]Summary Info'!B5:E5, theworkbook name is
A.
B.
C.
D.
5.  To open the Solver parameters dialog box, click Tools, and then click
A.
B.
C.
D.
6.  In a non-interactive web page the user can __________.
A.
B.
C.
D.
7.  The first argument in the VLOOKUP function is the __________ value.
A.
B.
C.
D.
8.  To deal with problems with ________ input cell(s), you have to create scenarios.
A.
B.
C.
D.
9.  By default, Excel uses __________ references while recording macros.
A.
B.
C.
D.
10.  One way to ensure that correct data is entered into a cell or range is to use the Excel __________ feature.
A.
B.
C.
D.
11.  When creating a two-variable data table, you must identify the _____ input Cell
A.
B.
C.
D.
12.  You must place an order for refrigerators with the restrictions that the cost of the order cannot exceed $18,000 and that the available space is limited to a maximum of 1,000 cubic feet; which of the following are goal-seeking questions related to this problem?
A.
B.
C.
D.
13.  Whenever you start Excel and see the blank workbook called __________, you are using a workbook that is based on a template known as the default template.
A.
B.
C.
D.
14.  You enter 3-D cell references by
A.
B.
C.
D.
15.  The first component of CVP analysis is ___________
A.
B.
C.
D.
16.  You can assign range names of up to __________ characters.
A.
B.
C.
D.
17.  To select consecutive worksheets, press and hold down the __________ key, and then click the last sheet tab you want to include.
A.
B.
C.
D.
18.  To create macro buttons, you will display the __________ toolbar.
A.
B.
C.
D.
19.  To retain the Solver solutions, select the __________ option button in the Solver Results dialog box.
A.
B.
C.
D.
20.  Raw material is a(n) __________ expense because the expenses increase with higher quantities produced.
A.
B.
C.
D.
21.  Goal Seek can change the contents of __________ cell(s) to find a solution.
A.
B.
C.
D.
22.  The message "#DIV/0!" means that
A.
B.
C.
D.
23.  How can you tell if a worksheet is being shared?
A.
B.
C.
D.
24.  To quickly go to the cell referenced by name, you can select the name from the  __________.
A.
B.
C.
D.
25.  The __________ cell is the cell whose input values are placed in the first column of a data table.
A.
B.
C.
D.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.