Deck 11: User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Question 1

What should be selected in the Formula Bar to manually rename a form control button after clicking and selecting a new button?

A) Name Box
B) Formula box
C) Form Control box
D) Form control button box

Answer 1

A

Question 2

Saul wants to add a legend to a chart.On which of the following boxes should he click in Chart Elements after selecting the chart and then the + sign?

A) Color
B) Legend
C) Chart Titles
D) Data labels

Answer 2

B

Question 3

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

Answer 3

D

Question 4

Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

A) Worksheet > View tab > Workbook Views group > Custom Views > Close
B) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> OK
C) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (Tick check box- Hidden rows,columns and filter settings )> OK
D) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (select check box- Print settings )> OK

Question 5

To insert WordArt in Excel,click on Insert > WordArt,then select the WordArt style and then replace with the desired text in the Placeholder text.

Question 6

Don wants to compare two worksheets in the same workbook by viewing them side by side.What can he click to do so?

A) View tab > Window group > New Window > View Side by Side > Arrange All
B) View tab > Window group > New Window > View Side by Side > Freeze Panes > Select from drop down option
C) View tab > Window group > New Window > View Side by Side > Switch Windows > Select a window from the drop down menu
D) View tab > Window group > New Window > View Side by Side > Click sheets to compare in each workbook window

Question 7

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 8

Betty wants to choose the list to create a custom number format.To do so,what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Formats < Format Cells dialog box < Category < Custom

A) Type
B) Symbol
C) Locale
D) Decimal places

Question 9

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control)into a worksheet?

A) AutoLoad (Excel)
B) Enabled (Form)
C) Locked (Form)
D) Name (Form)

Question 10

Which of the following will you click after the following series to distribute form controls horizontally: Select controls > Drawing Tools Format tab > Align?

A) Distribute Horizontally
B) Distribute Vertically
C) Distribute Evenly
D) Distribute Across

Question 11

For use as watermark,Alba wants to insert a picture as a worksheet background.For this,she clicks the worksheet she wants to display with a background,then selects an option X from the Page Layout tab in the Page Setup group.Alba then selects the picture for use as background,and then clicks Insert.What can X in her series of selections be?

A) Breaks
B) Margins
C) Orientation
D) Background

Question 12

Alexa wants to insert a command button control in VBA and execute a program using the button.To do this,she clicks the option "Insert button" from the Active X Control,selects the command button option from it,then drags the mouse cursor to Excel sheet to insert "clickcommandbutton1." After this,she follows a step X.Then,she enters a code in the sheet,saves the code file,exits the editor,clicks the Excel sheet icon to the extreme left to return to the editor,turns off Design mode before clicking the Command button and executes the program.What did she do in step X in the procedure?

A) Right click on the command button and select "Format Control".
B) Right click on the command button and select "Command Button Object".
C) Right click on the command button and select "View Code".
D) Right click on the command button and select "Properties".

Question 13

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time.Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

A) Reset Window Position
B) Synchronous Scrolling
C) Arrange All
D) Zoom to Selection

Question 14

Rukha has created two custom views of a worksheet.In one view,all rows and columns can be seen whereas in the other,specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

A) Click Custom Views and double-click on the display settings she wants to see.
B) Under Windows group on the View tab,click on View Side by Side.
C) Under Windows group on the View tab,click on Switch Windows and select the View she wants.
D) Click Custom View and check the box beside Hidden rows,column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden.

Question 15

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 16

Which of these combination of keys will you click to clear an outline?

A) Worksheet > Data tab > Outline group > Group > AutoOutline
B) Worksheet > Data tab > Outline group > Ungroup > Clear Outline
C) Worksheet > Data tab > Outline group > Group > Group > Rows > OK
D) Worksheet > Data tab > Outline group > Ungroup > Ungroup > Rows > OK

Question 17

Mila wants to digitally sign a workbook to communicate that no further modifications should be made in the workbook.She clicks Insert tab > Text group > X > Microsoft Office Signature Line > Signature Setup Dialog box > Type Information for each box in the dialog box > Show sign date in signature line OK.What can X be in this series of clicks? ​

A) Create New
B) Create from File
C) Signature line List
D) Add Signature Services

Question 18

Nadine wants to insert a sparkline in Excel using the Quick Analysis tool.She can do this by selecting the data for which she wants to add Sparklines,then in the empty column to the right side of the data click the Quick Analysis button,click Sparklines and select the type of Sparkline she wants.

Question 19

Cora wants to manually rename a new form control button with a macro assigned to it.Which of the following combination of keys can she use to select it?

A) Tab + Click
B) Ctrl + Click
C) Ctrl + Alt + Click
D) Shift + Alt + Click

Question 20

How can you align all objects to the upper-left corner of a cell?

A) Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Grid.
B) Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Shape.
C) Click the Drawing Tools Format tab,then click the arrow next to Align,and then click Align Top.
D) Click the Drawing Tools Format tab,then click the arrow next to Align,and then click Align Bottom.

Question 21

Which of the following will you select as X in the series to insert a button (form control)into a worksheet: Developer tab > X > Insert > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type OK in the Assign Macro popup window?

A) XML group
B) Modify group
C) Controls group
D) Add-ins group

Question 22

To insert a scroll bar (form control)into a worksheet,click the Developer tab > Insert > Form Controls > Button labeled as "A."

Question 23

