• 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)

XtremePapers

M
mistique_bee
have u practiced the papers? u did oct/nov 15? do tht ppr..any hw..if u r done with tht..thn no ppr is difficult.....
M
mistique_bee
Insha Allah u will..so u want me to give u a basic view abt access n excel?
A
aries123
im doing that paper now
and im finding it soooooo difficult
A
aries123
i hav done may june 2015 that i found quite easy cuz there was very less of excel
A
aries123
i really dont know wen to apply the formula and which one to aplly
A
aries123
yess plzz abt excel
M
mistique_bee
its all tht u have to understand the question..they will not tell directly which formula to use...bt if u read the question wrd by wrd..u actually get it..
i knw tht ppr is hard....i solved it twice at home..thn i got it as test ....n Alhamdullilah i only lost 10 marks....
A
aries123
thats really good
A
aries123
for me i need to see the markscheme to know the formula
M
mistique_bee
thr is no use of doing this.... mark scheme wont help any way
A
M
mistique_bee
so..should i just explain it frm basic..tht wht actually excel is..n every small thing?
A
aries123
yaa
A
aries123
it took me 2 days to complete may june 2015 paper 2
M
mistique_bee
so u r familliar with word ryt? The Clipboard, Font, Alignment and Number groups in the HOME tab are similar in excel also....by which u will be able to edit the text ....so for AS the three basic tabs present in excel r really imprtnt ..which r The HOME Tab, The PAGE LAYOUT Tab and the VIEW Tab.
M
mistique_bee
the basic of all those formulas r SUM, AVERAGE, COUNT NUMBERS, MAX and MIN
M
mistique_bee
do u knw how n when to use them?
M
mistique_bee
so.. MIN- To find the lowest value in a range of cells, use the MIN function....this formula will find the lowest value in cells....example like thr r cells c2:c15 so to find the Minimum value u will write the formula..as =MIN(C2:C15) so ur result will be the lowest value btwen the range
M
mistique_bee
thn..MAX- To find the highest value in a range of cells, use the MAX function...... For example, this formula will find the highest value in cells..example same if thr cells c2:c15 so to find the Maximum value u will write the formula..as =MAX(C2:C15) so ur result will be the highest value btwen the range
Top