LESSON 1 (SCHOOL For MARKSHEET)
TOTAL=SUM(B2:D2)
PERCENT=E2/300*100

RESULT
FAIL=IF(AND(B2>=32,C2>=32,D2>=32),"pass","fail")
PASS=IF(AND(B3>=32,C3>=32,D3>=32),"pass","fail")
DIVISIONFAIL=IF(G2="pass",IF(F2>=60,"first",IF(F2>=45,"second","third")),"fail")
THIRD=IF(G3="pass",IF(F3>=60,"first",IF(F3>=45,"second","third")),"fail")
SECOND=IF(G4="pass",IF(F4>=60,"first",IF(F4>=45,"second","third")),"fail")
FIRST=IF(G5="pass",IF(F5>=60,"first",IF(F5>=45,"second","third")),"fail")

LESSON 2 (SALES AND STORE)
(IN THIS EXAMPLE FROM G TO AF(1-26 AS EXAMPLE) YOU CAN TYPE DAYS (1-31) AND IF YOU FILL UP QUANTITY IN THIS DAY COLUMN THE REMAINING AND RESULT WILL BE DISPALY IN SALES, STORE AND AMOUNT COLUMN. FOR IT'S FORMULA HERE WE GO...
SALES=SUM(G11:AF11)
STORE=B11-D11
AMOUT (RATE*SALE)=C11*D11

LESSON 3 (PHONE CALL RATE AND AMOUNT)
TOTAL (CALL*RATE)=C21*D21
vAT (TOTAL*12%)=E21*12%
TOTAL AMOUNT(TOTAL+VAT)=E21+F21

Some Excel Keyboard Shortcuts
F2: Edit a cell's contents
Ctrl+1: Open the Format Cells dialog
Ctrl+Page Up: Move to the next sheet in the workbook
Ctrl+Page Down: Move to the previous sheet in the workbook
Ctrl+Shift-": Copy the value from the cell above into the current cell
Ctrl+': Copy the formula from the cell above into the current cell
Ctrl+R: Fill contents of active cell into selected cells to the right
Ctrl+D: Fill contents of active cell into selected cells down
Ctrl+`: Toggle between showing cell values and formulas in cells
Ctrl+$: Set selection to currency format with two decimal places
Ctrl+End: Skip to the end of a document
End: Skip to the end of line
Shift+F2: Edit or create a comment in the current cell
Ctrl+ F8: Re-size the document
Ctrl+(semicolon): Enter the current date
Ctrl+(colon): Enter the time