Flashcards IT Basics

Composants matériels fondamentaux

CPU

Question : What does CPU stand for?

Réponse : Central Processing Unit

Détail : The CPU is the main processor that executes program instructions.

RAM

Question : What does RAM stand for?

Réponse : Random Access Memory

Détail : RAM is the primary memory used for temporary data storage while programs run.

Fonctions et raccourcis Excel

Extraction de texte

Question : In Excel, the formula =LEFT(A1,3) returns the {{first three characters}} of the text in A1.

Réponse : first three characters

Valeur maximale

Question : What result does the Excel function =MAX(12,3,9,15,8) return?

Réponse : 15

Détail : MAX returns the largest number among its arguments.

Fonction conditionnelle imbriquée

Question : What does the Excel formula =IF(F4=10,"Xuất sắc",IF(F4>8,"Giỏi",IF(F4>6.5,"Khá","Trung bình"))) return when F4 = 8?

Réponse : Trung bình

Détail : Since F4 is not >8 nor >6.5, the final else condition "Trung bình" is returned.

Comptage avec critères multiples

Question : What is the purpose of the Excel function COUNTIFS?

Réponse : Counts cells that meet multiple criteria

Détail : COUNTIFS returns the number of cells that satisfy all given conditions.

Références absolues vs relatives

Question : Difference between absolute and relative cell references in Excel?

Réponse : Absolute → fixed row/column | Relative → adjusts when copied

Détail : Absolute references use $ (e.g., $A$1) to lock row and column; relative references change based on position.

Raccourci de référence absolue

Question : Which shortcut toggles absolute reference mode while editing a formula in Excel?

Réponse : F4

Détail : Pressing F4 cycles through relative, absolute, and mixed references.

PowerPoint : raccourcis et paramètres

Ajout d'une diapositive

Question : What shortcut adds a new slide in PowerPoint?

Réponse : Ctrl + M

Détail : Ctrl+M inserts a new slide after the current one.

Onglet des transitions

Question : Which PowerPoint tab contains the Transition timing settings?

Réponse : Transitions

Détail : The Transitions tab includes options for automatic slide advance and duration.

Extension de fichier PowerPoint 2010

Question : What is the file extension for PowerPoint 2010 presentations?

Réponse : PPTX

Détail : PPTX is the default format for PowerPoint 2007 and later.

Word : fonctions et raccourcis

Modification de casse

Question : What shortcut changes selected text to uppercase or lowercase in Word?

Réponse : Shift + F3

Détail : Pressing Shift+F3 cycles through UPPERCASE, lowercase, and Capitalized case.

Insertion d'un tableau

Question : How do you insert a table in Word?

Réponse : Insert \ Table \ Insert Table

Détail : Use the Insert tab, select Table, then choose Insert Table.

Annuler et refaire

Question : The shortcut Ctrl + Z in Word redoes the last action.

Réponse : Faux

Détail : Ctrl+Z undoes the last action; redo is Ctrl+Y.

Réseaux et systèmes d'exploitation

Appareil de connexion réseau

Question : Which device is used to connect a computer to a network?

Réponse : Router

Détail : A router directs data between networks and provides internet access.

Définition d'un système d'exploitation

Question : Define an operating system.

Réponse : Software that manages hardware and software resources

Détail : It provides a platform for applications and controls device operations.

Routeur vs commutateur

Question : Difference between a router and a switch?

Réponse : Router → connects different networks | Switch → connects devices within same network

Détail : Routers route traffic between networks and assign IP addresses; switches forward frames within a LAN.

Facteurs de lenteur de téléchargement

Question : File có dung lượng lớn là nguyên nhân duy nhất gây chậm tải file từ internet.

Réponse : Faux

Détail : Other factors like low bandwidth and overloaded servers also cause slow downloads.