Question 1

To preserve an exact cell address in a copied formula,you can use a relative cell reference.

Accepted Answer

A) True 
 B)False

Question 2

How can you remove data labels from a chart?

Accepted Answer

A)  Uncheck the box beside Data Labels in Chart Elements. 
B)  Click on Remove on the options on the right side of Data Labels. 
C)  Click on Delete on the options on the right side of Data Labels. 
D)  Click to select the Data labels,then click on Edit and then Delete. 
A)  Uncheck the box beside Data Labels in Chart Elements. 
B)  Click on Remove on the options on the right side of Data Labels. 
C)  Click on Delete on the options on the right side of Data Labels. 
D)  Click to select the Data labels,then click on Edit and then Delete.

Question 3

The Clipboard task pane shows the contents of the _____.

Accepted Answer

A)  Office Clipboard 
B)  Table Styles gallery 
C)  Quick Analysis tool 
D)  Recently-Used Add-Ins 
A)  Office Clipboard 
B)  Table Styles gallery 
C)  Quick Analysis tool 
D)  Recently-Used Add-Ins

Question 4

To copy a cell's formatting to another cell,which of the following can you use?

Accepted Answer

A)  Format Cells dialog box 
B)  Format Painter 
C)  Quick Analysis Tool 
D)  Format as Table 
A)  Format Cells dialog box 
B)  Format Painter 
C)  Quick Analysis Tool 
D)  Format as Table

Question 5

To move a worksheet,you can drag its sheet tab to the left or right.

Accepted Answer

A) True 
 B)False

Question 6

Sala wants to unfreeze the first column of his worksheet.Which of the following series of clicks will help him do so?

Accepted Answer

A)  View tab > Windows group > Freeze Panes > Unfreeze Panes 
B)  View tab > Windows group > Freeze Panes > Freeze Top Column > Arrange All 
C)  View tab > Windows group > Freeze Panes > Unfreeze Panes> Arrange All 
D)  View tab > Windows group > Freeze Panes > Freeze First Column > Unfreeze Panes 
A)  View tab > Windows group > Freeze Panes > Unfreeze Panes 
B)  View tab > Windows group > Freeze Panes > Freeze Top Column > Arrange All 
C)  View tab > Windows group > Freeze Panes > Unfreeze Panes> Arrange All 
D)  View tab > Windows group > Freeze Panes > Freeze First Column > Unfreeze Panes

Question 7

Bart needs to apply a sparkline style to a sparkline chart.To do so,he can click on the following: Sparkline chart > Design > Style (choose a style).

Accepted Answer

A) True 
 B)False

Question 8

Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+)sign > Arrow next to Chart title > X?

Accepted Answer

A)  Above Chart 
B)  Over Chart 
C)  Below Chart 
D)  Centered Overlay 
A)  Above Chart 
B)  Over Chart 
C)  Below Chart 
D)  Centered Overlay

Question 9

Penina wants to insert markers into a sparkline chart.To do so,she can click on the following: Sparkline chart > Design > Line > Markers check box.

Accepted Answer

A) True 
 B)False

Question 10

To rotate cell contents,you use the Alignment tab in the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 11

To insert the current date in cell B1,type CURRENT DATE in cell A1 and NOW()in cell B1 and press ENTER.

Accepted Answer

A) True 
 B)False

Question 12

A students wants to insert a column sparkline in Excel.To do this,she can click on the cell she wants to insert a Sparkline,then click Insert tab,select the Sparkline type of choice from the Sparklines group and then select OK.

Accepted Answer

A) True 
 B)False

Question 13

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.

Accepted Answer

A) True 
 B)False

Question 14

Why is it necessary to use care when inserting worksheet cells?

Accepted Answer

A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment,which can affect worksheet accuracy. 
A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment,which can affect worksheet accuracy.

Question 15

Your worksheet contains a price in cell A5,and many formulas refer to that price.How would you refer to that price in the formulas?

Accepted Answer

A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5 
A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5

Question 16

Arrow keys can be used to move any chart element.

Accepted Answer

A) True 
 B)False

Question 17

Decreasing a cell's indent moves its contents to the right one space.

