Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Book1.1 Final

    Uploaded by

    photolabjsd
    This document contains four assignments with answers related to spreadsheet tools. The first assignment contains cell references and their uses. The second contains a table with risk data and calculations. The third shows a basic income statement with revenue, costs, and profit. The fourth displays student marks in different subjects and calculations of total marks.

    Copyright:

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

    Book1.1 Final

    Uploaded by

    photolabjsd
    3 views6 pages
    This document contains four assignments with answers related to spreadsheet tools. The first assignment contains cell references and their uses. The second contains a table with risk data and calculations. The third shows a basic income statement with revenue, costs, and profit. The fourth displays student marks in different subjects and calculations of total marks.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains four assignments with answers related to spreadsheet tools. The first assignment contains cell references and their uses. The second contains a table with risk data and calculations. The third shows a basic income statement with revenue, costs, and profit. The fourth displays student marks in different subjects and calculations of total marks.

    Copyright:

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

    Book1.1 Final

    Uploaded by

    photolabjsd
    This document contains four assignments with answers related to spreadsheet tools. The first assignment contains cell references and their uses. The second contains a table with risk data and calculations. The third shows a basic income statement with revenue, costs, and profit. The fourth displays student marks in different subjects and calculations of total marks.

    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 6

    ADVANCED SPREADSHEET TOOLS

    (Sem-I)
    ASSIGNMENT

    NAME :- OM BAGODIA
    ROLL NO. :- 3701
    B.COM HONS
    SEC :- C
    ANSWER 1

    A cell reference identifies the location of a cell or


    group of cells in the spreadsheet also referred as a cell address.
    Cell references are used in formulas, functions, charts, other
    Excel commands and also refer to a group or range of cells.
    ANSWER 2
    S.NO. RISK
    1 3.4 MEAN 3.24
    2 5.6 STANDARD DEVIATION 1.4960689
    3 2.8 VARIANCE 2.2382222
    4 1.3 coefficient of variance 46.17%
    5 1.5
    6 1.7
    7 3.4
    8 5.3
    9 4.2
    10 3.2
    ANSWER 3

    PRICE $35.00
    QUANTITY 174
    TOTAL REVENUE $6,086.96
    TRANSPORTATION $608.70
    ITEM COST $3,478.26
    TOTAL COST $4,086.96
    PROFIT $2,000.00
    ANSWER 4

    S NO. NAME SUB 1 SUB 2 SUB 3 TOTAL MARKS MARKS IN DIFF


    1 DEEP 30 34 45 109 140
    128 125
    2 JAYESH 40 38 50 128
    120
    3 YASH 45 40 40 125 109
    4 SANA 48 32 28 108 100
    5 SARA 30 21 30 81
    80
    6 KAPIL 32 25 35 92

    MARKS
    7 GITA 36 30 38 104 60
    50
    8 MINAL 40 34 42 116 45 45
    40 38 40 40
    40 34
    9 NEERAJ 42 28 43 113 30
    10 PRIYA 23 44 50 117 20

    0
    DEEP JAYESH YASH
    MARKS IN DIFFERENT SUBJECTS AND TOTAL
    128 125
    116 117
    113
    108
    104
    92
    81

    50 48 50
    45 42 42 43 44
    40 38 40 40 38 40
    35 36 34
    32 30 30 32 30
    28 25 28
    21 23

    JAYESH YASH SANA SARA KAPIL GITA MINAL NEERAJ PRIYA

    SUB 1 SUB 2 SUB 3 TOTAL MARKS

    You might also like