
Microsoft Excel is a powerful tool used for data analysis, financial modeling, and a wide range of business applications. While many are familiar with basic functions, mastering advanced Excel skills can significantly enhance your productivity and data management capabilities. Hereâs a comprehensive guide to some of the advanced features and techniques in Excel that can help you become an expert.
Key areas covered in an Advanced Excel course typically include:
- Data Modeling: Creating complex data structures and relationships.
- PivotTables and Pivot Charts: Mastering these tools for data summarization and visualization.
- Power Query: Efficiently cleaning, transforming, and loading data.
- Power Pivot: Building data models and performing complex calculations.
- Data Analysis Tools: Utilizing statistical functions and analysis tools.
- Macros and VBA: Automating tasks and creating custom functions.
- Data Visualization: Creating impactful and interactive dashboards.
By mastering these advanced Excel skills, you’ll be equipped to handle intricate data challenges, make data-driven decisions, and elevate your productivity to new heights.
Why Advanced Excel Skills Matter
Advanced Excel skills are crucial for professionals who need to manage, analyze, and visualize large datasets. Whether youâre a financial analyst, project manager, data scientist, or business professional, the ability to perform sophisticated calculations, create dynamic reports, and automate tasks can set you apart in the workplace. Advanced Excel skills enable you to:
- Perform Complex Calculations: Utilize advanced formulas and functions to solve intricate problems and perform multi-step calculations.
- Analyze Data Efficiently: Use advanced data analysis tools to identify trends, patterns, and insights from large datasets.
- Automate Tasks: Streamline repetitive tasks through macros and VBA (Visual Basic for Applications) programming.
- Create Professional Reports: Develop interactive dashboards and detailed reports that effectively communicate your data findings.
Key Components of an Advanced Excel Course
An Advanced Excel Course typically covers a range of topics designed to deepen your understanding of Excelâs capabilities and improve your ability to work with complex data. Hereâs what you can expect:
- Advanced Formulas and Functions
- Array Formulas: Perform calculations on multiple values at once using array formulas.
- Lookup Functions: Master advanced lookup functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH to retrieve and analyze data from different ranges.
- Logical Functions: Utilize IF, AND, OR, and other logical functions to perform conditional calculations.
- Data Analysis and Pivot Tables
- Pivot Tables: Create and customize pivot tables to summarize and analyze large datasets efficiently.
- Pivot Charts: Use pivot charts to visualize data trends and insights derived from pivot tables.
- Data Validation: Implement data validation techniques to ensure data accuracy and consistency.
- Advanced Data Visualization
- Dynamic Charts: Create dynamic charts that update automatically with changes in your data.
- Conditional Formatting: Apply conditional formatting to highlight key data points and trends.
- Sparklines: Use sparklines to display trends within a cell, providing a compact visual representation of data.
- Automation with Macros and VBA
- Recording Macros: Record and run macros to automate repetitive tasks and processes.
- VBA Programming: Learn the basics of VBA programming to write custom code and create advanced automation solutions.
- Data Management and Analysis Tools
- Power Query: Use Power Query to import, transform, and clean data from various sources.
- Power Pivot: Enhance data modeling and analysis with Power Pivot, allowing for complex calculations and data relationships.
- What-If Analysis: Perform scenario analysis and data forecasting using tools like Goal Seek and Data Tables.
- Advanced Workbook and Worksheet Management
- Workbook Protection: Implement advanced security features to protect sensitive data and control access.
- Worksheet Navigation: Master techniques for managing and navigating large workbooks with multiple sheets.
Benefits of Completing an Advanced Excel Course
- Enhanced Efficiency: Streamline your workflow and save time by mastering advanced techniques and automation tools.
- Improved Decision-Making: Gain the ability to analyze data more effectively and make informed decisions based on comprehensive insights.
- Career Advancement: Strengthen your resume and increase your marketability by showcasing your advanced Excel skills to potential employers.
- Professional Development: Expand your skill set and stay competitive in fields where advanced data analysis and reporting are essential.
How to Enroll in an Advanced Excel Course
To enroll in an Advanced Excel Course, follow these steps:
- Research Providers: Look for reputable institutions or online platforms offering Advanced Excel training. Check reviews and course content to ensure it meets your needs.
- Review Course Details: Examine the course syllabus, duration, format (online or in-person), and prerequisites to confirm it aligns with your learning objectives.
- Register: Complete the registration process by filling out the necessary forms and paying the course fee.
- Prepare for Classes: Gather any required materials and ensure you have access to the necessary software and tools.
How can I learn Advanced Excel?
You can learn Advanced Excel through CSTC live and online course.
What are the benefits of using Advanced Excel features?
Advanced Excel features enable you to handle larger datasets, perform complex analyses, automate repetitive tasks, and create dynamic reports. These skills can improve your efficiency, accuracy, and ability to make data-driven decisions.
What is VBA and how can it help?
VBA (Visual Basic for Applications) is a programming language that allows you to automate tasks in Excel, create custom functions, and build complex data models. You can use VBA to write macros that automate repetitive tasks, create custom user forms, and interact with other Office applications.
What is Advanced Excel?
Advanced Excel refers to the use of complex functions, tools, and features within Microsoft Excel to perform sophisticated data analysis, create dynamic reports, and automate tasks. This includes skills like using advanced formulas, Pivot Tables, Power Query, Power Pivot, and VBA programming.
Conclusion
The Advanced Excel Course is an essential investment for anyone looking to elevate their data management and analysis skills. By mastering advanced techniques and tools, youâll enhance your ability to handle complex data tasks, automate repetitive processes, and create insightful reports. Whether for career advancement or personal development, gaining expertise in advanced Excel is a powerful way to unlock new opportunities and achieve greater efficiency in your work.
āĻā§āύ āϏāĻžāϞ⧠āĻŦāĻžāĻāϞāĻžāĻĻā§āĻļā§ āĻĒā§āϰāĻĨāĻŽ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻšāϝāĻŧ? āĻ. ⧧⧝ā§Ģ⧝ āĻ. ⧧⧝ā§Ŧā§ āĻ. ⧧⧝ā§ā§Ē āĻ. ⧧⧝ā§Ŧā§Ē
F5 āĻšāϤ⧠F25 āϏā§āϞā§āϰ āĻĄāĻžāĻāĻž āϝā§āĻ āĻāϰāĻžāϰ āĻĢāĻžāĻāĻļāύ- āĻ. SUM (F5, F25) āĻ. SUM (F5: F25) āĻ. SUM (F5+F25 āĻ, SUM (F5. F25)
āĻĄāĻžāĻāĻžāĻŦā§āϏ āĻāĻ āĻŋāϤ āĻšāϝāĻŧ- āĻ. āĻāϤāĻāĻā§āϞ⧠āϰā§āĻāϰā§āĻĄ āύāĻŋāϝāĻŧā§ āĻ. āĻāϤāĻāĻā§āϞ⧠āĻĢāĻŋāϞā§āĻĄ āύāĻŋāϝāĻŧā§
āĻ. āĻāϤāĻāĻā§āϞ⧠āĻĢāĻžāĻāϞ āύāĻŋāϝāĻŧā§ āĻ. āĻāĻ āĻŦāĻž āĻāĻāĻžāϧāĻŋāĻ āĻĄāĻžāĻāĻž āύāĻŋāϝāĻŧā§
LAN āĻļāĻŦā§āĻĻā§āϰ āĻĒā§āϰā§āĻŖāϰā§āĻĒ āĻā§āύāĻāĻŋ? āĻ. Local Assemble Network āĻ. Local Area Note āĻ. Local Area Network āĻ. Legal Assemble Network
āĻā§āύāĻāĻŋ Network Operating system? āĻ. Window 98 āĻ. DOS āĻ. Google earth āĻ. UNIX
(⧍⧝)ā§§ā§Ļ āϏāĻāĻā§āϝāĻžāĻāĻŋāĻā§ āĻŦāĻžāĻāύāĻžāϰāĻŋāϤ⧠āĻĒā§āϰāĻāĻžāĻļ āĻāϰāϞ⧠āĻāϤ āĻšāϝāĻŧ? āĻ. (ā§§ā§§ā§Ļā§§ā§§)⧍ āĻ. (ā§§ā§§ā§§ā§§ā§Ļ)⧍ āĻ. (ā§§ā§§ā§§ā§Ļā§§)⧍ āĻ ,(ā§§ā§Ļā§§ā§§ā§§) ⧍
Query āĻāϰ āĻāĻžāĻ āĻšāϞ⧠āĻĄāĻžāĻāĻžāĻŦā§āϏ āĻĨā§āĻā§ āĻĒā§āϰā§ā§āĻāύā§ā§ āĻĄāĻžāĻāĻž āĻ. āϏāĻžāĻāĻŋāϝāĻŧā§ āĻĒā§āϰāĻŋāύā§āĻ āĻāϰāĻž āĻ. āĻā§āĻāĻā§ āĻŦā§āϰ āĻāϰāĻžāϰ āĻ. āϏā§āύā§āĻĻāϰāĻāĻžāĻŦā§ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻāϰāĻž āĻ. āϰā§āĻāϰā§āĻĄ āĻā§āϞ⧠āϏāĻžāĻāĻžāύā§
āύāĻŋāĻā§āϰ āĻā§āύāĻāĻŋ āĻĢāĻžāϰā§āĻŽāĻāϝāĻŧā§āϝāĻžāϰ? āĻ. Processor āĻ. CMOS āĻ. ROM-BIOS āĻ. ROM
IC āĻāϰ āĻ āϰā§āĻĨ āĻ. Important Circuit āĻ. Integrated Circuit āĻ. International Circuit āĻ. Impossible Circuit
Save āĻāϰ āĻā§-āĻŦā§āϰā§āĻĄ āĻāĻŽāĻžāύā§āĻĄ āĻā§āύāĻāĻŋ? āĻ. Ctrl + P āĻ. Ctrl + S āĻ. Ctrl + C āĻ. Ctrl +X
āϏāĻ āĻŋāĻ āĻļāĻŦā§āĻĻ āĻĻāĻŋāϝāĻŧā§ āĻļā§āύā§āϝāϏā§āĻĨāĻžāύ āĻĒā§āϰāĻŖ āĻāϰāĨ¤
āĻŽā§āĻŽāϰāĻŋāϰ āĻāĻāĻ āĻšāĻā§āĻā§ __
āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰā§āϰ āĻĒā§āϰāĻĨāĻŽ āĻĒā§āϰā§āĻā§āϰāĻžāĻŽ āϰāĻāϝāĻŧāĻŋāϤāĻžāϰ āύāĻžāĻŽ__
= Sum (*5″. 15, TRUE) == _
Microsoft Power Point __ Software Package
Page break āĻāϰāĻžāϰ āĻā§- āĻŦā§āϰā§āĻĄ āĻāĻŽāĻžāύā§āĻĄ _
ROM āĻāĻāĻāĻŋ āĻŽā§āĻŽā§āϰāĻŋ _
A4 āĻāĻžāĻāĻā§āϰ āϏāĻžāĻāĻ __
Recycle bin-āĻ āĻĢāĻžāĻāϞ āĻāĻŽāĻž āĻĨāĻžāĻā§ __
NIC āĻāϰ āĻĒā§āϰā§āĻŖāύāĻžāĻŽ __
āĻāĻāĻāĻŋ āĻāĻŋāĻ āĻŋ āĻŦāĻŋāĻāĻŋāύā§āύ āĻ āĻŋāĻāĻžāύāĻžāϝāĻŧ āĻĒā§āϰā§āϰāĻŖā§āϰ āĻāύā§āϝ__ āĻŦā§āϝāĻŦāĻšā§āϤ
āϏāϤā§āϝ āĻŽāĻŋāĻĨā§āϝāĻž āϞā§āĻāĻ
Office program āĻāϰ āĻĄāĻžāĻāĻž My Computer-āĻ Save āĻšāϝāĻŧāĨ¤
Software āĻšāĻā§āĻā§ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰā§āϰ āĻāĻāĻāĻŋ āĻĒā§āϰāĻā§āϰāĻŋāϝāĻŧāĻžāĻāϰāĻŖ āĻ āĻāĻļāĨ¤
Copy āĻāϰāĻžāϰ āĻā§-āĻŦā§āϰā§āĻĄ āĻāĻŽāĻžāύā§āĻĄ Ctrl + X
āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰā§āϰ āĻāĻžāĻāϰāĻžāϏ āĻāĻāĻāĻŋ āĻĒā§āϰā§āĻā§āϰāĻžāĻŽ āĨ¤
Ms Word-āĻ āĻŦāĻžāύāĻžāύ āĻļā§āĻĻā§āϧ āĻāϰāĻžāϰ āĻāύā§āϝ Spell Checker āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧāĨ¤
My Access āĻāϰ āĻā§āώā§āϤā§āϰ⧠āĻā§āϝāĻŧā§āϰāĻŋ ā§Ģ (āĻĒāĻžāĻāĻ) āĻĒā§āϰāĻāĻžāϰāĨ¤
(ā§§ā§Ļā§Ļā§§)2 āϏāĻāĻā§āϝāĻžāĻāĻŋāĻā§ āĻĻāĻļāĻŽāĻŋāĻ āϏāĻāĻā§āϝāĻžāϝāĻŧ āĻĒā§āϰāĻāĻžāĻļ āĻāϰāϞ⧠⧧⧧ āĻšāϝāĻŧāĨ¤
āĻĒā§āϰāĻĨāĻŽ āĻŦāĻžāĻŖāĻŋāĻā§āϝāĻŋāĻ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰā§āϰ āύāĻžāĻŽ UNIVAC
Form āĻāϰ āĻāĻžāĻ āĻšāϞ⧠āϰā§āĻāϰā§āĻĄāĻā§āϞ⧠āϏāĻžāĻāĻžāύā§āĨ¤
Google āĻāĻāĻāĻŋ Internet āϏāĻžāϰā§āĻ āĻāĻā§āĻāĻŋāύāĨ¤
āĻ āϤāĻŋ āϏāĻāĻā§āώā§āĻĒā§ āĻāϤā§āϤāϰ āĻĻāĻžāĻ :
āĻĻā§āĻāĻŋ Spreadsheet package āĻāϰ āύāĻžāĻŽ āϞā§āĻāĨ¤
āĻšāĻžāĻāĻĒāĻžāϰ āϞāĻŋāĻā§āĻ āĻŦāϞāϤ⧠āĻā§ āĻŦā§āĻāĻžāϝāĻŧ?
Function āĻā§?
āĻāϧā§āύāĻŋāĻ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰā§āϰ āĻāύāĻ āĻā§?
Mall Merge āĻā§?
Column Break āĻāϰāĻžāϰ āĻāύā§āϝ āĻā§-āĻŦā§āϰā§āĻĄ āĻĨā§āĻā§ āĻĒā§āϰāĻĻāϤā§āϤ āĻāĻŽāĻžāύā§āĻĄ āĻā§?
Marks-Field āĻāϰ Data type āĻā§?
āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āĻā§?
āĻĻā§āĻāĻŋ Network operating systems āĻāϰ āύāĻžāĻŽ āϞā§āĻāĨ¤
Row/Column Auto Fit āĻā§āύ āĻāϰāĻž āĻšāϝāĻŧ?
Fill in the blanks with appropriate preposition :
I would like — appear the final examination.
You have to do well to get merchandising ——- training Institute.
I do feel you- honestly.
Steel is made __ iron, sils
She was lying â my bed
Translate into English:
āĻāĻŽāĻŋ āĻŽāĻžāϰā§āĻā§āύā§āĻĄāĻžāĻāĻāĻŋāĻ āĻā§āϰā§āĻĄā§āϰ āĻāĻāĻāύ āĻāĻžāϤā§āϰāĨ¤
āϏā§āϰā§āϝ āĻĒā§āϰā§āĻŦāĻĻāĻŋāĻā§ āĻāĻ ā§āĨ¤
āĻāĻŽāĻžāϰ āĻŦāĻžāĻŦāĻž āĻāĻāĻāύ āĻāϰā§āĻŦ āϞā§āĻāĨ¤
āĻāĻŽāĻŋ āĻāĻāĻāĻŋ āĻāĻžāϰā§āĻŽā§āύā§āĻāϏ-āĻ āĻāĻžāĻāϰāĻŋ āĻāϰāĻŋāĨ¤
āĻāĻŽāĻŋ āĻŦāĻžāĻĄāĻŧāĻŋ āϝāĻžāĻŦāĨ¤
* āϏāĻ āĻŋāĻ āĻāϤā§āϤāϰāĻāĻŋāϤ⧠āĻāĻŋāĻ (V) āĻāĻŋāĻšā§āύ āĻĻāĻžāĻ āĨ¤
MS word-āĻ āĻŦāĻžāύāĻžāύ āĻļā§āĻĻā§āϧ āĻāϰāĻžāϰ āĻāύā§āϝ āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāϝāĻŧāĻžāϰāĻĻ
(āĻ) Edit (āĻ) Format (āĻ)Spelling checker (āĻ) Print
āĻā§āύāĻāĻŋ Optical device?(āĻ) CD (āĻ) Pen drive (āĻ) FDD(āĻ) HDD
Document āύāĻžāĻŽ āĻŦāĻĻāϞāĻŋāϝāĻŧā§ Save āĻāϰāĻžāϰ āĻāύā§āϝ āĻŦā§āϝāĻŦāĻšā§āϤ
(āĻ) Save (āĻ) Save new (āĻ) Save as (āĻ) Save old
āĻāĻŋāύā§āύ āĻāĻŋāύā§āύ āĻŽāĻžāύā§āϰ Data store āĻāϰāĻžāϰ āĻāύā§āϝ āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧ
āĻ. Hot key āĻ. Primary key āĻ. Secondary key āĻ. Key
āĻā§āύāĻāĻŋ Logical Functfon?
āĻ. = IF () āĻ. = SUM()āĻ. AVG () āĻ. MOD ()
ā§ŦāĨ¤ MS Word-āĻāϰ Table āĻ
āĻ, āĻļā§āϧ⧠Raw āĻŦāĻžāĻĄāĻŧāĻžāύ⧠āϝāĻžāϝāĻŧ āĻ, āĻļā§āϧ⧠āĻāϞāĻžāĻŽ āĻŦāĻžāĻĄāĻŧāĻžāύ⧠āϝāĻžāϝāĻŧ āĻ. āĻāĻāϝāĻŧāĻ āĻŦāĻžāĻĄāĻŧāĻžāύ⧠āϝāĻžāϝāĻŧ āĻ. āĻā§āύāĻāĻŋāĻ āĻŦāĻžāĻĄāĻŧāĻžāύ⧠āϝāĻžāϝāĻŧ āύāĻž
MS-Access-āĻ Data entry āĻāϰāĻžāϰ āĻāύā§āϝ āĻŽā§āϞāϤ āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧ- āĻ. Query āĻ. Macro āĻ. Report āĻ, Form
āĻāĻ āϏā§āĻĨāĻžāύā§āϰ āϞā§āĻāĻž āĻŽā§āĻā§ āĻ āύā§āϝ āϏā§āĻĨāĻžāύ⧠āύāĻŋāϤ⧠āĻšāϞ⧠āĻāϰāϤ⧠āĻšāĻŦā§-
āĻ. Cut-paste āĻ. Copy-paste āĻ. Delete-paste āĻ. Copy
Presentation Package āĻā§āύāĻāĻŋ?
āĻ. Front page āĻ. Oracle āĻ. Outlook āĻ. Power Point
Excel-āĻ āĻāĻāĻžāϧāĻŋāĻ Cell āĻāĻāϤā§āϰāĻŋāϤ āĻāϰāĻžāĻā§ āĻŦāϞā§
āĻ. Add āĻ. Join āĻ. Merge āĻ. Union
āϏāĻ āĻŋāĻ āĻļāĻŦā§āĻĻ āĻĻāĻŋāϝāĻŧā§ āĻļā§āύā§āϝāϏā§āĻĨāĻžāύ āĻĒā§āϰāĻŖ āĻāϰ
āĻšāĻžāϰā§āĻĄ āĻĄāĻŋāϏā§āĻ āĻšāϞ āĻāĻāĻāĻŋ__ āĻĄāĻŋāĻāĻžāĻāϏ
MS Excel āĻāϰ āĻĒā§āϰāϤāĻŋāĻāĻŋ āĻāϝāĻŧāĻžāϰā§āĻāĻļā§āĻā§ __āĻāĻŋ Row āĻāĻā§āĨ¤
Data base (MS Access) āĻĢāĻžāĻāϞā§āϰ āĻāĻā§āϏāĻā§āύāĻļāύ āĻšāϞ__
Record āĻšāϞ āĻāϤāĻāĻā§āϞ⧠âāĻāϰ āϏāĻŽāώā§āĻāĻŋāĨ¤
OMR āĻāϰ āĻĒā§āϰā§āĻŖāύāĻžāĻŽ āĻšāϞ â
Accounting āĻāĻžāĻā§ āĻŽā§āϞāϤ â āĻĒā§āϝāĻžāĻā§āĻ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻž āĻšāϝāĻŧāĨ¤
Pen drive āϏāĻāϝā§āĻā§āϤ āĻāϰāĻžāϰ āĻāύā§āϝ â Port āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻž
1 GB=__ MB
Mouse āĻāĻāĻāĻŋ āĻāύāĻĒā§āϰāĻŋāϝāĻŧ___ āϝāύā§āϤā§āϰāĨ¤
āĻāĻāĻ āĻāĻŋāĻ āĻŋ āĻāĻāĻžāϧāĻŋāĻ āύāĻžāĻŽā§āϰ āĻ āĻŋāĻāĻžāύāĻžāϝāĻŧ āĻĒā§āϰā§āϰāĻŖā§āϰ āĻāύā§āϝ Ms Word___āĻ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰāĻž āĻšāϝāĻŧāĨ¤
*āϏāϤā§āϝ āĻšāϞ⧠āϏâ āĻāĻŦāĻ āĻŽāĻŋāĻĨā§āϝāĻž āĻšāϞ⧠āĻŽāĻŋ’ āϞā§āĻāĻ
MS word-āĻ āϏāĻŽāĻžāϰā§āĻĨāĻ āĻļāĻŦā§āĻĻ āĻŦā§āϰ āĻāϰāĻžāϰ āĻāύā§āϝ Find āĻāĻŽāĻžāύā§āĻĄ āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧāĨ¤
G5 āĻšāϤ⧠K5 āĻĒāϰā§āϝāύā§āϤ āϝā§āĻ āĻāϰāĻžāϰ āĻĢāĻžāĻāĻļāύ āĻšāϞ =SUM(G5:K5)
Front page āĻāϝāĻŧā§āĻ Page āϤā§āϰāĻŋāϰ āĻāύā§āϝ āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧāĨ¤
$B$20 āĻāĻāĻāĻŋ āĻ ā§āϝāĻžāϏāĻŋāϞā§āĻ āĻ ā§āϝāĻžāĻĄā§āϰā§āϏāĨ¤
a4 ‘ āϞā§āĻāĻžāϰ āĻāύā§āϝ Subscript āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧāĨ¤
āĻā§āύ⧠Folder-āĻ File āĻ Folder āĻāĻāϝāĻŧāĻ āĻĨāĻžāĻāϤ⧠āĻĒāĻžāϰā§āĨ¤
Database-āĻ āĻā§āύ āĻāĻŋāĻā§ āĻāĻžāĻĒāĻžāύā§āϰ āĻāύā§āϝ Report āϤā§āϰāĻŋ āĻāϰāϤ⧠āĻšāϝāĻŧāĨ¤’
Bijoy āĻāĻāĻāĻŋ āĻŦāĻžāĻāϞāĻž āĻĢāύā§āĻā§āϰ āύāĻžāĻŽāĨ¤
āĻŦāĻžāĻāϞāĻž-āĻāĻāϰā§āĻāĻŋ Keyboard āĻĒāϰāĻŋāĻŦāϰā§āϤāύā§āϰ āĻāύā§āϝ āĻāĻŽāĻžāύā§āĻĄ Ctrl+Alt+B1
Header/Footer margin āĻāϰ āĻŦāĻžāĻāϰ⧠āĻāĻžāĻĒāĻž āĻšāϝāĻŧāĨ¤
āĻ āϤāĻŋ āϏāĻāĻā§āώā§āĻĒā§ āĻāϤā§āϤāϰ āĻĻāĻžāĻ
Macro āĻāĻŋ ?
Excel-āĻ āĻāĻŋāĻšā§āύ āĻāĻāύ āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧ?
Data base-āĻ āĻāĻŦāĻŋ āĻā§āύ āϧāϰāύā§āϰ Data?
Equation editor ?
Windows XP āĻā§ āĻāĻžāĻā§ āĻŦā§āϝāĻŦāĻšā§āϤ āĻšāϝāĻŧ?
Recycle bin āĻāϰ āĻŦā§āϝāĻŦāĻšāĻžāϰ āϞā§āĻāĨ¤
Ctrl+Z āĻāĻŽāĻžāύā§āĻĄā§āϰ āĻāĻžāĻ āϞāĻŋāĻ ?
Excel-āĻ āĻā§āύ Cell āĻāϰ Address-āĻ āĻā§ āĻā§ āĻŦā§āϝāĻŦāĻšā§āϤ?
Query āĻāĻāύ āĻĒā§āϰāϝāĻŧā§āĻāύ āĻšāϝāĻŧ?
WWW-āĻāϰ āĻĒā§āϰā§āĻŖāύāĻžāĻŽ āϞā§āĻāĨ¤
Fill in the blanks and complete the paragraph using the clues given below: (is, I’m, address, telephone number, is, I’m, old, is, years old, are, is)
My name __ Martin and__ a doctor. My__ is York Avenue, 23 and my__â+ 4423517534,___ 40 years and I’m married. My son, Peter,___ tenMy wife, Linda, is American. She___a lawyer.
*Choose the correct word or phrase to complete the questions:
How__ money do you have in your pocket?
(a) Many (b) few (c) much (d) some
Did you go__mosque last friday?
(a) at (b) in (c) to (d) on
What___ in your free time?
(a) you do (b) do you do (c) are you doing
Where __you born?
(a) are (b) were (c) was
__ do you do?
(a) Who (b) What (c) How
* āϏāĻ āĻŋāĻ āĻāϤā§āϤāϰāĻāĻŋāϤ⧠āĻāĻŋāĻ (v) āĻāĻŋāĻšā§āύ āĻĻāĻžāĻ āĨ¤
HDD āĻšāϞ
(āĻ)Hard Drive Disk (āĻ)Head Disk Drive (āĻ)Hard Disk Drive (āĻ)Header Disk Drive
CPU āĻšāϞ -(āĻ)Central Processing Unit (āĻ) Central Providing Unit (āĻ) Control Programming Unit (āĻ)Control Problem Unit
(ā§§ā§§)ā§§ā§Ļ āϏāĻāĻā§āϝāĻžāĻāĻŋāĻā§ āĻŦāĻžāĻāύāĻžāϰāĻŋ āϏāĻāĻā§āϝāĻžāϝāĻŧ āĻĒā§āϰāĻāĻžāĻļ āĻāϰāϞ⧠āĻāϤ āĻšāĻŦā§?
āĻ. (ā§§ā§Ļā§§ā§§)⧍ āĻ. (ā§Ļā§§ā§§ā§§ā§Ļ)⧍ āĻ. (ā§§ā§Ļā§§ā§Ļ)⧍ āĻ. (ā§§ā§§ā§Ļā§Ļ)⧍
Macro āĻā§? āĻ, āĻĒā§āϰā§āĻā§āϰāĻžāĻŽ āĻāĻžāώāĻžāϝāĻŧ āĻŦā§āϝāĻŦāĻšā§āϤ āĻŦāĻŋāĻāĻŋāύā§āύ āϧāϰāύā§āϰ āύāĻŋāϰā§āĻĻā§āĻļāύāĻž āĻ, āĻĢāĻžāϰā§āĻŽāĻāϝāĻŧā§āϝāĻžāϰ āĻ, āϏāĻĢāĻāĻāϝāĻŧā§āϝāĻžāϰ āĻ, āĻšāĻžāϰā§āĻĄāĻāϝāĻŧā§āϝāĻžāϰ
I have completed my quizzes practice.
Pingback: āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āĻā§āϰā§āϏ – āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āϏāϞāĻŋāĻāĻļāύ āĻāύā§āĻĄ āĻā§āϰā§āύāĻŋāĻ āϏā§āύā§āĻāĻžāϰ
Pingback: Computer Training Center Registration in Bangladesh: A Guide by Computer Solution and Training Center (CSTC) – āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āϏāϞāĻŋāĻāĻļāύ āĻāύā§āĻĄ āĻā§āϰā§āύāĻŋāĻ āϏā§āύā§āĻāĻžāϰ
Pingback: āĻāϝāĻŧ āĻŽāĻžāϏ āĻŽā§āϝāĻŧāĻžāĻĻā§ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āĻā§āϰā§āϏ āĻļāĻŋāĻāϤ⧠āĻāĻžāĻā§āĻā§āύ? – āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āϏāϞāĻŋāĻāĻļāύ āĻāύā§āĻĄ āĻā§āϰā§āύāĻŋāĻ āϏā§āύā§āĻāĻžāϰ
Pingback: āĻāϰ⧠āĻŦāϏā§āĻ āĻ āύāϞāĻžāĻāύ⧠āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āĻĒā§āϰāĻļāĻŋāĻā§āώāĻŖā§āϰ āϏā§āϝā§āĻ āĻĻāĻŋāĻā§āĻā§ āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āϏāϞāĻŋāĻāĻļāύ – āĻāĻŽā§āĻĒāĻŋāĻāĻāĻžāϰ āϏāϞāĻŋāĻāĻļāύ āĻāύā§