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

Question 1

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?

A) Add Shape After
B) Add Shape Before
C) Add Shape Under
D) Add Shape Below

Answer 1

D

Question 2

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?

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

Answer 2

B

Question 3

Braydon wants to sharpen a picture to the maximum limit to make it more appealing.He clicks on the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should he select from the drop-down menu that appears on clicking Sharpen/Soften?

A) Select the left-most thumbnail.
B) Select the thumbnail at the top.
C) Select the right-most thumbnail.
D) Select the thumbnail at the bottom.

Answer 3

C

Question 4

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

A) Insert tab > Illustrations group > Online Pictures > Insert pictures > Select from menu > [Text] in Text pane > Type text
B) Insert tab > Illustrations group > SmartArt > Choose a SmartArt Graphic dialog box > Select type and layout >[Text] in Text pane > Type text
C) Insert tab > Illustrations group > Shapes > Recently used shapes > Select type and layout > [Text] in Text pane > Type text
D) Insert tab > Illustrations group > Take a Screenshot > Available Windows > Select from the menu > [Text] in Text pane > Type text

Question 5

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

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

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?

A) Select Shadow from the drop-down menu,then under Inner,select the effect she wants.
B) Select Shadow from the drop-down menu,then under Outer,select the effect she wants.
C) Select Shadow from the drop-down menu,then under No Shadow,select the effect she wants.
D) Select Shadow from the drop-down menu,then under Perspective,select the effect she wants.

Question 7

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

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 8

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

A) File > Open > Open Dialog box > Text files > Locate and double-click the text file you want to open > Finish
B) File > Save As > Save As dialog box > Save As type box > click Text (Tab delimited)or CSV (Comma delimited)> Browse to location where you want to save the new text file > Save.
C) Cell to insert data from the text file >Data tab > Get External Data > From Text/CSV > Locate and double-click the text file that you want to import > Finish > Import data dialog box > Where do you want to put the data? > New Worksheet > OK
D) Cell to insert data from the text file >Data tab > Get External Data > From Text/CSV > Locate and double-click the text file that you want to import > Finish > Import data dialog box > Properties > Select formatting,and layout options for the imported data > Ok

Question 9

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?

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

Question 10

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?

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

Question 11

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?

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

Question 12

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?

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

Question 13

Brielle wants to increase the size of a SmartArt graphic in her worksheet.To do so,she clicks the following series: Shape > Format tab > SmartArt tools .What should she do next to resize the object proportionally?

A) Drag a middle handle.
B) Click the Larger button.
C) Click the Edit in 2-D button.
D) Click the Arrange button and select a arrange button options.

Question 14

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

A) Click the SmartArt button on the Insert tab,then click Picture,click a layout,and then click OK.
B) Select a picture,click the Picture Layout button on the Format tab under Picture Tools,and then select a layout.
C) Select a picture,click the Insert tab under Picture Tools,click the Insert Picture,and then select a layout.
D) Under SmartArt Tools,click the Design tab,then click the Add Shape button arrow,and then select the picture you want to add.

Question 15

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?

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

Question 16

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?

A) Layouts group
B) Illustrations group
C) SmartStyles group
D) Create Graphic group

Question 17

Olivia wants to align a certain shape on her worksheet in a specific manner.To do so,she clicks on the shape,and then clicks on the Format tab under Drawing Tools.She then clicks on Align in the Arrange group.What should Olivia click on next to align the picture to the left?

A) Align Top
B) Align Left
C) Align Center
D) Align Bottom

Question 18

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?

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 19

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?

A) Size
B) Adjust
C) Arrange
D) Picture Styles

Question 20

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?

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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.

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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.

Question 32

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

Question 33

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

Question 34

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

Question 35

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.

Question 36

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.

Question 37

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.

Question 38

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.

Question 39

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

Question 40

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

Question 41

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

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 42

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

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

Question 43

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

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

Question 44

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.

A) reverse
B) transpose
C) fill
D) merge

Question 45

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

A) Quick Analysis tool
B) Cell Styles dialog box
C) Font formatting buttons on the Home tab
D) Number formatting buttons on the Home tab

Question 46

A workbook template has which of the following file extensions?

A) .xltx
B) .xls
C) .xlsx
D) .xlst

Question 47

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.

Question 48

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

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

Question 49

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

A) Gridlines View
B) Gridlines Print
C) Headings View
D) Headings Print

Question 50

To switch chart rows and columns,we can click anywhere in the chart containing the data series that we want to plot on different axes,click on the Design tab in Chart Tools,then in the Data group,and finally click Switch Row/Column.