Page 39 - ClickGPT V4.0 C-5

Hintbot

To use the the common functions like SUM, AVERAGE, MAX and MIN: click
on the down-arrow of the AutoSum button.

To use other functions: click on More Functions option.

Topic Flashback 21 st Century #Technology Literacy
Skills #Productivity & Accountability
Write the output of the following:
a. =MIN(5,7,8) d. =TODAY()
b. =Left("Computer", 4) e. =LEN("Touch")

c. =AVERAGE(12,3,6) f. =COUNT(4,8,12)

Quick Quiz
1. Which feature in Excel is used to visually represent and analyse data, such as trends and comparisons?

a. Data Types b. Charts

2. When creating a formula in Excel, what is a cell reference that doesn't change when copied to another cell?
a. Mixed Cell Reference b. Absolute Cell Reference

Recap

A cell reference is a cell address that can be used in a formula to denote a specific cell.
In relative reference, you actually refer to cell that is above or below and left or right to a number
of rows or columns.
If you wish to maintain the original references as they were, then you should make use of the

absolute references.
A mixed reference is a reference that refers to a specific row or column.
Functions are predefined formulas in Excel to perform both simple and complex calculations.

Assess Yourself

Choose the correct option.

1. Sohan has created a worksheet in Excel to store the marks of students in his class. He wants to display
the data from the sheet in pictorial form. Which of the following features of Excel will help him to do so?

a. Chart b. Formula

c. Text d. Operator

Charts, Formulas & Functions in Excel 37