2_Ôn Tập Lý Thuyết Nghề Thvp

The given answer states that one of the signs of a computer being infected with a virus is that the programs run slowly or do not run at all. This is a common symptom of a virus infection as viruses can consume a significant amount of system resources, causing the computer to slow down or crash. Therefore, if the programs on a computer are running slowly or not running at all, it is a strong indication that the computer may be infected with a virus.

To insert special characters at the mouse cursor position, the correct menu command to use is "Insert / Symbol...". This command allows the user to choose from a list of special characters and insert them into the document at the desired location. The other menu commands listed, such as "Insert / TextBox...", "Insert / Picture...", and "Insert / File...", do not specifically deal with inserting special characters at the mouse cursor position.

The programs Microsoft Security Essentials, BKAV, and Norton AntiVirus are all antivirus programs. These programs are designed to scan and protect a computer from viruses and other malicious software.

The file extensions *.bmp and *.jpg are commonly used for image files. The other file extensions mentioned in the options are used for audio and video files, not image files.

To open an existing file in Word, the correct keyboard shortcut is Ctrl+O. This shortcut allows the user to quickly access the Open File dialog box, where they can browse and select the file they want to open. Ctrl+S is used to save a document, Ctrl+N is used to create a new document, and Ctrl+P is used to print a document.

The correct answer is "View / Full Screen" because selecting this option will display the document in full screen mode, maximizing the use of the screen and removing any distractions such as toolbars or menus. This is useful when you want to focus solely on the content of the document without any other visual elements. The other options listed are different viewing modes, but they do not specifically address the need for a full screen display.

The function Data/Filter/Advance Filter is used to extract or filter data based on specific conditions. It allows users to specify criteria and extract only the data that meets those criteria. This helps in narrowing down the dataset and retrieving only the relevant information. This function is commonly used in data analysis and reporting tasks to filter out unnecessary data and focus on specific subsets of data.

To select all objects in the current Folder window in Windows Explorer, you can press the Ctrl + A combination of keys.

The correct answer is "Hàm Upper". In Excel, the "Hàm Upper" function is used to convert lowercase letters to uppercase letters.

In Excel, to extract data, we use the "Data/Filter" option. This option allows us to filter and display specific data based on certain criteria. It helps in analyzing and organizing large amounts of data by showing only the relevant information.

The correct answer is "menu lệnh Format / Sheet / Rename." This is because in Excel, to change the name of a sheet, we need to go to the Format menu, then select Sheet, and finally choose Rename.

To sort files in the folder window of Windows Explorer by size, you would use the menu command "View / Arrange icons by / Size." This option allows you to arrange the icons based on the file size, from the smallest to the largest or vice versa. By selecting this option, the files will be organized in ascending or descending order according to their respective sizes.

The formula =VALUE(RIGHT(C1,3))>0 in cell C2 is used to extract the last 3 characters from the string in cell C1 and convert it into a numerical value. If the numerical value is greater than 0, the formula will return TRUE. Therefore, the data in cell C2 will be TRUE.

To frame the selected text in Word, the correct menu command to use is "Format / Borders and Shading…". This option allows the user to apply borders and shading to the selected text, providing a visually appealing frame around it. The other options mentioned, "Format / Borders…" and "View / Borders and Shading…" are not the correct commands for this specific task.

Pressing Ctrl + A is the shortcut to select all the text on the screen. This action will highlight and select the entire text in the document or window, allowing the user to perform various operations such as copying, cutting, or deleting the selected text.

To bring the first character of a paragraph down into a larger font size, the correct menu command to use is "Format / DropCap". This option allows for the customization of the appearance of the initial character in a paragraph, making it stand out and catch the reader's attention. The other menu commands listed do not specifically address the task of creating a drop cap effect.

To adjust the width of a selected column in Excel, you can go to the menu command Format, then Column, and finally Width. This option allows you to manually set the width of the selected column to a specific value.

The correct answer is "Tất cả đểu đúng" (All are correct). The question is asking how to save a new file in Excel. The options provided are:
- Go to the File menu and select Save.
- Go to the File menu and press Save As.
- Press the Ctrl - S key combination.
All of these options are correct ways to save a new file in Excel.

In Excel, the formula syntax for the IF function is "IF(logical_test, value_if_true, value_if_false)". When the logical_test evaluates to TRUE, the value_if_true is returned. In this case, if we enter TRUE in cell D10, it will evaluate to TRUE and the result will be in the middle position of the cell.

