Excel Expert - MOS 2019_Office 365 with
correct answers 100% 2026
Enable Macros in a Workbook - Correct Answers 1. Go to FILE, OPTIONS, TRUST CENTER, TRUST
CENTER SETTINGS.
2. Click on MACRO SETTINGS in the navigation pane, ENABLE ALL MACROS
Create a Macro and copy to another workbook. - Correct Answers Go to View, MACROS.
By default Macros records using Absolute reference.
You can also 'Use Relative References'.
..continued
Tip: Creating Macros - Correct Answers You can create a Personal Macro workbook to store all
of your macros which will give you access to them no matter which workbook you are in.
Edit VBA - Correct Answers Right click Ribbon.
Customise the Ribbon.
Select 'DEVELOPER' checkbox.
Go to DEVELOPER, VISUAL BASIC
Go to the navigation pane and select the project.
Double click MODULES
NOTE:
,You can also rename your Modules by selecting the module 'Name' property in the navigation
pane and editing the default Module name.
Copy Macro to another Workbook. - Correct Answers 1. Ctrl + N to create a new workbook.
2. Go to ' VIEW', 'SWITCH WINDOWS' to return to initial workbook.
3. Go to DEVELOPER, VISUAL BASIC to see the new workbook you created.
4. In the navigation pane in VISUAL BASIC click on the first workbook.
5. Drag and drop your first module into the Module folder for the new Workbook.
Reference Data in Other Workbooks. - Correct Answers You can have a workbook closed and still
create a link between 2 documents.
Go to the destination workbook.
Open a worksheet and select a cell.
=, VIEW tab, SWITCH WINDOWS, select workbook you want to link to, select the range of cells in
the source workbook and press Enter.
Now when you change a value in the source workbook worksheet it will reflect on the linked
worksheet
, You can also link a named range of cells from a worksheet by naming the range then selecting it
from FORMULAS tab, Use in FORMULA.
Get and Transform - Correct Answers You can still create a connection from a closed workbook.
In your current workbook (destination) select the cell you want to bring the data into.
Go to DATA tab, GET DATA, FROM FILE, FROM WORKBOOK.
Select the Workbook.
Select Worksheet from Workbook in the Navigator window.
Select TRANSFORM DATA (or Edit) in Navigator Window to clean the data first which brings up
Power Query Editor.
In Power Query use the ribbon to perform operations like REMOVE ROWS, CHOOSE COLUMNS.
Select the Dropdown on the top left of the Worksheet in Power Query. Here you can select 'USE
FIRST ROW AS HEADERS'.
When you complete your Transform operations choose CLOSE and LOAD TO.
In the dialog you can bring the information in as a Table, or a Pivot table, Chart or a Connection.
You can also add the information to your Data Model which occurs when you are pulling
information from different worksheets.
correct answers 100% 2026
Enable Macros in a Workbook - Correct Answers 1. Go to FILE, OPTIONS, TRUST CENTER, TRUST
CENTER SETTINGS.
2. Click on MACRO SETTINGS in the navigation pane, ENABLE ALL MACROS
Create a Macro and copy to another workbook. - Correct Answers Go to View, MACROS.
By default Macros records using Absolute reference.
You can also 'Use Relative References'.
..continued
Tip: Creating Macros - Correct Answers You can create a Personal Macro workbook to store all
of your macros which will give you access to them no matter which workbook you are in.
Edit VBA - Correct Answers Right click Ribbon.
Customise the Ribbon.
Select 'DEVELOPER' checkbox.
Go to DEVELOPER, VISUAL BASIC
Go to the navigation pane and select the project.
Double click MODULES
NOTE:
,You can also rename your Modules by selecting the module 'Name' property in the navigation
pane and editing the default Module name.
Copy Macro to another Workbook. - Correct Answers 1. Ctrl + N to create a new workbook.
2. Go to ' VIEW', 'SWITCH WINDOWS' to return to initial workbook.
3. Go to DEVELOPER, VISUAL BASIC to see the new workbook you created.
4. In the navigation pane in VISUAL BASIC click on the first workbook.
5. Drag and drop your first module into the Module folder for the new Workbook.
Reference Data in Other Workbooks. - Correct Answers You can have a workbook closed and still
create a link between 2 documents.
Go to the destination workbook.
Open a worksheet and select a cell.
=, VIEW tab, SWITCH WINDOWS, select workbook you want to link to, select the range of cells in
the source workbook and press Enter.
Now when you change a value in the source workbook worksheet it will reflect on the linked
worksheet
, You can also link a named range of cells from a worksheet by naming the range then selecting it
from FORMULAS tab, Use in FORMULA.
Get and Transform - Correct Answers You can still create a connection from a closed workbook.
In your current workbook (destination) select the cell you want to bring the data into.
Go to DATA tab, GET DATA, FROM FILE, FROM WORKBOOK.
Select the Workbook.
Select Worksheet from Workbook in the Navigator window.
Select TRANSFORM DATA (or Edit) in Navigator Window to clean the data first which brings up
Power Query Editor.
In Power Query use the ribbon to perform operations like REMOVE ROWS, CHOOSE COLUMNS.
Select the Dropdown on the top left of the Worksheet in Power Query. Here you can select 'USE
FIRST ROW AS HEADERS'.
When you complete your Transform operations choose CLOSE and LOAD TO.
In the dialog you can bring the information in as a Table, or a Pivot table, Chart or a Connection.
You can also add the information to your Data Model which occurs when you are pulling
information from different worksheets.
