NEW
Font size
WorksheetsICT - GRADE 6 - APRIL 2021
Total questions: 10
Worksheet time: 5mins
A WORKSHEET CAN BE REORGANIZED BY _________________ THE DATA.
FILTERING
SORTING
HIDING
SHIFTING
A ____________ _________ CAN BE CREATED TO DEFINE OUR OWN SORTING ORDER.
LIST CUSTOM
SORT LIST
CUSTOM LIST
NUMBER LIST
IN SORTING ____________________ ______________ CAN BE ADDED TO SORT ONE'S DATA BY MORE THAN ONE COLUMN.
SINGLE LEVEL
TEXT VALUES
NUMERIC VALUES
MULTIPLE LEVELS
_____________ CAN BE USED TO NARROW __________ THE DATA IN A WORKSHEET.
SORT - DOWN
FILTER - DOWN
MERGING - DOWN
WRAPPING - DOWN
IN ORDER FOR FILTERING TO WORK CORRECTLY, THE WORKSHEET ____________ INCLUDE A ____________ ________.
CAN - HEADER ROW
CELLS - COLUM HEADING
SHOULD - HEADER ROW
CELLS - ROW HEADING
ADVANCE FILTERING TOOLS, INCLUDING ___________, ___________, ___________ AND ____________ FILTERING, WHICH CAN NARROW YOUR RESULTS TO HELP FIND EXACTLY WHAT YOU NEED.
SEARCH - TEXT - NUMBERS - OPERATORS
SEARCH - SORT - DATE - NUMBERING
SEARCH - DATE - TEXT - ADVANCED
SEARCH - TEXT - DATE - NUMBERING
BY DEFAULT, ALL CELL REFERENCES ARE _____________ ___________.
RELATIVE ADDRESSES
ABSOLUTE REFERENCES
RELATIVE REFERENCES
ABSOLUTE ADDRESSES
IN MS EXCEL ______________________ ______________ DO NOT CHANGE WHEN _______________ OR FILLED IN CELLS.
RELATIVE REFERENCES - DRAGGED
ABSOLUTE REFERENCES - DRAGGED
RELATIVE REFERENCES - COPIED
ABSOLUTE REFERENCES - COPIED
AN ABSOLUTE REFERENCE IS SPECIFIED IN A _____________ BY THE ADDITION OF A ______________ SIGN.
CELL - DOLLAR
FORMULA - DOLLAR
COLUMN - DOLLAR
ROW - DOLLAR
A _______________ COMMAND ALLOWS YOU TO AUTOMATICALLY _____________ GROUPS AND USE COMMON FUNCTIONS.
GROUP - CREATE
SUBTOTAL - MERGE
GROUP - MERGE
SUBTOTAL - CREATE
