Question 1

You can press Ctrl+F11 to update a linked object from another app.

Accepted Answer

A) True 
 B)False  False

Question 2

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?

Accepted Answer

A)  Data tab 
B)  View tab 
C)  Insert tab 
D)  Page Layout tab 
A)  Data tab 
B)  View tab 
C)  Insert tab 
D)  Page Layout tab C

Question 3

You want to change all worksheet occurrences of "Radio" to "TV"; to do this,you can use the _____ feature.

Accepted Answer

A)  Find and Replace 
B)  Locate and Replace 
C)  Edit and Find 
D)  Find and Edit 
A)  Find and Replace 
B)  Locate and Replace 
C)  Edit and Find 
D)  Find and Edit A

Question 4

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?

Accepted Answer

A)  Right-click and select Insert from the drop-down menu,and pick Table Rows Above. 
B)  Right-click and select Insert from the drop-down menu,and pick Table Rows Below. 
C)  Click on the Design tab in the Tools group,and then click Remove Duplicates. 
D)  Click on the Design tab in the Tools group,and then click Remove Duplicates 
A)  Right-click and select Insert from the drop-down menu,and pick Table Rows Above. 
B)  Right-click and select Insert from the drop-down menu,and pick Table Rows Below. 
C)  Click on the Design tab in the Tools group,and then click Remove Duplicates. 
D)  Click on the Design tab in the Tools group,and then click Remove Duplicates

Question 5

Which of the following steps will you take to demote a shape on your spreadsheet?

Accepted Answer

A)  With the insertion point in the task pane,press Shift+Tab keys. 
B)  Click the Insert a SmartArt Graphic command in a placeholder. 
C)  With the insertion point in the task pane,press the Tab key. 
D)  Select the shape,click the Convert command on Design tab and select Convert to Text. 
A)  With the insertion point in the task pane,press Shift+Tab keys. 
B)  Click the Insert a SmartArt Graphic command in a placeholder. 
C)  With the insertion point in the task pane,press the Tab key. 
D)  Select the shape,click the Convert command on Design tab and select Convert to Text.

Question 6

Jenny wants to change the style of a SmartArt in her worksheet.To do so,she clicks the shape in the SmartArt graphic.She then clicks on an option under SmartArt Tools,on the Format tab,in the Shape Styles group and then selects the thumbnail she wants.What can the option that she selected under SmartArt Tools be?

Accepted Answer

A)  Shape Fill 
B)  Change Colors 
C)  Shape Outline 
D)  Shape Effects 
A)  Shape Fill 
B)  Change Colors 
C)  Shape Outline 
D)  Shape Effects

Question 7

To change the text fill color of WordArt,we need to select the WordArt text,click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Accepted Answer

A) True 
 B)False

Question 8

Margaret wants to resize a shape in a SmartArt graphic in her worksheet proportionally.To do so,she selects the shapes in the shape in the SmartArt graphic to modify and clicks the Format tab under SmartArt Tools.What should she do next to resize the object proportionally?

Accepted Answer

A)  Drag a middle handle. 
B)  Drag a corner handle. 
C)  Click the Edit in 2-D button. 
D)  Click the Size button and enter the size she wants. 
A)  Drag a middle handle. 
B)  Drag a corner handle. 
C)  Click the Edit in 2-D button. 
D)  Click the Size button and enter the size she wants.

Question 9

Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X?

Accepted Answer

A)  Shape Fill 
B)  Shape Outline 
C)  Shape Effects 
D)  Shape Borders 
A)  Shape Fill 
B)  Shape Outline 
C)  Shape Effects 
D)  Shape Borders

Question 10

Colin wants to apply a Quick Style to a SmartArt graphic.To do so,he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice.Which of these can X be in the following series of clicks?

Accepted Answer

A)  Insert tab 
B)  Format tab 
C)  Design tab 
D)  Review tab 
A)  Insert tab 
B)  Format tab 
C)  Design tab 
D)  Review tab

Question 11

Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet.He clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should Stephen select from the drop down menu that appears on clicking Corrections?

Accepted Answer

A)  Color Tone 
B)  Sharpen/Soften 
C)  Color Saturation 
D)  Brightness/Contrast 
A)  Color Tone 
B)  Sharpen/Soften 
C)  Color Saturation 
D)  Brightness/Contrast

Question 12

To insert an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

Accepted Answer

A) True 
 B)False

Question 13

Linda wants to change the color of the SmartArt that she has used in her spreadsheet.To do so,she clicks on the shape in the SmartArt graphic.She then clicks on the arrow next to Shape Fill under Drawing Tools,on the Format tab,in the Shape Styles group.Linda then selects an option from the menu that appears,and under the Colors Dialog box and Standard,she chooses the color she wants the SmartArt to be and clicks OK.What can the option that she selected from the menu under Shape Fill be?

Accepted Answer

A)  No Fill 
B)  Theme Colors 
C)  Standard Colors 
D)  More Fill Colors 
A)  No Fill 
B)  Theme Colors 
C)  Standard Colors 
D)  More Fill Colors

Question 14

Which of the following lets you resize a selected picture on your worksheet?

Accepted Answer

A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture. 
A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture.

Question 15

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?

Accepted Answer

