اختبار سابق في برنامج اكسل excel مع ملف الحل كاملا
- 2020-11-28
توصيف
اختبار سابق مع الحلول
exersice-point of sell transations example-with answers
Questions:
1.make data validation rule type 'List' for the following fields: "brand", "product", and "sales man"
Pivot table Questions:
1.how much is the transactions sell for each product and brand
2.what is the number of transactions for each brand
3.what is the brand with highest transactions number.
4.what is the average gross profit by products
Other Questions:
1.Set page layout options.
2.Set print options.
3.Set an appropriate header and footer for the sheet.
بالمرفقات ملف اكسل للحل كاملا
