Deck 8: Excel

Question 1

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 1

B

Question 2

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)

Answer 2

D

Question 3

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 3

A

Question 4

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 5

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

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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 21

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 22

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 23

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

Question 24

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

Question 25

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 26

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 27

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

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 30

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

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

Question 31

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 32

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

Question 33

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

Question 34

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

Question 35

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 36

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

Question 37

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 38

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 39

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 40

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

Question 41

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 42

Tim wants to insert a hyperlink to a new file for quick access to related information on a web page.Which of these can be X in the following series of clicks he can use: Cell to insert hyperlink > Insert tab > Links group > Hyperlink > Link to > Create new Document > Name of New Document (Type a name for new file ) > When to Edit > Select an option > Text to display box > ( Type text that you want to use to represent the hyperlink) > X > (Type information to be displayed when pointer rests on hyperlink in the box) > OK?

A) Style dialog box
B) Dynamic Text box
C) ScreenTip Text box
D) Edit Hyperlink dialog box

Question 43

Calista wants to add a screentip to a hyperlink she inserted into a cell.She selects the cell with the hyperlink, then presses a certain combination of buttons, then selects ScreenTip, types in a message, clicks OK, then clicks OK again to save the link.Which of these combination of buttons must she have pressed during this procedure?

A) Ctrl + Z
B) Ctrl + K
C) Alt + E
D) Alt + F4

Question 44

Which of these keys will you press to remove a hyperlink completely?

A) Esc
B) Delete
C) Ctrl + F9
D) Ctrl + Shift + F7

Question 45

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 46

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 47

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 48

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 49

Which of these will you select as X in the following series of clicks to insert a hyperlink to a webpage: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Insert Hyperlink box > X > Type or paste link?

A) Bookmark
B) ScreenTip
C) Address box
D) Text to display

Question 50

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 51

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 52

Bella wants to insert a hyperlink to a location in the current file.Which of these can be X in the following series of clicks she can use to solve her purpose: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Link To > X > Select heading (current document only), bookmark, slide, custom show, or cell reference to link to in the list?

A) E-mail Address
B) Create New Document
C) Place in This Document
D) Existing File or Webpage

Question 53

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 54

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 55

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

Question 56

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

Question 57

Amelia wants to insert a hyperlink to an e-mail address.Which of these can be X in the following series of clicks she can use: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Link To > X > Subject box (Type subject ) > OK?

A) E-mail Address
B) Create New Document
C) Place in This Document
D) Existing File or Webpage

Question 58

Which of these series of clicks would you select to remove hyperlink from a cell?

A) Home tab > Editing group > Clear > Remove Hyperlinks
B) Home tab > Editing group > Delete > Delete Hyperlinks
C) Home tab > Hyperlink group > Remove Hyperlinks
D) Home tab > Styles group > Delete > Remove Hyperlinks

Question 59

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

Question 60

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 61

Esperanza wants to record a macro to automate a repetitive task.Which of the following combinations of keys should she press to open the Macro name box?

A) Ctrl + Z
B) Alt + F8
C) Ctrl + Shift
D) Alt + T + M + R

Question 62

Willa wants to insert a 3-D Map to explore data.Which of the following options should she click in Custom Maps Options box to get the best fit?

A) AutoFit
B) Pixel Space
C) Swap the X and Y axis
D) Lock current coordinate values

Question 63

Nathan wants to run a macro from the developer tab.He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run.What should he click as X in this procedure?

A) Macros
B) Visual Basic
C) Record Macro
D) Macro Security

Question 64

Which of the following series of clicks will you follow after clicking on a column to create a measure in the Power Pivot Window using AutoSum?

A) Calculations > AutoSum
B) Home > View> Calculation Area
C) PivotTable Fields > (Drag a field into) Values
D) Power Pivot > Calculations > Measures > New Measure

Question 65

Arlo creates a rectangular shape and inserts the text 'Color Box' in it.Then, he right clicks on the shape and selects a button to assign a macro to it.Which of the following can his selection be?

A) Assign Macro…
B) Format Shape…
C) Set as Default Shape
D) Size and Properties…

Question 66

What is the file extension of macro-enabled workbook?

