Question 1

Use this form creation tool to build a form based on Multiple Items, Datasheet, or Split Form.

Accepted Answer

A)  Form Design 
B)  Blank Form 
C)  More Forms 
D)  Form Wizard 
A)  Form Design 
B)  Blank Form 
C)  More Forms 
D)  Form Wizard

Question 2

You can add a text box using the Chart Tools ____ tab.

Accepted Answer

A)  Design 
B)  Layout 
C)  Format 
D)  Text 
A)  Design 
B)  Layout 
C)  Format 
D)  Text

Question 3

You can quickly create a miniature chart called a(n) ______________ that serves as a visual indicator of data trends directly within a cell.

Accepted Answer

The answer of You can quickly create a miniature chart...

Question 4

The Bold and Underline buttons are found in the Font group on the Home tab of the Ribbon.

Accepted Answer

A) True 
 B)False

Question 5

Reference operators compare values for the purpose of true/false results.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: Often contains numerical values that help you interpret the size of chart elements.
An independent element on a worksheet.
Visually represents each data point.
Presents information in a pictorial format.
Often contains the names of data groups, such as locations, months, or years.

Accepted Answer

The Answer of chart and category axis and value axis is...

Question 7

Use the ____ command to save the current object with a new name.

Accepted Answer

A)  Datasheet 
B)  View 
C)  Save Object As 
D)  Save 
A)  Datasheet 
B)  View 
C)  Save Object As 
D)  Save

Question 8

To add, delete, or change fields in a query, you use Query Design View.

Accepted Answer

A) True 
 B)False

Question 9

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

Accepted Answer

A)  Home 
B)  Page Layout 
C)  Review 
D)  Data 
A)  Home 
B)  Page Layout 
C)  Review 
D)  Data

Question 10

When copying or moving formulas in an Excel worksheet, the default type of cell reference is ____________________.

Accepted Answer

The answer of When copying or moving formulas in an...

Question 11

"Focus" refers to which data you would edit if you started typing.

Accepted Answer

A) True 
 B)False

Question 12

The default Accounting number format adds dollar signs and ____ decimal places to the data.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
A)  one 
B)  two 
C)  three 
D)  four

Question 13

To format a cell or range, first you select it, and then you apply the formatting using the ____ or a keyboard shortcut.

Accepted Answer

A)  Name box 
B)  formula box 
C)  Ribbon 
D)  Sheet tabs 
A)  Name box 
B)  formula box 
C)  Ribbon 
D)  Sheet tabs

Question 14

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

Accepted Answer

A)  SmartArt 
B)  WordArt 
C)  ClipArt 
D)  3-DArt 
A)  SmartArt 
B)  WordArt 
C)  ClipArt 
D)  3-DArt

Question 15

A form contains record navigation buttons, with information about the current record number and total number of records, similar to those found on a datasheet.

Accepted Answer

A) True 
 B)False

Question 16

The $ symbol placed before a row or column address indicates a(n) ____________________ cell reference.

Accepted Answer

The answer of The $ symbol placed before a row...

Question 17

The Excel operator for division is ____.

Accepted Answer

A)  / 
B)  \ 
C)  % 
D)  ^ 
A)  / 
B)  \ 
C)  % 
D)  ^

Question 18

One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon .

Accepted Answer

A) True 
 B)False

Question 19

Discuss how the order of precedence works in the formula =25+2/3 and =(25+2)/3. Describe the order of calculations in your answer.

Accepted Answer

The order of precedence in Excel is that

Question 20

With Excel, you can adjust the width of one or more columns by using the Ribbon.

Accepted Answer

A) True 
 B)False

Use this form creation tool to build a form based on Multiple Items, Datasheet, or Split Form.

You can add a text box using the Chart Tools ____ tab.

You can quickly create a miniature chart called a(n) ______________ that serves as a visual indicator of data trends directly within a cell.

The Bold and Underline buttons are found in the Font group on the Home tab of the Ribbon.

Reference operators compare values for the purpose of true/false results.

Use the ____ command to save the current object with a new name.

To add, delete, or change fields in a query, you use Query Design View.

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

When copying or moving formulas in an Excel worksheet, the default type of cell reference is ____________________.

"Focus" refers to which data you would edit if you started typing.

The default Accounting number format adds dollar signs and ____ decimal places to the data.

To format a cell or range, first you select it, and then you apply the formatting using the ____ or a keyboard shortcut.

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

A form contains record navigation buttons, with information about the current record number and total number of records, similar to those found on a datasheet.

The $ symbol placed before a row or column address indicates a(n) ____________________ cell reference.

The Excel operator for division is ____.

One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon .

Discuss how the order of precedence works in the formula =25+2/3 and =(25+2)/3. Describe the order of calculations in your answer.

With Excel, you can adjust the width of one or more columns by using the Ribbon.

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

Use this form creation tool to build a form based on Multiple Items, Datasheet, or Split Form.

You can add a text box using the Chart Tools ____ tab.

You can quickly create a miniature chart called a(n) ______________ that serves as a visual indicator of data trends directly within a cell.

The Bold and Underline buttons are found in the Font group on the Home tab of the Ribbon.

Reference operators compare values for the purpose of true/false results.

Use the ____ command to save the current object with a new name.

To add, delete, or change fields in a query, you use Query Design View.

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

When copying or moving formulas in an Excel worksheet, the default type of cell reference is ____________________.

"Focus" refers to which data you would edit if you started typing.

The default Accounting number format adds dollar signs and ____ decimal places to the data.

To format a cell or range, first you select it, and then you apply the formatting using the ____ or a keyboard shortcut.

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

A form contains record navigation buttons, with information about the current record number and total number of records, similar to those found on a datasheet.

The $ symbol placed before a row or column address indicates a(n) ____________________ cell reference.

The Excel operator for division is ____.

One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon .

Discuss how the order of precedence works in the formula =25+2/3 and =(25+2)/3. Describe the order of calculations in your answer.

With Excel, you can adjust the width of one or more columns by using the Ribbon.

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