Microsoft Excel 2003 Exam 2

25 Questions  I  By Ichintu
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.


Question Excerpt

Removing question excerpt is a premium feature

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