Question 1

Which of the following will you select as X in the following series of clicks to apply a shadow effect: (Double-click)Text box > Format Options > Text Options > X > Shadow?
A) Text Fill & Outline
B) Text Effects
C) Text Box
D) Size & Properties

Accepted Answer

The Shadow effect falls under Text Effects, so option B is the correct choice. Text Fill & Outline deals with the color and style of the text, Text Box deals with resizing and positioning the text box, and Size & Properties deals with adjusting the dimensions and properties of the text box.

Question 2

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

This is the correct process for inserting an object from another application.

Question 3

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box)Show Data table?
A) Layout
B) Design
C) Format
D) Kutools

Accepted Answer

From the given options, the correct choice to click on after selecting Chart Tools is Layout. The data table option to select is under the Layout tab, and selecting it will display the table on the chart. Therefore, the correct series of clicks would be: Data Chart > Chart Tools > Layout > Data table > (Select check box)Show Data table.

Question 4

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

Accepted Answer

The answer of To embed an object from another application,click...

Question 5

While moving a picture in Excel,one can select it and hover the mouse over it until the pointer changes into a particular shape,then click the image and drag it to the required location.What is the shape into which the mouse pointer changes during this procedure?
A) Hand
B) Circle
C) Two-headed arrow
D) Four-headed arrow

Accepted Answer

The mouse pointer changes into a four-headed arrow when you hover over a picture in Excel and are able to move it. This indicates that you can click and drag the picture in any direction.

Question 6

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

While the described steps will copy and paste the content from Excel to Word, it does not create a dynamic link that updates the Word document automatically when the Excel worksheet is updated. For that, Avril should use the "Paste Special" feature and choose "Paste link" to ensure the data updates dynamically.

Question 7

Kimani is working on a data set in which she has to add pictures into cells adjacent to the respective names of objects in her file.To do so,she clicks on the following series: Insert tab > X > Pictures > Insert Picture dialog box > Locate the picture that she wants to insert into a cell in Excel > Insert > Format tab > Y > Edit height and width to fit into cell > Place picture into cell.What can X and Y in the series of clicks/entries be?
A) Apps group,Arrange group
B) Illustrations group,Size group
C) Sparklines group,Adjust group
D) Charts group,Picture Styles group

Accepted Answer

In the series of clicks, Kimani is trying to insert a picture into a cell in Excel and then format it to fit into the cell. The correct option for X is the 'Pictures' option under the 'Illustrations' group which allows her to browse and locate the picture that she wants to insert. For Y, the 'Size' group under the 'Format' tab provides options to edit the height and width of the picture and adjust it to fit into the cell. Therefore, the best choice is B, Illustrations group for X and Size group for Y.

Question 8

Tyler wants to add SmartArt graphic to his file to make a visual representation of information in his file.He clicks/selects the following series to do so: Insert tab > Illustrations group > SmartArt > X > Select the type and layout of choice.What can X in this series of clicks/ selections be?
A) Stars and Banners
B) Screen Clipping
C) Recently Used Shapes
D) Choose a SmartArt Graphic dialog box

Accepted Answer

X in this series of clicks/selections should be "Choose a SmartArt Graphic dialog box". This option will allow Tyler to select the type and layout of the SmartArt graphic he wants to add to his file.

Question 9

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?
A) Shape Fill
B) Shape Effects
C) Shape Outline
D) More button

Accepted Answer

To apply a shape style in most graphic or office software, you typically need to access a broader selection of styles than what's immediately visible. The "More button" (often represented by a small arrow or a drop-down icon) within the "Shape Styles" group allows you to view and select from additional styles not immediately displayed in the ribbon or toolbar.

Question 10

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?
A) Shape Fill
B) Shape Outline
C) Shape Effects
D) Shape Borders

Accepted Answer

The question asks for the selection of X in the following series of clicks. The options listed after "Shape Styles" are the various types of formatting that can be applied to a chart element. Among them, "Shape Fill" is the option that allows you to apply the desired fill color or pattern to the selected shape.

Question 11

Pam wants to break the link to the external reference of a formula so that all its values are replaced by the calculated values.To do so,she can click Data Tab > Queries & Connections Group > Edit Links button > Edit Links dialog box > Break Link button.

Accepted Answer

This is the correct process to break the link to an external reference in Excel.

