Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Excel Class Activity 1

    Uploaded by

    onke25819

    Copyright:

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

    Excel Class Activity 1

    Uploaded by

    onke25819
    6 views4 pages

    Original Title

    Excel Class Activity 1_ (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    6 views4 pages

    Excel Class Activity 1

    Uploaded by

    onke25819

    Copyright:

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

    Foundations of Information Systems

    INF1102F/S
    Excel Class Activity 1

    Instructions

    • This activity is a practice activity and it’s not for DP (marks).


    • Please attempt t ALL TASKS. If you run out of time, ensure that you do it
    later in the week to ensure you have grasped the basic Excel concepts. ALL
    of the topics and tasks are very important to enhance your understanding for
    the upcoming topics.
    • Files for submission
    o Word document with answers in Sections 1 & 2 name this file
    STDNUM001.docx
    o Excel file with answers in Section 3>> name this file STDNUM001.xlxs
    Week 1: Getting started with MS Excel 2019

    1. Starting Excel, knowing the various menus and basic features of the Excel
    environment

    Open Excel and open the “Diet and exercise journal” template provided by Microsoft. If you cannot
    find it, you can use any other template. (Note: this year we’ll only use the Exercise part, not the Diet
    part!)

    Locate the following common Office interface elements:


    a) Status bar: what happens when you “highlight” a range of
    numbers e.g. highlight the range from cell A20 to A40 …
    what do you see on the status bar?
    b) Ribbon – click on EACH of the tabs and get an idea of the
    various functions on each of the ribbons.
    c) Title bar: what does it say? What happens when you
    double-click it?
    d) Quick access toolbar: how can you add new commands
    (icons) to it? Add the command to create new workbooks
    to the quick access toolbar.
    e) Zoom control: shrink (zoom) the sheet to 66%; expand to
    300%; zoom back to 80%
    f) Scroll bar: try both the horizontal and vertical scroll bar
    g) Help function: click Help – Learn Excel Basics and check
    what it covers. Later today (but not now else you run out
    of time), go through this help page and try everything for
    yourself to prepare for tomorrow’s session.

    Find the meaning of the following spreadsheet concepts:


    Hint: use HELP, google or ask a friend
    h) Workbook versus worksheet
    i) Cell – row – column – range
    j) Formula
    k) (built-in) function

    Locate the following Excel-specific interface elements:


    l) Where is the name box? What do you see when you click
    the dropdown icon?
    m) Where is the formula bar? What does it show when you
    click on cell A24?
    n) Where do you see the column and row names? What
    happens when you click on them?
    o) Use the (worksheet) scroll bars to show different parts of
    the sheet.
    p) What are the worksheet tabs? Click on Exercise.
    q) Create a new worksheet in this workbook – what is it
    called? Rename it to “INF1102F”

    What do the following cell names/references mean or refer to? (Note – these references are not
    linked to the template)
    r) A1 – IJK12345 – Sheet2!B6 – [Book2]Sheet1!C6 – A1:C4.
    2: Navigating a workbook (worksheets, data input ,formatting a worksheet and
    working with cell ranges)

    Navigating a sheet using the keyboard arrow keys.


    s) What do the PgUp; PgDn; Tab; and Shift-Tab keys do?
    Hint: if you using the arrow keys on the NumPad, make sure
    NumLock is off
    t) Can you highlight a (rectangular) range of cells? How?
    u) Put your cursor somewhere in the Exercise sheet. What
    happens when you press and release the <End>-key
    followed by pressing an arrow key? Play around until you
    know the exact meaning of what the <End>-key can do.
    v) Use this to find out how many rows there are in a sheet?
    How many columns?
    w) What does <Home> do? <Ctrl>-<Home>? <Ctrl>-<End>?
    x) What does the ScrollLock key do when it is on?
    y) If you have a mouse with a scroll wheel, find out what the
    scroll wheel does? What happens when you hold down
    the <Ctrl>-key?

    3. Saving and updating workbooks


    Open (i.e. create) a new (blank) Workbook.
    Hint: <Ctrl>-N [N=New] or your new shortcut icon
    Enter your student number in cell A1 on Sheet1 and a few more random words and numbers in
    different cells of the workbook.

    Save your new file using “Class activity1” as the file name:
    z) On C drive
    aa) Save it again but on your One drive: what is the very
    important difference between saving on C : versus
    OneDrive:?
    Hint: Use Save-As
    bb) In the Computer Labs; Try saving on the G: drive: what
    happens? Write your answer on a newworksheet >> Labs
    cc) Save another copy on your OneDrive. (If you don’t have
    an account, do the signup process and the saving later in
    the day. What is the benefit of saving on the OneDrive?
    Sae this answer on a worksheet named>> Labs2
    dd) If you have a data stick (USB drive; flash drive), save a
    copy there too!
    ee) Create a new folder by the name of “Excel Assignments”
    on Onedrive: and save your new file there as well.
    Hint: Create the folder using Windows Explorer or from within
    Excel’s Save dialog

    4. Learning Resources
    • LinkedIn Learning is a learning company which offers over 2,000 online
    courses. UCT staff and students have full access to the online training
    library, both on- and off-campus. We will make use of LinkedIn videos at
    certain points in the course. Follow the steps here to create your free
    account: http://www.icts.uct.ac.za/linkedin-learning
    • It is recommended that you strongly complete the Excel Essential Training
    (Excel 2019) . These self-guided tutorials are designed to equip you with
    additional skills on how to navigate and use Excel.

    You might also like