Set up a drop-down menu, Set up a drop-down menu in C13 to

Set up a drop-down menu

Assignment Help Accounting Basics

Reference no: EM132671604

The file named Candybardata.xlsx contains a list of stores where you sell candy bars. The worksheet also contains the types of candy bars you sell at each store and the price charged for each candy bar. Set up your worksheet so that users can enter or select both the store and a candy bar from a drop-down menu and have the price show up in D19.

Question 1: Enable users to select a store from the drop-down menu in B19.

Question 2: Set up a drop-down menu in C13 to let users choose a type of candy bar from a list containing only those candy bars sold at a selected store. Hint: Use the INDIRECT function when defining the list.

Question 3: If you change the store in B19, then C19 might temporarily not list a candy bar sold at the newly selected store. Ensure that in C19, your worksheet reads Make selection above if this is the case. For example, if B19 contains CVS and C13 contains gumballs, then C19 should display Make selection above

Reference no: EM132671604

Questions Cloud

Transformation strategies from semi-structured data format : Common logging structure of a social media server Twitter, Facebook, LinkedIn and Transformation Strategies from Semi-Structured Data Format JSON to Relational

Determine the annual worth of the project : The following cash flow is associated with a project under consideration in your company. Determine the annual worth of the project

Future evolutionary change of physical structures : Tell why you feel that we will have no future evolutionary change of our physical structures. Remember you also must use Darwinian principles.

Make the journal entry to record the revaluation of asset : Withdrawal of a Partner Ventic was the senior member, Make the journal entry to record the revaluation of the assets on June 5 prior to dissolution of the firm

Set up a drop-down menu : Set up a drop-down menu in C13 to let users choose a type of candy bar from a list containing only those candy bars sold at a selected store

Analyze the effect of the issuance of the promissory note : Identify and analyze the effect of the issuance of the promissory note. Notes Payable and Interest On July 1, 2017, Kamer's Trinkets borrowed $29,000

Prepare the current liabilities section of atunlu : Prepare the Current Liabilities section of Atunlu's 2017 balance sheet. Atunlu Partial Balance Sheet As Of December 31, 2017 Current liabilities

How much is the cash shortage as of June : A check drawn by Raki - Raki, Inc., payable to the order of Jingle, fund custodian 1,100. How much is the cash shortage as of June 30, 2007

Change management impact on projects : Changing Organizational Priorities that change scope of projects and Change Management impact on Projects and/or Change management impact on operations

User Account

All Pages