Which of the following must be checked after selecting Main tabs from Customize the Ribbon drop down box,to turn the Design Mode on?

A) Data
B) View
C) Review
D) Developer

Question 24

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

Question 25

One can use the InputBox function in Excel VBA to prompt a user to enter a value.

Question 26

To insert a list box (form control)into a worksheet,click the Developer tab > Controls group > Insert > Form Controls > Button with an up and a down arrow in two rectangular boxes,placed one below the other.

Question 27

To insert an If Then statement into a VBA macro,type: If [condition is true] Then.

Question 28

Which of the following properties is used to specify the way the control is attached to the cells below it,while inserting a command button (ActiveX control)into a worksheet?

A) Visible (Form)
B) Placement (Excel)
C) PrintObject (Excel)
D) WordWrap (Form)

Question 29

A new worksheet has items listed in cell range A1 to A20.Which of the following will you type in the Format Object window in the Input Range box to specify the range for the list?

A) "A1:A20"
B) 'A1:A20'
C) A1-A20
D) A1:A20

Question 30

Which of the following will you click after File > Options to open the Developer tab to change the back color of an ActiveX control?

A) Formulas
B) Proofing
C) Trust Center
D) Customize Ribbon

Question 31

To insert a spin button(form control)into a worksheet,click the Developer tab > Insert > Form Controls > Button labeled as "Aa."

Question 32

Which of the following will you select on the Color and Lines tab to adjust the gradient,texture,and pattern of a form control?

A) Fill Effects
B) More Colors
C) Color List Box
D) Special Effects

Question 33

To insert an option button into a worksheet,click on the following series: Developer tab > Insert > Form Controls > Image with a tick inside a rectangular box.

Question 34

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 35

A Function procedure uses the Return statement to specify the return value,and returns control immediately to the calling program.

Question 36

What should you select to get a finer control over the line width setting for the text of a command button (ActiveX)control?

A) FontBold
B) FontItalic
C) FontWeight
D) FontStrikeThru

Question 37

What value of Shadow property has an effect of Offset Right on an ActiveX control?

A) 1
B) 3
C) 4
D) 5

Question 38

To add a toggle button (ActiveX control)into a worksheet,click the Developer tab > Insert > ActiveX Controls > Button image of concentric circles inside a rectangular box.

Question 39

If you want to write a macro for a workbook in use,you need to first click the name of the VBA Project in the Project Explorer window.

Question 40

Which of the following should be selected as X in the series of clicks to insert a check box (form control)into a worksheet: Developer tab > Controls group > Insert > Form Controls > X?

A) Button image with a check inside two concentric rectangular boxes
B) Button image with an up and a down arrow in two rectangular boxes,placed one below the other
C) Button image of concentric circles inside a rectangular box
D) Button image with a tick inside a rectangular box

Question 41

Which of the following should you select as X in the series of clicks to clear a comment from a cell: Cell containing comment > Review tab > X > Delete button?

A) Changes group
B) Proofing group
C) Language group
D) Comments group

Question 42

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

Question 43

One can select the macro one wants to edit in the Macro Name box.

Question 44

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

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

Question 45

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

Question 46

The initial screen of Visual Basic Editor provides four GUI elements: Menu bar,Toolbar,Project Explorer,and Property Window.

Question 47

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it.What should she select in the Protect Workbook box under Options in the File tab to do this?

A) Mark as Final
B) Encrypt with Password
C) Protect Current Sheet
D) Protect Workbook Structure

Question 48

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 49

To run code,use shortcut Ctrl+Alt+N.

Question 50

To change theme effects,click on Effects on the Page Layout tab,then select the set of effects that you want to use.

Question 51

You can open the VBA editor with the keyboard shortcut Alt + F11.

Question 52

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

A) Insert
B) Developer
C) Formulas
D) Page Layout

Question 53

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

A) The Specific People
B) The People with Existing Access
C) The Co-workers in .
D) The People in .

Question 54

To choose a standard theme color,click on the Insert tab,click Colors,then pick the color set you want.

Question 55

The .NET Framework calls the Main procedure when it has loaded the application and is ready to pass control to it.

Question 56

Musa wants to choose a standard color theme for an Excel worksheet he is working on.He clicks on the Page Layout tab and then clicks Colors.What should he do next to complete the procedure?

A) Pick the color set he wants.
B) Enter numbers on the Custom tab.
C) Select More Colors,and then pick a color on the Standard tab.
D) Under Customize Colors,click the button next to the theme color he wants to change and then pick a color under Theme Colors.

Question 57

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 58

Sven wants to create a custom theme font set for the heading and body of a presentation.Under tab X,he selects Fonts,and then selects Create New Theme Fonts.Then he selects a heading font,a body font,types in a name for his theme font set and clicks Save.Which of the following can tab X be in the above-mentioned procedure?

A) Insert
B) Design
C) Review
D) Developer

Question 59

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 60

To open the macro dialog box for editing a macro in Visual Basic Editor,press Alt+F8.

Question 61

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

Question 62

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 63

To set the default language,open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

Question 64

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 65

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

Question 66

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 67

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 68

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

Question 69

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

Question 70

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 71

To detect language automatically,you should select the Detect language automatically check box in the Language dialog box.

Question 72

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 73

To create your own theme color,click on Page Layout,then Colors,then Customize Colors,then click the button next to the theme color you want to change,and finally pick a color under Theme Colors.

Question 74

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