Sample ICT Final 2024 Vesennyi

1. How do I apply formatting to cells containing numbers greater than 100?

• a) Use conditional formatting with the "Greater than" rule

• b) Format > Cells > Conditions > Greater than 100

• c) Insert > Formatting > Custom Condition

• d) Data > Filter > Custom Filter > More than 100

• e) Edit > Find and Select > Conditional Formatting

2. How do I filter the data in ascending order?

• a) Data > Sort and Filter > Sort in ascending order

• b) View > Filter > Ascending order

• c) Format > Filter > Ascending order

• d) Home > Edit > Filter > Ascending order

• e) Insert > Filter > Ascending order

3. What означает does the abbreviation SQL mean?

• a) Simple Query Language

• b) Structured Query Language

• c) Standard Query Language

• d) Sequential Query Language

• e) Simplified Query Language

4. How do I change the slide background?

• a) Design > Background Format

• b) Insert > Background

• c) Home > Background

• d) Development > Change Background

• e) Format > Slide Background

5. How do I automatically fill in a series of dates in Excel?

• a) Using Autocomplete

• b) Using the date formula

• c) Using a macro

• d) Using the 'SERIES ()' function

• e) Using the `DATEDIF()`function

6. How do I create a new PowerPoint presentation?

• a) File > Open

• b) File > New

• c) View > To create

• d) Tools > New presentation

• e) Format > New Presentation

7. What SQL statement is used to change data in the table?

• a) MODIFY

• b) ALTER

• c) CHANGE

• d) UPDATE

• e) EDIT

8. How do I add a new slide to my presentation?

• a) Home > New Slide

• b) Insert > Slide

• c) Design > Add Slide

• d) Develop > New Slide

• e) Format > Insert Slide

9. What command creates a new table in SQL?

• a) CREATE TABLE tableName;

• b) NEW TABLE tableName;

• c) TABLE CREATE tableName;

• d) MAKE TABLE tableName;

• e) BUILD TABLE tableName;

10. What formula can be used to calculate the arithmetic mean for the range A1:A10

• a) AVERAGE(A1:A10)

• b) MEDIAN(A1:A10)

• c) SUM(A1:A10)/COUNT(A1:A10)

• d) MEAN(A1:A10)

• e) TOTAL(A1:A10)