A) .xls
B) .xlx
C) .xlsx
D) .xlsm

Question 67

Derek wants to remove columns from Query he doesn't need.To do so, he can select the columns he wants to remove with Ctrl+Click.Then he can select Remove Columns > Remove Columns in the Query Editor ribbon.

Question 68

Amin wants to extract data from a Pivot table he has created for items sold in the East region of his company in a year.The table contains the following entries: Cells A1, B1, A3 and B3 have the headings "Region," "East", "Items" and "Sum" in them respectively.Cells A4 to A6 has the names of Items: A3 sheets, A4 sheets and A5 sheets in them, respectively.Cells B4 to B6 had their respective selling prices.Cells B7 has the title "Grand Total" and cell C7 has the grand total of all selling prices in the table.To calculate the total for the item, A4 sheets, Amin can use the formula: =GETPIVOTDATA("Total","Product","A4 sheets").

Question 69

Edward wants to edit a relationship between two tables.To do this, he places the cursor pointing to the relationship line and then clicks the line to select it.Then, he clicks on tab "X" > Group "Y" > Edit Relationships.What are X and Y in the procedure?

A) A-Design tab, B-Tools group
B) A-Developer tab, B-Code group
C) A-Format tab, B-Arrange group
D) A-Design tab, B-Relationships group

Question 70

Chris wants to remove the rows with data errors in a query.To do so, he can right-click on the selected columns from where he wants to remove the rows containing the errors and select Remove Errors.

Question 71

Avery wants to transform data from data sources in order to analyze it.To do this, she can click Data > Get Data > Navigator window > Select table (or tables) to use in the query > Edit > OK.

Question 72

Rachel wants to use Microsoft Query to retrieve data from her corporate databases and files so that she doesn't have to retype the data that she wants to analyze in Excel.To do so, she can click and/or enter the following information in the following series of clicks: Data tab > Get External Data group > From Other Sources > From Microsoft Query > Databases tab (To specify a data source for a database, text file, or Excel workbook) > OK > Create New Data Source dialog box > Type a name to identify the data source > Click a driver for the type of database for use as data source > Connect (Provide the information needed to connect to the data source) > OK.

Question 73

Kahir wants to delete a macro.To do this, he selects Tools > Macro > X > Select Macro > - sign > Yes on confirmation message dialog box.Which of the following will he select as X in this series of selections?

A) Macros
B) Excel Add-ins
C) Stop Recording
D) Visual Basic Editor

Question 74

To update the data associated with external links, close all workbooks and open the one that contains the links.Then click Options on the Trust Bar and then click Enable this Content.

Question 75

Grace wants to insert a Form control button into a worksheet.Which of the following will she select as X in the following series of clicks/entries/selections to display the Developer tab: File menu > Options from drop down menu > X in Excel Options Window > Developer checkbox under the list of Main Tabs > OK?

A) Advance
B) Language
C) Customize Ribbon
D) Quick Access Toolbar

Question 76

Which of these will you click select as X in this series of clicks/entries/selections to edit relationships between Pivot tables: Power Pivot window > Design tab > Manage Relationships command > Manage Relationships dialog box > Relationship > Edit > X > Use the drop-down and list box controls on this form to select the appropriate table and field names?

A) Warning Dialog box
B) Format Cells dialog box
C) Create Relationship Dialog box
D) Edit Relationship Dialog box

Question 77

Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?

A) Layer Pane
B) Editor Pane
C) Center Pane
D) Tour Editor Pane

Question 78

Finley wants to create a 3-D map scene in a tour.To do this, she selects a range of cells containing her data in an Excel table.She then clicks on Insert tab > X > 3D Maps > Open 3D Maps.What is X in the procedure?

A) Tours group
B) Scene group
C) Tables group
D) Sparklines group

Question 79

One can use Get & Transform (Power Query) feature of Excel to create a dynamic connection to an existing Excel table and refresh the connection when the data in table changes.

Question 80

Which of the following should be selected as X in the series to assign a macro to a button: Developer tab > Controls group > X > Form Controls > Button Form Control > Worksheet location where you want the upper-left corner of the button to appear > Type in the Assign Macro popup window?

A) Insert
B) View Code
C) Run Dialog
D) Design Mode