Accepted Answer

A) True 
 B)False

Question 18

To delete a worksheet column,you can first select it by _____.

Accepted Answer

A)  clicking the column heading 
B)  double-clicking the column heading 
C)  clicking anywhere in the column 
D)  double-clicking anywhere in the column 
A)  clicking the column heading 
B)  double-clicking the column heading 
C)  clicking anywhere in the column 
D)  double-clicking anywhere in the column

Question 19

To select nonadjacent cells or ranges on a worksheet,you can press and hold _____ while selecting each one.

Accepted Answer

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

Question 20

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?

Accepted Answer

A)  Select the column to the left of the page break you want to delete. 
B)  Select the column to the right of the page break you want to delete. 
C)  Select the row above the page break you want to delete. 
D)  Select the row below the page break you want to delete. 
A)  Select the column to the left of the page break you want to delete. 
B)  Select the column to the right of the page break you want to delete. 
C)  Select the row above the page break you want to delete. 
D)  Select the row below the page break you want to delete.

To preserve an exact cell address in a copied formula,you can use a relative cell reference.

How can you remove data labels from a chart?

The Clipboard task pane shows the contents of the _____.

To copy a cell's formatting to another cell,which of the following can you use?

To move a worksheet,you can drag its sheet tab to the left or right.

Sala wants to unfreeze the first column of his worksheet.Which of the following series of clicks will help him do so?

Bart needs to apply a sparkline style to a sparkline chart.To do so,he can click on the following: Sparkline chart > Design > Style (choose a style).

Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+)sign > Arrow next to Chart title > X?

Penina wants to insert markers into a sparkline chart.To do so,she can click on the following: Sparkline chart > Design > Line > Markers check box.

To rotate cell contents,you use the Alignment tab in the Format Cells dialog box.

To insert the current date in cell B1,type CURRENT DATE in cell A1 and NOW()in cell B1 and press ENTER.

A students wants to insert a column sparkline in Excel.To do this,she can click on the cell she wants to insert a Sparkline,then click Insert tab,select the Sparkline type of choice from the Sparklines group and then select OK.

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.

Why is it necessary to use care when inserting worksheet cells?

Your worksheet contains a price in cell A5,and many formulas refer to that price.How would you refer to that price in the formulas?

Arrow keys can be used to move any chart element.

Decreasing a cell's indent moves its contents to the right one space.

To delete a worksheet column,you can first select it by _____.

To select nonadjacent cells or ranges on a worksheet,you can press and hold _____ while selecting each one.

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

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

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 3: Working With Large Worksheets, charting, and What-If Analysis

To preserve an exact cell address in a copied formula,you can use a relative cell reference.

How can you remove data labels from a chart?

The Clipboard task pane shows the contents of the _____.

To copy a cell's formatting to another cell,which of the following can you use?

To move a worksheet,you can drag its sheet tab to the left or right.

Sala wants to unfreeze the first column of his worksheet.Which of the following series of clicks will help him do so?

Bart needs to apply a sparkline style to a sparkline chart.To do so,he can click on the following: Sparkline chart > Design > Style (choose a style).

Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+)sign > Arrow next to Chart title > X?

Penina wants to insert markers into a sparkline chart.To do so,she can click on the following: Sparkline chart > Design > Line > Markers check box.

To rotate cell contents,you use the Alignment tab in the Format Cells dialog box.

To insert the current date in cell B1,type CURRENT DATE in cell A1 and NOW()in cell B1 and press ENTER.

A students wants to insert a column sparkline in Excel.To do this,she can click on the cell she wants to insert a Sparkline,then click Insert tab,select the Sparkline type of choice from the Sparklines group and then select OK.

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.

Why is it necessary to use care when inserting worksheet cells?

Your worksheet contains a price in cell A5,and many formulas refer to that price.How would you refer to that price in the formulas?

Arrow keys can be used to move any chart element.

Decreasing a cell's indent moves its contents to the right one space.

To delete a worksheet column,you can first select it by _____.

To select nonadjacent cells or ranges on a worksheet,you can press and hold _____ while selecting each one.

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

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

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters