Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap

    Uploaded by

    Cathryne Kisha Flores
    The document contains a grocery list with 29 items categorized into different types. It provides the item name, category, price, and price description. There are tasks at the bottom to analyze the data such as calculating subtotals by category, averages, and creating a column chart to visualize the results.

    Copyright:

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

    Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap

    Uploaded by

    Cathryne Kisha Flores
    11 views3 pages
    The document contains a grocery list with 29 items categorized into different types. It provides the item name, category, price, and price description. There are tasks at the bottom to analyze the data such as calculating subtotals by category, averages, and creating a column chart to visualize the results.

    Original Title

    spreAdsheat

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a grocery list with 29 items categorized into different types. It provides the item name, category, price, and price description. There are tasks at the bottom to analyze the data such as calculating subtotals by category, averages, and creating a column chart to visualize the results.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    11 views3 pages

    Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap Cheap

    Uploaded by

    Cathryne Kisha Flores
    The document contains a grocery list with 29 items categorized into different types. It provides the item name, category, price, and price description. There are tasks at the bottom to analyze the data such as calculating subtotals by category, averages, and creating a column chart to visualize the results.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    Item Category Amount Price Description TASKS

    Juice beverages ₱ 10.00 Cheap


    1
    Iced Tea beverages ₱ 17.00 Cheap
    Sardines canned goods ₱ 18.00 Cheap 2
    Popcorn snacks ₱ 22.00 Cheap 3
    Tuna canned goods ₱ 24.00 Cheap 4
    Dishwashing Soap cleaning products ₱ 29.00 Cheap 5
    Wipes baby stuff ₱ 29.00 Cheap 6
    Sports drink beverages ₱ 30.00 Cheap 7
    Butter dairy ₱ 32.00 Cheap 8
    Bath Soap personal care ₱ 38.00 Cheap 9
    Bananas fruits ₱ 44.00 Cheap
    Cookies snacks ₱ 46.00 Cheap 10
    Garbage Bag cleaning products ₱ 46.00 Cheap
    Broccoli vegetable ₱ 54.00 Cheap
    Toothpaste personal care ₱ 56.00 Cheap 11
    Apples fruits ₱ 60.00 Cheap
    Carrots vegetable ₱ 61.00 Cheap Find the Sum of the following item c
    Mangoes fruits ₱ 65.00 Cheap 12
    Shampoo personal care ₱ 89.00 Cheap 13
    Air Freshener cleaning products ₱ 96.00 Cheap 14
    Milk dairy ₱ 108.00 Expensive 15
    Diaper baby stuff ₱ 112.00 Expensive 16
    Chicken meat ₱ 120.00 Expensive 17
    Detergent cleaning products ₱ 120.00 Expensive 18
    Hotdog meat ₱ 128.00 Expensive 19
    Ground Pork meat ₱ 140.00 Expensive 20
    Bathroom cleaner cleaning products ₱ 298.00 Expensive 21
    Baby wash baby stuff ₱ 566.00 Expensive 22
    Champagne beverages ₱ 990.00 Expensive
    23
    24
    25
    TASKS ANSWERS
    Sort Items based on the Amount
    Format your answers into Currency in PESO with 2 decimal places
    What is the SUM of the grocery list? 3448.00
    What is the SUM of all cleaning products? 589.00
    What is the AVERAGE spend? 118.90
    What is the AVERAGE spend among baby stuff? 235.67
    How many items are in the list? 29.00
    How many beverages items are in the list? 4.00
    What is the minimum price list? 10.00
    What is the maximum price list? 566.00
    Fill in the Price Description Column per Item using IF Function
    If PRICES are Below P100 = Cheap
    If PRICES are Above P100 = Expensive
    Format the cells in Price Description column with the following details
    CHEAP = GREEN Font
    EXPENSIVE = RED Font
    Find the Sum of the following item categories
    baby stuff 707
    beverages 1047
    canned goods 42
    cleaning products 589
    dairy 140
    fruits 169
    meat 388
    personal care 183
    snacks 68
    vegetable 115
    Create a COLUMN Graph among the Subtotals
    Show the following details:
    Chart Title "GROCERIES"
    Show X-Y Axes
    Show Legend

    GROCERIES
    ₱1,200.00

    ₱1,000.00

    ₱800.00

    ₱600.00
    Y-AXIS

    Column C
    ₱400.00

    ₱200.00

    ₱-
    1 3 5 7 9 11 13 15 17 19 21 23 25 27 29

    X-AXIS
    ₱600.00

    Y-AXIS
    Column C
    ₱400.00

    ₱200.00

    ₱-
    1 3 5 7 9 11 13 15 17 19 21 23 25 27 29

    X-AXIS

    You might also like