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

To paste a data range so that column data appears in rows and row data appears in columns,you can _____ the data using the Paste list arrow.

Which of these series of clicks will you use to promote a shape in an Excel sheet?

To view a worksheet without gridlines showing on the screen,which of the following would you uncheck?

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.

Johnson doesn't like the organization of information in a SmartArt graphic and wants to change its layout to fit the content better.To do so,he follows this series of clicks: SmartArt graphic > Design tab > X > More drop-down menu > Select layout of choice.Which of the following can X be?

Which of these series of clicks will you select to add text to a SmartArt?

Issac wants to add a border to a picture in a worksheet.To do so,he clicks the following series: Picture > X > Arrow next to Picture Border > Select color of choice.Which of these can X be in the following series of clicks?

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.

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?

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/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?

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?

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?

Misha wants to set the brightness of a picture to 40% and contrast to 20%.She clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should she select from the drop-down menu that appears on clicking Corrections and then select the thumbnail that fulfils her purpose?

How can you add a new picture to a SmartArt graphic?

You can create conditional cell formats using either the Home tab or the _____.

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.

Which of these series of clicks will you select to import a text file by opening it in Excel?

Kyler wants to add an outer shadow to a picture in his worksheet.He clicks on the picture,then clicks Picture Effects on Format tab under Picture Tools.What should he do next to fulfil his purpose?

Smith creates a basic cycle graphic with five shapes and then decides to add a sixth one below it.To do this,he clicks the down arrow to the right of the Add Shape button on the SmartArt Tools under Design tab,and then selects an option from the menu to finish the task.Which of these must he have selected from the menu options?