Question 1

=D8+E8*0.5 is a complex formula.

Accepted Answer

A) True 
 B)False  True

Question 2

Match between columns
                        Premises: Equal to 1/72 of an inch.
Has a default value of 8.43 characters, a little less than one inch.
A type of conditional formatting that visually illustrates differences among values.
A predefined set of attributes that gives your Excel worksheet a professional look.
The name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design.

Accepted Answer

The Answer of data bar and point and column width is...

Question 3

What are the advantages of database software such as Access over spreadsheet software such as Excel?

Accepted Answer

1.Duplicate data is minimized. 
2.Information is more accurate, reliable, and consistent. 
3.Data entry is faster and easier. 
4.Information can be viewed and sorted in multiple ways. 
5.Information is more secure. 
6.Information can be shared among several users.

Question 4

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. What expression would Marshall use to calculate a grand total of the PurchasePrice field in the Report Footer?

Accepted Answer

=Sum([Purc

Question 5

In forms created by using the Form Wizard, labels are generally in the first column, to the left of the text boxes they describe.

Accepted Answer

A) True 
 B)False

Question 6

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

Accepted Answer

A)  represent values graphically 
B)  organize data 
C)  create what-if data scenarios 
D)  perform calculations 
A)  represent values graphically 
B)  organize data 
C)  create what-if data scenarios 
D)  perform calculations

Question 7

Explain the difference between Normal view and Page Layout view in Excel.

Accepted Answer

Normal view shows the worksheet without

Question 8

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Accepted Answer

A)  Record 
B)  Table 
C)  Database 
D)  Object 
A)  Record 
B)  Table 
C)  Database 
D)  Object

Question 9

In Excel, a worksheet is contained in a file called a ____.

Accepted Answer

A)  workbook 
B)  workpad 
C)  notebook 
D)  datapad 
A)  workbook 
B)  workpad 
C)  notebook 
D)  datapad

Question 10

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

Accepted Answer

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

Question 11

Describe four commonly used Excel chart types.

Accepted Answer

A column chart compares distinct object

Question 12

The formula =(25*2)/5 would calculate the result of 10, according to the order of precedence.

Accepted Answer

A) True 
 B)False

Question 13

Any time you use a worksheet to ask the question "what if?" you are performing ____________________ analysis.

Accepted Answer

The answer of Any time you use a worksheet to...

Question 14

Arguments are Excel's built-in formulas.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: Used to visually separate information on a form
Best choice to create a three-dimensional aspect to a form
Used to run a macro
Best choice to display a field such as Veteran that has only two options, Yes or No
Used to provide a list of options for a field plus the ability for the user to enter a new value
Best choice to provide choices for a field in an option group
Used to provide a list of options for a field with no ability for the user to enter a new value
Best choice to describe information on a form

Accepted Answer

The Answer of Command button and Line and Option button is...

Question 16

To quickly jump to the first cell in a worksheet press ____.

Accepted Answer

A)  [Alt][Page Up] 
B)  [Shift][Home] 
C)  [Page Up] 
D)  [Ctrl][Home] 
A)  [Alt][Page Up] 
B)  [Shift][Home] 
C)  [Page Up] 
D)  [Ctrl][Home]

Question 17

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

Accepted Answer

A)  Page Setup 
B)  AutoCorrect 
C)  Insert 
D)  Format Cells 
A)  Page Setup 
B)  AutoCorrect 
C)  Insert 
D)  Format Cells

Question 18

The question mark (?) is the wildcard character which stands for any single character in criteria.

Accepted Answer

A) True 
 B)False

Question 19

A scatter chart ____.

Accepted Answer

A)  compares distinct, unrelated objects over time using a horizontal format 
B)  compares trends over even time intervals 
C)  compares trends over uneven time or measurement intervals 
D)  combines a column and line chart to compare data requiring different scales of measure 
A)  compares distinct, unrelated objects over time using a horizontal format 
B)  compares trends over even time intervals 
C)  compares trends over uneven time or measurement intervals 
D)  combines a column and line chart to compare data requiring different scales of measure

Question 20

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Accepted Answer

A) True 
 B)False

=D8+E8*0.5 is a complex formula.

What are the advantages of database software such as Access over spreadsheet software such as Excel?

In forms created by using the Form Wizard, labels are generally in the first column, to the left of the text boxes they describe.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

Explain the difference between Normal view and Page Layout view in Excel.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

In Excel, a worksheet is contained in a file called a ____.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

Describe four commonly used Excel chart types.

The formula =(25*2)/5 would calculate the result of 10, according to the order of precedence.

Any time you use a worksheet to ask the question "what if?" you are performing ____________________ analysis.

Arguments are Excel's built-in formulas.

To quickly jump to the first cell in a worksheet press ____.

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

The question mark (?) is the wildcard character which stands for any single character in criteria.

A scatter chart ____.

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

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

=D8+E8*0.5 is a complex formula.

What are the advantages of database software such as Access over spreadsheet software such as Excel?

In forms created by using the Form Wizard, labels are generally in the first column, to the left of the text boxes they describe.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

Explain the difference between Normal view and Page Layout view in Excel.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

In Excel, a worksheet is contained in a file called a ____.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

Describe four commonly used Excel chart types.

The formula =(25*2)/5 would calculate the result of 10, according to the order of precedence.

Any time you use a worksheet to ask the question "what if?" you are performing ____________________ analysis.

Arguments are Excel's built-in formulas.

To quickly jump to the first cell in a worksheet press ____.

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

The question mark (?) is the wildcard character which stands for any single character in criteria.

A scatter chart ____.

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

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