Yunus Sir Blog

 Ms Excel Ribbon Home Ribbon Groups :-  Clipboard ( cut , copy, format painter, paste) Font (font, size, highlighter, border, .) Alignment alignment Wrap text Merge & Center Number ( format) Styles  Conditional formatting format as table cell styles Cell Insert  Delete format Editing Auto sum Fill Clear sort & Filter Find & Select Insert Ribbon Group  Table Pivot table table     Illustrations picture Clip Art Shape Smart art Chart Column Line Pie bar Area Scatter   Links Hyperlink Text Text Box Header and Footer Word Art Signature Object Symbol  Page Layout Themes Page Setup Page Setup Margin orientation Size Area Print Break Background Print Titles Scale to Fit Width Height Scale Sheet Option gridlines Headings Arrange bring front , send back Group, Rotate formula Formula Library Text Logical Data & Time Financial Look Up  math Define Names Name Manager formula Auditing error Checking  trace Precedents Wat...

MS excel  Row & Column. 1. 1,048,576 rows by 16,384 columns 2.Column width - 255  Character. 3.Row height : 409 point  4. Zoom range : 10 % to 400% 5.Example Comment =A1 -----Complete relative reference =$A1 -----The column is absolute; the row is relative =A$1 -----The column is relative; the row is absolute =$A$1------- Complete absolute reference * Column Size 0 - Min    & 255 - Maximum    & Default 8.43 * Row Size   0 - Min     & 409  - Maximum    & Default 15 6. Error #DIV/0!------- Trying to divide by 0. जब हम लोग किसी संख्या को 0 से Divide करते हैं तब इस तरह का इरादा है) #N/A! ------- A formula or a function inside a formula cannot find the referenced data(जब कोई वैल्यू वहां पर एग्जिट ही नहीं करती तब ऐसी आती है) #NAME? --------- Text in the formula is not recognized गलत Furmula use करने पर. (= Sum ( A1:A4) in place = Sums(A1:A4) #NULL!  ---------A space ...