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
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...