Question 1

A(n) ____ is a temporary view of the data whose criteria are always discarded when you close the datasheet.

Accepted Answer

A)  Filter 
B)  Query 
C)  Grid 
D)  Sort 
A)  Filter 
B)  Query 
C)  Grid 
D)  Sort

Question 2

On a form, text box controls display data from an underlying record source.

Accepted Answer

A) True 
 B)False

Question 3

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.

Accepted Answer

A)  Alignment 
B)  Styles 
C)  Cells 
D)  Editing 
A)  Alignment 
B)  Styles 
C)  Cells 
D)  Editing

Question 4

Which of the following is NOT a form view?

Accepted Answer

A)  Data 
B)  Form 
C)  Layout 
D)  Design 
A)  Data 
B)  Form 
C)  Layout 
D)  Design

Question 5

Press [Esc] once to undo a change to the current field.

Accepted Answer

A) True 
 B)False

Question 6

All functions begin with the formula prefix ____.

Accepted Answer

A)  @ (at symbol) 
B)  = (equals sign) 
C)  # (number symbol) 
D)  + (plus sign) 
A)  @ (at symbol) 
B)  = (equals sign) 
C)  # (number symbol) 
D)  + (plus sign)

Question 7

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

Accepted Answer

A)  Table 
B)  Control 
C)  Element 
D)  Object 
A)  Table 
B)  Control 
C)  Element 
D)  Object

Question 8

You can add words to the dictionary of the spelling checker.

Accepted Answer

A) True 
 B)False

Question 9

The capabilities of various report views are mutually exclusive.

Accepted Answer

A) True 
 B)False

Question 10

SQL stands for ____.

Accepted Answer

A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language 
A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language

Question 11

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

Accepted Answer

A) True 
 B)False

Question 12

This control provides an easy way to initiate a command or run a macro.

Accepted Answer

A)  Check box 
B)  Toggle button 
C)  Command button 
D)  Image control 
A)  Check box 
B)  Toggle button 
C)  Command button 
D)  Image control

Question 13

The Report Wizard applies many formatting embellishments to a report.

Accepted Answer

A) True 
 B)False

Question 14

Marshall plans to generate reports from an Access table using the Report Wizard. The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice. How could Marshall create a report that listed the blowers first, then the mowers, and then the trimmers?

Accepted Answer

Create a report usin

Question 15

You can change the ____ of labels and values in cells to be left, right, or center.

Accepted Answer

A)  font 
B)  font size 
C)  cell style 
D)  alignment 
A)  font 
B)  font size 
C)  cell style 
D)  alignment

Question 16

The z-axis of 3-D charts is used for comparing data across both categories and values.

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ refers to which data you would edit if you started typing.

Accepted Answer

The answer of The ____________________ refers to which data you...

Question 18

Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells.

Accepted Answer

A) True 
 B)False

Question 19

This control is used to display, edit, or enter data for each record. It does not provide a list of possible data entries.

Accepted Answer

A)  Label 
B)  Text box 
C)  Combo box 
D)  Command button 
A)  Label 
B)  Text box 
C)  Combo box 
D)  Command button

Question 20

Text annotations are ____ that you can add to further describe the data in your chart.

Accepted Answer

A)  arrows 
B)  titles 
C)  labels 
D)  notes 
A)  arrows 
B)  titles 
C)  labels 
D)  notes

A(n) ____ is a temporary view of the data whose criteria are always discarded when you close the datasheet.

On a form, text box controls display data from an underlying record source.

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.

Which of the following is NOT a form view?

Press [Esc] once to undo a change to the current field.

All functions begin with the formula prefix ____.

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

You can add words to the dictionary of the spelling checker.

The capabilities of various report views are mutually exclusive.

SQL stands for ____.

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

This control provides an easy way to initiate a command or run a macro.

The Report Wizard applies many formatting embellishments to a report.

You can change the ____ of labels and values in cells to be left, right, or center.

The z-axis of 3-D charts is used for comparing data across both categories and values.

The ____________________ refers to which data you would edit if you started typing.

Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells.

This control is used to display, edit, or enter data for each record. It does not provide a list of possible data entries.

Text annotations are ____ that you can add to further describe the data in your chart.

Understanding Essential Computer

Integrating Word and Excel

Getting Started With Microsoft

Finishing a Presentation

Appendix Working With Windows Live and Office Web Apps Question

Getting Started With Windows 7

Creating Documents With Word 2010

Filters

Exam 2: Getting Started With Access 2.0

A(n) ____ is a temporary view of the data whose criteria are always discarded when you close the datasheet.

On a form, text box controls display data from an underlying record source.

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.

Which of the following is NOT a form view?

Press [Esc] once to undo a change to the current field.

All functions begin with the formula prefix ____.

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

You can add words to the dictionary of the spelling checker.

The capabilities of various report views are mutually exclusive.

SQL stands for ____.

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

This control provides an easy way to initiate a command or run a macro.

The Report Wizard applies many formatting embellishments to a report.

You can change the ____ of labels and values in cells to be left, right, or center.

The z-axis of 3-D charts is used for comparing data across both categories and values.

The ____________________ refers to which data you would edit if you started typing.

Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells.

This control is used to display, edit, or enter data for each record. It does not provide a list of possible data entries.

Text annotations are ____ that you can add to further describe the data in your chart.

Understanding Essential Computer

Integrating Word and Excel

Getting Started With Microsoft

Finishing a Presentation

Appendix Working With Windows Live and Office Web Apps Question

Getting Started With Windows 7

Creating Documents With Word 2010

Filters