I have this questionnaire I want to answer these questions in bottm , thank you
ID: 3672224 • Letter: I
Question
I have this questionnaire I want to answer these questions in bottm , thank you
----------------------------------------------------------------------------------------
1-What do you know about e-shopping ?
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..……………………………………………………………………………………………………………………
2- Have you ever shop online?
YES NO
3- What sites do you use for online shopping?
Amazon EBay Alibaba Souq.com Nemshi
4- What type of card used in electronic shopping?
Visa MasterCard Other ……………..
5- What is your favourite E-commerce website? and Why?
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
6- Which age group do you belong to?
11-20
21-30
31-40
41-50
50 or above
7- How often do you have online shopping?
Twice a week or above
Weekly
Once per two weeks
Monthly
Occasionally
8- What are the items that you usually buy online?
Electronics
Clothes
Food
Others
-----------------------------------------------------------------------------
Excel: (6 Marks)
a. Create a validation rule, set the input messages, error alert.
b. Populate your worksheet with your data manually- 20 records-.
c. In worksheet, set the suitable category for cells –Number, Currency, date, time or custom-.
d. At least using 6 functions: to calculate or find needs.
e. Create 1-2 Pivot tables to summarize your data for analysis.
f. Create chart to display your result.
g. Create a word document and Embedded Object/ Linked Object data charts or table from your workbook.
Explanation / Answer
1-What do you know about e-shopping ?
e-shoping is an online shopping otherwords electronic shopping where we can shop and purchase our products.
Or simply:
Go online --- using computer/mobile/tab etc. ------ shop from home
2- Have you ever shop online?
Yes
3- What sites do you use for online shopping?
Amazon
4- What type of card used in electronic shopping?
Almost all type of cards
5- What is your favourite E-commerce website? and Why?
Amazon.in is my favorite E-commerce website becasue they provide good service.
6- Which age group do you belong to?
21-30
7- How often do you have online shopping?
Occasionally
8- What are the items that you usually buy online?
Electronics
EXCEL:
a. Follow the steps to validate the data
Select a cell to validate, Goto the Data>Data Validation- choose data i,e valid in that cell, Goto input message tab- type the title and message, Goto error alert- type error alert in text box.
b &c data can be entered in excelsheet.
d. functions:
=sum(A2:A30)
=Average(A2:A30)
=Min(A2:A30)
=Max(A2:A30)
=count(A2:A30)
=days(A5:A9)
e. Summerization of data done using pivot table
f.representation of data done using chart table