Excel 2
Subject: Computing
Age range: 14-16
Resource type: Unit of work
A step-by-step, fully illustrated guide to using Microsoft Excel (part 2 of 3 - intermediate).
Activities include: functions of, sum, average, stdev, max, min, count, counta, today, now; using AutoSum; sorting text and numbers in ascending and descending order; sorting on multiple columns; challenge activity; the use of charts (graphs) in Excel to visually display data; absolute and relative addressing; the use of lookup tables; naming ranges; the if logical function; and practical application of absolute addressing and a lookup table.
All files required for the activities are available as a free download through a link at the bottom of the title page.
Get this resource as part of a bundle and save up to 38%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
did not receive the excel documents so was useless, very frustrating.
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£5.00