Microsoft Excel

Use of Statistics and Data Analysis in Microsoft Excel, use of Excel Built-in Statistical Functions, Analysis ToolPak, and creating Sheets for different statistical Analyses and Tests.

Power Query MCQs 11

by

Test your knowledge of Power Query with these multiple-choice questions! Challenge yourself with these Power Query MCQs and see how well you know data transformations, M language, and query editing. Perfect for Excel users, data analysts, and BI professionals looking to sharpen their data transformation skills. See how well you know Power Query and boost your data skills today! Let us start with the Power Query MCQs now.

Online Power Query MCQs Test with Answers

Online Power Query MCQs with Answers

1. In Australia, the first two digits represent the area code for a phone number, such as 0223789456. Consider a field that contains phone numbers in this format. What would be the appropriate option under Split Column to extract the area code?

 
 
 

2. Which aspect of getting data from a folder is similar to the result of an Append Query?

 
 
 
 

3. Suppose that we have created a new table by getting data from a folder that contains data from each of 5 branches of a company, each with its file. What should we do if we open two new branches – that maintains the existing structure and also gives unique information for each branch in its file?

 
 
 

4. When getting data from a PDF that contains multiple pages, what would be a query that would be usually run, right at the end?

 
 
 
 

5. What are some differences between Power Query and standard Excel?

 
 
 
 
 

6. When getting data from a PDF that contains a table in each of 5 pages and selecting multiple items, this will create as many queries as the number of items you have selected.

 
 

7. If you created a table in Excel after getting data from a database, changing the data in the new table will update the original database if you click Refresh.

 
 

8. When getting data from a database, unlike getting data from a spreadsheet, you have to transform the data at the source first.

 
 

9. What would happen if you tried to create a query from data in the current workbook that is not part of a table or a named range?

 
 
 
 

10. When getting data from a PDF that contains a table in each of the 5 pages, what will we see in the preview panel?

 
 
 
 

11. Which sources does Power Query allow us to Get Data from?

 
 
 
 
 

12. If you are utilising Power Query primarily as a ‘working space’ without viewing the data in your spreadsheet within Close & Load to, you should choose the option:

 
 
 
 

13. After creating a new Table via Power Query, what would happen when the original data is edited or changed?

 
 

14. There are currently three columns in Power Query: Street Address, City, and State, with data such as “42 Wallaby Way” (Street Address), “Sydney” (City), and “NSW” (State).
What could we do to create a new column that displayed the full address as a single string, such as “42 Wallaby Way, Sydney, NSW”?

 
 
 
 

15. Suppose we created 2 queries, one for Sydney and one for Other Instructors. We did not load these into the worksheet; and we only created a connection. Due to this setup, when choosing to append these queries, the result cannot be loaded into the worksheet – we can only create a connection.

 
 

16. When using an Append Query, the two tables must:

 
 
 
 

17. An American company has 50 offices, one in each state, which all use their own Excel spreadsheet for their human resources data, but the parent company wants to maintain a separate spreadsheet that gets the data from all these files. What would be an efficient solution to this problem?

 
 
 
 

18. Imdad was working in Power Query and loaded the data into a new worksheet. He notices that he has made an error and needs to undo one of his steps. What should he do?

 
 
 
 

19. When getting data from another workbook, it is essential to transform the data within that workbook first.

 
 

20. When getting data from a folder, the preview panel only shows a preview of the first file. Suppose there is an Australian company with an office in each of the 8 states and territories, where the parent office is in the state of New South Wales. If the 8 files are named as below, which file will appear in the preview pane, and why?

Western Australia
South Australia
Northern Territory
Tasmania
Victoria
Australian Capital Territory
New South Wales
Queensland

 
 
 
 

Online Power Query MCQs with Answers

  • Which sources does Power Query allow us to Get Data from?
  • What would happen if you tried to create a query from data in the current workbook that is not part of a table or a named range?
  • In Australia, the first two digits represent the area code for a phone number, such as 0223789456. Consider a field that contains phone numbers in this format. What would be the appropriate option under Split Column to extract the area code?
  • If you are utilising Power Query primarily as a ‘working space’ without viewing the data in your spreadsheet within Close & Load to, you should choose the option:
  • After creating a new Table via Power Query, what would happen when the original data is edited or changed?
  • When getting data from another workbook, it is essential to transform the data within that workbook first.
  • What are some differences between Power Query and standard Excel?
  • Imdad was working in Power Query and loaded the data into a new worksheet. He notices that he has made an error and needs to undo one of his steps. What should he do?
  • When getting data from a database, unlike getting data from a spreadsheet, you have to transform the data at the source first.
  • There are currently three columns in Power Query: Street Address, City, and State, with data such as “42 Wallaby Way” (Street Address), “Sydney” (City), and “NSW” (State). What could we do to create a new column that displayed the full address as a single string, such as “42 Wallaby Way, Sydney, NSW”?
  • If you created a table in Excel after getting data from a database, changing the data in the new table will update the original database if you click Refresh.
  • An American company has 50 offices, one in each state, which all use their own Excel spreadsheet for their human resources data, but the parent company wants to maintain a separate spreadsheet that gets the data from all these files. What would be an efficient solution to this problem?
  • When getting data from a folder, the preview panel only shows a preview of the first file. Suppose there is an Australian company with an office in each of the 8 states and territories, where the parent office is in the state of New South Wales. If the 8 files are named as below, which file will appear in the preview pane, and why? Western Australia South Australia Northern Territory Tasmania Victoria Australian Capital Territory New South Wales Queensland
  • Suppose that we have created a new table by getting data from a folder that contains data from each of 5 branches of a company, each with its file. What should we do if we open two new branches – that maintains the existing structure and also gives unique information for each branch in its file?
  • Which aspect of getting data from a folder is similar to the result of an Append Query?
  • When using an Append Query, the two tables must:
  • Suppose we created 2 queries, one for Sydney and one for Other Instructors. We did not load these into the worksheet; and we only created a connection. Due to this setup, when choosing to append these queries, the result cannot be loaded into the worksheet – we can only create a connection.
  • When getting data from a PDF that contains a table in each of the 5 pages, what will we see in the preview panel?
  • When getting data from a PDF that contains a table in each of 5 pages and selecting multiple items, this will create as many queries as the number of items you have selected.
  • When getting data from a PDF that contains multiple pages, what would be a query that would be usually run, right at the end?

