NEW
Font size
WorksheetsICT - GRADE 4 - APRIL 2021
Total questions: 10
Worksheet time: 5mins
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
