logo

Crowdly

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Sorteer die databasis op grond van die kelder (cellar, kolom B) in dalende volgorde (Z-A).  Waar die kelders dieselfde is, moet die inskrywings gesorteer word op grond van jaar (year, kolom G) in stygende volgorde, en daarna volgens prys per bottel (kolom I) in dalende volgorde.

Verskaf die vertoon waarde van sel A13.

 

Sort the database in descending sequence (Z-A) based on the cellar (column B).  Where the cellars are the same, the entries must be sorted based on the year (column G) in ascending sequence, and then according to price per bottle (column I) in descending sequence.

Supply the display value of cell A13.

 

More questions like this

Want instant access to all verified answers on emslearn.sun.ac.za?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!