Online Data Science Deep Learning Quiz

MS Excel Visualization Quiz 10

by

Explore your MS Excel skills with our MS Excel Visualization Quiz! Test your knowledge of creating, customizing, and interpreting graphs and charts in Excel. Perfect for beginners and advanced users alike, these 20 quizzes will help you master data visualization techniques. Boost your Excel expertise and enhance your data presentation skills today! Let us start with the MS Excel Visualization Quiz now.

MS Excel Visualization Quiz with Answers
Please go to MS Excel Visualization Quiz 10 to view the test

Online MS Excel Visualization Quiz with Answers

  • A chart can only be drawn if we select the labels as well as the data.
  • What is the difference between a column chart and a bar chart?
  • When Excel refers to a clustered column chart, what is the cluster referring to?
  • There is a problem with the chart that has been generated below. What is the problem?
  • To fix the problem that we noted “Year be added as an axis label” and remove Year as a series, what is the best option to choose from the Select Data Source dialog box?
  • To fix the problem that we noted “Year be added as an axis label” and add Year as a label to each cluster, what is the best option to choose from the Select Data Source dialog box?
  • A pie chart is useful when we want to show:
  • For a pie chart to be an effective visualization, the number of categories should be:
  • The key advantage that a doughnut chart has over a pie chart is that:
  • How can we modify the line chart below to adjust the vertical axis to better display the range of the data?
  • What does the R-Square value represent?
  • What will choosing a Polynomial trendline likely do to the R-squared value below?
  • How can we forecast forward into the future using the chart below? Click on the trendline and drag this forward.
  • If we choose Display Equation on Chart, why is this equation useful?
  • Both area charts and line charts are mainly useful for time series data.
  • Which chart from the following list would be useful to visualize both the individual contribution as well as the total contribution to the trend in a time series data set of several categories?
  • Which Excel functionality would allow you to quickly recolor your chart according to a set of preset options?
  • If you apply a theme after you have individually customized one or two series colors, these series will not be reset to fit the theme.
  • When applying a theme, the default setting in Excel is to apply the theme to only the active sheet, and not the entire workbook
  • A scatter chart is essentially an x-variable versus y-variable plot just like in standard mathematics.

Deep Learning Quiz

Microsoft Excel Quiz Questions 9

by

Are you ready to test your knowledge of Microsoft Excel Quiz Questions and master essential text functions? This post features 20 multiple-choice Microsoft Excel Quiz Questions and Answers designed to help you sharpen your skills in handling text data, reference, range, conditional formatting, and dashboards in Excel. Whether you are a beginner or looking to refresh your knowledge, this quiz covers the basics of MS Excel text functions like UPPER(), LOWER(), and PROPER(), COUNT(), COUNTA(). Let us start with Microsoft Excel Quiz Questions now.

Please go to Microsoft Excel Quiz Questions 9 to view the test

Microsoft Excel Quiz Questions and Answers

  • What is one of the functions you can use to change the text case in your data?
  • What does the Flash Fill feature have in common with the UPPER, LOWER, and PROPER functions?
  • Which of the following tasks can Flash Fill do?
  • Why do you need to use the Paste Values option when you paste contents from a helper row to the original row?
  • Which of the following are valid sorting orders you can choose when adding sorting levels to your data?
  • Which one of the following statements best describes the main purpose of a digital dashboard?
  • According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?
  • Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?
  • Which of the following tasks should you perform before creating a dashboard?
  • After importing a text file into Excel, some columns aren’t showing all the data. How can you fix all column widths at the same time?
  • Which Excel feature helps divide a column that contains into two columns: ?
  • Which of the following file types are not native Excel files but can be easily imported?
  • Column B contains the named range, sales_price. Column C contains the named range, shipping_cost. What would be an appropriate formula to obtain the total of columns B and C in a single cell?
  • Column C contains the named range, shipping_cost. Column D contains the named range, and location. What would be an appropriate formula to calculate the total shipping cost for all orders originating from the location of Sydney, given that location is the named range for column D?
  • To quickly create a named range: highlight the data, including the heading, and press:
  • Applying named ranges automatically embeds conditional formatting into your spreadsheet.
  • What is the difference between the functions COUNT and COUNTA?
  • Which of the following file types support macros?
  • When using a formula to apply conditional formatting to a whole row, how should we refer to cell B34 in our formula?
  • Which of the following are mixed cell references in Excel?
Microsoft Excel Quiz Questions Answers

R Frequently Asked Questions with Answers

Statistics Software Quiz