How is the Microsoft Excel VLOOKUP tool used in data analysis? to summarize descriptive data sets to interpret inferential data sets to find specific information in a large spreadsheet to…
What are inferential data sets? They are data sets gathered from a representative sample to make generalizations or predictions about a population. They are data sets that describe the current…
In Microsoft Excel, what is a characteristic of an "absolute reference"? the reference changes depending on the relative position of the cell it is indicated by preceding a cell reference in…
What sign do all Microsoft Excel formulas start with? equal sign (=) plus sign (+) number sign (#) asterisk symbol (*) Answers Explanation & Hints: All Excel formulas start with…
What is the Microsoft Excel "LEN" function used for? it returns the number of characters in a text string in a cell it automatically adds the values in a given…
In Microsoft Excel, what is the "INDEX" function used for? it is used to sort the data in an ascending order it is used to sort the data in a…
What is the name of the Microsoft Excel function in the formula "=INDEX(ProductSales,MATCH(1,($A2=ProductSales[Country])*($B2=ProductSales[Product]),0), 3)"? MATCH INDEX $A2 $B2 Answers Explanation & Hints: The name of the function in the formula…
How is an active cell displayed in Microsoft Excel? a blinking border a flashing border a pointer arrow a wide dark border Answers Explanation & Hints: In Microsoft Excel, an…
What is the Microsoft Excel Data > Sort command used for? it sums up the values in a given column it filters out the values in all blank cells it is used to arrange…
What is the Microsoft Excel "CONCATENATE" function used for? it is used to combine the data from one or more columns into a single column it is used to combine…
What keyboard shortcut can be used in Microsoft Excel to select all the data? CTRL-V CTRL-A CTRL-C CTRL-P Answers Explanation & Hints: You can use the keyboard shortcut keys CTRL-A…
Which two methods are used to collect unstructured data for analysis? (Choose two.) querying a relational database using a web-scraping tool copying a spreadsheet obtaining data through an API downloading…
Which universal file format is organized in rows and has the columns separated by a delimiter character? HTML CSV JSON XML Explanation & Hint: Comma-separated values (CSV) files are a…
What are Web scrapping tools used for in big data analytics? to automatically extract data from HTML pages to provide standardized interfaces for data collection to store real-time data in its original…
An analyst is reviewing gathered data from various sources and modifying incompatible metrics into a usable form. In which ETL step would this task be completed in? action extract load…
What is a characteristic of open data? data that lacks intellectual property restrictions data that lacks predefined organization data that does not need to be stored data that does not…
In a data analysis project, which process gathers all grades for students enrolled in a college course? action extract load transform Explanation & Hint: There are three processes in data…
Which two tasks are part of the transforming data process? (Choose two.) collecting data required to perform the analysis reviewing the data and addressing erroneous or missing values eliminating the…
What task is performed as part of the loading process in data preparation? transferring the data into a database providing values for missing data collecting and recording the data locating…
What term is used for the process of conditioning data into a form that can be analyzed? transforming extracting loading processing Explanation & Hint: Three processes must occur before data…