• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

Computers & ICT: Post your doubts here!

Messages
291
Reaction score
1,576
Points
153
Sorry to bother you, but i really don't know why when i opened your answers from the spreadsheet N/A signs appear in the J8BUS workbook and in the automatic calendar days workbook #VALUE! appear. I also don't really know how to do the graph. I actually tried doing that question and i did the same thing like you did which was finding the destination, then the number of trips and the average minutes it was late, but then when i had to make the graph i used a scatter graph and i don't know why my horizontal axis are not correct so instead of having (Dive centre, tawara town centre,..) it has numbers and i don't know what to do. I'll also upload my file so it could be easier to understand what i mean.
Thank you, i really appreciate your help.

1. The N/A sign appears for routes which have the no 8,and that is because in the {table array of lookup} J8SEATS,there is no value for 8.
even the ms shows N/A for no 8.
2.( in the automatic calendar days workbook #VALUE! appear.) where is this?? I didnt get this.
3.I dont know how to make the no into text on the horizintal axis,
but one thing which I noticed was that its we should select such a chart type which shows only "Series value" in 'edit data series' and does not show "Series X value" & "Series Y value", like line,bar,column,pie,etc. And we have been given a choice to select the chart type.
{see the attachment to understand better}
I tried with all the chart types and came on this conclusion.
Because such charts show the exact text of the data.

Hope you understand,
and sorry I couldn`t help you much this time.
 

Attachments

  • New Microsoft Office Word Document.docx
    44.1 KB · Views: 4
Messages
291
Reaction score
1,576
Points
153
n hw must i do qn9 in qp2 s10?

s10_q9
1.You make a query, with only the customerId and the profit.
2.Then you create a report with this query.
i)in report wizard,select this query.
ii)then you add customerID as the grouping level.
iii)then before selecting next, you select grouping options---in that--in group intervals you select 1st letter-OK---then next
iv) now select summary options---and average.
v) then complete making the report.
vi)in the report delete the customerid column & the profit column.
vii)then format the report as per required.

Hope you understand my explanation, do reply.
And if you face any difficulty with formatting do ask.
 
Messages
1,162
Reaction score
6,306
Points
523
s10_q9
1.You make a query, with only the customerId and the profit.
2.Then you create a report with this query.
......Hope you understand my explanation, do reply.
And if you face any difficulty with formatting do ask.
Jazakillahu khairaa, may Allah bless you n help us all... aameen (y)
:)
all d best 4 ur exams :) btw, ur appearing 4 a levels or as?
 
Messages
291
Reaction score
1,576
Points
153
Does someone have the source files for 9713_s12_qp2?
PLZ give me...I need it for practice.
Have my exams just the next week.
JazakAllah.
 

Tkp

Messages
1,660
Reaction score
11,026
Points
523
FACING problem in oct nov 12 qp 15.i knw its cross tab and when i put forename as a value they r telling cannot have aggreagte function in order of clause
 
Messages
1,162
Reaction score
6,306
Points
523
plz help me wid dese ques!
24. tk a new excel sheet n enter d tbl so dat it looks similar 2 d 1 in d qp. dont add d values under d Route row, in d 3rd row. merge cells A1 to I1.
25. now in cell A3, u need 2 "count the number of buses that are 5 or more minutes late for each bus route". so 4 route 1, u'll go =COUNTIF({d minutes late column}, >=5)
26. {at least dis is hw i did it} copy each cell n paste it in its ryt plc 2 match d qp.
May Allah Help us all, n purify r intentions. Aameen
All d best(y)
 

Tkp

Messages
1,660
Reaction score
11,026
Points
523
i am trying to import all the data from the file of mj 09 album but it says Not all of ur data was successfully imported.Error descriptions with assocaited row numbers can be found in the microsoft office access table import error.cn any 1 help me
 
Messages
1,162
Reaction score
6,306
Points
523
i am trying to import all the data from the file of mj 09 album but it says Not all of ur data was successfully imported.Error descriptions with assocaited row numbers can be found in the microsoft office access table import error.cn any 1 help me
it must b containing "Date". if ur importing date, while importing, always 4mat it as Text, n after d tbl is imported, in design view, change d data type to "Date/Time"

May Allah help us all. aameen. :D
 
Top