Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Sort by Last Name (desc), then T-Shirt Size (asc) and then Payment Method (desc).   2.  Freeze row panes from 1-7 so that when you scroll down  data remains on screen.

Sort by Last Name (desc), then T-Shirt Size (asc) and then Payment Method (desc).   2.  Freeze row panes from 1-7 so that when you scroll down  data remains on screen.

Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
See similar textbooks
icon
Related questions
Question
Exercise 1        
         
1.  Use the following table to answer the questions below.    
         
Homeroom# First Name Last Name T-Shirt Size Payment Method
105 Derek MacDonald Large Cash
105 Nathan Albee Medium Check
105 Sidney Kelly Medium Check
105 Christiana Chen Medium Check Bounced
105 Melissa White Small Debit Card
105 Esther Yaron Small Pending
110 Kris Ackerman Large Credit Card
110 Matt Benson Medium Money Order
110 Gabriel Del Toro Medium Cash
110 Lilian Arnold X-Large Cash
135 Anisa Naser Small Check Bounced
135 Davi Bell X-Large Credit Card
220-A Asher Hepburn Large Pending
220-A Brigid Ellison Small Cash
220-A Christopher Peyton-Gomez Small Check  
220-B Avery Kelly Large Money Order
220-B Samantha Bell Medium Check
220-B Michael Lazar Small Cash
220-B Malik Reynolds Small Cash
220-B Wendy Shaw Small Cash
         
1.  Sort by Last Name (desc), then T-Shirt Size (asc) and then Payment Method (desc).  
2.  Freeze row panes from 1-7 so that when you scroll down  data remains on screen.  
         
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS