Question 1

Which of the following is not a data type?

Accepted Answer

A)  Number 
B)  Formula 
C)  Date/Time 
D)  Text

Question 2

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

Accepted Answer

The answer of Excel's ____________________ feature suggests functions depending on...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of A(n) ____________________ object provides an easy-to-use data...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Explain the difference between AND and OR criteria.

Accepted Answer

The answer of Explain the difference between AND and OR...

Question 7

An Excel complex formula uses more than one arithmetic operator.

Accepted Answer

A) True 
 B)False

Question 8

The Page Footer section prints ____.

Accepted Answer

A)  At the bottom of every page 
B)  At the end of the entire report 
C)  At the end of the first and last pages in the report 
D)  Once for every group of records

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Which formula contains a mixed cell reference?

Accepted Answer

A)  =(A6+A7)*0.20 
B)  =($A$6+A7)*0.20 
C)  =($A$6+$A$7)*0.20 
D)  =($A6+$A$7)*0.20

Question 11

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

Accepted Answer

A)  inner 
B)  embedded 
C)  sub 
D)  interactive

Question 12

Differentiate between label and text box controls.

Accepted Answer

The answer of Differentiate between label and text box controls....

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 15

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

Accepted Answer

A)  formula contains an error 
B)  value contains an error 
C)  label has a spelling error 
D)  column is too narrow to display the value completely

Question 16

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

Accepted Answer

A)  the data is permanently deleted from the copied cells 
B)  the data is temporarily deleted from the copied cells 
C)  the data remains in its original location 
D)  the data is moved to another location and removed from its original location

Question 17

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

Accepted Answer

A)  the same worksheet where the cells were copied 
B)  a different worksheet 
C)  both a. and
B. 
D)  neither a. nor
B.

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 20

How does grouping compare to sorting?

Accepted Answer

The answer of How does grouping compare to sorting?...

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.

###### 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.

How does grouping compare to sorting?