4.4.2 Module 4 Quiz – Transforming Data with Excel Exam Answers

4.4.2 Module 4 Quiz – Transforming Data with Excel Exam Answers Full 100% | Data Analytics Essentials 2023

This is 4.4.2 Module 4 Quiz – Transforming Data with Excel Exam Answers Full 100%  in 2023. It is also module 4 quiz answers in the Cisco NetAcad SkillsForAll Data Analytics Essentials course. Our experts have verified all the answers with explanations to get the 100%.

1. 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 to select all the data in the spreadsheet.

2. 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 data from multiple worksheets in Excel in order to have the data you need to inform the analysis
   • it is used to filter blank cells in a given column
   • it is used to sum up the values in a given column
     

     Answers Explanation & Hints: The function “CONCATENATE” is used to combine the data from one or more columns into a single column. When you concatenate cells in Excel, you combine only the contents of those cells. In other words, “CONCATENATE” in Microsoft Excel is the process of joining two or more values together. This method is often used to combine a few pieces of text that reside in different cells (technically, these are called text strings or simply strings) or insert a formula-calculated value in the middle of some text.

3. 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 the contents of a range or array
   • it is used to calculate the mean average of a column
     

     Answers Explanation & Hints: The Microsoft Excel Data > Sort command is used to alphabetically or numerically arrange the content of a column or multiple columns.

4. 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 active cell is displayed as having a wide dark border in contrast to all other cells.

5. 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 “=INDEX(ProductSales,MATCH(1,($A2=ProductSales[Country])*($B2=ProductSales[Product]),0), 3)” is INDEX. ProductSales is the table that we want to get the information from MATCH specifies what we want to match from our ProductProfit table to get the information 1 is the lookup value ($A2 contains the country name and is the value to match = ProductSales[Country] is where to look for the value) The * joins the two lookups ($B2 contains the product description to be matched = ProductSales[Product] is where to look) 0 is the type of match (equals), there is also greater than (1) or less than (-1) 3 is the column in which to put the match in the target table

6. 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 descending order
   • it is used to return a value or the reference to a value from within a table or range
   • it is used to auto sum the values in a given range
     

     Answers Explanation & Hints: The Microsoft Excel INDEX function is a built-in function that is categorized as a Lookup/Reference tool. It is used to return a value or the reference to a value from within a table or range.

7. 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 range
   • it searches for blank cells in a given column
   • it sorts values in a given column
     

     Answers Explanation & Hints: The “LEN” function is used to return the number of characters in a text string. Please note that any spaces in the text string will be considered as a character and counted as such.

8. 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 an equal sign (=). The equal sign indicates that the entry is not text or a number, but a calculation. This ensures that your formula will not be displayed in the cell instead of the result of the calculation.

9. 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 a formula with a $ meaning the cell reference will not change when the formula is copied to a new location
   • it requires no parenthesis and brackets when used in the formula
   • it is used to automatically summarize, analyze, explore, and present data
     

     Answers Explanation & Hints: Cell and range references can have either a relative or absolute attribute. The relative reference changes depending on the relative position of the cell, so if the formula is copied to a new location, the cell location in the formula will change. An absolute reference (indicated by a $ preceding the location in the formula), will not change when the formula is copied to a new location.