Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Experiencing MIS Study Set 4

Computing

Quiz 19 :

Using Excel and Access Together

Quiz 19 :

Using Excel and Access Together

search
arrow
Which of the following shows the correct sequence of steps for formatting the currency values in Microsoft Excel?
Free
Multiple Choice
Answer:

Answer:

A

arrow
Which of the following statements is true of delimited files?
Free
Multiple Choice
Answer:

Answer:

D

arrow
Which of the following shows the correct sequence of steps for creating a column chart in Microsoft Excel?
Free
Multiple Choice
Answer:

Answer:

D

arrow
In Microsoft Access,the Totals button is present in the ________ section of the Design tab.
Multiple Choice
Answer:
arrow
An organization stores the details of its employees using Access: The Employee table has EmployeeName,EmployeeID,Department,and Salary columns: Which of the following statements is true?
Multiple Choice
Answer:
arrow
Which of the following shows the correct sequence of steps for importing Access data that has been stored in a text file into Excel?
Multiple Choice
Answer:
arrow
Which of the following Excel diagrams is the best to compare performance data over many years of different employees?
Multiple Choice
Answer:
arrow
Delimited text files can be imported to Microsoft Access by selecting the ________ tab.
Multiple Choice
Answer:
arrow
Which of the following tabs in Microsoft Excel contains the option to create a column chart?
Multiple Choice
Answer:
arrow
Which of the following shows the correct sequence of steps for creating a pie chart in Microsoft Excel?
Multiple Choice
Answer:
arrow
The process of transferring data from one computer system to another is referred to as ________.
Multiple Choice
Answer:
arrow
Which of the following statements is true of queries?
Multiple Choice
Answer:
arrow
A user can readily create data entry forms,queries,and sophisticated and professional reports with the help of ________.
Multiple Choice
Answer:
arrow
Microsoft Access is a database management system.
True False
Answer:
arrow
Which of the following is true of import/export of data from Access to Excel?
Multiple Choice
Answer:
arrow
Which of the following procedures must be used to create a named range for data in Excel?
Multiple Choice
Answer:
arrow
A school stores attendance records of its students on an Access database: The Attendance table has StudentName,StudentID,Grade,and DateAbsent columns: Each time a student is absent,an entry is made into the database: Which of the following statements is true?
Multiple Choice
Answer:
arrow
Data can be transferred from Excel to Access by creating a ________,which is a subset of the cells in a worksheet that has a unique name.
Multiple Choice
Answer:
arrow
Which of the following is an advantage of Microsoft Excel over Microsoft Access?
Multiple Choice
Answer:
arrow
________ is well-suited for tracking orders,inventory,equipment,people,and so forth.
Multiple Choice
Answer:
Showing 1 - 20 of 50