[SukhBamrah]

I have a twain of questions or queries regarding MS EXCEL and they are as follows -

1) I am a beginner in EXCEL and have been using it since long, and today when I was trying to make a list by entering data, I faced the piquent problem when I got the print out as it I mean the print out did not show the lines, and so I got fed up and now I am taking your help...

kindly help..

2) The second prob is that I have to make a list in which the students have to be given grades as per their marks, if marks are x, then

Grade = F (if 33<x<50)
Grade = E (if 50<x<60)
Grade = D (if 60<x<70)
Grade = C (if 70<x<80)
Grade = B (if 80<x<90)
Grade = A (if 90<x)

[friendship4any1]

Its so simple just select your data and press Ctrl+1 or go to Format => Cells

Then select the Border Tab choose your desire borders and press OK.

Then take a print preview it shows you the borders. :)

[friendship4any1]

The second prob is that you have to make a list in which the students have to be given grades as per their marks, if marks are x, then

Grade = F (if 33<x<50)
Grade = E (if 50<x<60)
Grade = D (if 60<x<70)
Grade = C (if 70<x<80)
Grade = B (if 80<x<90)
Grade = A (if 90<x)
-----------------------------------------------------------------

The Answer is:

=IF(B2>90,"A",IF(B2>80,"B",IF(B2>70,"C",IF(B2>60," D",IF(B2>50,"E","F")))))

where B2 is the desire cell.

[JBeaucaire]

1. To show the normal gridlines on a printout without manually adding them yourself, click in:

File > Page Setup > Sheet > [x] Gridlines

2. Where the grade to be checked is in B2:

=LOOKUP(B2,{0,51,61,71,81,91},{"F","E","D","C","B" ,"A"})

Copy that down for further students.

[SukhBamrah]

Thanks