facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Data Forms Excel Test
Excel 2010 Training - Working with Data
Free Online Microsoft Excel Test

* What are Data Forms?
* How to Enable Data Forms
* Using Data Forms to Find Entries
* Using Data Forms to Create Entries
* Using Data Forms to Edit or Delete Entries

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Data Forms Excel Test

Question 1 Excel Data Forms Test
1) Study the screenshot above.  The box that is displayed is a specific function in Excel.  What is the name of that function?
a) The Data Entry dialogue box.
b) The Records dialogue box.
c) Form or Data Forms.
d) Criteria Form.


2) Where will you find the Forms function?
a) Under the Insert tab on the Ribbon in the Data Forms group.
b) It is not on the Ribbon, you have to add it to the Ribbon or Quick Access Toolbar yourself.
c) Under the Data tab on the Ribbon in the Data Tools group.
d) Under the Page Layout tab in the Page Set-Up group.



3) Which buttons or keys can you use to navigate between entries to view their contents in a Form?
a) The Find Prev and Find Next buttons.
b) The Enter key.
c) The Arrow keys.
d) All of the above listed options are correct.
Question 4 Excel Data Forms Test
4) Study the Screenshot above.  Which of the options below most accurately describes the function of the New button (circled in yellow)?
a) It creates a new data entry that will be added in the row below the last entry on your worksheet.
b) It creates a new worksheet that will be added next to the last worksheet you created.
c) It creates a new Excel worksheet.
d) It creates a new column or data entry field.



5) In the Excel Options dialogue box, under the Choose Commands From heading, which option should you select to quickly find the Forms function?
a) You should choose the Excel Forms Commands option.
b) You should choose the Commands Not in the Ribbon option.
c) You should choose the Show All Commands on the Ribbon option.
d) You should choose the Data Entry Functions option.


Question 6 Excel Data Forms Test
6) Study the Screenshot above.  Shaheed wants to add a field called Security Pin to the Data Form.  It should appear directly after the Surname field.  How can she do this?
a) By clicking on the New button and inserting the words, Security Pin, directly after Surname on the Form.
b) By right-clicking the Form and selecting New Field from the menu list.  Next, type the name, Security Pin, directly after Surname on the Form.
c) By closing the Form and inserting a column titled Security Pin directly after the Surname column on the worksheet.
d) None of the options listed above are correct.



7) To find a specific entry or set of entries that contain matching information.  Which option in the Form can I use to achieve this?
a) Click on the Criteria button in the Form and type the search items or criteria into the relevant field boxes.
b) Click, on the Go To button in the Form and type the search items or criteria into the relevant field boxes.
c) Click on the Find option and type in the criteria you wish to search the records by.
d) Click on the Form Arguments button and enter the search criteria into the boxes provided.


8) If you make changes to data entries within the Data Form, will these changes be displayed in the worksheet?
a) No changes you make in a Data Form will affect or change data in the actual worksheet.
b) Any changes you make in a Data Form will affect and change data in the actual worksheet.
c) Only some changes you make in a Data Form will affect and change data in the actual worksheet.
d) None of the options listed above are correct.


9) Which of the functions listed below can you NOT carry out using a Data Form?
a) Navigate between data entries or records on a worksheet.
b) Create new data entries.
c) Delete obsolete data entries.
d) All of the above options are correct.

10) When entering data using a Data Form, which of the following is the quickest method to navigate to the next field?
a) Click your mouse cursor in the next field.
b) Press the tab key on your keyboard to move to the next field.
c) Press the Find Prev and Find Next buttons to move to the next field.
d) Press Ctrl+Enter to move to the next blank row.