Question

Situation
Tool
Pivot Table Sort
While searching for a contact in your
phonebook, you type out the name you
are looking for.
Criteria in
Data Form
Filling up your birthdate in an online Advanced Data Creating a
application form to ensure you are under Filter
Validation new record
18 years of age
Sort
Your hard disk is running out of storage
space and you consider deleting either
the oldest or the largest files in order to
create space
Subtotal
function
Data
Validation
Points table in a T20 championship that
shows average team scores for every
team for all matches, matches won, and
matches lost
Subtotal
function
Advanced Pivot Table
Filter
Pivot Table
Subtotal
Filter
Annual holiday calendar which also
shows the number of working days and
holidays in each month
function​

Answer 1

Explanation:

Situation

Tool

Pivot Table Sort

While searching for a contact in your

phonebook, you type out the name you

are looking for.

Criteria in

Data Form

Filling up your birthdate in an online Advanced Data Creating a

application form to ensure you are under Filter

Validation new record

18 years of age

Sort

Your hard disk is running out of storage

space and you consider deleting either

the oldest or the largest files in order to

create space

Subtotal

function

Data

Validation

Points table in a T20 championship that

shows average team scores for every

team for all matches, matches won, and

matches lost

Subtotal

function

Advanced Pivot Table

Filter

Pivot Table

Subtotal

Filter

Annual holiday calendar which also

shows the number of working days and

holidays in each month

function

Answer 2

Answer:

Don't have time to read........ Sorry!!!!!