Question 1 Fill in the blanks:
Len, Count, pie chart, time, cloud, MS Excel, Concat, line chart, design, today
1. The _____________ function returns the number of cells that contains
number.
2. The function NOW returns the system’s date as well as the________________.
3. ______________is a versatile spreadsheet software developed by Microsoft,
used globally for organizing data and performing financial analysis.
4. The function that retunes the computer date is called _________________.
5. The ____________ function combines two or more text cells.
6. The ____________ returns the number of characters in a text cell
7. We use ______________ when we want to show percentages or parts of
something compared to the total.
8. We use ______________ when you want to your data in an attractive way.
9. We use the ________________ tab to change your chart and make it fancier.
10. Google Drive is a ____________based storage.
Question 2 Answer (T) or (F) for the following statements:
1- The most popular search engine is Google ( ).
2- I should ask for permission first before downloading anything on my PC ( ).
3- OneDrive allows you to create and share folders with your friends ( ).
4- You don’t need a Microsoft Account in order to work with OneDrive ( ).
5- I can use the same Password everywhere ( ).
6- When writing a blog, safety first ( ).
7- We can share our real name when we are online ( )
Question 3 Match the terms from column A accordingly to column B:
A
1
B
2
Question 4 Match shortcut with its correct meaning:
3
Question 5 Choose the correct answer:
1. What is LibreOffice Base primarily used for?
A) Spreadsheet calculations
B) Database management
C) Word processing
D) Image editing
2. Which of the following file types can LibreOffice Base open?
A) .xls
B) .dbf
C) .docx
D) .jpg
3. Which database engine can LibreOffice Base use for its databases?
A) MySQL
B) SQLite
C) HSQLDB
D) All of the above
4. Which of the following is NOT a valid object in LibreOffice Base?
A) Tables
B) Forms
C) Pictures
D) Queries
5. In LibreOffice Base, what is the purpose of a query?
A) To store data
B) To display data in tables
C) To retrieve data from a database
D) To create a report
6. How do you create a new table in LibreOffice Base?
A) Right-click and select "New Table"
B) Go to "Tools" and click "Create Table"
4
C) Click the "Table" button in the toolbar
D) Click "Create Table" under the "File" menu
7. What is the default database engine used in LibreOffice Base for new
databases?
A) SQLite
B) MySQL
C) HSQLDB
D) PostgreSQL
8. What is the function of a form in LibreOffice Base?
A) To create calculations
B) To display data and create user-friendly data entry interfaces
C) To design database structures
D) To format reports
9. What is the purpose of a report in LibreOffice Base?
A) To print the data in a table
B) To summarize and present data in a structured format
C) To update the data in the database
D) To define relationships between tables
