Purchase Solution

Excel 2003 Multiple Choice

Not what you're looking for?

Ask Custom Question

1. Which of the following enables you to calculate the input value required to yield a desired outcome result?
a. Tools, Goal seek
b. Insert, Goal seek
c. Format, Goal seek
d. Tools, Options, Goal seek
e. Data, Goal seek
Save Answer

2. Which of the following belong in the Goal Seek dialog box?
a. By changing cell
b. To value
c. Set cell
d. both A and C are correct
e. A, B, and C are all correct
Save Answer

3. Which program evaluates the most efficient solutions for problems with multiple input values?
a. trial and error program
b. the Solver add-in program
c. random access selection program
d. linear regression program
e. VBA program
Save Answer

4. Which of the following is not a good application of the Solver add-in?
a. maximize profits
b. shift schedules for manufacturing
c. economic order quantities
d. minimize operating costs
e. all of these are good applications
Save Answer

5. Which of the following are valid constraints for the Solver add-in program?
a. C3>=42
b. $D$5<=$B$1
c. C6=F23
d. both A and C are correct
e. A, B, and C are all correct
Save Answer

6. Once you find an acceptable solution, Solver lets you create all of the following summary reports except:
a. Answer
b. Sensitivity
c. Demo
d. Limits
e. all of these reports can be created
Save Answer

7. Which of the following is an advantage of using Scenario Manager?
a. you can save multiple scenarios within a single workbook and then view and summarize their results at any time
b. when you select a scenario for display in the Scenario Manager dialog box, Excel 2003 instantaneously updates the current worksheet with the stored input values and outcomes
c. you can also generate a summary report that compares various scenarios
d. A and C are definite advantages of using Scenario Manager
e. A, B and C are all advantages of using Scenario Manager
Save Answer

8. Which of the following commands will add a new scenario?
a. View, Scenario
b. Data, Scenario
c. Tools, Scenario
d. File, Scenario
e. Insert, Scenario
Save Answer

9. Which of the following functions uses a linear (straight-line) trend equation to predict future values based on existing or historical results?
a. FORECAST
b. GROWTH
c. RSQ
d. TREND
e. LINEAR
Save Answer

10. What is the name of the special add-in program provided by Excel 2003, which enables advanced data analysis tools for performing complex statistical and engineering calculations?
a. Analysis ToolPak
b. Analysis ToolPack
c. Analysis Tools
d. Analysis kit
e. Complex Analysis Tool kit

Purchase this Solution
Solution Summary

This posting contains solutions to following excel 2003 MCQs.

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • High School Excel 2003 Questions

    =DAVERAGE(list_range, field_name, criteria_range) 1.b 2.b 3.a 4.b 5.d 6.c 7.b 8.e 9.a 10.a 11.b 12.a 13.c 14.c 15.e Answers provided to HS multiple choice quiz on MS Excel 2003.

  • Terry Corporation and Walker Clothing Store

    49541 Excel Solver Multiple Choice Terry Corporation had net income of $200,000 and paid dividends to common stockholders of $40,000 in 2003. The weighted average number of shares outstanding in 2003 was 50,000 shares.

  • MCQs: Time Series Analysis

    The solution provides answers to multiple choice questions on time series analysis.

  • Future Trends in Counselor Assessments

    However, as Liu and Wilson (2009) explain, in their assessment, no differences were found on multiple-choice items using the PISA 2000 and 2003 math assessment.

  • Analysis of assessment item types.

    Multiple binary choice test items are similar to simple binary choice items in that responses are still of two possible choices, as are the binary choice items.

  • Financial Accounting Problems

    51256 Multiple Choice Financial Accounting problems (See attached file for full problem description) --- I CASH FLOW Condensed financial data for West Corporation are given below.

  • Least Squares Trend Equation - Regression Analysis

    5 24.0 By using regression analysis: Solution: Using excel Data  data analysis  regression SUMMARY OUTPUT Regression Statistics Multiple R 0.997802097 R Square 0.995609025

  • 10 M/C Questions on Excel 2003

    129509 Excel 2003 Multiple Choice 1. The primary object in a MS Access database for collecting and storing data is a: a. record b. field c. file d. table e. database 2.

  • Preparation of an Income & Retained Earnings Statement

    Instructions (a) Prepare a multiple-step income statement. (b) Prepare a retained earnings statement. I have completed both statements in the attached Excel 97-2003 workbook.

View More Related Solutions