Excel Question #1

-
Excel Questions Part-1
Biswajit Bhunia, Assistant Teacher, Bankura Banga Vidyalay
  1. Excel file এর extension লেখ. 
  2. Excel Sheet এ কতগুলো Row ও Column আছে?
  3. Active Cell কাকে বলে?
  4. Name Box, Formula Bar এর কাজ কি?
  5. Row এর default উচ্চতা,  Column এর default প্রস্থ কত?
  6. কয়েকটি Electronic Spreadsheet এর নাম লেখ।
  7. Row কে কিভাবে সনাক্ত করা হয়?
  8. Column কে কিভাবে সনাক্ত করা হয়?
  9. ৩০ তম রো এবং ৩০ তম কলাম কে প্রকাশ করা হয় কিভাবে?
  10. Default Sheet এর সংখ্যা কত?
  11. Excel এ default Ribbon এর সংখ্যা কত?
  12. Fill Handle কাকে বলে?
  13. Text ও Number Data এর default Alignment লেখ।
  14. Row Insert এর Shortcut key লেখ।
  15. Column Hide এর Shortcut key লেখ।

Comments

Post a Comment

Popular posts from this blog

Python Programming: Area of Triangle

-
#Find the area of triangle import math a= int ( input ( "Enter the length of first side : " )) b= int ( input ( "Enter the length of second side : " )) c= int ( input ( "Enter the lenth of third side : " )) if ((a+b)>c and (c+a)>b and (b+c)>a): s=(a+b+c)/ 2 Area=math.sqrt(s*(s-a)*(s-b)*(s-c)) print ( "Area of the triangle : " , Area) else : print ( "Invalid Triangle" ) Output: Run 1:  Enter the length of first side : 2 Enter the length of second side : 2 Enter the lenth of third side : 6 Invalid Triangle Run 2: Enter the length of first side : 6 Enter the length of second side : 4 Enter the lenth of third side : 7 Area of the triangle : 11.976539567003485
Read more

visual Basic Assignment #1

-
Biswajit Bhunia Assistant Teacher, Bankura Banga Vidyalay my mail: biswajit62418@gmail.com  Question: Write a Program in VB to check whether a given number is Prime or Not. Ans. Open Visual Basic 6.0 Start → Programs/All Programs → Microsoft Visual Studio 6.0 → Microsoft Visual Basic 6.0 Select Standard EXE → Open Take one Label(Label1) → Press F4 → Caption → Enter any Number Take one  TextBox(Text1) → Press F4 → Text → Press SpaceBar Take on CommandButton(Command1) → Press F4 → Caption Double Click on Command1 Write the following Code- PRIVATE SUB COMMAND1_CLICK() DIM N,R,I AS INTEGER N=VAL(TEXT1.TEXT) R=0 FOR I=2 TO N/2 R=N MOD i IF R=0 THEN    MSGBOX “NUMBER IS NOT PRIME”   Exit sub END IF NEXT I IF R=0 THEN  MSGBOX “THE NUMBER IS NOT PRIME” ELSE MSGBOX “THE NUMBER IS PRIME” ENDIF END SUB Save the Project File → Save Project → Save in → Select Desktop → xi69.frm → Save → xi69.vbp → Save Run The Project Press F5
Read more