Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Tahsan - CSE101 R

    Uploaded by

    232007202
    computer science presentation

    Copyright:

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

    Tahsan - CSE101 R

    Uploaded by

    232007202
    5 views10 pages
    computer science presentation

    Original Title

    Tahsan_CSE101 R

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    computer science presentation

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    5 views10 pages

    Tahsan - CSE101 R

    Uploaded by

    232007202
    computer science presentation

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 10

    Name: Tahsan Uddin Ahmed

    Id: 232007202

    section: 2

    Course Code: CSE 101

    Course Instructor: Sidratul Muntaha

    Assignment: Excel Assignment


    Task 1: Basic Data Manipulations

    1.Sorting data: Select the whole sales amount data then go to the data option and select z-a for
    descending order.

    Select the whole salesman data and go to the data option to select a-z for the ascending order.
    2. Removing Duplicates: Select the salesman column and go to the “Remove duplicate” for the answer.

    3. Creating Charts: For the bar chart 1st select the sales amount column then press ctrl and also select
    the salesman column. Then select bar chart option.

    For the line chart, 1st select the sales amount column then press ctrl and also select the salesdate
    column. Then go to the line chart option for the answer.
    Task 2: Mathematical Functions

    For sum, =sum(select the whole sales amount column)

    For average, =average(select the whole sales amount column)

    For minimum, =min(select the whole sales amount column)

    For maximum, =max(select the whole sales amount column)

    For count, =count(select the whole sales amount column)

    For countA, =countA(select the whole sales amount column)

    For Mod, =mod(sum,1000)


    Task 3: Logical Functions

    1. Performance Evaluation: Make a column name performance then write 5000 in another column. Then
    write =IF(salesamount>5000,”HIGH”,”LOW”)

    2. Conditional Alerts: Make a column name alert and write 2000 in another coloumn and write
    =AND(salesamount<2000,sales date<DATEVALUE(“O1/01/2024”)).

    Make a column name “Sales Issue”. Then write 1000 in another column and write =OR(sales
    amount<1000,salesdate=”WEEKEND”).

    4.Negation check: make a column name date check and write =NOT(YEAR(orderdate)=YEAR(TODAY)())).
    Task 4: Statistical Functions

    1. Descriptive Statistics: For median, write =MEDIAN(select the whole sales amount data)

    For mode, write =MODE(Select the whole sales amount data)


    Task 5: Lookup and Reference Functions

    1. Lookup Function: For Lookup function, copy paste any salesman name then write
    =LOOKUP(LUIS,Select whole sales data and salesman column together).
    Task 6: Date and Time Functions

    For Today, write =Today()

    For 1st day of next year, =Date(year,month,day)


    2. Date Extraction: Select any date of the sales date column and write =year(select the selected date).
    Next box for the month, =Month(select the selected date). Next box for the day, =Day(select the
    selected date).
    Summary Report: While Doing the CSE 101 Course and after the Excel
    Assignment i got to learn some important skills in computer science and data
    management. These new skills will be helpful in many ways of my future life,
    studies and works
    Basic Coding: Using programming languages like Python or Java, I learned how
    to create basic programs. It includes using functions, variables, and cycles to solve
    issues via code.
    Problem Solving: I learned how to break down complex issues into smaller
    portions and come up with solutions during the course. This logical thinking will
    make it easier for me to manage challenging assignments.
    Data Structures: I also learned about the use of matrices and lists for arranging
    data. In the future, this will come in handy when handling a lot of data
    Data handling: I developed my ability to use Excel to organize and categorize
    data. Keeping things organized and making sense of big datasets is made easier by
    this.
    Formulas and Functions: I gained knowledge on how to speed up processes
    and improve data analysis by using functions like The graphics as well as pivot
    charts
    Data visualization: To successfully display information, I learnt how to build
    charts and graphs. This will help me in providing ideas and data in a way that is
    clear.
    I'll be able to solve issues and make decisions based on data at work and in the
    classroom using these skills.
    I can manage projects, increase output, handle difficult data, and become
    prepared for challenges in the future by using my knowledge of Excel and coding.

    You might also like