## Graded Quiz >> Excel Basics for Data Analysis

TOTAL POINTS 7

**1.Which of the following is a valid way of editing existing data in a cell?**

**Select all that apply**

1 point

**2.In Excel for the web, how can you format data in cells to use a currency?**

**Select all that apply**

1 point

**3.What character do you type first when you want to start writing a formula?**

1 point

Correct: You type the ‘=’ character first when you want to start writing a formula

**4.What is one of the functions found in the AutoSum drop-down list?**

1 point

Correct: Count Numbers is one of the functions found in the AutoSum drop-down list, The other options are Sum, Average, Max and Min

**5.In Excel Desktop, what is one of the function categories on the Formulas tab, in the Function Library group?**

1 point

Correct: Lookup & Reference is one of the function categories on the Formulas tab, in the Function Library group

**6.How do you make a cell reference absolute in a formula?**

1 point
Put a percentage sign (%) behind the column or row identifiers in the formula
Put an asterisk (*) in front of the column or behind the row identifiers in the formula
Put a dollar sign ($) in front of the column and/or row identifiers in the formula
Put a plus sign (+) between the column and row identifiers in the formula

Correct; Putting a dollar sign ($) in front of the column and/or row identifiers is how you make a cell reference absolute in a formula

**7.Formula errors in Excel are preceded by a hash symbol (#). What does it mean when multiple hash symbols exist in a cell?**

1 point

Correct: When you see multiple hash symbols in a cell it means that either the column isn’t wide enough to display the full data, or it contains negative date or time values

### Related Questions & Answers:

- Graded Quiz-1 Graded Quiz >> Excel Basics for Data Analysis Latest Submission Grade 100% 1.Which of the following key Data Analyst ... Read more...
- Graded Quiz-3 Graded Quiz >> Excel Basics for Data Analysis TOTAL POINTS 3 1.Which data quality trait can be summarized by ... Read more...
- Graded Quiz-4 Graded Quiz >> Excel Basics for Data Analysis 1.What is one of the issues that empty rows cause in your ... Read more...
- Graded Quiz-5 Graded Quiz >> Excel Basics for Data Analysis LATEST SUBMISSION GRADE 100% 1.If you have multiple filters set, how ... Read more...
- Our analysts often work within the same spreadsheet, but for different purposes. What tools would you use in such a situation? 8. Scenario 2 continued Consider and respond to the following question. Select all that apply. Our analysts often work within ... Read more...
- Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data. What does this mean? 1. Scenario 1, questions 1-5 You’ve been working at a data analytics consulting company for the past six months. Your ... Read more...