MIS lect excel (Autosaved).xlsx - Arithmetic Functions Random Serial Number 0.9769974 1 0.2084956 2 0.5313813 3 0.2363869 4 0.4021892 5 0.6265133 6

MIS lect excel (Autosaved).xlsx - Arithmetic Functions...

This preview shows page 1 - 16 out of 24 pages.

Arithmetic Functions:RandomSerial NumberRandom BetweenSumAverageCount0.976997418039949.87580.20849562140.53138133640.23638694900.40218925220.62651336140.19087257260.77227328783991238.3571428571Notes:Alt+I+C: Adds a column To find the forecast for the 12th month:R050100150200250300350
Background image
ProductSumproductWeighted AverageQuotientRemainder76960173148.083333333319235279340.958RandomSerial NumberRandom BetweenRow 10Row 9Row 8Row 7Row 6Row 5Row 4
Background image
INTABSROUNDCEILINGFLOORFACT-345344.56-344.6-300-40020922789888000Parameter1Parameter2502556138222632339295244CORRELATIONSTD DEVRANKING-0.209126129 35.730938971
Background image
Background image
Number-344.56
Background image
Top 10 movies of Hollywood of 2016 so farSerial NumberMoviesIMDB ScoreWW BOScore1 Avatar7.976060042 Titanic7.76585066.63 Star Wars: The Force Awakens8.29367675.24 Jurassic World765245645 The Avengers8.16235046.36 Furious 77.235025207 Avengers: Age of Ultron7.5458343588.138030789 Frozen7.64003040107.24082937.6Harry Potter and the Deathly Hallows: Part 2Iron Man 3
Background image
RankSum of the top 10 grossing movies: 56252Average of top 10 movies:562.5031Max BO amongst top 109365Min BO amongst top 10350410Max IMDB Score8.26Min IMDB Score778Correlation between IMDB score & BO0.45198898289
Background image
Text FunctionsCASE FUNCTIONSFirst NameSurnameName (Concatenation)Upper CaseLower CaseGayatriSawantMs. Gayatri SawantGAYATRIgayatriJaneDoeMs. Jane DoeJANEjaneAdamSmithMr. Adam SmithADAMadam
Background image
ProperLengthLefRightReplaceGayatri18 GayaatriAAyatriJane12 JaneneAAneAdam14 AdamamAAam
Background image
DATE FUNCTIONSSubstituteDOBAgeYearsDaysGayatri3/24/199028.4328158Jane5/6/198236.3236117Adam2/3/197741.5841210593First B'day210Years 5Days935 Years and 93 Days593Difference between ages of Jane and Adam
Background image
Specialization- all -Count - NameGraduationStateB.ComB.E. B.M.MB.M.SB.PharmB.Sc (emptyB.A.FTotal ResulGujrat22Maharashtra8215715148#N/A1515Total Result823571515165
Background image
lt
Background image
Column NameNameRoll No.Roll No31ValueMamta Avadia23NameMamta Avadia4Column No25ValueB.E.678910111213141516171819202122232425262728293031323334353637383940414243
Background image
44454647484950515253545556575859606162636465
Background image
NameGraduationSpecializationCityStateNumber
Background image
Image of page 16

You've reached the end of your free preview.

Want to read all 24 pages?

  • Summer '17
  • Rusha Das
  • Gujarat, Err

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture