Graded Quiz-4 | Quizerry

Graded Quiz >> Excel Basics for Data Analysis

You must delete the empty rows one at a time

Use Search & Replace to look for empty rows and delete

Select all rows and then filter for Blanks, select these and then delete

Use Remove Duplicates to remove empty rows

Correct: To remove all empty rows at the same time in your imported spreadsheet, select all rows, filter for Blanks, then select these and delete

Select a column and choose Conditional Formatting > Highlight Cells Rules > Duplicate Values

Use the HLOOKUP function

Search for the first character in rows

Select all data and click the Remove Duplicates button

Correct: This is the easiest of the two methods to locate and remove duplicated rows in Excel

Repairs a REF error

Changes text to sentence case

Converts upper case text to lower case

Converts lower case text to upper case

Correct: The PROPER function changes text to sentence case

Ensures consistency

Keeps cell formatting the same

Validates the copied function

Makes sure formulas aren’t also copied

Correct: To ensure that formulas aren’t also copied when you paste contents from a helper row to the original row, you use the Paste Values option

Format button

Paste Special tool

Format Painter tool

Text Import wizard

Correct: You use the Format Painter tool to apply new data formats to the rest of a column

Text to Columns feature

Paste Special

Format Painter tool

Flash Fill feature

Graded Quiz >> Excel Basics for Data Analysis