Scribd Logo
Upload

Welcome to Scribd!

  • 277 views

    BPC Computer 113 Practical Exam

    Uploaded by

    Clara Jane Caparas
    1. The document provides instructions to create a pie chart showing sales performance data by salesperson using a table with sales figures by quarter. 2. A second table is provided with additional sales data and instructions are given to calculate total sales, average sales, commissions, and compare sales in quarters 1 and 3 using a chart. 3. A worksheet with expenses data is provided and a series of instructions are given to format, calculate values, and analyze the budget vs actual expenses data. Formulas, formatting, totals, and percentages are to be added to the worksheet.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    BPC Computer 113 Practical Exam

    Uploaded by

    Clara Jane Caparas
    277 views2 pages
    1. The document provides instructions to create a pie chart showing sales performance data by salesperson using a table with sales figures by quarter. 2. A second table is provided with additional sales data and instructions are given to calculate total sales, average sales, commissions, and compare sales in quarters 1 and 3 using a chart. 3. A worksheet with expenses data is provided and a series of instructions are given to format, calculate values, and analyze the budget vs actual expenses data. Formulas, formatting, totals, and percentages are to be added to the worksheet.

    Original Description:

    computer

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document provides instructions to create a pie chart showing sales performance data by salesperson using a table with sales figures by quarter. 2. A second table is provided with additional sales data and instructions are given to calculate total sales, average sales, commissions, and compare sales in quarters 1 and 3 using a chart. 3. A worksheet with expenses data is provided and a series of instructions are given to format, calculate values, and analyze the budget vs actual expenses data. Formulas, formatting, totals, and percentages are to be added to the worksheet.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    277 views2 pages

    BPC Computer 113 Practical Exam

    Uploaded by

    Clara Jane Caparas
    1. The document provides instructions to create a pie chart showing sales performance data by salesperson using a table with sales figures by quarter. 2. A second table is provided with additional sales data and instructions are given to calculate total sales, average sales, commissions, and compare sales in quarters 1 and 3 using a chart. 3. A worksheet with expenses data is provided and a series of instructions are given to format, calculate values, and analyze the budget vs actual expenses data. Formulas, formatting, totals, and percentages are to be added to the worksheet.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Computer 113

    1. From the data given in the table below, create a Pie Chart to show the distribution of the
    total amount amongst the various salesmen.
    A B C D E F
    1 ABC Company Sales Performance Report
    2
    3 Salesman Qtr1 Qtr2 Qtr3 Qtr4 Total
    4 Albert 148 156 171 140 615
    5 Carl 122 131 153 118 524
    6 Cornell 211 243 246 250 950
    7 Edwin 129 150 92 218 589
    8 Francis 311 270 247 322 1,150

    2.
    A B C D E F G H I
    1 XYZ COMPANY SALES PERFORMANCE
    2
    3
    4 SALESPERSON ANNUAL QTR1 QTR2 QTR3 QTR4 TOTAL AVERAGE
    TARGET SALES SALES COMMISSION
    5
    6 ALBERT 750 148 256 133 154 X
    7 MICHAEL 650 187 143 258 143 X
    8 CARL 800 233 200 216 152 X
    9 GEORGE 700 256 145 136 259 X
    10 LUCY 1,000 249 212 215 124 X
    11
    12 TOTAL X X X X X X
    13
    14 COMMISSION 6%
    15
    a. Given the table above, write formulas or describe how you would calculate the Total Sales in
    column G and Row 12.
    b. How would you calculate the Average Sales? Write the formula as it should appear in Excel
    and show the method of duplicating it to the other cells.
    c. How would you calculate the Commission? Write the formula as it would appear in Excel
    and explain the method of duplicating it to the other cells.
    d. You are asked to compare QTR1 and QTR3 sales for all salespersons in the above table using
    a chart:
    (a). What range of cells do you need to select and how would you select it?
    (b).What type of graph would you use?
    3.Use the worksheet given to answer the questions that follow:
    Expenses for the Month
    of January vs. Budget

    Budget Savings
    Salaries and Wages 156675.00
    Rent 4300.00
    Electricity 1000.00
    Telephone 200.00
    Advertisements 20000.00
    Freight and clearing 15650.00
    Security 3800.00

    Questions
    (i). Insert a new column between Budget and Savings column.
    (ii). Enter the title ‘Actual’ in cell C3.
    (iii). Enter the following figures in the new column.
    Actual
    Salaries and Wages 145200
    Rent 4300
    Electricity 1207
    Telephone 142
    Advertisements 18550
    Freight and clearing 13400
    Security 3800
    (iv). Calculate the savings in cells D4:D10.
    (v). Format the sheet title to Arial Black, size 14, and Bold.
    (vi). Save the file as Audit 1.
    (vii). Format the range B4:D10 to two decimal places.
    (viii). Adjust column C such that all the values are displayed.
    (ix). Add the title Savings % in cell E3 and calculate the savings as a percentage of the budget.
    (x). Format the range E4:E10 as a percentage.
    (xi). Enter the row title Total in cell A12 and obtain totals for Budget, Actual, and Savings
    columns.
    (xii). Copy the formula in E10 to E12.
    (xiii). Format the new heading to match the existing headings and Align the heading to Right.
    (xiv). Save and Close the worksheet.

    You might also like