The following worksheet shows Product Name ,Unit cost in columns A and B. Write steps to compute selling price in column C when profit percentage is entered in cell D9. (Excel Problems)

The following worksheet shows Product Name ,Unit cost in columns A and B. Write steps to compute selling price in column C when profit percentage is entered in cell  D9.

To calculate selling price in column C,

Enter the formula

=B1+B1*$D$9 in cell C2 and then press enter key,

using the fill handle of cell C2, copy the formula to cells C3 :C6 by dragging the fill handle up to cell C6 .

 

Related Posts by Categories

Excel Problem

• Write steps to assign Rank and Compute Bonus using VLOOKUP() function in Excel-2007
• To compute letter grade using VLOOKUP( ) function in Excel-2007
• How to create Pivot table with different example. (To summarize the data using pivot table)
• To calculate result as “Fail” when percentage of marks (PER) is less than 35, otherwise “Pass”.
• To compute income tax in Excel-2007
• To compute DA. To compute HRA. To compute PF. To compute GROSS PAY. To compute column total. To find highest gross. To find LEAST gross. To find NO. OF ROWS WHERE BASIC PAY IS LESS THAN 20000 (Excel-2007)
• Arrange the data in the order of Dept and further in the order of Name. To display only those rows where salary is above Rs.15000. To display all the rows except the ‘STORES’ dept. (Excel-2007)
• To find the total marks of each student . To arrange the worksheet in descending order of total marks and further in the alphabetical order of names. To display those rows where the total marks are above 450. (Excel-2007)
• To find total sales for each city. To construct column chart for First Quarter and Fourth Quarter sales for all cities. To construct Pie chart of Total Sales. (Excel-2007)
• To find annual production in column F. To draw column chart of production of Rice & Wheat for 4 years. To draw PIE chart for the production of Year 2002. (Excel-2007)
• To create a straight-line chart. To construct 3-D pie diagramTo draw Bar diagram for total pass in Excel-2007
• Write steps to calculate total tax payable by the individuals at the following rate showing income tax, surcharge and total tax in column C, D & E respectively:Surcharge is to be calculated at 10% on the income tax only if the Income exceeds Rs.5 lakhs. (Excel-2007)
• Explain how to calculate the result in 8th column, a student is declared ‘PASS’ if he gets 40 or more in each subject or the average of marks is 50 or more, otherwise result is ‘FAIL’.(Excel-2007)
• Give steps to compute HRA at @20% of basic pay or Rs.3000 whichever is less, and DA is 70% of basic pay rounded to nearest 10 in column C and D respectively.(Excel-2007)
• Write steps to construct the following charts to display year along X Axis and sales of the two depots along Y Axis: (a) A 3-D column chart (b) A Line chart with column series (Excel-2007)
• Write steps to calculate the Simple Interest using what if Table for the following interest rates (Column input) and terms (Row input) (Excel-2007)
• Assign letter Grade in Column F using the following policy in Excel-2007
• Find Average of highest scoring in two tests (Excel-2007)
• Explain the steps to create two way data table for maturity amount and Interest for the table in cells A1:B5. (Excel-2007)
• Write steps to compute depreciation using reducing balance method or written down value method or Diminishing balance method in Excel-2007
• Write steps to compute Depreciation using straight line method or approach or Fixed Instalment method or Original Cost Method in Excel-2007
• The following worksheet shows Account no. , Name, Deposit amount, yearly rate of interest and no. of years of deposit. Assuming that the amount is compounded annually ,write steps to compute maturity amount in column F .(Excel Problems)
• The following worksheet shows Account no. , Name, Deposit amount, yearly rate of interest and no. of days of deposit. Write steps to compute simple interest in column E assuming 365 day year. (Excel Problems)
• The following worksheet shows Product Name ,Unit cost and % of profit in columns A ,B and C. Write steps to compute selling price in column D. (Excel Problems)

Excel Notes

• How to create a template in excel 2007?
• Tips for Setting Up a Table in Excel
• Table Terms in Excel
• Sorting Data in Excel (Sort Button and Sort Dialog Box)
• Separating Text in Excel (Separating the Data)
• Separating Text in Excel (Considerations)
• Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows)
• Hiding Columns, Rows, and Cells in Excel (Hiding Rows)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)
• Hiding Columns, Rows, and Cells in Excel (Hiding Columns)
• Find and Replace Features in Excel (Using the Replace Feature)
• Find and Replace Features in Excel (Using the Find Feature)
• Paste Special Feature in Excel (Paste Special Options)
• Paste Special Feature in Excel (Using the Paste Special Dialog Box)
• Using the Fill Command in Excel (Filling Cells, Filling Cells: Ribbon Option, Filling Cells: Mouse Option, Working with Custom Fills, Creating a Custom Fill, Importing Custom Fills, Using a Custom Fill)
• Working with Comments in Excel (Adding Comments, Adding Comments: Ribbon Option, Adding Comments: Mouse Option , Editing Comments, Editing Comments: Ribbon Option, Editing Comments: Mouse Option, Displaying/Hiding Comments, Displaying/Hiding Comments: Single Cell , Displaying/Hiding Comments: Ribbon Option, Displaying/Hiding Comments: All Cells , Moving Comments , Deleting Comments, Removing Comments from a Single Cell: Mouse Option, Removing Comments from a Single Cell: Ribbon Option, Removing Comments from All Cells, Printing Comments)
• Importing an External Data File in Excel
• Working with Rows and Columns in Excel (Adjusting Row Height and Column Width, Adjusting Row Height: Ribbon Option, Adjusting Row Height: Mouse Option, Adjusting Column Width: Ribbon Option, Adjusting Column Width: Mouse Option, Using AutoFit to Adjust Rows and Columns, Using AutoFit to Adjust Row Height: Ribbon Option, Using AutoFit to Adjust Column Width: Mouse Option, Using AutoFit to Adjust Column Width: Ribbon Option, Adding and Removing Rows and Columns, Adding Rows, Adding Columns, Deleting Rows, Deleting Columns)
• Calculating Subtotals in Excel (Adding Subtotals , Adjusting Views with Subtotals , To expand the view one level:, To collapse the view one level: , Removing Subtotals , Re-sorting the Data )
• Calculating with Functions in Excel (Parts of a Function , Inserting Functions, Inserting Functions: Dialog Box Option, Inserting Functions: Ribbon Option, About the Function Arguments Dialog Box, To access the Function Arguments dialog box:, Inserting Functions with the Point and Click Method, Adding Cells Together, Adding a Range of Cells with the SUM Function)
• Editing Cell Contents in Excel (Moving Information, Drag and Drop vs. Cut and Paste, Moving Information: Drag and Drop , To Undo Drag and Drop:, Moving Information: Cut and Paste , Copying Formulas, Copy and Paste )
• Working with Conditional Formatting in Excel (Applying Preformatted Rules , Applying Cell Highlighting , Applying Top, Bottom, and Average Rules , Applying Data Bars, Color Scales, and Icon Sets , Creating a Customized Rule , Editing Rules , Prioritizing Rules , Deleting Rules )
• Formatting Numbers in Excel (Formatting Numbers: Toolbar Option , Formatting Numbers: Ribbon Option , Formatting Numbers: Dialog Box Option , Clearing Number Formatting )
• Formatting Cells in Excel (Applying Cell Styles , Formatting Borders , Changing Borders, Changing Border Color , Changing Border Style , Deleting Borders , Using Conditional Formatting , Merging Cells , Creating a Cell Merge , Customizing a Cell Merge , Removing a Cell Merge , Wrapping Text, Copying Cell Formatting, Clearing Cell Formatting )