Pressing Ctrl+Alt+Del is used to bring up the Windows Task Manager.

The question is asking where the result will be located in cell D101 in Excel if the value 0100 is entered. In Excel, leading zeros are typically ignored, so the value 0100 would be treated as 100. Therefore, the result would be located to the right of the cell D101.

The formula in cell F10 is =SUMIF(A2:A7,"11A1",C2:C7), which means it will sum the values in the range C2:C7 if the corresponding value in range A2:A7 is equal to "11A1". In the given data, there is only one cell (A6) that matches the criteria "11A1". The corresponding value in C6 is 16. Therefore, the result of the formula in F10 is 16.

The given answer is "Biên phải đoạn văn bản" which translates to "Right margin of the paragraph". This is because the symbol shown in the image is used to adjust the right margin of the paragraph, indicating the end point of the text on the right side.

To create a new folder in Windows Explorer, you would navigate to the "File" menu and select "New", then choose "Folder" from the options. This option allows you to create a new directory to organize your files and documents.

To open the window displaying the contents of a drive in My Computer, you need to double click on the drive icon. This action will open a new window showing the files and folders stored on that drive.

To change the measurement units on the ruler from centimeters to inches, you need to go to the Tools/Options menu, select the General tab, and then choose Inches as the Measurement Units.

The given Excel formula is using the IF function with the OR function nested inside it. The OR function checks if either of the two conditions is true: 3=2 and 1=1. Since the second condition is true, the overall result of the OR function is true. As a result, the IF function returns the value "True". Therefore, the correct answer is "True".

The correct answer is "chuỗi 123456789" because the given formula "=C1&C2&C3" concatenates the values in cells C1, C2, and C3. Therefore, it combines the values 123, 456, and 789 to form the string "123456789".

To enable or disable the display of rulers, the correct option is "View/Ruler". The rulers in a document provide a visual reference for measuring and aligning objects or elements within the document. By selecting this option from the View menu, users can toggle the visibility of rulers on or off, depending on their preference or specific needs for working on the document. This option does not affect other aspects of the document's display, such as toolbars, full screen mode, or header and footer visibility.

To select the entire worksheet in Excel, you need to click on the intersection cell between the column headers and row headers.

The correct answer is stating that a folder is an object that can contain other objects. This means that a folder can hold files as well as other folders within it. This statement is true as folders are commonly used to organize and store various files and subfolders within a computer system.

The correct answer is 7 because the COUNTA function counts the number of cells in a range that are not empty. In this case, the range A1:A8 contains 7 non-empty cells, so the result is 7.

The ROUND function in Excel is used to round a number to a specified number of digits. In this case, the function ROUND(D1, -2) is rounding the value in cell D1 to the nearest hundred. The value in cell D1 is 1758.4963, so rounding it to the nearest hundred would result in 1800. Therefore, the correct answer is 1800.

The formula =RANK(A1,A1:A4,1) is used to determine the rank of a value in a given range. In this case, the value in cell A1 is 7.0 and the range A1:A4 contains the values 7.0, 7.5, 9.1, and 6.5. The formula will rank the value in A1 compared to the values in the range A1:A4 in descending order. Since 7.0 is the second highest value in the range, the rank of 7.0 will be 2.

The correct answer is Windows 2000, Windows XP, Windows 7. This is because Windows 2000 was released before Windows XP, and Windows XP was released before Windows 7.

In Word, to move the cursor to the beginning of the document, the correct key combination is Ctrl + Home. This key combination allows the user to quickly navigate to the start of the document without having to scroll or manually move the cursor using the arrow keys.

To delete the current sheet in Excel, you need to go to the "Edit" menu and select the "Delete Sheet" option. This option allows you to remove the currently active sheet from the workbook. The other options mentioned (File, Delete Sheet and Format, Delete Sheet) are not correct as they do not correspond to the actual steps required to delete a sheet in Excel.

To select consecutive objects in Windows Explorer, you need to click on the first file, hold down the SHIFT key, and then click on the last file.

The correct answer is Ctrl + J. This keyboard shortcut is used to justify both sides of a selected text in a document. By pressing Ctrl + J, the text will be aligned evenly on both the left and right margins, creating a clean and professional appearance.

The fonts Tahoma and Arial are able to display Vietnamese characters with diacritics correctly.