USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Forms or queries can be created using single table only. Forms can also be used to modity the table’s data. Cheries can extract the data only from the tables. Multiple criteria can also be set on a query.
Detailed explanation-2: -Double-click the two tables that contain the data you want to include in your query and also the junction table that links them, and then click Close. All three tables appear in the query design workspace, joined on the appropriate fields. Double-click each of the fields that you want to use in your query results.
Detailed explanation-3: -Answer: a query can be based on a table and a query both.
Detailed explanation-4: -Explanation: Its false database can have more than one table .
Detailed explanation-5: -Queries can only use data from one table at a time. A primary key field from one table appears in a second table.