Exam 2: Getting Started With Access 2.0

Which of the following is not a data type?

Excel's ____________________ feature suggests functions depending on the first letters typed by the user.

You can use buttons on the Insert tab of the Ribbon to create and modify a chart.

A(n) ____________________ object provides an easy-to-use data entry screen.

The [F2] key switches between Edit and Navigation modes.

Explain the difference between AND and OR criteria.

An Excel complex formula uses more than one arithmetic operator.

The Page Footer section prints ____.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Which formula contains a mixed cell reference?

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

Differentiate between label and text box controls.

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

Daniel Arno owns a lawn and landscape business.He has some very particular clients who want their lawns manicured on a specific day of the week.He has other clients who allow him to use his own judgement as to when their lawns need cutting.To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision, and fee.Daniel creates a table called Customers.For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Daniel wants to build a query that will show each customer name, day of the week (if specific), and subdivision.What criterion should he use to quickly find his customers whose day of the week varies?

###### in a cell means that the ____________.

When cells are copied using Excel's copy function, what happens to the data in the copied cells?

An Excel user may paste a range of cells in which of the following locations?

In Query Design View, record selectors are thin gray bars above the field names.

Daniel Arno owns a lawn and landscape business.He has some very particular clients who want their lawns manicured on a specific day of the week.He has other clients who allow him to use his own judgement as to when their lawns need cutting.To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision, and fee.Daniel creates a table called Customers.For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Daniel creates a query using the Name, Day of the Week, and Subdivision fields.He wants to sort the records by day of the week, beginning with Monday and ending with Sunday.He decides to number each day of the week: 1=Monday, 2=Tuesday, and so forth. a. Will his idea work? b. Why or why not? c. Should he plan to sort in ascending or descending order?

How does grouping compare to sorting?