Question 1

You can drill all of the following down through a workbook EXCEPT ____.

Accepted Answer

A)  formats 
B)  numbers 
C)  formulas 
D)  groupings 
A)  formats 
B)  numbers 
C)  formulas 
D)  groupings

Question 2

The result of an arithmetic operation,such as multiplication or division,is accurate to the factor with the least number of decimal places.

Accepted Answer

A) True 
 B)False

Question 3

To select nonadjacent sheets,select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

Accepted Answer

A)  CTRL 
B)  SHIFT 
C)  ALT 
D)  ESC 
A)  CTRL 
B)  SHIFT 
C)  ALT 
D)  ESC

Question 4

A range that spans two or more worksheets in a workbook is called a ____ range.

Accepted Answer

A)  1-D 
B)  2-D 
C)  3-D 
D)  4-D 
A)  1-D 
B)  2-D 
C)  3-D 
D)  4-D

Question 5

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

Accepted Answer

A) True 
 B)False

Question 6

By default,Excel places charts in the center of the worksheet.t.​

Accepted Answer

A) True 
 B)False

Question 7

A(n)____ reference is a formula that depends on its own value.

Accepted Answer

A)  explicit 
B)  implicit 
C)  singular 
D)  circular 
A)  explicit 
B)  implicit 
C)  singular 
D)  circular

Question 8

The following sequence,Jan,Feb,Mar,etc.,is an example of a ____ series.

Accepted Answer

A)  linear 
B)  date 
C)  growth 
D)  fill 
A)  linear 
B)  date 
C)  growth 
D)  fill

Question 9

If you are summing numbers on noncontiguous sheets,hold down the SHIFT key rather than the CTRL key when selecting the sheets.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is the path to the Switch Windows button?

Accepted Answer

Question 11

When tiling windows vertically the windows appear as wide as possible._________________________

Accepted Answer

A) True 
 B)False

Question 12

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

Accepted Answer

A)  Standard 
B)  Number 
C)  Currency 
D)  Normal 
A)  Standard 
B)  Number 
C)  Currency 
D)  Normal

Question 13

The following sequence,2,4,6,etc.,is an example of a ____ series.

Accepted Answer

A)  linear 
B)  growth 
C)  fill 
D)  date 
A)  linear 
B)  growth 
C)  fill 
D)  date

Question 14

____ format codes allow you to specify how a cell entry assigned a format will appear.

Accepted Answer

A)  Individual 
B)  Specific 
C)  Custom 
D)  Duplicate 
A)  Individual 
B)  Specific 
C)  Custom 
D)  Duplicate

Question 15

The system date might be displayed as a series of number signs if the date,as initially formatted by Excel,does not fit in the width of the cell.

Accepted Answer

A) True 
 B)False

Question 16

As you link workbooks,the cell reference inserted by Excel each time you click a cell in a workbook results in a(n)____ cell reference.

Accepted Answer

A)  dynamic 
B)  relative 
C)  absolute 
D)  integrated 
A)  dynamic 
B)  relative 
C)  absolute 
D)  integrated

Question 17

Excel copies page setup characteristics when one sheet is copied to another.

Accepted Answer

A) True 
 B)False

Question 18

The following sequence,1,1,1,etc.,is an example of a(n)____ series.

Accepted Answer

A)  date 
B)  growth 
C)  auto fill 
D)  linear 
A)  date 
B)  growth 
C)  auto fill 
D)  linear

Question 19

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Accepted Answer

A)  Accounting 
B)  Custom 
C)  General 
D)  Number 
A)  Accounting 
B)  Custom 
C)  General 
D)  Number

Question 20

Which of the following is a method of electronic document distribution?

Accepted Answer

A)  posting on OneDrive 
B)  sharing an XPS image of a document 
C)  blog posting 
D)  posting on a social networking site 
A)  posting on OneDrive 
B)  sharing an XPS image of a document 
C)  blog posting 
D)  posting on a social networking site

You can drill all of the following down through a workbook EXCEPT ____.

The result of an arithmetic operation,such as multiplication or division,is accurate to the factor with the least number of decimal places.

To select nonadjacent sheets,select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

A range that spans two or more worksheets in a workbook is called a ____ range.

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

By default,Excel places charts in the center of the worksheet.t.

A(n)____ reference is a formula that depends on its own value.

The following sequence,Jan,Feb,Mar,etc.,is an example of a ____ series.

If you are summing numbers on noncontiguous sheets,hold down the SHIFT key rather than the CTRL key when selecting the sheets.

Which of the following is the path to the Switch Windows button?

When tiling windows vertically the windows appear as wide as possible._________________________

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

The following sequence,2,4,6,etc.,is an example of a ____ series.

____ format codes allow you to specify how a cell entry assigned a format will appear.

The system date might be displayed as a series of number signs if the date,as initially formatted by Excel,does not fit in the width of the cell.

As you link workbooks,the cell reference inserted by Excel each time you click a cell in a workbook results in a(n)____ cell reference.

Excel copies page setup characteristics when one sheet is copied to another.

The following sequence,1,1,1,etc.,is an example of a(n)____ series.

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Which of the following is a method of electronic document distribution?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

You can drill all of the following down through a workbook EXCEPT ____.

The result of an arithmetic operation,such as multiplication or division,is accurate to the factor with the least number of decimal places.

To select nonadjacent sheets,select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

A range that spans two or more worksheets in a workbook is called a ____ range.

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

By default,Excel places charts in the center of the worksheet.t.​

A(n)____ reference is a formula that depends on its own value.

The following sequence,Jan,Feb,Mar,etc.,is an example of a ____ series.

If you are summing numbers on noncontiguous sheets,hold down the SHIFT key rather than the CTRL key when selecting the sheets.

Which of the following is the path to the Switch Windows button?

When tiling windows vertically the windows appear as wide as possible._________________________

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

The following sequence,2,4,6,etc.,is an example of a ____ series.

____ format codes allow you to specify how a cell entry assigned a format will appear.

The system date might be displayed as a series of number signs if the date,as initially formatted by Excel,does not fit in the width of the cell.

As you link workbooks,the cell reference inserted by Excel each time you click a cell in a workbook results in a(n)____ cell reference.

Excel copies page setup characteristics when one sheet is copied to another.

The following sequence,1,1,1,etc.,is an example of a(n)____ series.

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Which of the following is a method of electronic document distribution?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

By default,Excel places charts in the center of the worksheet.t.