Assalamualaikum,
You are welcome to Knowledge World to become master in learning Microsoft Excel, Word, Power Point, Power BI, Bdjobs Tips, Outlook Tips, Gmail tips, Technical Tips & more exciting videos.
@ Business Inquires : shohanrahman00@gmail.com
Thank in advance for visiting in #Knowledge_World #Sohan_Rahman
Knowledge World
đ¤ āĻāύā§āĻāĻžāϰāĻāĻŋāĻāϤ⧠āĻĒā§āϰāĻžā§āĻ āϝ⧠⧍āĻāĻž āĻĒā§āϰāĻļā§āύ āĻāϰāĻž āĻšā§ â āĻāϰ āĻāĻā§āϞā§āϰ āĻāϤā§āϤāϰ āĻā§āĻāĻžāĻŦā§ āϏā§āĻŽāĻžāϰā§āĻāĻāĻžāĻŦā§ āĻĻāĻŋāĻŦā§đ
đŦ āĻĒā§āϰāĻļā§āύ ā§§:
āĻāĻĒāύāĻŋ āĻŦāϰā§āϤāĻŽāĻžāύ āĻāĻžāĻāϰāĻŋ āĻĒāϰāĻŋāĻŦāϰā§āϤāύ āĻāϰāϤ⧠āĻāĻžāύ āĻā§āύ?
Why do you want to change your current job?
āĻāĻāĻžāϰ āĻāϤā§āϤāϰ āϝā§āύ āĻļā§āύāϞā§āĻ āĻŦā§āĻāĻž āϝāĻžā§â
āϤā§āĻŽāĻŋ āĻāύā§āύāϤāĻŋ, āĻļā§āĻāĻž āĻāϰ āύāϤā§āύ āĻ āĻāĻŋāĻā§āĻāϤāĻžāϰ āĻāύā§āϝ āĻāĻā§āĻā§āĻā§āĨ¤ āĻā§āύ⧠āύā§āϤāĻŋāĻŦāĻžāĻāĻ āĻŽāύā§āϤāĻŦā§āϝ āύā§āĨ¤
---
â āĻāϤā§āϤāϰ āϧāϰāύ ā§§: āĻā§āϝāĻžāϰāĻŋā§āĻžāϰ āĻā§āϰā§āĻĨ
âāĻŦāϰā§āϤāĻŽāĻžāύ āĻāĻžā§āĻāĻžā§ āĻāĻžāĻ āĻāϰāϤ⧠āĻāĻžāϞ⧠āϞāĻžāĻā§, āĻāĻŋāύā§āϤ⧠āĻāĻāύ āĻŽāύ⧠āĻšāĻā§āĻā§ āĻāϰāĻ āĻŦā§ āĻā§āϝāĻžāϞā§āĻā§āĻ āĻāϰ āĻŦā§āĻļāĻŋ āĻĻāĻžā§āĻŋāϤā§āĻŦ āύāĻŋā§ā§ āύāĻŋāĻā§āĻā§ āĻāĻĒāĻā§āϰā§āĻĄ āĻāϰāĻž āĻāĻāĻŋāϤāĨ¤ āϤāĻžāĻ āύāϤā§āύ āϏā§āϝā§āĻ āĻā§āĻāĻāĻāĻŋāĨ¤â
âI enjoy my current job, but now I want new challenges, more responsibility, and better growth opportunities. Thatâs why Iâm looking for a change.â
---
â āĻāϤā§āϤāϰ āϧāϰāύ ⧍: āĻļā§āĻāĻžāϰ āϏā§āϝā§āĻ
âāύāϤā§āύ āĻā§āϞ, āύāϤā§āύ āϏā§āĻāĻŋāϞ āĻāϰ āĻāϧā§āύāĻŋāĻ āĻāĻžāĻā§āϰ āϧāϰāĻŖ āĻļāĻŋāĻā§ āύāĻŋāĻā§āĻā§ āĻāϰāĻ āĻļāĻā§āϤāĻŋāĻļāĻžāϞ⧠āĻāϰāϤ⧠āĻāĻžāĻāĨ¤ āĻāĻāĻžāύāĻāĻžāϰ āĻļā§āĻāĻžāϰ āĻĒāϰāĻŋāϏāϰ āϏā§āĻŽāĻŋāϤ, āϤāĻžāĻ āύāϤā§āύ āĻĒāϰāĻŋāĻŦā§āĻļā§ āĻāĻžāĻā§āϰ āĻ āĻāĻŋāĻā§āĻāϤāĻž āύāĻŋāϤ⧠āĻāĻžāĻāĨ¤â
âI want to learn new tools and skills to improve myself. The learning scope at my current job is limited, so I want a new environment to grow.â
---
â āĻāϤā§āϤāϰ āϧāϰāύ ā§Š: āĻāĻžāϞ⧠āĻĒāĻāĻŋāĻļāύ āĻŦāĻž āĻĒāϰāĻŋāĻŦā§āĻļ
âāϝā§āĻāĻžāύ⧠āĻāĻŋāĻŽāĻā§āĻžāϰā§āĻ, āĻāĻžāϞ⧠āĻĒāϰāĻŋāĻŦā§āĻļ āĻāϰ āĻā§āϝāĻžāϰāĻŋā§āĻžāϰ āĻā§āϰā§āĻĨâ āĻāϏāĻŦ āĻāĻŋāύāĻŋāϏ āĻĒāĻžāĻā§āĻž āϝāĻžā§, āϏā§āĻ āϧāϰāύā§āϰ āĻĒā§āϰāϤāĻŋāώā§āĻ āĻžāύ⧠āĻāĻžāĻ āĻāϰāϤ⧠āĻāĻžāĻāĨ¤ āϤāĻžāĻ āĻāĻ āĻĒāĻāĻŋāĻļāύāĻāĻŋ āĻāĻŽāĻžāϰ āĻāĻžāĻā§ āĻāĻāϰā§āώāĻŖā§ā§āĨ¤â
âI want to work in an organization with a good environment, teamwork, and career growth. Thatâs why Iâm interested in this role.â
---
â āĻāϤā§āϤāϰ āϧāϰāύ ā§Ē: āĻŦā§āϤāύ āĻŦāĻž āϏā§āĻŦāĻŋāϧāĻž (āĻāĻĻā§āϰāĻāĻžāĻŦā§ āĻŦāϞāĻž)
âāĻāĻŽāĻŋ āĻĻāĻžā§āĻŋāϤā§āĻŦ āύāĻŋā§ā§ āĻāĻžāĻ āĻāϰāĻŋ, āĻāĻŋāύā§āϤ⧠āĻāĻŽāĻžāϰ āĻā§āώā§āĻāĻžāϰ āϝāĻĨāĻžāϝāĻĨ āĻŽā§āϞā§āϝāĻžā§āύ āĻŦāϰā§āϤāĻŽāĻžāύ⧠āĻĒāĻžāĻā§āĻāĻŋ āύāĻžāĨ¤ āϤāĻžāĻ āĻāĻŽāύ āĻāĻžā§āĻāĻžā§ āĻāĻžāĻ āĻāϰāϤ⧠āĻāĻžāĻ āϝā§āĻāĻžāύ⧠āĻĒāϰāĻŋāĻļā§āϰāĻŽā§āϰ āύā§āϝāĻžāϝā§āϝ āĻŽā§āϞā§āϝ āĻĒāĻžāĻā§āĻž āϝāĻžā§āĨ¤â
âI work responsibly, but Iâm not getting proper salary and benefits according to my effort. So I want a place where my work is valued.â
---
đš āϝāĻž āĻāĻāύ⧠āĻŦāϞāĻŦā§ āύāĻž:
â āĻŦāϏ āĻāĻžāϰāĻžāĻĒ
â āĻā§āĻŽā§āĻĒāĻžāύāĻŋāϤ⧠āϏāĻŽāϏā§āϝāĻž
â āĻāĻžāĻŽā§āϞāĻž āĻŦā§āĻļāĻŋ
āϤā§āĻŽāĻŋ āĻļā§āĻāĻžāϰ āĻāύā§āϝ, āĻāύā§āύāϤāĻŋāϰ āĻāύā§āϝ, āĻāϰ āĻāĻžāϞ⧠āĻā§āϝāĻžāϰāĻŋā§āĻžāϰ āĻā§āĻžāϰ āĻāύā§āϝ āĻāĻā§āĻā§āĻā§ â āĻāĻāĻŋāĻ āĻŽā§āϞ āĻŦāĻžāϰā§āϤāĻžāĨ¤
---
đŦ āĻĒā§āϰāĻļā§āύ ⧍:
āĻāĻŽāϰāĻž āĻā§āύ āĻāĻĒāύāĻžāĻā§ āύāĻŋā§ā§āĻ āĻĻā§āĻŦ? āĻāĻĒāύāĻžāϰ āĻļāĻā§āϤāĻŋ āĻā§āĻĨāĻžā§?
Why should we hire you? What are your strengths?
āĻāĻāĻžāύ⧠āĻāϤā§āĻŽāĻŦāĻŋāĻļā§āĻŦāĻžāϏ āĻĻāϰāĻāĻžāϰ, āĻ āĻšāĻāĻāĻžāϰ āύā§āĨ¤
---
â āĻāϤā§āϤāϰ āϧāϰāύ ā§§: āĻĻāĻžā§āĻŋāϤā§āĻŦāĻļā§āϞāϤāĻž
âāĻāĻŽāĻŋ āĻāĻžāĻā§ āύāĻŋā§āĻŽāĻŋāϤ, āϏāĻŽā§āĻŽāϤ⧠āĻāĻžāϰā§āĻā§āĻ āĻļā§āώ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŋ, āĻāϰ āĻā§ā§āĻžāϞāĻŋāĻāĻŋāϰ āĻĻāĻŋāĻā§ āϏāĻŦāϏāĻŽā§ āĻā§ā§āĻžāϞ āϰāĻžāĻāĻŋāĨ¤ āĻĻāĻžā§āĻŋāϤā§āĻŦ āύāĻŋā§ā§ āĻāĻžāĻ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŋāĨ¤â
âI complete my tasks on time, maintain quality, and work responsibly.â
---
â āĻāϤā§āϤāϰ āϧāϰāύ ⧍: āĻļā§āĻāĻžāϰ āĻŽāĻžāύāϏāĻŋāĻāϤāĻž + āĻāĻŋāĻŽāĻā§āĻžāϰā§āĻ
âāύāϤā§āύ āĻāĻžāĻ āĻā§āĻŦ āĻĻā§āϰā§āϤ āĻā§āϤā§āϤ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŋāĨ¤ āĻāĻŋāĻŽā§ āĻāĻžāĻ āĻāϰāϤ⧠āϏā§āĻŦāĻžāĻā§āĻāύā§āĻĻā§āϝāĻŦā§āϧ āĻāϰāĻŋ āĻāĻŦāĻ āϏāĻšāĻāϰā§āĻŽā§āĻĻā§āϰ āϏāĻžāĻĨā§ āϏāĻšāĻā§āĻ āĻŽāĻžāύāĻŋā§ā§ āύāĻŋāϤ⧠āĻĒāĻžāϰāĻŋāĨ¤â
âI learn fast and work well in a team.â
---
â āĻāϤā§āϤāϰ āϧāϰāύ ā§Š: āϏāϤāϤāĻž + āύāĻŋā§āĻŽāĻŋāϤ āĻāĻĒāϏā§āĻĨāĻŋāϤāĻŋ
âāĻāĻŽāĻŋ āĻāĻžāĻā§ āύāĻŋā§āĻŽāĻŋāϤ, āϏ⧠āĻāĻŦāĻ āĻĻāĻžā§āĻŋāϤā§āĻŦ āĻā§āĻŋā§ā§ āϝāĻžāĻ āύāĻžāĨ¤ āϝā§āĻāĻž āĻĻā§āĻā§āĻž āĻšā§, āϏā§āĻāĻŋ āϝāĻĨāĻžāϏāĻŽā§ā§ āĻļā§āώ āĻāϰāĻžāϰ āĻā§āώā§āĻāĻž āĻāϰāĻŋāĨ¤â
âIâm honest, regular, and sincere about my duties.â
---
â āĻāϤā§āϤāϰ āϧāϰāύ ā§Ē: āĻā§ā§āĻžāϞāĻŋāĻāĻŋ + āĻāĻžāϰā§āĻā§āĻ āĻĢā§āĻāĻžāϏ
âāĻĒā§āϰā§āĻĄāĻžāĻāĻļāύ āĻāĻžāϰā§āĻā§āĻ āĻāϰ āĻā§ā§āĻžāϞāĻŋāĻāĻŋâ āĻĻā§āĻā§āĻ āĻāĻŽāĻžāϰ āĻāĻžāĻā§ āĻā§āϰā§āϤā§āĻŦāĻĒā§āϰā§āĻŖāĨ¤ āĻāĻžāĻĒā§āϰ āĻŽāϧā§āϝ⧠āĻĨā§āĻā§āĻ āĻāĻžāĻ āϏāĻžāĻŽāϞāĻžāϤ⧠āĻĒāĻžāϰāĻŋāĨ¤â
âI can maintain both quality and target even under pressure.â
---
â āĻāϤā§āϤāϰ āϧāϰāύ ā§Ģ: āĻĻā§āϰā§āĻāĻŽā§ā§āĻžāĻĻāĻŋ āĻāĻžāĻŦāύāĻž
âāĻāĻŽāĻŋ āĻļā§āϧ⧠āĻāĻžāĻāϰāĻŋ āύā§â āύāĻŋāĻā§āϰ āĻā§āϝāĻžāϰāĻŋā§āĻžāϰ āϤā§āϰāĻŋ āĻāϰāϤ⧠āĻāĻžāĻāĨ¤ āϤāĻžāĻ āĻĻā§āϰā§āĻāĻŽā§ā§āĻžāĻĻā§ āĻāĻžāĻ āĻāϰāĻžāϰ āĻŽāĻžāύāϏāĻŋāĻāϤāĻž āϰā§āĻā§āĻ āĻāĻŦā§āĻĻāύ āĻāϰāĻāĻŋāĨ¤â
âI want to build a long-term career here.â
---
đš āĻāĻŋāĻĒāϏ:
âī¸ āĻāϤā§āĻŽāĻŦāĻŋāĻļā§āĻŦāĻžāϏ⧠āĻāĻā§āĻāĻŋāϤ⧠āĻāϤā§āϤāϰ āĻĻā§āĻŦā§
âī¸ āĻšāĻžāϏāĻŋāĻŽā§āĻā§ āĻāĻĨāĻž āĻŦāϞāĻŦā§
âī¸ āϏāĻŦāϏāĻŽā§ āĻāϤāĻŋāĻŦāĻžāĻāĻ āĻļāĻŦā§āĻĻ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻŦā§
âī¸ āĻāĻā§āϰ āĻāĻžāĻāϰāĻŋ āϏāĻŽā§āĻĒāϰā§āĻā§ āĻāĻāĻāĻŋāĻ āύā§āϤāĻŋāĻŦāĻžāĻāĻ āĻāĻĨāĻž āĻŦāϞāĻž āϝāĻžāĻŦā§ āύāĻž
#InterviewTips
#JobInterviewBD
#CareerGuide
#HireMe
#InterviewPreparation
#JobSeekerBD
#CareerGrowth
#ProfessionalSkills
#BangladeshJobs
#InterviewQuestions
#SoftSkills
#JobHunting
#CareerAdvice
#InterviewAnswer
#WorkplaceSkills
10 hours ago | [YT] | 1
View 0 replies
Knowledge World
āĻāϰ⧠āĻŦāϏā§āĻ āύāĻŋāĻā§ āύāĻŋāĻā§ Windows Setup āĻĻāĻŋāύ â āĻāĻāĻĻāĻŽ āϏāĻšāĻ āĻāĻžāĻāĻĄ!
āĻ āύā§āĻā§ āĻāĻžāĻŦā§, āĻāĻāύā§āĻĄā§āĻ āϏā§āĻāĻāĻĒ āĻĻāĻŋāϤ⧠āĻā§āϞā§āĻ āύāĻžāĻāĻŋ āĻāĻā§āϏāĻĒāĻžāϰā§āĻ āϞāĻžāĻā§âĻ āĻāϏāϞ⧠āύāĻž! āĻāĻĒāύāĻŋ āĻāĻžāĻāϞ⧠āĻā§āĻŦ āϏāĻšāĻā§āĻ āύāĻŋāĻā§ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŦā§āύāĨ¤
āϧāĻžāĻĒâā§§: āĻĒā§āϰā§ā§āĻāύā§ā§ āĻĒā§āϰāϏā§āϤā§āϤāĻŋ āύāĻŋāύ
âī¸ Pendrive (ā§ŽGB āĻŦāĻž āĻŦā§āĻļāĻŋ)
âī¸ Windows 10/11 āĻāϰ ISO File â āĻ āĻĢāĻŋāϏāĻŋā§āĻžāϞ āϏā§āϰā§āϏ āĻĨā§āĻā§ āĻĄāĻžāĻāύāϞā§āĻĄ āĻāϰā§āύ
âī¸ Rufus Software â Bootable Pendrive āϤā§āϰāĻŋ āĻāϰāϤā§
âĄī¸ Rufus āĻāĻĒā§āύ āĻāϰā§āύ
âĄī¸ Pendrive āϏāĻŋāϞā§āĻā§āĻ āĻāϰā§āύ
âĄī¸ ISO āĻĢāĻžāĻāϞ āϝā§āĻā§āϤ āĻāϰā§āύ
âĄī¸ âStartâ āĻāĻžāĻĒā§āύ â Bootable āϤā§āϰāĻŋ āĻšā§ā§ āϝāĻžāĻŦā§
āϧāĻžāĻĒâ⧍: āĻāĻĒāύāĻžāϰ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ Boot āĻāϰā§āύ
1ī¸âŖ Pendrive PC-āϤ⧠āϞāĻžāĻāĻžāύ
2ī¸âŖ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ Restart āĻĻāĻŋāύ
3ī¸âŖ Boot Menu āĻā§āϞā§āύ (āϏāĻžāϧāĻžāϰāĻŖāϤ F12, F9, F2, Delete āĻŦāĻž Esc)
4ī¸âŖ Boot Device āĻšāĻŋāϏā§āĻŦā§ Pendrive āϏāĻŋāϞā§āĻā§āĻ āĻāϰā§āύ
đĄ Hint: āĻŦāĻŋāĻāĻŋāύā§āύ āĻŦā§āϰā§āϝāĻžāύā§āĻĄā§ Boot Key āĻāϞāĻžāĻĻāĻž āĻšāϤ⧠āĻĒāĻžāϰ⧠â āϏā§āĻā§āϰāĻŋāύ⧠āĻĻā§āĻāĻžāύ⧠āύāĻŋāϰā§āĻĻā§āĻļāύāĻž Follow āĻāϰā§āύāĨ¤
âī¸ āϧāĻžāĻĒâā§Š: Windows Install āĻāϰāĻžāϰ āϧāĻžāĻĒ
đ âInstall Nowâ āĻā§āϞāĻŋāĻ āĻāϰā§āύ
đ āĻāĻā§āϰ Drive Format āĻāϰāϤ⧠āĻāĻžāĻāϞ⧠āϏāϤāϰā§āĻ āĻšā§ā§ āĻāϰā§āύ â āĻā§āϞ āĻāϰāϞ⧠āĻĄā§āĻāĻž āĻŽā§āĻā§ āϝāĻžāĻŦā§
đ āϏāĻ āĻŋāĻ Drive āϏāĻŋāϞā§āĻā§āĻ āĻāϰ⧠Next āĻĻāĻŋāύ
đ āĻāύāϏā§āĻāϞā§āĻļāύ āĻļā§āώ āĻšāϞ⧠PC āύāĻŋāĻā§ āĻĨā§āĻā§āĻ Restart āĻšāĻŦā§
āϧāĻžāĻĒâā§Ē: āĻĒā§āϰāĻĨāĻŽāĻŦāĻžāϰ āĻāĻžāϞ⧠āĻāϰāĻžāϰ āϏā§āĻāĻŋāĻāϏ
đĄ āĻāĻžāώāĻž (Language) āĻ āϏāĻŽā§ (Time Zone) āĻ āĻŋāĻ āĻāϰā§āύ
đĄ Wi-Fi āύā§āĻāĻāϝāĻŧāĻžāϰā§āĻ āϝā§āĻā§āϤ āĻāϰā§āύ
đĄ āĻāĻžāĻāϞ⧠Microsoft Account āϞāĻāĻāύ āĻĻāĻŋāϤ⧠āĻĒāĻžāϰā§āύ
đĄ āϏāĻŦāĻļā§āώ⧠āĻāĻŋāĻā§ Basic Settings āĻāύāĻĢāĻžāϰā§āĻŽ āĻāϰā§āύ
āĻāĻŦāĻžāϰ āĻāĻĒāύāĻžāϰ PC āϏāĻŽā§āĻĒā§āϰā§āĻŖ Ready!
āύāĻŋāĻā§ āĻāĻāύā§āĻĄā§āĻ āϏā§āĻāĻāĻĒ āĻāϰāĻž āĻŽā§āĻā§āĻ āĻāĻ āĻŋāύ āύāĻž â āĻŦāϰāĻ āĻāĻāĻŦāĻžāϰ āĻāϰāϞā§āĻ āĻāϤā§āĻŽāĻŦāĻŋāĻļā§āĻŦāĻžāϏ āĻ āύā§āĻ āĻŦāĻžā§āĻŦā§āĨ¤
đ āĻā§āώā§āĻāĻž āĻāϰ⧠āĻĻā§āĻā§āύ, āĻāϰ āϏāĻŽāϏā§āϝāĻžā§ āĻĒā§āϞ⧠āĻāĻŽā§āύā§āĻā§ āĻāĻžāύāĻžāϤ⧠āĻĒāĻžāϰā§āύ!
#WindowsSetup
#TechTipsBD
#ComputerTips
#Windows10
#Windows11
#BootablePendrive
#PCSetup
#TechGuide
#LearnComputers
#BDTech
#ITSupport
#TechEducation
#TechTutorials
#SelfLearning
1 day ago | [YT] | 3
View 0 replies
Knowledge World
đĨ Excel-āĻāϰ āϏāĻŦāĻā§ā§ā§ āĻĻāϰāĻāĻžāϰāĻŋ ā§§ā§ĻāĻāĻž Formula! đģ
āĻ āĻĢāĻŋāϏ, āϏā§āĻā§āϞ, āĻŦāĻž āĻĢā§āϰāĻŋāϞā§āϝāĻžāύā§āϏâExcel āĻāĻžā§āĻž āĻāĻžāĻā§āϰ āĻĻāĻŋāύāĻ āĻāϞ⧠āύāĻž!
āĻŦāĻŋāĻā§āϰāĻŋāϰ āϰāĻŋāĻĒā§āϰā§āĻ, āĻŽāĻžāϰā§āĻāĻļāĻŋāĻ, āĻŦāĻžāĻā§āĻ, āĻšāĻŋāϏāĻžāĻŦâāϏāĻŦāĻ āĻā§ā§āĻāĻāĻž Formula āĻāĻžāύāϞā§āĻ āϏāĻšāĻāĨ¤
āĻāϞ⧠āĻĻā§āĻāĻŋ āĻā§āύāĻā§āϞ⧠āϏāĻŦāĻā§ā§ā§ āĻŦā§āĻļāĻŋ āĻāĻžāĻā§ āϞāĻžāĻā§đ
---
1ī¸âŖ =SUM() â āĻŽā§āĻ āϝā§āĻāĻĢāϞ āĻŦā§āϰ āĻāϰā§
đ āĻāĻāĻžāϧāĻŋāĻ āϏā§āϞā§āϰ āĻŽāĻžāύ āϝā§āĻ āĻāϰ⧠āĻŽā§āĻ āĻĢāϞ āĻĻā§āĻāĻžā§āĨ¤
đĄ āϝā§āĻŽāύ: āĻŦāĻŋāĻā§āϰāĻŋāϰ āĻŽā§āĻ, āĻāϰāĻā§āϰ āĻŽā§āĻ, āĻŦāĻž āϏā§āϝāĻžāϞāĻžāϰāĻŋ āĻā§āĻāĻžāϞ āĻŦā§āϰ āĻāϰāϤā§āĨ¤
đ§Ž āĻāĻĻāĻžāĻšāϰāĻŖ:
=SUM(A1:A5) â āϏāĻŦ āĻŽāĻžāύ āϝā§āĻ āĻšā§ā§ āĻŽā§āĻ 150 āĻĻā§āĻāĻžāĻŦā§
---
2ī¸âŖ =AVERAGE() âī¸ āĻā§ āĻŽāĻžāύ āĻŦā§āϰ āĻāϰā§
đ āĻāĻāĻžāϧāĻŋāĻ āϏāĻāĻā§āϝāĻžāϰ āĻā§ āĻŦā§āϰ āĻāϰāϤ⧠āϞāĻžāĻā§āĨ¤
đĄ āϝā§āĻŽāύ āĻĒāϰā§āĻā§āώāĻžāϰ āĻā§ āύāĻŽā§āĻŦāϰ āĻŦāĻž āĻŽāĻžāϏāĻŋāĻ āĻā§ āĻŦāĻŋāĻā§āϰāĻŋāĨ¤
đ§Ž =AVERAGE(B1:B5) â āĻĢāϞāĻžāĻĢāϞ āĻšāĻŦā§ 30
---
3ī¸âŖ =MAX() âŦī¸ āϏāĻŦāĻā§ā§ā§ āĻŦā§ āĻŽāĻžāύ āĻā§āĻāĻā§ āĻĻā§ā§
đ āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āϰā§āĻā§āĻ āĻĨā§āĻā§ āϏāϰā§āĻŦā§āĻā§āĻ āĻŽāĻžāύ āĻŦā§āϰ āĻāϰā§āĨ¤
đĄ āϝā§āĻŽāύ: āĻāĻžāϰ āĻŽāĻžāϰā§āĻāϏ āϏāĻŦāĻā§ā§ā§ āĻŦā§āĻļāĻŋ, āĻā§āύ āĻŽāĻžāϏ⧠āĻŦāĻŋāĻā§āϰāĻŋ āĻŦā§āĻļāĻŋāĨ¤
đ§Ž =MAX(C1:C5) â āĻĢāϞāĻžāĻĢāϞ: 50
---
4ī¸âŖ =MIN() âŦī¸ āϏāĻŦāĻā§ā§ā§ āĻā§āĻ āĻŽāĻžāύ āĻŦā§āϰ āĻāϰā§
đ āϰā§āĻā§āĻā§āϰ āϏāĻŦāĻā§ā§ā§ āĻā§āĻ āϏāĻāĻā§āϝāĻž āĻŦāĻž āĻŽāĻžāύ āĻāĻžāύāĻžā§āĨ¤
đĄ āϝā§āĻŽāύ: āϏāϰā§āĻŦāύāĻŋāĻŽā§āύ āĻŦāĻŋāĻā§āϰāĻŋ, āĻĻāĻžāĻŽ, āĻŦāĻž āύāĻŽā§āĻŦāϰāĨ¤
đ§Ž =MIN(C1:C5) â āĻĢāϞāĻžāĻĢāϞ: 10
---
5ī¸âŖ =COUNT() đĸ āĻā§āĻāĻž āϏā§āϞ⧠āϏāĻāĻā§āϝāĻž āĻāĻā§ āϤāĻž āĻā§āύā§
đ āϰā§āĻā§āĻā§ āĻā§āĻāĻŋ āϏā§āϞ⧠āϏāĻāĻā§āϝāĻž āĻāĻā§ āϤāĻž āĻŦā§āϰ āĻāϰā§āĨ¤
đĄ āϝā§āĻŽāύ: āĻŽā§āĻ āĻā§āĻāĻž āĻĄāĻžāĻāĻž āĻāύā§āĻā§āϰāĻŋ āĻšā§ā§āĻā§ āĻāĻžāύāϤā§āĨ¤
đ§Ž =COUNT(A1:A10) â āĻĢāϞāĻžāĻĢāϞ: 7 (āϝāĻĻāĻŋ ā§āĻāĻž āϏā§āϞ⧠āϏāĻāĻā§āϝāĻž āĻĨāĻžāĻā§)
---
6ī¸âŖ =IF() â āĻļāϰā§āϤ āĻ āύā§āϝāĻžā§ā§ āĻĢāϞāĻžāĻĢāϞ āĻĻā§ā§
đ āĻļāϰā§āϤ āĻ āĻŋāĻ āĻĨāĻžāĻāϞ⧠āĻāĻ āϰā§āĻāĻžāϞā§āĻ, āύāĻž āĻĨāĻžāĻāϞ⧠āĻ āύā§āϝāĻāĻž āĻĻā§āĻāĻžā§āĨ¤
đĄ āϝā§āĻŽāύ: āĻĒāĻžāĻļ/āĻĢā§āϞ, āĻĄāĻŋāϏāĻāĻžāĻāύā§āĻ āĻŦāĻž āĻŦā§āύāĻžāϏ āĻšāĻŋāϏāĻžāĻŦ āĻāϰāϤā§āĨ¤
đ§Ž =IF(B2>=40,"Pass","Fail") â āϝāĻĻāĻŋ 40 āĻŦāĻž āϤāĻžāϰ āĻŦā§āĻļāĻŋ āĻšā§, âPassâ āĻĻā§āĻāĻžāĻŦā§
---
7ī¸âŖ =TODAY() đ āĻāĻāĻā§āϰ āϤāĻžāϰāĻŋāĻ āĻĻā§āĻāĻžā§
đ āϰāĻŋāĻĒā§āϰā§āĻ āĻŦāĻž āĻāύāĻā§ā§āϏ⧠āĻŦāϰā§āϤāĻŽāĻžāύ āϤāĻžāϰāĻŋāĻ āĻĻā§āĻāĻžāϤ⧠āĻāĻžāĻā§ āϞāĻžāĻā§āĨ¤
đ§Ž =TODAY() â āϝā§āĻŽāύ āĻĢāϞāĻžāĻĢāϞ: 11-Nov-2025
---
8ī¸âŖ =NOW() â° āϏāĻŽā§āϏāĻš āϤāĻžāϰāĻŋāĻ āĻĻā§āĻāĻžā§
đ āĻŦāϰā§āϤāĻŽāĻžāύ āϤāĻžāϰāĻŋāĻ āĻ āϏāĻŽā§ āĻāĻāϏāĻžāĻĨā§ āĻĻā§āĻāĻžā§āĨ¤
đĄ āϞāĻ āĻŦāĻž āĻāĻžāĻāĻŽ āϰā§āĻāϰā§āĻĄā§ āĻĻāϰāĻāĻžāϰāĻŋāĨ¤
đ§Ž =NOW() â āĻāĻĻāĻžāĻšāϰāĻŖ: 11-Nov-2025 08:45 PM
---
9ī¸âŖ =CONCATENATE() đ āϞā§āĻāĻž āĻāĻāϤā§āϰ āĻāϰā§
đ āĻĻā§āĻ āĻŦāĻž āϤāĻžāϰ āĻŦā§āĻļāĻŋ āĻā§āĻā§āϏāĻ āĻāĻāϤā§āϰ āĻĻā§āĻāĻžā§āĨ¤
đĄ āϝā§āĻŽāύ: āύāĻžāĻŽ + āĻĒāĻĻāĻŦāĻŋ, āĻļāĻšāϰ + āĻāϰāĻŋā§āĻž āĻāϤā§āϝāĻžāĻĻāĻŋāĨ¤
đ§Ž =CONCATENATE(A2," ",B2) â âAbu Sayeedâ
---
đ =VLOOKUP() đ āϤāĻĨā§āϝ āĻā§āĻāĻā§ āĻāύā§
đ āĻāĻ āĻā§āĻŦāĻŋāϞ āĻĨā§āĻā§ āĻ āύā§āϝ āĻā§āĻŦāĻŋāϞ⧠āĻŽāĻŋāϞāĻŋā§ā§ āϤāĻĨā§āϝ āĻā§āύ⧠āĻāύā§āĨ¤
đĄ āϝā§āĻŽāύ: āĻāĻāĻĄāĻŋ āĻĻāĻŋā§ā§ āύāĻžāĻŽ āĻŦāĻž āĻĻāĻžāĻŽ āĻŦā§āϰ āĻāϰāϤā§āĨ¤
đ§Ž =VLOOKUP(A2,B2:D10,3,FALSE) â A2 āĻ āύā§āϝāĻžā§ā§ āϤā§āϤā§ā§ āĻāϞāĻžāĻŽā§āϰ āĻŽāĻžāύ āĻĻā§āĻāĻžāĻŦā§
---
đ Bonus: =ROUND() đ āϏāĻāĻā§āϝāĻž āϰāĻžāĻāύā§āĻĄ āĻāϰā§
đ āϏāĻāĻā§āϝāĻžāĻā§ āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻĻāĻļāĻŽāĻŋāĻ āĻĒāϰā§āϝāύā§āϤ āϰāĻžāĻāύā§āĻĄ āĻāϰ⧠āĻĻā§āĻāĻžā§āĨ¤
đ§Ž =ROUND(12.3456,2) â āĻĢāϞāĻžāĻĢāϞ: 12.35
---
đĄ Excel āĻļāĻŋāĻāϤ⧠āĻāĻžāĻāϞ⧠āĻāĻ āϞāĻŋāϏā§āĻāĻāĻž āϏāĻāϰāĻā§āώāĻŖ āĻāϰ⧠āϰāĻžāĻā§āĨ¤
đ˛ āĻŦāύā§āϧā§āĻĻā§āϰ āϏāĻžāĻĨā§ āĻļā§ā§āĻžāϰ āĻāϰā§, āĻāĻĻā§āϰāĻ āĻāĻžāĻā§ āϞāĻžāĻāĻŦā§!
đ āĻĢāϞ⧠āĻāϰ⧠āύāĻŋā§āĻŽāĻŋāϤ Excel āĻāĻŋāĻĒāϏ āĻĒāĻžāĻā§āĻžāϰ āĻāύā§āϝāĨ¤
âī¸ āĻāĻŽā§āύā§āĻā§ āϞāĻŋāĻā§ āĻāĻžāύāĻžāĻ â āĻā§āύ Formula āϤā§āĻŽāĻŋ āϏāĻŦāĻā§ā§ā§ āĻŦā§āĻļāĻŋ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰā§?
#ExcelTips #MicrosoftExcel #ExcelāĻŦāĻžāĻāϞāĻž #OfficeWork #ExcelFormula #ExcelTutorial #LearnExcel #ExcelBasics #DataEntry #ExcelTraining
1 week ago | [YT] | 1
View 0 replies
Knowledge World
đ§ž Word āĻĢāĻžāĻāϞ āĻĻā§āĻāϞ⧠āĻŽāύ⧠āĻšā§ āĻāĻāĻā§ āĻ āĻā§āĻāĻžāϞā§?
āϞāĻžāĻāύ āϏā§āĻĒā§āϏāĻŋāĻ āĻāĻāϰāĻāĻŽ āύā§, āĻšā§āĻĄāĻŋāĻ āĻĢāύā§āĻ āĻāϞāĻžāĻĻāĻž, āĻāĻžāĻāĻā§āϞ āĻā§āĻ-āĻŦā§? đ
āϤāĻžāĻšāϞ⧠āϏāĻŽā§ āĻāϏā§āĻā§ āĻāĻāĻā§ āĻĒā§āϰāĻĢā§āĻļāύāĻžāϞ āĻāĻžāĻ āĻĻā§āĻā§āĻžāϰāĨ¤
āĻāĻ ā§¨ā§ĻāĻāĻž āĻāĻŋāĻĒāϏ āĻāĻžāύāϞ⧠āϤā§āĻŽāĻžāϰ āĻĢāĻžāĻāϞ āĻĻā§āĻā§āĻ āϏāĻŦāĻžāĻ āĻŦāϞāĻŦā§ â
đ âāĻā§āĻžāĻ, āĻāĻāĻĻāĻŽ āĻ āĻĢāĻŋāϏāĻŋā§āĻžāϞ āϰāĻŋāĻĒā§āϰā§āĻā§āϰ āĻŽāϤā§!â đ
---
đĄ MS Word Professional Formatting-āĻāϰ ⧍ā§ĻāĻāĻŋ āĻĻāϰāĻāĻžāϰāĻŋ āĻāĻŋāĻĒāϏ
1ī¸âŖ Font Family:
Calibri, Cambria, Arial āĻŦāĻž Times New Roman â āĻāϰāĻž āϏāĻŦāϏāĻŽā§ Safe āĻāϰ āĻĒā§āϰāĻĢā§āĻļāύāĻžāϞāĨ¤
2ī¸âŖ Font Size:
Heading: 14â16 pt | Subheading: 12â13 pt | Body Text: 11â12 pt āϰāĻžāĻā§āĨ¤
3ī¸âŖ Heading Styles:
Home â Styles â Heading 1, 2, 3 āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāϞ⧠āĻĄāĻā§āĻŽā§āύā§āĻ āĻāĻāϰāĻāĻŽ āĻĨāĻžāĻā§āĨ¤
4ī¸âŖ Table of Contents (TOC):
References â Table of Contents â āĻāĻ āĻā§āϞāĻŋāĻā§āĻ āϏā§āĻŦā§āĻāĻā§āϰāĻŋā§ āϏā§āĻāĻŋāĻĒāϤā§āϰāĨ¤
5ī¸âŖ Line Spacing:
Ctrl + 1 (Single), Ctrl + 2 (Double), Ctrl + 5 (1.5 Line)āĨ¤
6ī¸âŖ Paragraph Spacing:
Home â Paragraph â Before/After Space 6â12 pt āĻĻāĻŋāϞ⧠āĻĒā§āϤ⧠āĻāϰāĻžāĻŽ āϞāĻžāĻā§āĨ¤
7ī¸âŖ Justify Alignment:
Ctrl + J â āĻĻā§āĻ āĻĒāĻžāĻļ āϏāĻŽāĻžāύ āϏāĻžāĻāĻžāϞ⧠āϰāĻŋāĻĒā§āϰā§āĻā§āϰ āϞā§āĻ āĻ āύā§āĻ āĻāύā§āύāϤ āĻšā§āĨ¤
8ī¸âŖ First Line Indent:
Paragraph â Indent â First Line: 0.5 inch āϰāĻžāĻā§āĨ¤
9ī¸âŖ Use Styles Panel:
āĻāĻāĻŦāĻžāϰ Heading Style āĻĻāĻŋāϞ⧠āĻĒā§āϰ⧠āĻĢāĻžāĻāϞā§āĻ āĻāĻāϏāĻžāĻĨā§ āĻĢāϰāĻŽā§āϝāĻžāĻ āĻŦāĻĻāϞāĻžāύ⧠āϝāĻžā§āĨ¤
đ Bold/Italic āĻŦā§āϝāĻŦāĻšāĻžāϰ:
āĻļā§āϧ⧠āĻā§āϰā§āϤā§āĻŦāĻĒā§āϰā§āĻŖ āĻāĻžā§āĻāĻžā§ â āĻŦā§āĻļāĻŋ āĻĻāĻŋāϞ⧠āĻā§āĻā§ āϞāĻžāĻā§āĨ¤
---
1ī¸âŖ1ī¸âŖ Numbered List:
Home â Numbering â Step-by-step āύāĻŋāϰā§āĻĻā§āĻļāύāĻžāϰ āĻāύā§āϝ āĻāĻŽā§āĻāĻžāϰāĨ¤
1ī¸âŖ2ī¸âŖ Bulleted Points:
Home â Bullets â Circle āĻŦāĻž Square Bullet āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰā§āĨ¤
1ī¸âŖ3ī¸âŖ Consistent Color Palette:
āĻāĻāĻ āĻĄāĻā§āĻŽā§āύā§āĻ⧠⧍âā§ŠāĻāĻž āϰāĻ āϝāĻĨā§āώā§āĻ (Black, Blue, Gray āĻŦā§āϏā§āĻ)āĨ¤
1ī¸âŖ4ī¸âŖ Header/Footer āĻāĻāϰāĻāĻŽ āϰāĻžāĻā§:
Logo, Page Number, Date â āĻāĻāĻ āĻĢāϰāĻŽā§āϝāĻžāĻā§ āĻĻāĻŋāύāĨ¤
1ī¸âŖ5ī¸âŖ Cover Page āϝā§āĻ āĻāϰā§:
Insert â Cover Page â Report āĻŦāĻž Project-āĻāϰ āĻāύā§āϝ āϏā§āĻāĻžāĻāϞāĻŋāĻļ āĻāĻĒā§āύāĻŋāĻ āĻĒā§āĻāĨ¤
1ī¸âŖ6ī¸âŖ Section Breaks:
Layout â Breaks â Section Break āĻĻāĻŋā§ā§ āĻ āϧā§āϝāĻžā§ āĻāĻžāĻ āĻāϰā§āĨ¤
1ī¸âŖ7ī¸âŖ Alignment Guides āĻ āύ āĻāϰā§:
View â Gridlines / Ruler āĻ āύ āϰāĻžāĻāϞ⧠āϏāĻŦ āĻāϞāĻžāĻāύ āĻ āĻŋāĻ āĻĨāĻžāĻā§āĨ¤
1ī¸âŖ8ī¸âŖ Avoid Over Decoration:
āĻ āϤāĻŋāϰāĻŋāĻā§āϤ āĻļā§āĻĄāĻŋāĻ, āĻŦā§āϝāĻžāĻāĻā§āϰāĻžāĻāύā§āĻĄ āĻŦāĻž āĻāύā§āĻĄāĻžāϰāϞāĻžāĻāύ āύāĻž â Simple is Smart! đ
1ī¸âŖ9ī¸âŖ Spell Check:
F7 āĻāĻžāĻĒāϞā§āĻ Word āĻŦāĻžāύāĻžāύ āĻ āĻŦā§āϝāĻžāĻāϰāĻŖ āĻ āĻŋāĻ āĻāϰ⧠āĻĻā§āĻŦā§āĨ¤
2ī¸âŖ0ī¸âŖ Final Review:
File â Info â Inspect Document â Hidden Data āĻ Extra Space āϏāϰāĻŋā§ā§ āύāĻžāĻāĨ¤
---
đ¯ āĻāĻ āĻāĻŋāĻĒāϏāĻā§āϞ⧠āĻāĻžāύāϞ⧠āϤā§āĻŽāĻŋ āĻĒāĻžāϰāĻŦā§:
â CV, āϰāĻŋāĻĒā§āϰā§āĻ āĻŦāĻž āĻĒā§āϰāĻĒā§āĻāĻžāϞāĻā§ āĻāĻāĻĻāĻŽ āĻĒā§āϰāĻĢā§āĻļāύāĻžāϞāĻāĻžāĻŦā§ āϏāĻžāĻāĻžāϤā§
â āĻāĻ āĻā§āϞāĻŋāĻā§ āϏā§āύā§āĻĻāϰ TOC āϤā§āϰāĻŋ āĻāϰāϤā§
â āĻĄāĻā§āĻŽā§āύā§āĻā§ āĻāϰā§āĻĒā§āϰā§āĻ āϞā§āĻā§āϞā§āϰ āϞā§āĻ āĻāύāϤ⧠đŧ
---
đĸ āĻāĻŽā§āύā§āĻā§ āϞā§āĻā§ đ âWord Formatting Masterâ
āϝāĻĻāĻŋ āĻāĻ āĻĨā§āĻā§āĻ āĻĒā§āϰā§āϝāĻžāĻāĻāĻŋāϏ āĻļā§āϰ⧠āĻāϰāϤ⧠āĻāĻžāĻ!
đ˛ āĻĢāϞ⧠āĻāϰ⧠āύāĻŋā§āĻŽāĻŋāϤ Office Tips āĻĒāĻžāĻā§āĻžāϰ āĻāύā§āϝāĨ¤
#MicrosoftWord #WordTips #OfficeWork #DocumentFormatting #WordāĻŦāĻžāĻāϞāĻž #LearnMSWord #WordStyle #ProfessionalDocs
1 week ago | [YT] | 0
View 0 replies
Knowledge World
āĻāĻĒāύāĻŋ āĻāϤāĻāĻž Real-Life Excel Problem āĻŦā§āĻāϤ⧠āĻĒāĻžāϰā§āύ, āϤāĻžāĻšāϞ⧠āĻāĻ MCQ āĻāĻā§āϏāĻžāĻŽ āĻĻāĻŋāϝāĻŧā§ āĻāϤā§āϤāϰāĻā§āϞ⧠āĻāĻŽā§āύā§āĻ āĻāϰā§āύ đ
Q1. Excel-āĻ āϝāĻĻāĻŋ Column A-āϤ⧠âPriceâ āĻāϰ Column B-āϤ⧠âQuantityâ āĻĨāĻžāĻā§, āϤāĻžāĻšāϞ⧠Total Sales āĻŦā§āϰ āĻāϰāϤ⧠āĻā§āύ Formula āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāĻŦā§?
a) =A1+B1
b) =A1*B1
c) =SUM(A1,B1)
d) =ADD(A1,B1)
Q2. Excel-āĻ āϝāĻĻāĻŋ āĻā§āύ⧠Column-āĻāϰ āϏāĻŦ Value āϝā§āĻ āĻāϰāϤ⧠āĻāĻžāύ, āϤāĻžāĻšāϞ⧠āĻā§āύ Function āϏāĻŦāĻā§āϝāĻŧā§ āϏāĻšāĻ?
a) COUNT()
b) SUM()
c) TOTAL()
d) AVERAGE()
Q3. Excel-āĻ â#DIV/0!â Error āĻŽāĻžāύ⧠āĻā§?
a) Cell Blank āĻāĻā§
b) Formula āĻā§āϞ
c) Division by Zero āĻāϰāĻž āĻšāϝāĻŧā§āĻā§
d) Cell Locked
Q4. Excel-āĻ Text āĻā§ āĻā§āĻ āĻšāĻžāϤā§āϰ Letter-āĻ Convert āĻāϰāϤ⧠āĻā§āύ Function āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ?
a) LOWER()
b) UPPER()
c) PROPER()
d) TEXT()
Q5. Excel-āĻ âData Validationâ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ āĻā§āύ āĻāĻžāĻā§āϰ āĻāύā§āϝ?
a) Cell Merge āĻāϰāĻžāϰ āĻāύā§āϝ
b) Cell-āĻ āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ Type-āĻāϰ Data Allow āĻāϰāĻžāϰ āĻāύā§āϝ
c) Formula Protect āĻāϰāĻžāϰ āĻāύā§āϝ
d) Worksheet Hide āĻāϰāĻžāϰ āĻāύā§āϝ
Q6. Excel-āĻ âIF Functionâ āĻā§ āĻāĻžāĻā§ āϞāĻžāĻā§?
a) Calculation āĻāϰāĻžāϰ āĻāύā§āϝ
b) Logical Test āĻ āύā§āϝāĻžāϝāĻŧā§ āĻĢāϞāĻžāĻĢāϞ āĻĻā§āĻāĻžāύā§āϰ āĻāύā§āϝ
c) Text Format āĻāϰāĻžāϰ āĻāύā§āϝ
d) Chart āϤā§āϰāĻŋ āĻāϰāĻžāϰ āĻāύā§āϝ
Q7. Excel-āĻ āĻāĻāĻāĻŋ Column āĻŦāĻž Row Hide āĻāϰāĻžāϰ Shortcut āĻā§?
a) Ctrl + 9 (Row Hide), Ctrl + 0 (Column Hide)
b) Ctrl + H
c) Ctrl + Shift + H
d) Ctrl + â
Q8. Excel-āĻ âAlt + Enterâ Shortcut-āĻāϰ āĻāĻžāĻ āĻā§?
a) āύāϤā§āύ Row Insert āĻāϰāĻž
b) āĻāĻāĻ Cell-āĻāϰ āĻāĻŋāϤāϰ⧠āύāϤā§āύ Line āϤā§āϰāĻŋ āĻāϰāĻž
c) Formula Run āĻāϰāĻž
d) Cell Merge āĻāϰāĻž
Q9. Excel-āĻ Data āĻā§ Alphabetically āϏāĻžāĻāĻžāϤ⧠āĻā§āύ Option āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ?
a) Sort A to Z
b) Filter
c) Arrange
d) Format
Q10. Excel-āĻ âCtrl + 1â Shortcut āĻā§ āĻāϰā§?
a) Workbook Save āĻāϰā§
b) Format Cells Dialog Box āĻā§āϞā§
c) Formula Edit āĻāϰā§
d) Chart Insert āĻāϰā§
---
â Answers:
1-bâ2-bâ3-câ4-aâ5-bâ6-bâ7-aâ8-bâ9-aâ10-b
đ #MicrosoftExcel #ExcelMCQ #ExcelQuiz #ExcelForBeginners #ExcelPractice #LearnExcel #ExcelTips #OfficeTraining #ExcelLearning #KnowledgeWord #MSExcel
2 weeks ago | [YT] | 0
View 0 replies
Knowledge World
āĻāϞā§āύ Excel-āĻāϰ āĻāĻŋāĻā§ āϏāĻšāĻ MCQ āĻĒāϰā§āĻā§āώāĻž āĻĻāĻŋāϝāĻŧā§ āĻŽāĻāĻž āĻāϰāĻŋ! āĻāĻĒāύāĻžāϰ āĻāϤā§āϤāϰāĻā§āϞ⧠āĻāĻŽā§āύā§āĻā§ āĻāĻžāύāĻžāύ đ
Q1. Excel-āĻ āĻā§āύ Function āĻāĻž āĻāĻāĻāĻŋ Column āĻŦāĻž Row-āĻāϰ āĻŽāϧā§āϝ⧠āϏāϰā§āĻŦāύāĻŋāĻŽā§āύ Value āĻŦā§āϰ āĻāϰā§?
a) MAX()
b) MIN()
c) SMALL()
d) LOW()
Q2. Excel-āĻ āĻā§āύ⧠Cell-āĻāϰ āĻŽāϧā§āϝ⧠Text āĻŦāĻž Number Center āĻāϰāϤ⧠āĻā§āύ Tab āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ?
a) Home
b) Insert
c) Page Layout
d) Data
Q3. Excel-āĻ āĻā§āύ⧠Cell Merge āĻāϰāϤ⧠āĻā§āύ Option āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻž āĻšāϝāĻŧ?
a) Merge & Center
b) Combine Cells
c) Join Cells
d) Merge Only
Q4. Excel-āĻ Conditional Formatting āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻž āĻšāϝāĻŧ āĻā§āύ āĻāĻžāĻā§āϰ āĻāύā§āϝ?
a) Cell Color āĻĒāϰāĻŋāĻŦāϰā§āϤāύ
b) āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ Condition āĻ āύā§āϝāĻžāϝāĻŧā§ Format Apply āĻāϰāĻž
c) Formula āϞāĻŋāĻāϤā§
d) Data Sort āĻāϰāϤā§
Q5. Excel-āĻ âCtrl + ;â Shortcut āĻā§ āĻĻā§āϝāĻŧ?
a) Current Time
b) Current Date
c) Insert Formula
d) Insert Row
Q6. Excel-āĻ VLOOKUP Function āĻā§ āĻāĻžāĻā§ āϞāĻžāĻā§?
a) Column Add āĻāϰāĻžāϰ āĻāύā§āϝ
b) Data Search āĻāĻŦāĻ Retrieve āĻāϰāĻžāϰ āĻāύā§āϝ
c) Row Delete āĻāϰāĻžāϰ āĻāύā§āϝ
d) Chart Insert āĻāϰāĻžāϰ āĻāύā§āϝ
Q7. Excel-āĻ Text Wrap āĻāϰāϤ⧠āĻā§āύ Option āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ?
a) Wrap Text
b) Merge Cells
c) Text Align
d) Text Box
Q8. Excel-āĻ āĻāĻāĻāĻŋ Worksheet-āĻāϰ Name āĻĒāϰāĻŋāĻŦāϰā§āϤāύ āĻāϰāϤ⧠āĻāĻŋ āĻāϰāϤ⧠āĻšāϝāĻŧ?
a) Right Click on Sheet Tab â Rename
b) Double Click on Sheet Tab â Rename
c) Both a & b
d) Cannot Rename
Q9. Excel-āĻ Filter Apply āĻāϰāĻžāϰ āĻāύā§āϝ āĻā§āύ Tab-āĻ āϝā§āϤ⧠āĻšāϝāĻŧ?
a) Home
b) Data
c) Insert
d) View
Q10. Excel-āĻ āĻāĻāĻāĻŋ Row āĻŦāĻž Column Delete āĻāϰāϤ⧠Shortcut āĻā§?
a) Ctrl + -
b) Ctrl + D
c) Ctrl + X
d) Ctrl + Shift + D
â Answers:
1-bâ2-aâ3-aâ4-bâ5-bâ6-bâ7-aâ8-câ9-bâ10-a
đ #MicrosoftExcel #ExcelMCQ #ExcelQuiz #ExcelForBeginners #LearnExcel #ExcelTips #OfficeTraining #ExcelLearning #KnowledgeWord #MSExcel
2 weeks ago | [YT] | 1
View 0 replies
Knowledge World
āĻāϞā§āύ āĻĻā§āĻāĻŋ, āĻāĻĒāύāĻŋ āĻāϏāϞ⧠Excel Exam āĻ āĻāϤ Mark āĻĒāĻžāύ, āϏā§āĻāĻž āĻāĻŽā§āύā§āĻā§ āĻāĻžāύāĻžāύ đ
Q1. Excel-āĻ āĻā§āύ Function āĻāĻž Number āĻā§āϞā§āϰ āϝā§āĻāĻĢāϞ āĻŦā§āϰ āĻāϰāϤ⧠āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ?
a) ADD()
b) TOTAL()
c) SUM()
d) PLUS()
Q2. Excel-āĻāϰ āĻĒā§āϰāϤāĻŋāĻāĻŋ Column āĻā§ āĻāĻŋāĻšā§āύāĻŋāϤ āĻāϰāĻž āĻšāϝāĻŧ āĻā§ āĻĻāĻŋāϝāĻŧā§?
a) Number
b) Letter
c) Symbol
d) Color
Q3. Cell-āĻāϰ āĻāĻŋāϤāϰā§āϰ āϞā§āĻāĻž Center āĻāϰāϤ⧠āĻā§āύ Shortcut āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ?
a) Ctrl + C
b) Alt + H + A + C
c) Ctrl + E
d) Shift + C
Q4. Excel-āĻ Data āĻā§ āĻā§āĻ āĻĨā§āĻā§ āĻŦāĻĄāĻŧ āϏāĻžāĻāĻžāϤ⧠āĻā§āύ Option āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻž āĻšāϝāĻŧ?
a) Sort Z to A
b) Sort A to Z
c) Filter
d) Arrange
Q5. Excel-āĻ Formula āĻļā§āϰ⧠āĻšāϝāĻŧ āϏāĻŦāϏāĻŽāϝāĻŧ āĻā§āύ Symbol āĻĻāĻŋāϝāĻŧā§?
a) =
b) +
c) #
d) @
Q6. Excel-āĻāϰ Fill Handle āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻž āĻšāϝāĻŧ āĻā§ āĻāĻžāĻā§āϰ āĻāύā§āϝ?
a) Cell Delete āĻāϰāĻžāϰ āĻāύā§āϝ
b) Formula Copy āĻāϰāĻžāϰ āĻāύā§āϝ
c) Auto Fill āĻŦāĻž Series āϤā§āϰāĻŋ āĻāϰāĻžāϰ āĻāύā§āϝ
d) Cell Merge āĻāϰāĻžāϰ āĻāύā§āϝ
Q7. Excel-āĻ COUNTIF() Function āĻā§ āĻāϰā§?
a) āĻļā§āϧ⧠āϏāĻāĻā§āϝāĻžāϰ Cell āĻā§āύā§
b) āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ Condition āĻ āύā§āϝāĻžāϝāĻŧā§ Cell Count āĻāϰā§
c) Text āĻā§āϞ⧠āϝā§āĻ āĻāϰā§
d) Blank Cell Count āĻāϰā§
Q8. Excel-āĻ Chart Insert āĻāϰāϤ⧠āĻšāϞ⧠āĻā§āύ Tab-āĻ āϝā§āϤ⧠āĻšāϝāĻŧ?
a) Home
b) Insert
c) Data
d) View
Q9. Excel-āĻāϰ Shortcut âCtrl + Zâ āĻāϰ āĻāĻžāĻ āĻā§?
a) Redo
b) Undo
c) Save
d) Copy
Q10. Excel-āĻ Data Filter āĻāϰāϤ⧠āĻā§āύ Shortcut āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ?
a) Ctrl + F
b) Ctrl + Shift + L
c) Ctrl + L
d) Alt + F
â Answers:
1-câ2-bâ3-bâ4-bâ5-aâ6-câ7-bâ8-bâ9-bâ10-b
đ #MicrosoftExcel #ExcelMCQ #ExcelQuiz #ExcelForBeginners #LearnExcel #ExcelTips #OfficeTraining #ExcelLearning #KnowledgeWord #MSExcel
2 weeks ago | [YT] | 0
View 0 replies
Knowledge World
đ āĻāĻā§āϏā§āϞā§āϰ āĻŦā§āϏāĻŋāĻ āĻā§āĻāĻžāύ āĻĒāϰā§āĻā§āώāĻž āĻĻāĻŋāύ! āĻāĻ ā§§ā§ĻāĻāĻŋ āĻĒā§āϰāĻļā§āύā§āϰ āĻāϤā§āϤāϰ āĻĻāĻŋāϤ⧠āĻĒāĻžāϰā§āύ? āĻāϤā§āϤāϰ āĻā§āϞ⧠āĻāĻŽā§āύā§āĻ āĻāϰā§āύ āĨ¤
Q1. In Excel, which symbol is used to start a formula?
a) +
b) =
c) â
d) /
Q2. Which function is used to find the average range of numbers?
a) COUNT()
b) AVERAGE()
c) SUM()
d) MAX()
Q3. What is the default file extension for an Excel workbook in modern versions?
a) .xls
b) .xlsx
c) .csv
d) .docx
Q4. Which keyboard shortcut is used to copy selected data?
a) Ctrl + X
b) Ctrl + C
c) Ctrl + V
d) Ctrl + Z
Q5. Which function returns the highest value in a range?
a) MAX()
b) MIN()
c) LARGE()
d) HIGH()
Q6. In Excel, a cell reference like $A$1 is called:
a) Relative reference
b) Absolute reference
c) Mixed reference
d) Dynamic reference
Q7. Which option is used to combine text from multiple cells into one?
a) CONCATENATE or CONCAT
b) MERGE CELLS
c) COMBINE()
d) JOIN()
Q8. Which feature helps you quickly fill a series or pattern (like numbers or dates)?
a) AutoFill
b) Flash Fill
c) Data Fill
d) Fill Handle
Q9. Which function counts only the cells that contain numbers?
a) COUNTA()
b) COUNT()
c) COUNTIF()
d) SUM()
Q10. To insert a new row in Excel, you can use a shortcut:
a) Ctrl + N
b) Ctrl + Shift + +
c) Alt + Enter
d) Shift + Enter
đ #MicrosoftExcel #ExcelMCQ #ExcelForBeginners #LearnExcel #ExcelQuiz #OfficeTraining #ExcelTips #KnowledgeWord #ExcelLearning #MSExcel
2 weeks ago | [YT] | 0
View 1 reply
Knowledge World
#Resume_vs_CV_āĻāϏāϞ_āĻĒāĻžāϰā§āĻĨāĻā§āϝāĻāĻž_āĻā§?
āĻ āύā§āĻā§āĻ āĻŽāύ⧠āĻāϰ⧠Resume āĻāϰ CV āĻāĻāĻ āĻāĻŋāύāĻŋāϏāĨ¤ āĻāϏāϞ⧠āύāĻž!
đ Resume:
ā§§âā§Š āĻĒā§āĻāĻ
āĻļā§āϧ⧠āϏā§āĻāĻŋāϞ, āĻ āĻāĻŋāĻā§āĻāϤāĻž, āĻ āϰā§āĻāύā§āϰ āϏāĻāĻā§āώāĻŋāĻĒā§āϤāϏāĻžāϰ
āύāĻŋāϰā§āĻĻāĻŋāώā§āĻ āĻāĻžāĻāϰāĻŋāϰ āĻāύā§āϝ āĻāĻžāϏā§āĻāĻŽāĻžāĻāĻ āĻāϰāĻž āĻšā§
āĻāϰā§āĻĒā§āϰā§āĻ/āĻĒā§āϰāĻžāĻāĻā§āĻ āϏā§āĻā§āĻāϰ⧠āĻŦā§āĻļāĻŋ āĻŦā§āϝāĻŦāĻšāĻžāϰ
đ CV (Curriculum Vitae):
āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻĄāĻā§āĻŽā§āύā§āĻ
āĻļāĻŋāĻā§āώāĻž, āĻāĻŦā§āώāĻŖāĻž, āĻāĻžāĻā§āϰ āĻāϤāĻŋāĻšāĻžāϏ, āĻā§āϰā§āύāĻŋāĻ, āĻĒā§āϰāϏā§āĻāĻžāϰ, āĻĒāĻžāĻŦāϞāĻŋāĻā§āĻļāύ āϏāĻŦāĻāĻŋāĻā§ āĻĨāĻžāĻā§
āĻāĻāĻžāĻĄā§āĻŽāĻŋāĻ, āĻāĻŦā§āώāĻŖāĻž āĻŦāĻž āϏāϰāĻāĻžāϰāĻŋ āĻāĻžāĻāϰāĻŋāϤ⧠āĻŦā§āĻļāĻŋ āĻŦā§āϝāĻŦāĻšāĻžāϰ
đ āϏāĻšāĻāĻāĻžāĻŦā§ āĻŦāϞāϞā§â
Resume = āĻā§āĻ āĻ āĻāĻŦ-āĻĢā§āĻāĻžāϏāĻĄ
CV = āĻĻā§āϰā§āĻ āĻ āĻĄāĻŋāĻā§āĻāϞāĻĄ
âī¸ āĻ āύā§āĻ āϏāĻŽā§ āĻāĻŽāϰāĻž āĻšā§āĻĄāĻžāϰ⧠Resume āϞāĻŋāĻā§ āĻāϏāϞ⧠CV āĻŦāĻžāύāĻžāĻ, āĻāĻŦāĻžāϰ CV āϞāĻŋāĻā§ Resume āĻŦāĻžāύāĻžāĻāĨ¤ āĻāĻāύ āĻĨā§āĻā§ āĻ āĻŋāĻ āĻāĻžā§āĻāĻžā§ āϏāĻ āĻŋāĻ āĻĄāĻā§āĻŽā§āύā§āĻ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻŋāĨ¤
#ResumeVsCV #CareerTips #JobPreparation #ResumeWriting #CVTips #CareerGrowth #JobSeeker #InterviewTips
1 month ago | [YT] | 2
View 0 replies
Knowledge World
#āĻāĻžāĻāϰāĻŋāϰ_āĻāύā§āĻāĻžāϰāĻāĻŋāĻāϤā§_ā§§ā§ĻāĻāĻŋ_āĻāĻŽāύ_āĻĒā§āϰāĻļā§āύā§āϰ_āϏā§āĻŽāĻžāϰā§āĻ_āĻāϤā§āϤāϰ
āĻĒā§āϰāϤāĻŋ āĻĒā§āϰāĻžāϰā§āĻĨā§āĻā§ āĻāύā§āĻāĻžāϰāĻāĻŋāĻ āϤ⧠āĻĒā§āϰāĻžā§ āĻāĻāĻ āĻĒā§āϰāĻļā§āύ āĻāϰ⧠āĻĨāĻžāĻā§ āĻĨāĻžāĻā§, āĻāĻŋāύā§āϤ⧠āĻā§ āĻāϰ⧠āĻāϤā§āĻŽāĻŦāĻŋāĻļā§āĻŦāĻžāϏ⧠āĻāϤā§āϤāϰāĨ¤
1ī¸âŖ Tell me about yourself â āύāĻžāĻŽ, āĻĒā§āĻžāĻļā§āύāĻž, āĻ āĻāĻŋāĻā§āĻāϤāĻž, āĻā§āϝāĻžāϰāĻŋā§āĻžāϰ āĻā§āϞ ā§§ āĻŽāĻŋāύāĻŋāĻā§ āĻŦāϞā§āύāĨ¤
2ī¸âŖ Why should we hire you? â āύāĻŋāĻā§āϰ āĻĻāĻā§āώāϤāĻž āĻā§āĻŽā§āĻĒāĻžāύāĻŋāϰ āĻĒā§āϰā§ā§āĻāύā§āϰ āϏāĻžāĻĨā§ āĻŽāĻŋāϞāĻžāύāĨ¤
3ī¸âŖ Strengths â āĻŦāĻžāϏā§āϤāĻŦ āĻāĻĻāĻžāĻšāϰāĻŖ āĻĻāĻŋāύ, āϝā§āĻŽāύ āϏāĻŽāϏā§āϝāĻž āϏāĻŽāĻžāϧāĻžāύāĨ¤
4ī¸âŖ Weaknesses â āĻāĻŽāύ āĻĻā§āϰā§āĻŦāϞāϤāĻž āĻŦāϞā§āύ āϝā§āĻāĻž āĻāĻĒāύāĻŋ āĻ āĻŋāĻ āĻāϰāĻžāϰ āĻā§āώā§āĻāĻž āĻāϰāĻā§āύāĨ¤
5ī¸âŖ 5 years later â āĻāĻĒāύāĻžāϰ āĻāĻŋāĻļāύ āĻā§āĻŽā§āĻĒāĻžāύāĻŋāϰ āϏāĻžāĻĨā§ āĻŽāĻŋāϞāĻŋā§ā§ āĻŦāϞā§āύāĨ¤
6ī¸âŖ Last job āĻā§āύ āĻāĻžā§āϞā§āύ? â āύā§āϤāĻŋāĻŦāĻžāĻāĻ āύāĻž āĻšā§ā§ āĻā§āϰā§āĻĨ āĻ āĻā§āϝāĻžāϞā§āĻā§āĻā§āϰ āĻāĻĨāĻž āĻŦāϞā§āύāĨ¤
7ī¸âŖ Pressure handle āĻāϰāĻŦā§āύ āĻāĻŋāĻāĻžāĻŦā§? â āĻāĻĻāĻžāĻšāϰāĻŖ āĻĻāĻŋāύ, āϝā§āĻŽāύ āĻāĻžāϰā§āĻā§āĻ āĻ āϰā§āĻāύ āĻā§āĻļāϞāĨ¤
8ī¸âŖ What do you know about us? â āĻāĻā§ āĻĨā§āĻā§ āϰāĻŋāϏāĻžāϰā§āĻ āĻāϰā§āύāĨ¤
9ī¸âŖ Teamwork â āĻāĻŋāĻāĻžāĻŦā§ āϞāĻŋāĻĄ āĻāϰā§āĻā§āύ āĻŦāĻž āĻāĻŋāĻŽā§āϰ āϏāĻžāĻĨā§ āϏāĻĢāϞ āĻšā§ā§āĻā§āύ āĻŦāϞā§āύāĨ¤
đ Do you have any questions? â āϏā§āĻŽāĻžāϰā§āĻ āĻĒā§āϰāĻļā§āύ āĻāϰā§āύ, āϝā§āĻŽāύ āĻā§āĻŽā§āĻĒāĻžāύāĻŋāϰ āĻĢāĻŋāĻāĻāĻžāϰ āĻĒā§āϞā§āϝāĻžāύāĨ¤
#JobInterview #CareerTips #InterviewPreparation #JobHunt #CareerSuccess #BangladeshJobs #InterviewTips #CareerGrowth #SmartAnswers #JobSeeker
1 month ago | [YT] | 3
View 0 replies
Load more