User Account

All Pages

What-if analysis command in the data tools group on the data

Assignment Help Business Economics
Reference no: EM13925882

Question 1.

Excel's multiple worksheet abilities can do all of the following EXCEPT:

create Pivot Charts

group worksheets together to enter data.

display worksheets side by side.

create links among the worksheets.

Question 2.

If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets:

the same formula is entered into all grouped worksheets.

the formula changes by one row in each grouped worksheet.

the formula changes by one column in each grouped worksheet.

nothing happens to the other sheets.

Question 3.

If the active cell is in row 1, but not in column A, when you click the Split command, the worksheet will appear in two ________

panes.

horizontal

diagonal

vertical

square

Question 4. In Excel, which of the following is NOT a method for removing a split window?

Drag a split bar to the edge of the worksheet.

Double-click a split bar.

Click Split in the Window group on the View tab.

Right-click in the active cell and click Remove.

Question 5.Which of the following functions do NOT work with 3D formulas?

SUM

VLOOKUP

AVERAGE

COUNT

Question 6.

Before you can create an external reference you must first __________.

select the cell or cells to hold the external reference.

open the destination workbook and all source workbooks.

switch to the source workbooks and click the cells.

click on Insert Function on the Formulas tab.

Question 7.

Which of the following is the proper use of a 3D formula?

=SUM(Yr1:Yr5!C7)

=SUM(Yr1-Yr5!C7)

=SUM('Yr1:Yr5'!C7)

=SUM("Yr1:Yr5"!C7)

Question 8.

When creating a range for the substitution values in a one-variable data table, it is best to arrange

them in a(n) ________ orientation.

Horizontal

Vertical

Alphabetical

Reverse

Question 9. 

Which What-If Analysis tool would be best at comparing the combined effects of various interest rates

and down payments?

Scenario Manager

Goal Seek

One-variable data table

Two-variable data table

Question 10.

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?

Scenario Manager

Solver

Data Table

Goal Seek

Question 11.

The value you want to achieve in Goal Seek needs to be entered in the ________ box in the Goal

Seek dialog box.

Set cell

By changing cell

To value

Goal

Question 12.

Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

Scenario Manager

Goal Seek

Data Table

Solver

Question 13.

Which of the following is NOT one of the three parameters in Solver?

Constraints

Objective cell

Changing variable cells

Input value

Question 14.

Which of the following is NOT required for Solver to generate a solution?

Constraints

A formula that produces a value to be optimized

Precedent values

Variables that change within the specified limitations

Question 15.

Which of the following has to be loaded onto Excel?

Goal Seek

Solver

Scenario Manager

Data Tables

Reference no: EM13925882

Questions Cloud

Difference between net income and the amount of cash flow : Explain the difference between net income and the amount of cash flow from operating activities.
Determine the value of swap for dollars and pounds floating : Determine the value of the swap for each of the following cases: Dollars fixed, pounds fixed, Dollars fixed, pounds floating and Dollars floating, pounds floating.
History surrounding the numerous brands and types of coffee : Ask friends to go get coffee and the first question is which Starbucks is close for everyone to meet. Many know and enjoy Starbucks coffee but not many know the history surrounding the numerous brands and types of coffee. Opening in the 1970s the ..
Describe the phenomenons of osmosis : Describe the phenomenons of osmosis, freezing point lowering and boiling point increase and what is the osmotic pressure of the above salt/sugar solution in comparison to pure water?
What-if analysis command in the data tools group on the data : Which of the following is NOT required for Solver to generate a solution?
Spent focusing on a handful of different concepts : This week in class was spent focusing on a handful of different concepts. For example, we learned about the five steps which are required while testing a research hypothesis. We were introduced to the concept of comparing the means of two or more..
Experiment using thin-layer chromatography : At the start of the algal filament experiments, the bacteria were evenly distributed throughout the chamber. Subsequently, after the chamber was left in the dark for two minutes, the bacteria were
Discuss the advantage of estimating the amount : Discuss the advantage of estimating the amount of warranty expense.
What would you describe as the strengths in your writing : Describe a writing assignment (for either school or work) where you spent time proofreading your draft. Did your writing improve after you looked at your draft a second time? What kinds of changes did you make before turning it back to your instru..

Reviews

Write a Review

Business Economics Questions & Answers

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd