Deck 15: Collaborating with Your Team.(Digital Only).

Question 1

To check your workbook for features that assist people with disabilities,you can use the Ability Checker.

Answer 1

False

Question 2

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.

Answer 2

B

Question 3

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

Answer 3

D

Question 4

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

Question 5

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 6

The spell checker flags your company's name as a misspelling.Which of the following will stop the spell checker from flagging later occurrences in the document?

A) Change All
B) Change
C) Ignore Once
D) Ignore All

Question 7

Which of the following does the Accessibility Checker look for? Select all the options that apply.

A) Worksheets with default names.
B) Images without alternative text.
C) Worksheets with calculation errors.
D) Hyperlinks without alternative text.

Question 8

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 9

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 10

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 11

To make your workbooks usable by people with disabilities,you can add alternative text to worksheet images.

Question 12

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 13

Which of the following is true of the Excel spell checker?

A) You can change all instances of a flagged word to a selected suggestion.
B) You cannot add words to the spell checker dictionary.
C) You must accept all spell checker suggested replacement words.
D) For multiple instances of a misspelled word,you must change each one individually.

Question 14

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 15

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 16

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

Question 17

To accept a suggested spelling for that instance only,which of the following would you click?

A) Change
B) Change All
C) Ignore Once
D) Add to Dictionary

Question 18

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 19

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

To highlight track changes in a worksheet,go to the Highlight Changes dialog box and check the box for Highlight changes on screen,then click OK.

Question 22

To edit a comment in a cell,right-click on the cell containing the comment,select Edit Comment in it,then make the necessary changes in it and click on the cell again.

Question 23

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

Question 24

To go to a previous comment,use the Previous button in the Comments group on the Review tab.

Question 25

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 26

In order to reject changes made by all users in a workbook,click/enter information in the following series: Review tab > Changes group > Track Changes > Accept or Reject Changes > OK (if prompted to save the workbook)> Select Changes to Accept or Reject dialog box > Select Where check box > OK > Review information about each change in the dialog box > Reject > OK.

Question 27

To provide suggestions to other people using your document,select the text you want to comment on,then click New Comment on the Review tab and type your comment.

Question 28

To show a comment in an active cell,select the cell,then click Review tab > Comments group > Show/Hide Comment.

Question 29

It is possible to go to the next comment using the Next button in the Comments group on the Review tab.

Question 30

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 31

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 32

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 33

To copy and paste comments in an Excel sheet,select the cell containing the comment and press Ctrl+V.Then select the cell where you want to paste the comment,right click on it and select Paste Special from the popup menu.

Question 34

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 35

To delete comments,select the cell that contains comments,right-click on it and select Delete Comment option from the menu.

Question 36

To turn track changes on in an Excel sheet,click Review tab > Changes group > Track Changes command > Highlight Changes > Highlight Changes dialog box > Check box next to Track changes while editing > Ensure that box is checked for Highlight changes on screen > OK > OK (if prompted to allow Excel to save the workbook).

Question 37

To edit a comment in a cell,select the cell that contains the comment,right-click on it and select the Edit Comment option from the menu.
​

Question 38

Which of the following should be clicked to change the caption of a control after right-clicking on it?

A) Order
B) Grouping
C) Properties
D) Format Control

Question 39

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.

Question 40

To show all comments in a worksheet,click Review tab > Comments group > Show All Comments.

Question 41

Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?

A) Erase All
B) Clear All
C) Delete All
D) Remove All

Question 42

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 43

Annemarie wants to save a workbook as a shared workbook to allow several users to work on it simultaneously.For this,she clicks X > Y > Share Workbook > Editing tab > Allow changes by more than one user at the same time > OK > Save the shared workbook on a network location for other users to access it in Save As dialog box.What can X and Y be in the series of clicks?

A) X- View tab,Y- Show group
B) X- Insert tab,Y- Links group
C) X- Review tab,Y- Changes group
D) X- Developer tab,Y- Controls group

Question 44

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 45

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be? ​

A) Next
B) Delete
C) Previous
D) New Comment

Question 46

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 47

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 48

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file.To do so,she can click File > Info > Protect (Document,Presentation,or Workbook)> Protect Current Sheet > OK.

Question 49

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010,or 2013.To do so,he can click File > Info > Check for Issues > Check Compatibility > OK.

Question 50

Which of the following should be selected in the Quick Access Toolbar to email a workbook as an attachment?

A) Send
B) Send Now
C) Send to Mail Recipient
D) Send to Exchange Folder

Question 51

Return value comments help others understand what values are returned by a procedure.

Question 52

What is the default number of days for Excel change history?

A) 15
B) 30
C) 60
D) 90

Question 53

Stella wants to merge two workbooks.She begins by opening the workbooks,then selects the worksheets she wants to copy by clicking on the first sheet tab that she wants to copy,pressing and holding the Shift key,and then clicking on the last sheet tab.Then she right-clicks on one of the selected tabs and selects an option from the menu.Which of the following can her selection be?

A) Insert
B) Rename
C) View Code
D) Move or Copy