Question: Table 1 table [ [ First Name,Last Name,Age,,Balance ] , [ Ola , Vance, 5 4 , $ , 1 0 0 . 0

Table 1
\table[[First Name,Last Name,Age,,Balance],[Ola,Vance,54,$,100.00,],[Thomas,Werner,58,$,50.00,],[Detlev,Heitbreder,60,$,100.00,],[James,Awny,39,$,50.00,],[Lottie,Perkins,29,$,50.00,]]
Table 2
\table[[First Name,Last Name,Age,Balance],[James,Awny,39,$,50.00],[Lottie,Perkins,29,$,50.00],[Thomas,Werner,58,$,50.00],[Detlev,Heitbreder,60,$,100.00],[Ola,Vance,54,$,100.00]]
Refer to the pictured Excel worksheet. The data in Table 2 is a result of a custom sort of two columns on Table 1. Which columns were sorted in which order?
First level: Sort by "Last Name" ascending. Second level: Sort by "Balance" ascending.
First level: Sort by "Balance" ascending. Second level: Sort by "Age" ascending.
First level: Sort by "Last Name" ascending. Second level: Sort by "Age" ascending.
First level: Sort by "Balance" ascending. Second level: Sort by "Last Name" ascending.
Table 1 \ table [ [ First Name,Last

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!