Question 12

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

Accepted Answer

The correct shortcut to update a linked object from another app in Microsoft Office applications is usually Alt+F9, not Ctrl+F11. Ctrl+F11 is often used to lock a field in Microsoft Word.

Question 13

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?
A) Data tab
B) View tab
C) Insert tab
D) Page Layout tab

Accepted Answer

The Insert tab is the correct choice as it contains the Charts group where the Recommended Charts option is located.

Question 14

Kathy wants to add the numbers entered in a range of selected cells.To do this,which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?
A) Sum
B) Count
C) Average
D) %Total

Accepted Answer

The Sum option will add up the numbers entered in a range of selected cells, which is what Kathy wants to do. The Count option will count the number of cells with numeric values, while the Average option will calculate the average of the numbers entered. The %Total option will calculate the percentage of each cell value in relation to the total.

Question 15

Sophia wants to change the location of a picture linked to her workbook to a different drive.To do so,she can click on the following series: Data tab > Edit links group > Select link to change > Change Source > Change Source Dialog box > Use controls in the dialog box to locate and select the file for new source of the link > Open > OK.

Accepted Answer

Sophia should follow this series to change the location of a linked picture in her workbook: Right-click on the picture > Link Options > Change Source, or for changing links to external data sources (not specifically pictures), she would use: Data tab > Edit Links > Change Source. The detailed path provided mixes steps for changing external data links, not specifically for changing the location of a linked picture.

Question 16

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

The correct way to link an Excel chart to a PowerPoint presentation is to first copy the chart in Excel, then in PowerPoint, click on the slide where you want to insert the chart, and choose Home tab > Clipboard group > Paste command > Choose the option to "Link Data" or "Link Chart" depending on the version of PowerPoint. The steps mentioned in the question are not accurate.

Question 17

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?
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.

Accepted Answer

When the Available windows gallery appears, Ernie should click on the thumbnail image of the window whose screenshot he wants to insert. This will select the window and automatically insert the screenshot into his document.

Question 18

To edit an embedded object such as an Excel spreadsheet in its source application,double-click the drawer ID of the appropriate drawer in the Folders window,then double-click the folder containing the Excel spreadsheet,highlight it,choose Object > Edit Object to enter edit mode and make desired changes in it.

Accepted Answer

This is the correct process for editing an embedded object in its source application.

Question 19

Which of the following will you select as X in the following series of clicks/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?
A) Ctrl + W
B) Ctrl + R
C) Ctrl + Z
D) Ctrl + Q

Accepted Answer

Quick Analysis tool can be opened with the shortcut key Ctrl + Q, which will allow the user to select the range of cells and then insert a chart by clicking on the "Charts" option.

Question 20

Jacob wants to import a table from an Access database and put it into a workbook to organize it for a presentation.To do so,he opens a new workbook in Excel,clicks on the Data tab,then clicks on X under Get External Data.He then browses to the location of the database he wants to import and selects the table.He then selects the appearance of the data in the workbook,chooses the cell where he wants it to start,and finally clicks OK.What can X in the series of clicks be?
A) From Text
B) From Web
C) Form Access
D) From Other Sources

Accepted Answer

To import a table from an Access database into Excel, the correct option is "From Access," which allows Excel to connect to an Access database and import data directly.

Quiz 7: Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Which of the following will you select as X in the following series of clicks to apply a shadow effect: (Double-click) Text box > Format Options > Text Options > X > Shadow?

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 will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box) Show Data table?

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

While moving a picture in Excel,one can select it and hover the mouse over it until the pointer changes into a particular shape,then click the image and drag it to the required location.What is the shape into which the mouse pointer changes during this procedure?

Tyler wants to add SmartArt graphic to his file to make a visual representation of information in his file.He clicks/selects the following series to do so: Insert tab > Illustrations group > SmartArt > X > Select the type and layout of choice.What can X in this series of clicks/ selections be?

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice) ?

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?

Pam wants to break the link to the external reference of a formula so that all its values are replaced by the calculated values.To do so,she can click Data Tab > Queries & Connections Group > Edit Links button > Edit Links dialog box > Break Link button.

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?

Kathy wants to add the numbers entered in a range of selected cells.To do this,which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

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.

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?

Which of the following will you select as X in the following series of clicks/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?