Filters
Question type

Study Flashcards

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

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

E) A) and D)
F) C) and D)

Correct Answer

verifed

verified

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

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

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

E) A) and D)
F) C) and D)

Correct Answer

verifed

verified

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

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

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

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

False

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

A) True
B) False

Correct Answer

verifed

verified

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.

A) True
B) False

Correct Answer

verifed

verified

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.

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

A

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.

A) True
B) False

Correct Answer

verifed

verified

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.

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

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

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

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.

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

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

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

D

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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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.

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

Showing 1 - 20 of 53

Related Exams

Show Answer