Scribd Logo
Upload

Welcome to Scribd!

  • 53 views

    Group 7 Excel Questions

    Uploaded by

    SIMRAN SHOKEEN
    Here is the function to derive the name and date in the output format from the Name and DOB columns: =TEXT(G2,"ddd-mmm-yyyy") This will convert the date in G2 to a text string in the format "ddd-mmm-yyyy". Name DOB OUTPUT Kanak 11/30/1999 Mon-Nov-1999

    Copyright:

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

    Group 7 Excel Questions

    Uploaded by

    SIMRAN SHOKEEN
    53 views16 pages
    Here is the function to derive the name and date in the output format from the Name and DOB columns: =TEXT(G2,"ddd-mmm-yyyy") This will convert the date in G2 to a text string in the format "ddd-mmm-yyyy". Name DOB OUTPUT Kanak 11/30/1999 Mon-Nov-1999

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Here is the function to derive the name and date in the output format from the Name and DOB columns: =TEXT(G2,"ddd-mmm-yyyy") This will convert the date in G2 to a text string in the format "ddd-mmm-yyyy". Name DOB OUTPUT Kanak 11/30/1999 Mon-Nov-1999

    Copyright:

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

    Group 7 Excel Questions

    Uploaded by

    SIMRAN SHOKEEN
    Here is the function to derive the name and date in the output format from the Name and DOB columns: =TEXT(G2,"ddd-mmm-yyyy") This will convert the date in G2 to a text string in the format "ddd-mmm-yyyy". Name DOB OUTPUT Kanak 11/30/1999 Mon-Nov-1999

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 16

    Description Amount

    Carlota/West: 658 13 658 658


    Aspen/South: 345 12 345
    Yanaki/South: 19.5 13 19.5
    FlatTop/South: 987.75 14 987.75
    Carlota/West: 658 13 658
    Carlota/East: 23.5 13 23.5
    Carlota/ West: 321 14 321
    Yanaki/East: 1209.5 12 1209.5
    Yanaki/East: 123.5 12 123.5
    Quad/West: 399.95 10 399.95

    Q. DERIVE THE AMOUNT FROM DESCRIPTION USING A DYNAMIC FORMULA.


    Q. Use Replace function only, to derive result in
    the format (mmm-mmm-mmm).

    Original text Result


    123456789 123-456-789
    345678912 345-678-912
    125678349 125-678-349
    145678239 145-678-239
    156123789 156-123-789
    736738563 736-738-563
    738568390 738-568-390
    289476984 289-476-984
    187452091 187-452-091

    Hint: Use nested replace function.


    Q. Change the domian "@abc", to "@bca" and if the domain is different then
    original email value should be derived in the result column?

    Original email Result


    [email protected]
    [email protected]
    [email protected]
    [email protected]
    [email protected]
    [email protected]
    [email protected]
    [email protected]
    Rank Film Title Studio Year

    The Wizard of Oz (1939) Directed by King Vidor and Warner Bros.


    1 Victor Fleming 1939

    2 Citizen Kane (1941) Directed by Orson Welles RKO Radio 1941

    3 Get Out (2017) Directed by Jordan Peele Universal 2017

    4 The Third Man (1949) Directed by Carol Reed Rialto 1949

    Mad Max: Fury Road (2015) Directed by George


    5 Miller Warner Bros. 2015

    The Cabinet of Dr. Caligari (Das Cabinet des Dr.


    6 Caligari) (1920) Directed by Robert Wiene Rialto 1920

    All About Eve (1950) Directed by Joseph L.


    7 Mankiewicz 20th Century Fox 1950

    Inside Out (2015) Directed by Pete Docter and


    8 Ronnie del Carmen Disney/Pixar 2015

    9 Metropolis (1927) Directed by Fritz Lang Paramount 1927

    10 Moonlight (2016) Directed by Barry Jenkins (III) A24 Films 2016

    Use wildcards in
    Hints
    SEARCH
    Director + Directed by Director Only

    Directed by King Vidor and King Vidor and


    Victor Fleming Victor Fleming
    25 37 1939

    Directed by Orson Welles Orson Welles


    21 33
    Directed by Jordan Peele Jordan Peele 16 28
    Directed by Carol Reed Carol Reed
    22 34
    Directed by George Miller George Miller
    27 39

    Directed by Robert Wiene Robert Wiene


    67 79
    Directed by Joseph L. Joseph L.
    Mankiewicz Mankiewicz 22 34
    Pete Docter and
    Directed by Pete Docter and
    Ronnie del
    Ronnie del Carmen Carmen 19 31
    Directed by Fritz Lang Fritz Lang
    19 31

    Directed by Barry Jenkins (III) Barry Jenkins (III)


    18 30

    SEARCH for Directed SEARCH for By


    Name Required Output Write the function here

    Veer Pratap Singh VP Singh V 5P


    Mahendra Singh Dhoni MS Dhoni M 9S
    Ram Kumar Prasad RK Prasad R 4K
    Mayank R Sharma MR Sharma M 7R
    Deep Das Gupta DD Gupta D 5D
    Rahul Raj Rawat RR Rawat R 6R
    Rohan Madan Pal RM Pal R 6M
    Shyam Kumar Biswas SK Biswas S 6K
    Vijendra Singh Tripathi VS Tripathi V 9S

    Q. Derive the required output from name.


    12 Singh VP Singh
    15 Dhoni MS Dhoni
    10 Prasad RK Prasad
    9 Sharma MR Sharma
    9 Gupta DD Gupta
    10 Rawat RR Rawat
    12 Pal RM Pal
    12 Biswas SK Biswas
    15 Tripathi VS Tripathi
    Extract first initial of first name and
    Names Required Output first initial of last name separated by
    a space
    Gil Chung GC GC
    Fredric Odonnell FO FO
    Mindy Santos MS MS
    Gladys Pena GP GP
    Rae Murray RM RM
    Lynnette Watson LW LW
    Hugh Shields HS HS
    Dorian Greene DG DG
    Valentin Sherman VS VS
    Sophie Mosley SM SM

    Q. Derive the required output from names.


    Column1 Column2
    Name Education
    DuckinG samuels Arts Input
    LoreN DaMning commerce Tubri MAoto
    SheRo MaliTuUiJa Btech
    Hebroo Sunia Btech
    Tubri MAoto Btech DuckinG samuels
    FrnondeKL PHIlipsp Arts LoreN DaMning
    SheRo MaliTuUiJa
    Hebroo Sunia
    Tubri MAoto
    FrnondeKL PHIlipsp

    Hint:Use proper
    function
    to
    solve
    Output
    Tubri Maoto Tubri Maoto Education

    Ducking Samuels Ducking Samuels Arts


    Write a function for cells H7 to H12
    Loren Damning Loren Damning Commerce and the output should be in the form
    Shero Malituuija Shero Malituuija Btech cell H5.
    Hebroo Sunia Hebroo Sunia Btech
    Tubri Maoto Tubri Maoto Btech
    Frnondekl Philipsp Frnondekl Philipsp Arts
    lls H7 to H12
    be in the form
    Column1 Column2
    Name Education
    DuckinG samuels Arts
    LoreN DaMning commerce
    SheRo MaliTuUiJa Btech
    Hebroo Sunia Btech Input
    Tubri MAoto Btech DuckinG samuels
    FrnondeKL PHIlipsp Arts LoreN DaMning

    DuckinG samuels
    LoreN DaMning
    SheRo MaliTuUiJa
    Hebroo Sunia
    Tubri MAoto
    FrnondeKL PHIlipsp

    Hint:Use proper function


    to
    solve
    Output
    Ducking SamuelsDucking SamuelsDucking Samuels15
    Loren DamningLoren DamningLoren Damning13

    Ducking SamuelsDucking SamuelsDucking Samuels15 Write a function for cells G13


    to G18
    Loren DamningLoren DamningLoren Damning13 and the output should be in the form
    Shero MalituuijaShero MalituuijaShero Malituuija16 cell G9 and G10
    Hebroo SuniaHebroo SuniaHebroo Sunia12
    Tubri MaotoTubri MaotoTubri Maoto11
    Frnondekl PhilipspFrnondekl PhilipspFrnondekl Philipsp18
    function for cells G13
    to G18
    put should be in the form
    ell G9 and G10
    USING RIGHT USING REPLACE
    NAMES LAST NAME LAST NAME
    Anumeet Kaur Singh Singh 13
    Kanika Karan Vats Vats 13
    Vipul Mohan Sharma Sharma 12
    Jyotika Aman Rana Rana 13
    Raghevendra Singh Rajput Rajput 18
    Sonali Singh Chauhan Chauhan 13
    Mayank R Prajapati Prajapati 9
    Deepika Karan Sharma Sharma 14
    NAMES DOB NAME AND DATE
    Anumeet 1/1/1991
    Kanika 7/15/1979
    Vipul 7/14/1980
    Jyotika 4/12/1990
    Raghevendra 4/13/1931

    Q. Derive name and date in the output format.

    hint: Use TEXT function


    Name DOB OUTPUT
    Kanak 11/30/1999 Kanak-Tuesday-Nov-1999

    You might also like