Question 1

Match between columns
                        Premises: A dark rectangle that outlines the cell in which you are working
Identified by the coordinates of the intersecting column and row
Displays the active cell address
Work done in a virtual environment
Provides a brief description of the active command or task in progress

Accepted Answer

The Answer of status bar and cell address and Name is...

Question 2

What are some advantages of using an Excel template to create a workbook?

Accepted Answer

Excel templates allow users to create pr

Question 3

Discuss the difference between tab order and tab stop.

Accepted Answer

Tab order is the order the focus moves a

Question 4

Use the alignment buttons on the Design tab to align the edges of the controls with respect to one another.

Accepted Answer

A) True 
 B)False

Question 5

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

Accepted Answer

A)  Report View 
B)  Layout View 
C)  Design View 
D)  Print Preview 
A)  Report View 
B)  Layout View 
C)  Design View 
D)  Print Preview

Question 6

The upper portion of Query Design View shows a table's ____________________ list.

Accepted Answer

The answer of The upper portion of Query Design View...

Question 7

When do you apply formatting to a cell or range?

Accepted Answer

You can apply format

Question 8

The same expression in different sections of a report produces different calculations.

Accepted Answer

A) True 
 B)False

Question 9

A bar chart and column chart are equivalent chart types in Excel.

Accepted Answer

A) True 
 B)False

Question 10

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Accepted Answer

A) True 
 B)False

Question 11

Use this form creation tool to create a form by answering a series of questions provided by dialog boxes.

Accepted Answer

A)  Form Wizard 
B)  More Forms 
C)  Split Form 
D)  Navigation 
A)  Form Wizard 
B)  More Forms 
C)  Split Form 
D)  Navigation

Question 12

The default file extension for an Excel 2010 workbook is ____.

Accepted Answer

A)  .xltx 
B)  .xslx 
C)  .xlsx 
D)  .xlts 
A)  .xltx 
B)  .xslx 
C)  .xlsx 
D)  .xlts

Question 13

Which two properties are required for every field?

Accepted Answer

A)  Field Name and Data Type 
B)  Field Name and Field Size 
C)  Data Type and Format 
D)  Field Size and Format 
A)  Field Name and Data Type 
B)  Field Name and Field Size 
C)  Data Type and Format 
D)  Field Size and Format

Question 14

A tab control is an unbound control.

Accepted Answer

A) True 
 B)False

Question 15

While editing a record, pressing [Esc] a second time ____.

Accepted Answer

A)  Deletes the current field 
B)  Deletes the current datasheet 
C)  Removes all data from the current record 
D)  Removes all changes made to the record you are currently editing 
A)  Deletes the current field 
B)  Deletes the current datasheet 
C)  Removes all data from the current record 
D)  Removes all changes made to the record you are currently editing

Question 16

The area inside the horizontal and vertical axes is the legend .

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____________________ field automatically assigns a new number each time you add a record.

Accepted Answer

The answer of A(n) ____________________ field automatically assigns a new...

Question 18

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user.

Accepted Answer

A) True 
 B)False

Question 19

Which data type stores Web addresses?

Accepted Answer

A)  Lookup Wizard 
B)  Hyperlink 
C)  www address 
D)  HTML 
A)  Lookup Wizard 
B)  Hyperlink 
C)  www address 
D)  HTML

Question 20

Which chart type would be the best candidate to spot trends and extrapolate information based on research data?

Accepted Answer

A)  Pie 
B)  Area 
C)  Scatter 
D)  Hi-Low 
A)  Pie 
B)  Area 
C)  Scatter 
D)  Hi-Low

What are some advantages of using an Excel template to create a workbook?

Discuss the difference between tab order and tab stop.

Use the alignment buttons on the Design tab to align the edges of the controls with respect to one another.

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

The upper portion of Query Design View shows a table's ____________________ list.

When do you apply formatting to a cell or range?

The same expression in different sections of a report produces different calculations.

A bar chart and column chart are equivalent chart types in Excel.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Use this form creation tool to create a form by answering a series of questions provided by dialog boxes.

The default file extension for an Excel 2010 workbook is ____.

Which two properties are required for every field?

A tab control is an unbound control.

While editing a record, pressing [Esc] a second time ____.

The area inside the horizontal and vertical axes is the legend .

A(n) ____________________ field automatically assigns a new number each time you add a record.

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user.

Which data type stores Web addresses?

Which chart type would be the best candidate to spot trends and extrapolate information based on research data?

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

What are some advantages of using an Excel template to create a workbook?

Discuss the difference between tab order and tab stop.

Use the alignment buttons on the Design tab to align the edges of the controls with respect to one another.

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

The upper portion of Query Design View shows a table's ____________________ list.

When do you apply formatting to a cell or range?

The same expression in different sections of a report produces different calculations.

A bar chart and column chart are equivalent chart types in Excel.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Use this form creation tool to create a form by answering a series of questions provided by dialog boxes.

The default file extension for an Excel 2010 workbook is ____.

Which two properties are required for every field?

A tab control is an unbound control.

While editing a record, pressing [Esc] a second time ____.

The area inside the horizontal and vertical axes is the legend .

A(n) ____________________ field automatically assigns a new number each time you add a record.

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user.

Which data type stores Web addresses?

Which chart type would be the best candidate to spot trends and extrapolate information based on research data?

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