ICT - GRADE 4 - FEB 2021

EACH TAB IS DIVIDED INTO NUMBER OF SECTIONS CALLED ___________________.

• BUTTONS

• TOOLS

• GROUPS

• WORKSHEETS

BY _________________ EACH WORKBOOK HAS ONE WORKSHEET.

• 2016

• FILE

• TABS

• DEFAULT

TO ADD A NEW WORKSHEET IN MS EXCEL:

• CLICK ON FILE - CLICK ON INSERT

• CLICK ON NEW SHEET BUTTON - CLICK ON INSERT

• CLICK ON HOME - CLICK ON INSERT

• CLICK ON NEW WORKSHEET BUTTON - CLICK ON NEW

TO RENAME A WORKSHEET:

• RIGHT CLICK ON FILE - CLICK ON RENAME

• RIGHT CLICK ON ROW - CLICK ON INSERT

• RIGHT CLICK ON THE SHEET TAB - CLICK ON RENAME

• RIGHT CLICK ON COLUMN - CLICK ON RENAME

A _________________ IS THE AREA TO ENTER ______________ IN EXCEL.

• CELL - WORKSHEET

• CELL - DATA

• DATA - CELL

• ROW - COLUMN

TO HIDE A ROW/COLUMN:

• RIGHT CLICK ON THE ROW OR COLUMN HEADER AND CHOOSE HIDE.

• LEFT CLICK ON THE ROW OR COLUMN HEADER AND CHOOSE HIDE.

• RIGHT CLICK ON THE ROW OR COLUMN HEADER AND CHOOSE UNHIDE.

• LEFT CLICK ON THE ROW OR COLUMN HEADER AND CHOOSE UNHIDE.

MERGE&CENTRE BUTTON CAN BE FOUND IN THE:

• HOME TAB - FONT GROUP

• FILE TAB - NUMBER GROUP

• HOME TAB - ALIGNMENT GROUP

• FILE TAB - ALIGNMENT GROUP

THE __________ ____________ BUTTON WRAPS THE EXTRA LONG TEXT INTO ______________ LINES SO YOU CAN SEE ALL OF IT.

• WRAP TEXT - ABSTRACT

• MERGE CENTRE - MULTIPLE

• MERGE TEXT - MULTIPLE

• WRAP TEXT - MULTIPLE

IT DISPLAYS THE ADDRESS OF THE ACTIVE CELL:

• FORMULA BAR

• NAME BOX

• WORKSHEET TAB

• ADDRESS BOX

THE __________________ ARE REPRESENTED BY LETTERS AND ___________ ARE REPRESENTED BY NUMBERS.

• ROWS - COLUMNS

• SHEETS - ROWS

• SHEETS - COLUMNS

• COLUMNS - ROWS