Download Excel Data Analysis: Pivot Tables, Functions, and Data Cleaning Techniques and more Exams Nursing in PDF only on Docsity!
Excel Data Analysis: Pivot Tables,
Functions, and Data Cleaning
Techniques
What is the first trait of data quality? Accuracy What must a data analyst do to ensure data accuracy? Clean the data set by removing duplicates, correcting formatting errors, and removing blank rows. What does data completeness refer to? The availability of all necessary information required to complete the data set. Why is reliability important in data quality? It ensures that the data is consistently updated and accurate for analysis. What is relevance in the context of data quality? It refers to whether the data being collected is necessary for the project. What does timeliness mean in data quality? It refers to the availability and accessibility of the data when needed.
What is the purpose of the Text Import Wizard in Excel? To import data from text files and adjust formatting settings. What file formats can Excel import using the Text Import Wizard? Plain text files (.txt) and comma-separated values (.csv). What should you select in the Text Import Wizard to indicate that your data has headers? 'My data has headers' option. How do you specify the delimiter in the Text Import Wizard? Select the character that separates the data fields, such as a comma. What is the default data format for imported columns in Excel? General format. How can you adjust column widths in Excel? By dragging the divider or double-clicking the column divider to autosize. What is the method to delete a column in Excel? Select the column, right-click, and choose 'Delete'.
Exclude it early to avoid reviewing unnecessary information. What is the significance of having reliable data? It ensures that the analysis is based on accurate and up-to-date information. What should you do if the data required for analysis is incomplete? Consider other sources to obtain the missing information. What is the role of a data analyst in ensuring data quality? To profile data, discover inconsistencies, and ensure it is free from errors. What is the effect of including unnecessary personal information in a dataset? It complicates the analysis and may lead to privacy issues. How can you ensure that the imported data looks as expected? Review the data preview in the Text Import Wizard before finishing the import. What should be done if the headings in the imported data are not visible? Adjust the column widths to ensure all headings are displayed. What are the three fundamentals of data privacy regulations? Confidentiality, Collection and Use, and Compliance.
What does Confidentiality in data privacy refer to? It acknowledges that the customer's personal information belongs to them. What is Personal Information (PI)? Any type of information that can be traced back to a specific individual, such as emails or images. What is Personally Identifiable Information (PII)? Specific information that could be used to identify an individual, such as a social security number or driver's license number. What is Sensitive Personal Information (SPI)? Information that may not identify an individual but contains private information that needs protection, such as race or biometric data. How can data analysts help build consumer confidence? By understanding personal data and associated regulations to efficiently anonymize data. What is the General Data Protection Regulation (GDPR)? A regulation specific to the European Union that applies to the jurisdiction of the individual.
Why is data accuracy important in data analysis? It ensures that the conclusions drawn from data are valid and reliable. What can happen if the wrong SKU is analyzed? It can lead to incorrect conclusions about profitability, impacting major business decisions. What is the role of data privacy in industries like healthcare? It is crucial to ensure users receive appropriate data access based on their roles and permissions. What is the importance of having accessible privacy policies? Employees must be aware of privacy regulations to comply when handling sensitive information. What is a potential risk of taking sensitive data outside company property? It can lead to data breaches if the data is lost or stolen. What is the impact of poor data quality on business decisions? It can mislead business direction and waste time and resources. What is the relationship between data privacy and data collection?
Data must be collected with privacy in mind to avoid limitations and ensure accessibility. What is the first step in ensuring data quality? Sense-checking the data to ensure it is from a trusted source. What is a common phrase that emphasizes the importance of data quality? Garbage in, garbage out. What should companies do to remain compliant with data privacy regulations? They must understand and adhere to the privacy regulations of their jurisdiction. Why is it important for data analysts to know the location of data collection? It determines which regulations must be applied to the data. What can happen if data privacy regulations are not followed? It can result in financial penalties and loss of consumer trust. What is the role of data professionals in ensuring data privacy? To manage access levels and ensure appropriate data handling based on roles. What does PII stand for?
What feature in Excel helps identify duplicate values? Conditional Formatting. What is the second method for removing duplicates in Excel? Using the Remove Duplicates button without previewing. What does the Find & Replace feature do in Excel? It repairs misspelled entries in the data. What should you avoid doing when sending sensitive data? Sending it through regular email without encryption. What types of errors can occur in data collection? Spelling mistakes, extra white space, wrong case, empty rows, missing values, and duplicates. Why is it important to clean data? To improve the quality and usability of the data. What keyboard shortcut takes you to the end of a column in Excel? CTRL + DOWN ARROW.
What should you do after identifying empty rows? Delete them and clear the filter to view the data again. What is a common source of duplicate data? Human input error or issues during the import process. What column is a bad choice for finding duplicates? The Price Each column, as it is likely to have repeated values. What is an example of a column that is good for finding duplicates? The Sales column, as it is less likely to have repeated values. What happens if you don't remove empty rows? Your dataset may be split into multiple sections, complicating data manipulation. What should be done if a customer reports a misspelled surname? Use Find & Replace to correct the spelling in the data. What is the impact of having errors in your data? It can lead to issues with formulas not working and inadequate data visualization. What is one way to ensure data security when sharing sensitive information? Do not include sensitive information in the same email as encrypted data.
How do you use Flash Fill to combine names in Excel? Insert a helper column, type the full name in the desired format, and start typing the next name to see a preview for Flash Fill. What is the purpose of the Text to Columns feature in Excel? Text to Columns splits a column of multi-part text into separate columns based on specified delimiters. What steps do you follow to use the Text to Columns feature? Select the data, click 'Text to Columns' on the Data tab, choose 'Delimited', select the delimiter, and specify the destination. What should you do if you want to split names that are in a single column into first and last names? Use the Text to Columns feature to split the names based on a delimiter such as space. What is a helper column in Excel? A helper column is an additional column used to facilitate data manipulation, such as combining or formatting data. What types of functions does Excel offer for data analysis? Excel offers mathematical, statistical, logical, financial, and date and time-based functions.
What is the first step in analyzing data in Excel? Decide on the best method for analysis, including filtering, sorting, and performing calculations. How can sorting data help in identifying duplicates? Sorting organizes data based on conditions, making it easier to spot duplicate entries. What is the purpose of filtering data in Excel? Filtering allows you to display only the rows that meet specific criteria, making analysis more focused. How can you visualize the final output before manipulating data? By asking questions about the dataset size, required filtering, sorting methods, and necessary calculations. What is the benefit of using functions in Excel for calculations? Functions simplify calculations, reduce the risk of errors, and save time compared to manual calculations. What should you do if you are using Excel for the web and need to split text? Use functions instead of Text to Columns, as the web version does not have that feature. What is the significance of the Fill Handle in Excel?
