EXCEL
MICROSOFT EXCEL 2021
o Excel 2021 is an electronic spreadsheet
application.
o Each worksheet, consisting of rows and columns,
can be used to organise different types of related
information.
o Excel 2021 uses a workbook file that contains one
or more worksheets.
FILENAME TABS
RIBBON
Ribbon divided into groups of
related commands
ZOOM PERCENTANGE
Spreadsheet ZOOM FEATURE
New Spreadsheet
VIEW BUTTONS
Name Box
Formula bar
Column Letters
Selected cell
Row Numbers
Workbook Window
ENTER DATA
p. 363
1. Select cell
2. Type data
CHECK SPELLING
p. 363
2. Click Review
3. Click Spelling
1. Select cell
Spelling mistake
4. Make correction
3. Select correction
FIND AND REPLACE
p. 367
2. Click Home
3. Click Find and Select
4. Click Replace
1. Select cell
Text to Replace
Replacement Text
5. Use options to
replace required
text
Text Replaced
ENTER FORMULAS
p. 373
WORKING WITH FORMULAS
o A formula is an equation that performs a calculation on the
data contained in the worksheet. A formula always begins
with an equal sign (=) and uses arithmetic operators.
o An operator is a symbol that specifies the type of numeric
operation to perform. (+, -, *, /, %, ^)
o The calculated result from the formulas is a variable value
because it can change if the data it depends on changes.
o In contrast, a number entry is a constant value. It does not
start with an equal sign and does not change unless
Formula displayed in the formula bar
Colour coded references
Formula entered
Result calculated
COPY FORMULA
p. 374
1. Select the cell with formula
2. Drag Fill Handle
Results Calculated
ORDER OF OPERATION
1. Parenthesis
2. Exponents
3. Multiplication / Division
4. Addition / Subtraction
5. Same level of precedence are calculated from left to
right
COLUMN WIDTH
DRAGGING THE
BOUNDARY
p. 390
New Width
Drag boundary
COLUMN WIDTH
SET SPECIFIC WIDTH
p. 390
2. Click Home
3. Click Format
4. Click Column Width
1. Select Column
5. Enter Size
6. Click OK
Column Resized
MERGE CELLS
p. 396
2. Click Home
3. Click Merge and Centre
1. Select Range
Cells merged
CELL STYLES
p. 398
2. Click Home
3. Open the Cell Styles
4. Select Cell Style
1. Select Cells
Title Style
Heading 1 Style
NUMBER FORMATS
p. 390
2. Click Home
3. Open Formats
4. Select Format
1. Select Cells
Format Applied
FUNCTIONS
p. 390
WORKING WITH FUNCTIONS
o A function is a prewritten formula that performs certain
types of calculations automatically.
o The syntax or ‘rules of structure’ for entering all functions
is:
=function name(argument 1, argument 2,….)
o The function name identifies the type of calculation to be
performed. Most functions require you to enter one or more
arguments.
o An argument is the data the function uses to perform the
calculation.
Data Colour coded
1. Enter Function
Result Calculated
RECOMMENDED
CHARTS
p. 390
2. Click Insert
3. Open Recommended Charts
Other Chart Types
1. Select Data
4. Select Chart Type
Preview Chart
5. Click OK
4. Chart Inserted