ICT - GRADE 6 - APRIL 2021

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