Exploring Data Tools and Formats

What is the primary function of Excel?

• Writing code

• Editing images

• Creating presentations

• Data organization and analysis

How do you create a new worksheet in Excel?

• Click the '+' icon next to the worksheet tabs or use 'Insert' from the 'Home' tab.

• Use the 'File' menu and select 'New' to create a worksheet

• Press 'Ctrl + N' to create a new worksheet

• Right-click on the worksheet and select 'New Sheet'

What formula would you use to sum a range of cells in Excel?

• =SUMIF(range)

• =SUM(range)

• =TOTAL(range)

• =ADD(range)

What is Power BI primarily used for?

• Web development and design

• Data storage and management

• Social media marketing

• Data visualization and business intelligence

What file format is commonly used to store tabular data?

• JSON

• XML

• TXT

• CSV

How do you import a CSV file into Excel?

• Use the 'Data' tab in Excel to import a CSV file.

• Open the CSV file directly in a web browser.

• Use the 'File' menu to save the CSV file as an Excel document.

• Copy and paste the data from the CSV file into Excel.

What is the JSON format primarily used for?

• Data storage in databases.

• Transmitting audio and video files.

• Data interchange between a server and a web application.

• Creating user interfaces for applications.

In Pandas, which function is used to read a CSV file?

• import_csv

• read_csv

• load_csv

• fetch_csv

What is the difference between .xlsx and .xls file formats?

• Both formats are identical and can be used interchangeably without any issues.

• The .xlsx format is newer, supports more features, and is based on XML, while .xls is an older binary format with limitations.

• The .xls format is newer and supports more features than .xlsx.

• .xlsx files are only for images, while .xls files are for text documents.

How do you export a Power BI report?

• You need to print the report to export it as a PDF.

• You can export a Power BI report by going to 'File' > 'Export' and selecting the format.

• To export a Power BI report, use the 'Share' option in the menu.

• You can save a Power BI report by clicking 'Save' in the toolbar.