MISY 5325 MS EXCEL MIDTERM EXAM
STUDY GUIDE 2026 ACTUAL
EXAMINATION PAPER 2026 QUESTIONS
WITH ANSWERS GRADED A+
⩥ 2. To compact and repair a database, tap or click ———— button in
the Info gallery in the Backstage view. Answer: Compact & Repair
⩥ 3. To create a crosstab, click the———— button on the CREATE tab.
Answer: crosstab, Query Wizard
⩥ 4. To create a lookup field, select ————- from the menu of
available data types. Answer: Lookup Wizard
⩥ 5. To create a multivalued field, create a ———— field being sure to
check the Allow Multiple Values check box. Answer: lookup
⩥ 6. To create a multivalued field, create a(n) ———field being sure to
check the Allow Multiple Values check box. Answer: lookup
⩥ 7. To create a new query in Design view, click CREATE on the ribbon
to display the CREATE tab and then click the ———- button to create a
new query. Answer: Query Design
, ⩥ 8. create a parameter query, enter a parameter rather than a specific
value as a criterion in the design grid. The parameter must be enclosed in
Answer: parameter square brackets [ ]
⩥ 9. To create a split form, select the table in the Navigation Pane, click
CREATE on the ribbon, click the ———— button on the CREATE tab
to display a menu, and then click Split Form on the menu. Answer: More
Forms
⩥ 10. To create a top-values query, use the Top Values box on the
DESIGN tab to change the number of records to be included from All to
the desired number. Answer: False
⩥ 11. To create a validation rule for the State field to restrict entries to
TN or TX, enter ————in the Validation Rule property box. Answer:
T
⩥ 12. To create an update query, create a new query and then click the
———- button on the DESIGN tab. Answer: Update
⩥ 13. To define an additional field in Datasheet view, tap or click the —
——- column heading. Answer: Click to Add
STUDY GUIDE 2026 ACTUAL
EXAMINATION PAPER 2026 QUESTIONS
WITH ANSWERS GRADED A+
⩥ 2. To compact and repair a database, tap or click ———— button in
the Info gallery in the Backstage view. Answer: Compact & Repair
⩥ 3. To create a crosstab, click the———— button on the CREATE tab.
Answer: crosstab, Query Wizard
⩥ 4. To create a lookup field, select ————- from the menu of
available data types. Answer: Lookup Wizard
⩥ 5. To create a multivalued field, create a ———— field being sure to
check the Allow Multiple Values check box. Answer: lookup
⩥ 6. To create a multivalued field, create a(n) ———field being sure to
check the Allow Multiple Values check box. Answer: lookup
⩥ 7. To create a new query in Design view, click CREATE on the ribbon
to display the CREATE tab and then click the ———- button to create a
new query. Answer: Query Design
, ⩥ 8. create a parameter query, enter a parameter rather than a specific
value as a criterion in the design grid. The parameter must be enclosed in
Answer: parameter square brackets [ ]
⩥ 9. To create a split form, select the table in the Navigation Pane, click
CREATE on the ribbon, click the ———— button on the CREATE tab
to display a menu, and then click Split Form on the menu. Answer: More
Forms
⩥ 10. To create a top-values query, use the Top Values box on the
DESIGN tab to change the number of records to be included from All to
the desired number. Answer: False
⩥ 11. To create a validation rule for the State field to restrict entries to
TN or TX, enter ————in the Validation Rule property box. Answer:
T
⩥ 12. To create an update query, create a new query and then click the
———- button on the DESIGN tab. Answer: Update
⩥ 13. To define an additional field in Datasheet view, tap or click the —
——- column heading. Answer: Click to Add
