excel basics for data analysis coursera answers week 2

Getting Started with Using Excel Speadsheets

Practice Quiz

1. How can you zoom to a specific area of data in an Excel spreadsheet?

  • Use the 100% button
  • Use the Zoom to Selection button
  • Use the Freeze Frames option
  • Use the Zoom button 

2. What do you use the AutoFill feature for?

  • Move or copy data between spreadsheets
  • Paste data in a cell with the same column width settings
  • Drag selected data to another place
  • Automatically fill cells with data in a sequential series or pattern

3. What is one of the key components of a typical formula?

  • Division
  • Reference
  • Percentage
  • Calculation

4. What happens when you use the median calculation but select an even number of values in a range?

  • Returns both of the middle values of the selected range 
  • Divides the selected range in half 
  • Returns middle figure between the two middle values in the selected range
  • Returns one of the middle value of the selected range

5. What are Excel cell references by default?

  • Mixed references 
  • Cell references must be assigned
  • Relative references
  • Absolute references

6. When creating formulas, what is a mixed reference?

  • One cell reference is absolute, the other one is relative 
  • Both cell references are either absolute, or relative
  • Both cell references are manually assigned 
  • One cell reference is absolute, the other must be manually assigned 

Graded Quiz

7. Which of the following is a valid way of editing existing data in a cell? Select all that apply

  • Press F2

  • Press CTRL+N
  • Select the cell you want to edit and press Enter
  • Select the cell you want to edit and then click in the formula bar

8. In Excel for the web, how can you format data in cells to use a currency? Select all that apply

  • Select “More Number Formats” from the Number Format drop-down list in the Number group

  • Select the data and click the Decrease Decimal button
  • Right-click on a cell and select Number Format

  • Select “Format cells” from the Format drop-down list in the Cells group

 

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

  • Plus sign ‘+’
  • Division sign ‘/’
  • Equal sign ‘=’

  • Percentage sign ‘%’

 

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

  • Accounting
  • General
  • Number
  • Count Numbers

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

  • Medical
  • Lookup & Reference
  • Functional
  • Analytical

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

  • Put a plus sign (+) between the column and 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 percentage sign (%) behind the column or row identifiers in the formula

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

  • Formula is missing a cell reference
  • Formula contains unrecognized text
  • Formula contains multiple errors
  • Column isn’t wide enough or it contains negative date or time values

Leave a Reply