Κωδικός ερώτησης: 1524 13/17
ΠΡΟΗΓΟΥΜΕΝΗ ΕΡΩΤΗΣΗ ΕΠΟΜΕΝΗ ΕΡΩΤΗΣΗ

Insert the appropriate data in the cell range Á51:C52 so that if you apply an advanced filter, only entries:

Black color, pieces <50 and Total >2000 or

Red color, pieces >50 and Total <2000 are displayed. (Insert data in the provided order).

Copy the outcome in the cell range beginning from cell A60.

 

 

Άλλες εκδόσεις
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365

 

 

 


Insert the appropriate data in the cell range Á51:C52 so that if you apply an advanced filter, only entries:
Black color, pieces <50 and Total >2000 or
Red color, pieces >50 and Total <2000 are displayed. (Insert data in the provided order). 
Copy the outcome in the cell range beginning from cell A60.