Full Course Excel MIS in One Shot | Excel MIS Tutorial in Just 3 Hours | Computer Tech Academy https://youtu.be/9wkc7BDnTwo
YouTube
Full Course Excel MIS in One Shot | Excel MIS Tutorial in Just 3 Hours | Computer Tech Academy
📝 Course Enquiry: 👉 https://forms.gle/9oCgiEvqWdxNk2FP9
Join WhatsApp Channel (Notes & PDF): https://whatsapp.com/channel/0029VbAya0OKwqSUcr2Z1i0U
📊 Full Course Excel MIS in One Shot | Excel MIS Tutorial in Just 3 Hours | Computer Tech Academy
Want to…
Join WhatsApp Channel (Notes & PDF): https://whatsapp.com/channel/0029VbAya0OKwqSUcr2Z1i0U
📊 Full Course Excel MIS in One Shot | Excel MIS Tutorial in Just 3 Hours | Computer Tech Academy
Want to…
❤2👍2
Join WhatsApp Channel (Notes & PDF): https://whatsapp.com/channel/0029VbAya0OKwqSUcr2Z1i0U
WhatsApp.com
Computer Tech Academy | WhatsApp Channel
Computer Tech Academy WhatsApp Channel. 💻 Welcome to Computer Tech Academy!
Your one-stop destination for learning Computer Basics, MS Office, Advanced Excel, Typing, CCC, and more — all in easy-to-understand language!
📚 What We Share:
✅ Free Video Tutorials…
Your one-stop destination for learning Computer Basics, MS Office, Advanced Excel, Typing, CCC, and more — all in easy-to-understand language!
📚 What We Share:
✅ Free Video Tutorials…
❤1
💻 Basic Windows Shortcut Keys:
Shortcut Key Function
Ctrl + C Copy
Ctrl + X Cut
Ctrl + V Paste
Ctrl + Z Undo
Ctrl + Y Redo
Ctrl + A Select All
Alt + Tab Switch between open apps
Alt + F4 Close current window
Windows + D Show desktop
Windows + L Lock computer
Shortcut Key Function
Ctrl + C Copy
Ctrl + X Cut
Ctrl + V Paste
Ctrl + Z Undo
Ctrl + Y Redo
Ctrl + A Select All
Alt + Tab Switch between open apps
Alt + F4 Close current window
Windows + D Show desktop
Windows + L Lock computer
❤2
📝 MS Word Shortcut Keys:
Shortcut Key Function
Ctrl + B Bold
Ctrl + I Italic
Ctrl + U Underline
Ctrl + P Print
Ctrl + S Save
Ctrl + N New document
Ctrl + F Find
Ctrl + H Replace
Ctrl + E Center align
Shortcut Key Function
Ctrl + B Bold
Ctrl + I Italic
Ctrl + U Underline
Ctrl + P Print
Ctrl + S Save
Ctrl + N New document
Ctrl + F Find
Ctrl + H Replace
Ctrl + E Center align
Join Our WhatsApp Channel:
https://whatsapp.com/channel/0029VbAya0OKwqSUcr2Z1i0U
📊 MS Excel Shortcut Keys:
Shortcut Key Function
Ctrl + T Create a table
Ctrl + ; Insert current date
Ctrl + Shift + "$" Apply currency format
Ctrl + Arrow Keys Navigate to data edges
Alt + = Auto sum
F2 Edit selected cell
Ctrl + Shift + L Add/remove filter
https://whatsapp.com/channel/0029VbAya0OKwqSUcr2Z1i0U
📊 MS Excel Shortcut Keys:
Shortcut Key Function
Ctrl + T Create a table
Ctrl + ; Insert current date
Ctrl + Shift + "$" Apply currency format
Ctrl + Arrow Keys Navigate to data edges
Alt + = Auto sum
F2 Edit selected cell
Ctrl + Shift + L Add/remove filter
WhatsApp.com
Computer Tech Academy | WhatsApp Channel
Computer Tech Academy WhatsApp Channel. 💻 Welcome to Computer Tech Academy!
Your one-stop destination for learning Computer Basics, MS Office, Advanced Excel, Typing, CCC, and more — all in easy-to-understand language!
📚 What We Share:
✅ Free Video Tutorials…
Your one-stop destination for learning Computer Basics, MS Office, Advanced Excel, Typing, CCC, and more — all in easy-to-understand language!
📚 What We Share:
✅ Free Video Tutorials…
❤1
🖥️ CorelDRAW Basic Questions & Answers
Q1. What is CorelDRAW?
Ans: CorelDRAW is a vector graphics design software developed by Corel Corporation. It is used for designing logos, brochures, banners, and other graphic elements.
Q2. What is the file extension of CorelDRAW files?
Ans: The default file extension is .CDR.
Q3. What is the difference between vector and raster images?
Ans:
Vector images are made of lines and curves, and can be resized without losing quality (e.g., in CorelDRAW).
Raster images are made of pixels and may lose quality when scaled (e.g., in Photoshop).
Q4. What is the use of the Pick Tool in CorelDRAW?
Ans: The Pick Tool is used to select, move, resize, or rotate objects in the workspace.
Q5. How can you insert text in CorelDRAW?
Ans: Use the Text Tool (F8), click on the workspace, and start typing.
Q6. Which tool is used to draw freehand shapes?
Ans: The Freehand Tool or Bezier Tool is used to draw free-form lines and shapes.
Q7. What is the shortcut key to group objects?
Ans: Ctrl + G is used to group selected objects.
Q8. How to export a file in CorelDRAW?
Ans: Go to File → Export (Ctrl + E) and choose the required format (e.g., JPG, PNG, PDF).
Q9. What is PowerClip in CorelDRAW?
Ans: PowerClip is a feature that allows you to place one object inside another (e.g., placing an image inside a shape).
Q10. What is the shortcut key to save a CorelDRAW file?
Ans: Ctrl + S
Q1. What is CorelDRAW?
Ans: CorelDRAW is a vector graphics design software developed by Corel Corporation. It is used for designing logos, brochures, banners, and other graphic elements.
Q2. What is the file extension of CorelDRAW files?
Ans: The default file extension is .CDR.
Q3. What is the difference between vector and raster images?
Ans:
Vector images are made of lines and curves, and can be resized without losing quality (e.g., in CorelDRAW).
Raster images are made of pixels and may lose quality when scaled (e.g., in Photoshop).
Q4. What is the use of the Pick Tool in CorelDRAW?
Ans: The Pick Tool is used to select, move, resize, or rotate objects in the workspace.
Q5. How can you insert text in CorelDRAW?
Ans: Use the Text Tool (F8), click on the workspace, and start typing.
Q6. Which tool is used to draw freehand shapes?
Ans: The Freehand Tool or Bezier Tool is used to draw free-form lines and shapes.
Q7. What is the shortcut key to group objects?
Ans: Ctrl + G is used to group selected objects.
Q8. How to export a file in CorelDRAW?
Ans: Go to File → Export (Ctrl + E) and choose the required format (e.g., JPG, PNG, PDF).
Q9. What is PowerClip in CorelDRAW?
Ans: PowerClip is a feature that allows you to place one object inside another (e.g., placing an image inside a shape).
Q10. What is the shortcut key to save a CorelDRAW file?
Ans: Ctrl + S
❤3
Which function is used to find the average of a range?
Anonymous Quiz
15%
=SUM()
8%
=MEAN()
75%
=AVERAGE()
2%
=COUNT()
❤3
📘 What is "Digital Financial Tools & Applications"?
Digital Financial Tools & Applications refer to electronic or online methods used to manage, access, and perform financial transactions without the need for physical cash or visits to a bank. These tools make banking, payments, and financial services faster, safer, and more convenient.
✅ Key Digital Financial Tools Covered:
💳 1. Credit Card / Debit Card
Credit Card: Allows you to borrow money from the bank up to a limit for purchases and pay later with interest.
Debit Card: Directly deducts money from your bank account when you make a payment.
Both are used for online and offline payments, ATMs, and POS transactions.
📱 2. Mobile Banking
Banking through a mobile app offered by your bank.
You can check balances, transfer funds, pay bills, request services, and more.
Examples: SBI YONO, HDFC MobileBanking, etc.
🌐 3. Internet Banking (Net Banking)
Banking via a web browser using your bank’s official website.
Offers services like fund transfers, account management, bill payments, fixed deposits, etc.
💸 4. UPI (Unified Payments Interface)
A real-time payment system developed by NPCI (India) that allows instant money transfers using a mobile number or UPI ID.
No need to share bank details—just use a UPI ID like yourname@upi.
Examples: Google Pay, PhonePe, Paytm, BHIM UPI.
🎯 Why Are Digital Financial Tools Important?
Instant access to money and banking services
Promote cashless economy
Convenient, secure, and user-friendly
Widely used in online shopping, bill payments, fund transfers, and more
Digital Financial Tools & Applications refer to electronic or online methods used to manage, access, and perform financial transactions without the need for physical cash or visits to a bank. These tools make banking, payments, and financial services faster, safer, and more convenient.
✅ Key Digital Financial Tools Covered:
💳 1. Credit Card / Debit Card
Credit Card: Allows you to borrow money from the bank up to a limit for purchases and pay later with interest.
Debit Card: Directly deducts money from your bank account when you make a payment.
Both are used for online and offline payments, ATMs, and POS transactions.
📱 2. Mobile Banking
Banking through a mobile app offered by your bank.
You can check balances, transfer funds, pay bills, request services, and more.
Examples: SBI YONO, HDFC MobileBanking, etc.
🌐 3. Internet Banking (Net Banking)
Banking via a web browser using your bank’s official website.
Offers services like fund transfers, account management, bill payments, fixed deposits, etc.
💸 4. UPI (Unified Payments Interface)
A real-time payment system developed by NPCI (India) that allows instant money transfers using a mobile number or UPI ID.
No need to share bank details—just use a UPI ID like yourname@upi.
Examples: Google Pay, PhonePe, Paytm, BHIM UPI.
🎯 Why Are Digital Financial Tools Important?
Instant access to money and banking services
Promote cashless economy
Convenient, secure, and user-friendly
Widely used in online shopping, bill payments, fund transfers, and more
❤2
CCC (Course on Computer Concepts) in One Shot | CCC Full Course NIELIT | Computer Tech Academy
📢 New Video Alert!
https://youtu.be/tJD88CjQ4p0
💻 CCC (Course on Computer Concepts) – Full Course in One Shot
🎯 Perfect for NIELIT CCC Exam Preparation
🎥 Complete Syllabus Covered | Easy Explanation | One Video for All Topics
✅ Basics of Computers
✅ MS Office (Word, Excel, PowerPoint)
✅ Internet & Email
✅ Digital Payments
✅ Cyber Security
...and more – Everything as per NIELIT CCC Exam Pattern
📍 Watch Now & Boost Your Preparation:
👉 https://youtu.be/tJD88CjQ4p0
🎓 Best for: Students | Govt Job Aspirants | Beginners in Computers
📌 Brought to you by Computer Tech Academy – Your Learning Partner for Tech & Exams!
#CCCExam #NIELITCCC #ComputerTechAcademy #CCCFullCourse #ComputerBasics #GovtJobPreparation #DigitalLiteracy
📢 New Video Alert!
https://youtu.be/tJD88CjQ4p0
💻 CCC (Course on Computer Concepts) – Full Course in One Shot
🎯 Perfect for NIELIT CCC Exam Preparation
🎥 Complete Syllabus Covered | Easy Explanation | One Video for All Topics
✅ Basics of Computers
✅ MS Office (Word, Excel, PowerPoint)
✅ Internet & Email
✅ Digital Payments
✅ Cyber Security
...and more – Everything as per NIELIT CCC Exam Pattern
📍 Watch Now & Boost Your Preparation:
👉 https://youtu.be/tJD88CjQ4p0
🎓 Best for: Students | Govt Job Aspirants | Beginners in Computers
📌 Brought to you by Computer Tech Academy – Your Learning Partner for Tech & Exams!
#CCCExam #NIELITCCC #ComputerTechAcademy #CCCFullCourse #ComputerBasics #GovtJobPreparation #DigitalLiteracy
❤3