DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Get & Transform
|
|
|
Look and Find
|
|
|
View and Print
|
|
|
Source externals
|
Detailed explanation-1: -On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query. Do one of the following: To specify a data source for a database, text file, or Excel workbook, click the Databases tab.
Detailed explanation-2: -Click Options > Trust Center > Trust Center Settings, and then click External Content. Click the option that you want under Security settings for Linked Data Types: Enable all Linked Data Types (not recommended) Click this option if you want to create linked data types without receiving a security warning.
Detailed explanation-3: -The Workbook Connections dialog box (Select Data > Connections) helps you manage one or more connections to external data sources in your workbook. You can use this dialog box to do the following: Create, edit, refresh, and delete connections that are in use in the workbook.
Detailed explanation-4: -If you’re using the latest version of the Microsoft 365 subscription version of Access or Access 2019, on the External Data tab, in the Import & Link group, click New Data Source > From File > Excel.