Scribd Logo
Upload

Welcome to Scribd!

  • 35 views

    01 Excel Referencing, Conditional Formatting

    Uploaded by

    Aaron Orog
    The document provides instructions for 3 tasks involving formulas and conditional formatting in Excel: 1) Create formulas to calculate cell values based on referencing other cells. 2) Copy the formulas to other cells to generate tables of values. 3) Use conditional formatting to highlight cells meeting certain criteria.

    Copyright:

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

    01 Excel Referencing, Conditional Formatting

    Uploaded by

    Aaron Orog
    35 views14 pages
    The document provides instructions for 3 tasks involving formulas and conditional formatting in Excel: 1) Create formulas to calculate cell values based on referencing other cells. 2) Copy the formulas to other cells to generate tables of values. 3) Use conditional formatting to highlight cells meeting certain criteria.

    Original Title

    01 Excel Referencing, Conditional Formatting (1)

    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 provides instructions for 3 tasks involving formulas and conditional formatting in Excel: 1) Create formulas to calculate cell values based on referencing other cells. 2) Copy the formulas to other cells to generate tables of values. 3) Use conditional formatting to highlight cells meeting certain criteria.

    Copyright:

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

    01 Excel Referencing, Conditional Formatting

    Uploaded by

    Aaron Orog
    The document provides instructions for 3 tasks involving formulas and conditional formatting in Excel: 1) Create formulas to calculate cell values based on referencing other cells. 2) Copy the formulas to other cells to generate tables of values. 3) Use conditional formatting to highlight cells meeting certain criteria.

    Copyright:

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

    Referencing (1)

    Create a function in the yellow cell (D9) that adds the number in the cell above it and subtracts the number in the cell to its left.
    Copy paste the formula in the yellow cell (D9) to all the red cells.

    9 6 8 6 5 8 10 6 6
    4
    3
    2
    3
    4
    2
    3
    2
    2
    ell to its left.
    Referencing (2)
    Create a function in yellow cell D9 which adds the number in its column's top row (in blue) to the cell to
    Copy paste the formula in the yellow cell (D9) to all the red cells.

    1 3 3 4 3 2 2 1 2 1
    4
    4
    3
    2
    3
    1
    2
    4
    2
    4
    2
    (in blue) to the cell to its left.
    Referencing (3): Multiplication Table
    Create a multiplication table from 1 to 10 by making a formula in yellow cell (D9) and copy pasting it to a

    1 2 3 4 5 6 7 8 9 10
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    nd copy pasting it to all the red cells.
    Conditional Formatting (1)
    Below is a set of data showing the time it takes to get to Ateneo from Macros Highway for the month of
    Format Column D (Time) to be filled in RED if the day is considered traffic. A day is considered traffic is th

    Date Time (m)


    1-Apr 30.47
    2-Apr 15.16
    3-Apr 42.09
    4-Apr 31.48
    5-Apr 12.20
    6-Apr 43.31
    7-Apr 27.14
    8-Apr 32.18
    9-Apr 26.48
    10-Apr 24.19
    11-Apr 49.26
    12-Apr 33.29
    13-Apr 38.20
    14-Apr 26.91
    15-Apr 22.93
    16-Apr 57.08
    17-Apr 22.27
    18-Apr 39.31
    19-Apr 31.58
    20-Apr 19.16
    21-Apr 33.83
    22-Apr 57.68
    23-Apr 36.04
    24-Apr 56.36
    25-Apr 45.78
    26-Apr 42.63
    27-Apr 21.61
    28-Apr 36.43
    29-Apr 38.14
    30-Apr 21.24
    Macros Highway for the month of April.
    ffic. A day is considered traffic is the time taken >= 40)
    Referencing and Conditional Formatting: Grading She
    Input your ID Number in the Blue cell
    Create a formula in the yellow cell (I12) which computes for a student's final raw score given the weights
    Copy paste the formula to all the red cells.
    Format column J (Letter grades) according to the rules specified in the table to its right.
    Note: all grades here are randomized and are not reflective of the actual person. Thank you.

    Weights
    15% 15%
    ID Number Name Quizzes Recitation
    3.75 4.00
    140097 AHYONG, DAVID EMMANUEL Y. 4.00 3.50
    172760 ANG, FRANCISCO MANUEL R. 2.00 3.50
    140842 CHAN, KERWIN MALCOLM Y. 3.75 2.00
    121003 CONCEPCION, ANTON PAOLO C. 4.00 2.00
    170609 CRUZ, GABRIEL MARTIN S. 3.00 4.00
    134623 CRUZ, MARK JASON T. 4.00 3.50
    141091 CUA, ANA SHARMILA M. 1.00 0.00
    141226 DE LEON, ROLAND KRISTOFFER J. 2.00 4.00
    121412 DURAN, MICHAELMARK VINCENT C. 3.00 3.00
    131668 GALANG, ANTON LUIS R. 4.00 2.75
    141826 GORGONIO, FRANCIS NEIL I. 2.00 1.75
    141849 GUEVARA, ANA MARIA ISABEL C. 3.00 3.00
    141855 GUEVARRA, GIA NICOLE C. 2.00 1.00
    152190 IYOG, JONATHAN MAREL M. 4.00 3.00
    155258 JIAO, JONATHAN J. 2.00 3.00
    142080 KHO, JASMINE SARAH N. 2.75 1.00
    142179 LAT, JOSE LORENZO Q. 4.00 4.00
    142261 LEUTERIO, BRYAN CARLO A. 2.00 1.75
    144679 LLADO, MARC NATHANIEL C. 3.75 3.50
    142376 LOPEZ, KIARA MARIE CECILIA Y. 2.00 3.75
    142557 MANZANO, ANGELA LOUISE M. 2.00 4.00
    142586 MARGULIES, ELIZABETH ANNE 3.00 2.00
    133029 ORACION, JOSE PAOLO C. 4.00 4.00
    143445 RODRIGUEZ, MARIE PATRICIA CELINE S. 3.00 4.00
    143504 RYAN, CHLOE C. 3.00 4.00
    133619 SALUD, RAFAEL MIGUEL P. 0.00 0.00
    143785 SOON, RAPHAEL JOSHUA C. 4.00 3.00
    143818 SULTAN, JEFFREY TAYLOR R. 4.00 4.00
    143984 TANJUATCO, MICHAEL GABRIEL R. 4.00 3.50
    145173 TORRES, CAMILLE BIANCA Z. 2.25 3.25
    144197 UY, MATTHEW LAURENCE A. 4.00 2.00
    145177 UY, RENZ PHILIPPE C. 1.75 3.00
    124304 WANG, CEDRIC HANS C. 0.00 0.50
    tting: Grading Sheet
    final raw score given the weights of the requirements and their grades.

    ble to its right.


    person. Thank you.

    Weights
    30% 40%
    Midterms Finals Final Grade Letter Grade Raw Score Letter Grade
    3.50 3.75 0 F
    4.00 3.75 1 D
    3.00 3.00 2 C
    2.50 2.00 2.5 C+
    3.25 0.25 2.9 B
    4.00 4.00 3.4 B+
    0.00 1.50 3.8 A
    2.00 3.00
    1.00 3.00
    1.00 2.00
    3.50 3.75
    0.25 3.00
    4.00 4.00
    1.50 2.75
    0.00 4.00
    1.75 2.00
    4.00 3.75
    2.00 4.00
    3.00 3.25
    2.00 3.75
    1.00 3.00
    3.50 4.00
    0.00 2.00
    2.00 3.00
    4.00 3.00
    2.00 3.00
    0.75 2.00
    1.00 3.00
    3.50 3.75
    3.25 4.00
    2.00 4.00
    3.00 3.00
    3.00 4.00
    1.75 3.00
    Format
    F
    D
    C
    C+
    B
    B+
    A

    You might also like