A)  Click the thumbnail image of the window whose screenshot he wants to insert. 
B)  Click Screen Clipping,then press and hold the left mouse button to drag and capture the window screen. 
C)  Select a thumbnail of the required window,then press and hold the left mouse button to drag and capture the window screen. 
D)  Click Screen Clipping,and when the pointer becomes a hand icon,capture the window screen. 
A)  Click the thumbnail image of the window whose screenshot he wants to insert. 
B)  Click Screen Clipping,then press and hold the left mouse button to drag and capture the window screen. 
C)  Select a thumbnail of the required window,then press and hold the left mouse button to drag and capture the window screen. 
D)  Click Screen Clipping,and when the pointer becomes a hand icon,capture the window screen.

Question 16

Avril wants to link worksheet data to a Word document so that whenever the worksheet is updated,the changes are updated in the document.To do so,she should open the Excel worksheet and drag over the content and press Ctrl+C.Next she should move to the Word file,Place the insertion point where she wants the worksheet data to appear and press Ctrl + V.

Accepted Answer

A) True 
 B)False

Question 17

Jada types out full names of students in her class in a single column,with a comma and a space between the first and the last name.She now wants to split the first and the last names into two columns.To do so,she clicks on the Text to Columns option on the Data tab in the Data Tools group.In the dialog box that appears,Jada chooses an option and clicks Next.She then clears all the check boxes under the selected option except for the Comma and Space check box and clicks Finish.Which of these can be the option Jada selected in the dialog box?

Accepted Answer

A)  Delimited 
B)  Fixed Width 
C)  Fixed Length 
D)  Data Preview 
A)  Delimited 
B)  Fixed Width 
C)  Fixed Length 
D)  Data Preview

Question 18

Amari wants to paint the format of one object onto a target object.She selects the first object,then clicks on Format Painter,on the Clipboard group in the Home tab.She then observes the cursor change to a specific icon.Which of the following is the icon into which the cursor changed?

Accepted Answer

A)  Hand 
B)  Blackbox 
C)  Paintbrush 
D)  Underscore 
A)  Hand 
B)  Blackbox 
C)  Paintbrush 
D)  Underscore

Question 19

Alicia has already created a chart in Excel and wants to link it to her PowerPoint presentation.To do so,she can click Insert tab > Symbols group > Object command > (Dialog box > Create New > Locate desired file > Insert > OK > Tick box next to Link to file > OK.

Accepted Answer

A) True 
 B)False

Question 20

To create a workbook containing text,formulas,macros,and formatting that you use repeatedly,you create a _____.

Accepted Answer

A)  master 
B)  model 
C)  template 
D)  standard 
A)  master 
B)  model 
C)  template 
D)  standard

You can press Ctrl+F11 to update a linked object from another app.

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?

You want to change all worksheet occurrences of "Radio" to "TV"; to do this,you can use the _____ feature.

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?

Which of the following steps will you take to demote a shape on your spreadsheet?

To change the text fill color of WordArt,we need to select the WordArt text,click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Margaret wants to resize a shape in a SmartArt graphic in her worksheet proportionally.To do so,she selects the shapes in the shape in the SmartArt graphic to modify and clicks the Format tab under SmartArt Tools.What should she do next to resize the object proportionally?

Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X?

Colin wants to apply a Quick Style to a SmartArt graphic.To do so,he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice.Which of these can X be in the following series of clicks?

Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet.He clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should Stephen select from the drop down menu that appears on clicking Corrections?

To insert an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

Which of the following lets you resize a selected picture on your worksheet?

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?

Amari wants to paint the format of one object onto a target object.She selects the first object,then clicks on Format Painter,on the Clipboard group in the Home tab.She then observes the cursor change to a specific icon.Which of the following is the icon into which the cursor changed?

Alicia has already created a chart in Excel and wants to link it to her PowerPoint presentation.To do so,she can click Insert tab > Symbols group > Object command > (Dialog box > Create New > Locate desired file > Insert > OK > Tick box next to Link to file > OK.

To create a workbook containing text,formulas,macros,and formatting that you use repeatedly,you create a _____.

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

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

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 7: Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

You can press Ctrl+F11 to update a linked object from another app.

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?

You want to change all worksheet occurrences of "Radio" to "TV"; to do this,you can use the _____ feature.

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?

Which of the following steps will you take to demote a shape on your spreadsheet?

To change the text fill color of WordArt,we need to select the WordArt text,click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Margaret wants to resize a shape in a SmartArt graphic in her worksheet proportionally.To do so,she selects the shapes in the shape in the SmartArt graphic to modify and clicks the Format tab under SmartArt Tools.What should she do next to resize the object proportionally?

Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X?

Colin wants to apply a Quick Style to a SmartArt graphic.To do so,he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice.Which of these can X be in the following series of clicks?

Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet.He clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should Stephen select from the drop down menu that appears on clicking Corrections?

To insert an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

Which of the following lets you resize a selected picture on your worksheet?

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?

Amari wants to paint the format of one object onto a target object.She selects the first object,then clicks on Format Painter,on the Clipboard group in the Home tab.She then observes the cursor change to a specific icon.Which of the following is the icon into which the cursor changed?

Alicia has already created a chart in Excel and wants to link it to her PowerPoint presentation.To do so,she can click Insert tab > Symbols group > Object command > (Dialog box > Create New > Locate desired file > Insert > OK > Tick box next to Link to file > OK.

To create a workbook containing text,formulas,macros,and formatting that you use repeatedly,you create a _____.

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

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

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