Scribd Logo
Upload

Welcome to Scribd!

  • 1K views

    ASSIGNMENT - Excel Lab 1

    Uploaded by

    jobishchirayath1219
    The document provides instructions for an Excel lab assignment covering creating and saving a workbook, entering text and formulas, applying styles, and performing basic math operations. Students are asked to create a workbook called ExcelLabOne, enter text labels for math operations, insert rows and merge/center cells, apply various styles, then enter formulas to perform addition, subtraction, multiplication and division with and without parentheses.

    Copyright:

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

    ASSIGNMENT - Excel Lab 1

    Uploaded by

    jobishchirayath1219
    1K views2 pages
    The document provides instructions for an Excel lab assignment covering creating and saving a workbook, entering text and formulas, applying styles, and performing basic math operations. Students are asked to create a workbook called ExcelLabOne, enter text labels for math operations, insert rows and merge/center cells, apply various styles, then enter formulas to perform addition, subtraction, multiplication and division with and without parentheses.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for an Excel lab assignment covering creating and saving a workbook, entering text and formulas, applying styles, and performing basic math operations. Students are asked to create a workbook called ExcelLabOne, enter text labels for math operations, insert rows and merge/center cells, apply various styles, then enter formulas to perform addition, subtraction, multiplication and division with and without parentheses.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1K views2 pages

    ASSIGNMENT - Excel Lab 1

    Uploaded by

    jobishchirayath1219
    The document provides instructions for an Excel lab assignment covering creating and saving a workbook, entering text and formulas, applying styles, and performing basic math operations. Students are asked to create a workbook called ExcelLabOne, enter text labels for math operations, insert rows and merge/center cells, apply various styles, then enter formulas to perform addition, subtraction, multiplication and division with and without parentheses.

    Copyright:

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

    ASSIGNMENT: Excel Lab 1

    ITEMS COVERED IN THIS LAB

     Create a Blank Workbook


     Save a Workbook
     Modify an Excel Spreadsheet
     Enter Text Values in Excel Cells
     Merge and Center Text
     Apply Styles
     Create Basic Formulas

    Instructions
    1. Create a Blank workbook
    2. Save the Workbook as ExcelLabOne.xlsx in Document > MSExcelLabs folder
    3. Type “Working with Excel Math” in cell A1
    4. Merge and Center the text in cell A1 to the range A1:E1
    5. Apply Title style to the range A1:E1
    6. Type Addition in cell A2
    7. Type Subtraction in cell A3
    8. Type Multiplication in cell A4
    9. Type Division in cell A5
    10. Auto-fit the contents in column A
    11. Insert a row above row #2
    12. Type “Basic Math” in cell A2
    13. Merge and Center the text in cell A2 to the range A2:E2
    14. Apply Heading 4 to the range A2:E2
    15. Apply the Calculation Style to the range A3:A6
    16. Type = 4 + 6 / 2 in cell B3 then type = (4 + 6) / 2 in cell D3
    17. Type = 6 – 6 * 2 in cell B4 then type = (6 – 6) * 2 in cell D4
    18. Type = 2 * 2 + 6 in cell B5 then type = (2 * 2) + 6 in cell D5
    19. Type = 9 / 3 + 4 in cell B6 then type = ( 9 / 3 ) + 4 in cell D6
    20. Press Ctrl + ~ then press Ctrl + ~ again
    21. Save and submit ExcelLabOne.xlsx to your instructor
    Here Is a Sample Solution

    You might also like