Spreadsheet Functions & Commands PDF

 True or Flase : 1. Replace Replace the text inside the cell with another text. 2. Sort is to arrange data within a range of cells in ascending order only. 3. Filter is to filter data within a range of cells to show some and hide others. 4. cells Delete Used to delete cells. 5. Min: A function that...

 True or Flase : 1. Replace Replace the text inside the cell with another text. 2. Sort is to arrange data within a range of cells in ascending order only. 3. Filter is to filter data within a range of cells to show some and hide others. 4. cells Delete Used to delete cells. 5. Min: A function that displays the largest numerical value present in a range of cells. 6. Average: A function used to calculate the average of numbers within a range of cells. 7. All commands related to the worksheet are available when you click right. 8. sheet Rename: Rename the worksheet. 9. In choosing the data type: the numbers represent: currencies - decimal numbers - percentage points. 10. Merge: Used to adjust text according to cell size. 11. painter Format: To format a cell using another cell format. 12. The IF function is used to link two situations, one of which fulfills a certain condition. 13. You can delete or add a row or column to your spreadsheet. 14. Up look V: used to search rows for specific data present in another table. 15. Height Row: To change the height of the column. 16. Macro programming is safer than automatic programming. 17. When recording a macro, we write its function in the place of the macro’s description. (Description). 18. The function that calculates the difference between dates is datediff. 19. The appropriate function to display today’s date is (date(). 20. Megabox: A command used to display a message in the macro. 21. SUM is a function used to calculate the average of numbers within a range of cells in Excel. 22. All commands related to the worksheet are available when you click right. in Excel. 23. The General data type in Excel contains letters only. 24. Warp: It is used to adjust text according to the cell size in Excel. 25. The count function is used to link two conditions, one of which is achieved only under a specific condition in the Excel program. 26. You can delete or add a row or column to your spreadsheet that you designed through Excel. 27: Up look V is used to search in rows for specific data present in another table in the Excel program. Height column: 28. You can control the height of the column using a table in Excel. 29. Macro programming is safer than automatic programming. correct 30. When recording a macro, we write its function in the macro description.  Choose the correct answer : 1. A function used to sum the numbers within a range of cells: o AVERAGE o SUM o MAX o MIN 2. Know the rows: o letters o Numbers o Letters and numbers o Symbols 3. Enter a worksheet: o Format o Insert o New o None of the above 4. It is a program used to store and process data through arithmetic and logical operations and formatting it: o Excel o Access o Oracle o None of the above 5. The work book contains: o sheet o Work paper o File o None of the above 6. The worksheet on which the work is being done, which is written in bold, is: o Hidden Sheet o Active sheet o Locked sheet o None of the above 7. You know the columns B: o Names o Numbers o letters o None of the above 8. To move text from one cell to another cell: o Copy o cut o move o None of the above 9. To copy text from one cell to another cell: o Copy o cut o move o None of the above 10. Command to merge cells to become one cell: o Warp o Merge o move o None of the above 11. color Tab to control: o Cell color o Table color o sheet color o None of the above 12. Hide: o Hide the worksheet o Close the worksheet o To delete the worksheet o None of the above 13. Function User Calculate the sum for the range of cells 1A to 1C: o C1, A1 o C1:A1 o C1; A1 o None of the above 14. To set a specific condition, we use the function: o Condition o Case o If o None of the above 15. Width column to control: o Row view o Column width o Display selected cells o None of the above  True or Flase : 1. The query is created using query design 2. The number of ways to create a query is four 3. A record is a field in a table that is not repeated in any other record in the same table 4. Changing the size of a text field from 255 to 50 will allow 60 characters to be entered in this field. 5. Related columns have the same data type and the same size 6. You can change the value of a primary key in a primary key table if that row is related to other rows. For example, you cannot Delete an employee from the (Employees) table if this employee is assigned to a job in the (Job) table 7. The basic structure of the database is the table 8. The easiest way to enter data is the form. 9. Without using the key, the tables can be used better 10. In the relationship M:M, it must be broken with another table that contains the PK for linked tables in the Access program. Correct. 11. One of the characteristics of Pk in an Access table is that its value is repeated when needed. mistake 12. The number of ways to create a query in an Access database is four. mistake 13. Queries are used to display and analyze data in different ways in Access 14. Using the primary key makes using tables better in Access. correct 15. In the 1:1 relationship, it must be broken with another table that contains the PK of the linked tables in the Access program. Error 16. A form is an element of the database and is used to enter data. correct 17. The data regarding a university student’s name is represented in a record in a table in the Access program. correct 18. Automatic numbering (in Excel) is a numerical field that increments by one for each record that begins with the number 19. The report is the method used to enter data and save it in the table in the Access program. correct  20. Record (in Access) represents information about a specific object. Correct  Choose the correct answer : 1. Which of the following describes the database? o A collection of data organized in a way that makes it quick and easy to retrieve and search for. o Part of the GUI model. o Any device that can store data permanently on a storage medium. o A series of numbers that are processed by a computer. 2. What is a database? o Data list. o Collect data randomly. o A set of data collected in a systematic structure. o A set of data without any structure. 3. Choose the correct statement from the following o Records consist of tables containing data fields. o Tables consist of fields that store a number of records. o Fields consist of a set of tables and records. o Tables consist of a number of records, each record containing a number of fields. 4. Choose the correct statement from the following o Fields consist of records divided into several tables. o Tables consist of records divided into several fields. o Records consist of tables divided into several fields. o Tables consist of fields that are divided into several records. 5. The record consists of a number of: o Tables. o Relationships. o C- Lines. o D- Fields.  6. Choose the best statement to describe why the tables in the database are interconnected? o To ensure that the same names are used for tables of the same type. o To fetch information from two tables combined. o C- To speed up data processing. o D- To ensure that the data type is repeated in several tables. 7. Why are tables linked together in the database? o To ensure that the data type is repeated in several fields. o To ensure that tables with similar names can be displayed together. o To ensure that tables do not contain duplicate data. o To ensure that tables containing the same data type can be displayed together. 8. Linked tables in a database allow... o Preview external data. o Preview data from several tables at once. o Preview data from one table. o Perform calculations better and faster 9. Referential integrity in relationships between tables is important because o Prevents the user from naming similar objects, such as tables and forms, with the same names. o Forces the database to store data efficiently. o Reduces the space required on the hard disk by deleting redundant records from tables. o Ensuring that the relationship between records is correct and that no record is changed or deleted by mistake. 10. Which of the following best describes the term primary key: o It is a way to sort the first field in the table. o The first key in the table. o Defines one or more fields through which records can be distinguished from each other. o is a field that identifies other keys in related tables.  11. To inquire about specific data under certain conditions in the database in Access: o Form o Query o Report o Select 12. The record in the Access program table consists of a number of: o Fields o Relationships o Tables o Rows 13. The property of showing a field in the query result in the Access program: o Field size o Show o Appear o Required 14. One of the features of Access is that it can link database tables using: o Relationships o Programming o Master keys o Foreign keys 15. It is a program used to create a database and link its tables in order to prepare reports for easy business analysis: o Excel o Access o Oracle o None of the above 16. A feature that requires the user to enter data into the field when designing a table in Access: o Show o Required o Needed o Select  17. In an Access database: The condition (‘* like A’) is used to query name: o It starts with the letter A o It ends with the letter A o It does not contain the letter A o It contains the letter A 18. A property that determines the size of a specific field in the Access program: o Field size o Show o Appear o Required