← Back to quizzesFree quiz

Kiến thức cơ bản về CNTT và phần mềm

Welcome to this comprehensive course that covers the essential concepts of computer hardware, operating‑system shortcuts, and basic office‑suite functions. Whether you are a beginner looking…

10 questions~5 min
Kiến thức cơ bản về CNTT và phần mềm — Qwi
0 / 10
Score: 0%
1

Bộ nhớ nào dùng để lưu trữ chương trình và dữ liệu trước khi CPU xử lý?

2

RAM là viết tắt của cụm từ nào?

3

Khi máy tính bị treo, tổ hợp phím nào dùng để khởi động lại từ bàn phím?

4

Trong Windows, tổ hợp phím nào mở cửa sổ Explorer?

5

Địa chỉ ô $A$1 trong Excel là loại địa chỉ nào?

6

Khi nhập công thức =VALUE(A2) trong Excel, kết quả trả về là gì nếu A2 chứa chuỗi "2016"?

7

Trong PowerPoint, phím F12 thực hiện chức năng nào?

8

HTML là viết tắt của cụm từ nào?

9

Giao thức nào cho phép duyệt web an toàn trên Internet?

10

Trong Excel, hàm COUNTA có chức năng gì?

Fundamental Computer Science and Software Knowledge

Welcome to this comprehensive course that covers the essential concepts of computer hardware, operating‑system shortcuts, and basic office‑suite functions. Whether you are a beginner looking to solidify your foundation or a seasoned user needing a quick refresher, this guide is structured to help you master the core ideas that appear in many introductory quizzes.

1. Understanding Primary Memory: RAM vs. Other Storage Types

Random Access Memory (RAM) is the volatile memory that temporarily holds programs and data while the CPU processes them. Unlike permanent storage devices such as ROM, SSD, and HDD, RAM loses its content when power is removed, which is why it is often described as “working memory.”

  • ROM (Read‑Only Memory): Stores firmware and boot instructions; data is mostly immutable.
  • SSD (Solid‑State Drive): Uses flash memory for fast, non‑volatile storage; no moving parts.
  • HDD (Hard Disk Drive): Relies on magnetic platters and a moving read/write head; slower than SSD but offers large capacities at lower cost.
  • RAM: Provides rapid read/write access for active applications; essential for multitasking and performance.

When a computer runs a program, the operating system copies the executable code from permanent storage (SSD/HDD) into RAM. The CPU then fetches instructions directly from RAM because it can access any memory cell in constant time, which is why the phrase “random access” is used.

2. Decoding the Acronym RAM

The full form of RAM is Random Access Memory. This name highlights two key characteristics:

  • Random: Any memory location can be accessed directly without sequential scanning.
  • Access: Both read and write operations are possible, enabling dynamic data manipulation.
  • Memory: It temporarily stores data needed by the CPU.

Understanding this terminology helps you differentiate RAM from other memory types and explains why increasing RAM often improves overall system responsiveness.

3. Keyboard Shortcuts for System Control

Keyboard shortcuts are essential for efficient navigation and troubleshooting. Two common shortcuts appear in many quizzes:

  • Ctrl + Alt + Del: Triggers the Windows security screen, allowing you to lock the computer, switch users, open Task Manager, or restart the system when it becomes unresponsive.
  • Windows + E: Instantly opens the File Explorer window, giving you quick access to files, drives, and network locations.

These shortcuts are built into the operating system, so they work regardless of the active application. Memorizing them can save valuable time and reduce frustration during a system freeze.

4. Navigating Windows Explorer

Windows Explorer (or File Explorer) is the graphical interface for browsing files and folders. The Windows + E shortcut is the fastest way to launch it. Once opened, you can:

  • Browse drives (C:, D:, etc.) and network shares.
  • Search for files using the search bar.
  • Access quick‑access shortcuts like “Documents,” “Downloads,” and “Recent files.”

Understanding Explorer’s layout helps you manage storage, organize documents, and troubleshoot missing files.

5. Excel Cell Referencing: Absolute vs. Relative

Excel uses three main types of cell references:

  • Relative reference (e.g., A1): Adjusts automatically when copied to another cell.
  • Absolute reference (e.g., $A$1): Remains fixed regardless of where the formula is moved or copied.
  • Mixed reference (e.g., $A1 or A$1): Locks either the column or the row.

The address $A$1 is an absolute reference. It is commonly used when a formula must always refer to a constant value, such as a tax rate or a fixed multiplier.

6. Using the VALUE Function in Excel

The =VALUE(A2) function converts a text string that looks like a number into an actual numeric value. For example, if cell A2 contains the string "2016", the function returns the number 2016 (type: number), enabling arithmetic operations like addition or multiplication.

Key points about VALUE:

  • It strips formatting and returns a pure number.
  • If the text cannot be interpreted as a number, Excel returns #VALUE!.
  • It is useful when importing data from external sources that store numbers as text.

7. PowerPoint Shortcut: Saving a Presentation

In Microsoft PowerPoint, pressing F12 opens the Save As dialog, allowing you to specify a new file name or location. This shortcut is part of the broader set of function‑key shortcuts that streamline presentation editing:

  • F5: Start the slideshow from the beginning.
  • Shift + F5: Start the slideshow from the current slide.
  • Ctrl + M: Insert a new slide.

Knowing F12 helps you quickly create backup copies or export your work in different formats (e.g., PDF, video).

8. HTML: The Language of the Web

HTML stands for Hyper Text Markup Language. It is the foundational markup language used to structure content on the World Wide Web. HTML elements are defined by tags such as <h2>, <p>, and <ul>. These tags tell browsers how to display text, images, links, and other media.

Key concepts:

  • Elements consist of opening and closing tags with optional attributes.
  • Semantic markup (e.g., <header>, <article>) improves accessibility and SEO.
  • Responsive design often combines HTML with CSS and JavaScript to adapt layouts to different devices.

Understanding the full form of HTML is the first step toward learning how web pages are built and how search engines interpret content for ranking.

9. Putting It All Together: Study Tips for Quiz Success

To retain the information covered in this course, consider the following strategies:

  • Active recall: Test yourself by writing the definition of each term without looking at notes.
  • Flashcards: Create a card for each shortcut (e.g., "Ctrl + Alt + Del" on one side, "opens security screen" on the other).
  • Practical application: Open your computer and try each shortcut, observe RAM usage in Task Manager, and experiment with Excel formulas.
  • Teach back: Explain the concepts to a peer or record a short video tutorial; teaching reinforces learning.

By integrating theory with hands‑on practice, you will solidify your understanding of basic IT and software concepts, ensuring you can answer quiz questions confidently and apply the knowledge in real‑world scenarios.