$\backslash$table$[[$Ticket No$.,$Work,Ticket No$.,$Work,Ticket No$.,$Work$],[1,$Tires,$11,$Tires,$21,$Lube & oil$],[2,$Brakes,$12,$Brakes,$22,$Lube & oil$],[3,$Brakes,$13,$Brakes,$23,$Lube & oil$],[4,$Lube & oil,$14,$Lube & oil,$24,$Battery$],[5,$Brakes,$15,$Lube & oil,$25,$Brakes$],[6,$Tires,$16,$Battery,$26,$Tires$],[7,$Tires,$17,$Brakes,$27,$Lube & oil$],[8,$Lube & oil,$18,$Lub$$ & oil,$28,$Brakes$],[9,$Lube & oil,$19,$Brakes,$29,$Brakes$],[10,$Lube & oil,$20,$Transmission,$30,$Lube & oil$]]$

Click here for the Excel Data Fille

a$.$ Prepare a check sheet for the above car repair shop data:

Answer is complete but not entirely correct.

$\backslash$table$[[$Work Type,Frequency$],[$Tires$,7x$