Question 1

Which of the following fill actions can you perform by dragging the fill handle?

Accepted Answer

A)  Jan, Feb, March, etc. 
B)  1, 1, 1, etc. 
C)  2, 4, 6, etc. 
D)  1, 2, 3, etc. 
E)  None of the above 
A)  Jan, Feb, March, etc. 
B)  1, 1, 1, etc. 
C)  2, 4, 6, etc. 
D)  1, 2, 3, etc. 
E)  None of the above

Question 2

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area for numbers or formulas, but use the format of the destination area for text.

Accepted Answer

Values & N

Question 3

When should you use the ROUND function?

Accepted Answer

When you multiply or divide decimal numb

Question 4

When you consider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Accepted Answer

A) True 
 B)False

Question 5

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 6

You should create good ____ to ensure your workbooks are free of errors.

Accepted Answer

A)  color contrast 
B)  range boundaries 
C)  test data 
D)  none of the above 
A)  color contrast 
B)  range boundaries 
C)  test data 
D)  none of the above

Question 7

Case 5-1
Louie is designing a complex worksheet and needs to format cells containing numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips.
-You suggest to Louie that he ____.

Accepted Answer

A)  apply the built-in format or style that he likes the best; it is impossible to create or modify number formats 
B)  create and assign a custom format code using the Format Code category in the Number tab in the Create Code dialog box 
C)  create and assign a custom format code using the Custom category in the Number tab in the Format Cells dialog box 
D)  apply a different theme to the worksheet 
A)  apply the built-in format or style that he likes the best; it is impossible to create or modify number formats 
B)  create and assign a custom format code using the Format Code category in the Number tab in the Create Code dialog box 
C)  create and assign a custom format code using the Custom category in the Number tab in the Format Cells dialog box 
D)  apply a different theme to the worksheet

Question 8

You can press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

Accepted Answer

The answer of You can press and hold or right-click...

Question 9

When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Accepted Answer

A) True 
 B)False

Question 10

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

Accepted Answer

A)  DATE 
B)  ROUND 
C)  SUM 
D)  IF 
A)  DATE 
B)  ROUND 
C)  SUM 
D)  IF

Question 11

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.

Accepted Answer

A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V 
A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V

Question 12

A ____ is a reference to a cell or range of cells in another workbook.

Accepted Answer

A)  code 
B)  link 
C)  function 
D)  formula 
A)  code 
B)  link 
C)  function 
D)  formula

Question 13

Among the Paste Gallery commands, the ____________________ option will copy the contents and format of a source area but not any borders.

Accepted Answer

The answer of Among the Paste Gallery commands, the ____________________...

Question 14

A(n) ____________________ is a series of format symbols that defines how a cell entry assigned a format will appear.

Accepted Answer

The answer of A(n) ____________________ is a series of format...

Question 15

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________.

Accepted Answer

drilling a

Question 16

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

Accepted Answer

A)  style 
B)  workbook name 
C)  location 
D)  sheet name 
A)  style 
B)  workbook name 
C)  location 
D)  sheet name

Question 17

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

Accepted Answer

A) True 
 B)False

Question 18

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ that show the boundaries of what will print on each page.

Accepted Answer

A)  margins 
B)  selection barriers 
C)  indices 
D)  page breaks 
A)  margins 
B)  selection barriers 
C)  indices 
D)  page breaks

Question 19

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

Accepted Answer

A)  F5 
B)  F6 
C)  F11 
D)  F12 
A)  F5 
B)  F6 
C)  F11 
D)  F12

Question 20

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group) to display the Colors gallery.

Accepted Answer

The answer of You can tap or click the ____________________...

Which of the following fill actions can you perform by dragging the fill handle?

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area for numbers or formulas, but use the format of the destination area for text.

When should you use the ROUND function?

When you consider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

You should create good ____ to ensure your workbooks are free of errors.

Case 5-1 Louie is designing a complex worksheet and needs to format cells containing numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. -You suggest to Louie that he ____.

You can press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.

A ____ is a reference to a cell or range of cells in another workbook.

Among the Paste Gallery commands, the ____________________ option will copy the contents and format of a source area but not any borders.

A(n) ____________________ is a series of format symbols that defines how a cell entry assigned a format will appear.

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________.

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ that show the boundaries of what will print on each page.

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group) to display the Colors gallery.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

Filters

Exam 6: Financial Functions, Data Tables, and Amortization Schedules

Which of the following fill actions can you perform by dragging the fill handle?

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area for numbers or formulas, but use the format of the destination area for text.

When should you use the ROUND function?

When you consider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

You should create good ____ to ensure your workbooks are free of errors.

Case 5-1 Louie is designing a complex worksheet and needs to format cells containing numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. -You suggest to Louie that he ____.

You can press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.

A ____ is a reference to a cell or range of cells in another workbook.

Among the Paste Gallery commands, the ____________________ option will copy the contents and format of a source area but not any borders.

A(n) ____________________ is a series of format symbols that defines how a cell entry assigned a format will appear.

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________.

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ that show the boundaries of what will print on each page.

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group) to display the Colors gallery.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

Filters