ICT - GRADE 4 - APRIL 2021

AN MS EXCEL FILE IS REFERRED AS A :

• WORKSHEET

• CELL

• WORKBOOK

• GROUP

EVERY WORKSHEET IS DIVIDED INTO:

• TABS AND GROUPS

• NUMBERS AND LETTERS

• WORKBOOK AND FILES

• COLUMNS AND ROWS

THE NUMBER OF SHEETS PRESENT IN A WORKBOOK ARE SHOWN IN THE:

• FORMULA BAR

• NAME BOX

• WORKSHEET TABS

• FILE TAB

WRAP TEXT BUTTON:

• WRAPS THE EXTRA LONG TEXT INTO MULTIPLE LINES SO THAT ONE CAN SOME OF IT.

• WRAPS THE EXTRA LONG TEXT INTO MULTIPLE LINES SO THAT ONE CAN SEE ALL THE ROWS.

• WRAPS THE EXTRA LONG TEXT INTO MULTIPLE LINES SO THAT ONE CAN SEE ALL THE COLUMNS.

• WRAPS THE EXTRA LONG TEXT INTO MULTIPLE LINES SO THAT ONE CAN SEE ALL OF IT.

MOST OF THE TEXT AND CELL FORMATTING AND ALIGNMENT OPTIONS ARE FOUND IN:

• FONT AND ALIGNMENT GROUP ON INSERT TAB.

• FONT AND ALIGNMENT GROUP ON HOME TAB.

• FONT AND ALIGNMENT GROUP ON DATA TAB.

• FONT AND ALIGNMENT GROUP ON DRAW TAB.

DIFFERENT PREDESIGNED CELL STYLES CAN BE FOUND IN:

• INSERT TAB - STYLES GROUP - CELL STYLES BUTTON.

• HOME TAB - FONT GROUP - CELL STYLES BUTTON.

• INSERT TAB - ALIGNMENT GROUP - CELL STYLES BUTTON

• HOME TAB - STYLES GROUP - CELL STYLES BUTTON.

THE DATA THAT YOU ENTER ON THE WORKSHEET CAN BE:

• FORMATTED AS A ROW.

• FORMATTED AS A COLUMN.

• FORMATTED AS A TABLE.

• FORMATTED AS A WORKSHEET.

FILL HANDLES:

• ALLOWS YOU TO COPY THE CONTENT OF A CELL TO THE NEIGHBOURING WORKSHEETS.

• ALLOWS YOU TO COPY THE CONTENT OF A CELL TO THE NEIGHBOURING CELLS.

• ALLOWS YOU TO COPY THE CONTENT OF A CELL TO THE NEIGHBOURING ROWS ONLY.

• ALLOWS YOU TO COPY THE CONTENT OF A CELL TO THE NEIGHBOURING COLUMNS ONLY.

FIND AND REPLACE CAN BE FOUND IN THE:

• INSERT TAB - EDITING GROUP - FIND AND SELECT BUTTON

• HOME TAB - ALIGNMENT GROUP - FIND AND SELECT BUTTON

• HOME TAB - EDITING GROUP - FIND AND SELECT BUTTON

• HOME TAB - FONT GROUP - FIND AND SELECT BUTTON

USE OF CELL ADDRESSES IN A FORMULA IS CALLED:

• MATHEMATICAL OPERATORS

• NAME BOX

• WORKSHEET

• CELL REFERENCING