The purpose of this activity is to prepare an accounts receivable aging schedule given a small set of customer data. You will implement two tools that are often used in business spreadsheets: vlookup function and pivot tables.

What is the dollar amount of total receivables? Use a cell reference to input your answer. Do not key in numbers. Only use cell reference.

Which aging bucket total dollar amount is the greatest? Provide the aging bucket $($i$.$e $,"31-60$ days"$)$ not the total amount

Which specific customer accounts require management's attention? List the customer numbers.

Why did you select those customer accounts?