excel basics for data analysis coursera week 2 quiz answers

Practice Quiz

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

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

2. What do you use the AutoFill feature for?

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

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

  • Percentage
  • Calculation
  • Reference
  • Division

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

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

5. What are Excel cell references by default?

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

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

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

Graded Quiz

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

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

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

  • Select “Format cells” from the Format drop-down list in the Cells group
  • Select the data and click the Decrease Decimal button
  • Right-click on a cell and select Number Format
  • Select “More Number Formats” from the Number Format drop-down list in the Number group

Shuffle Q/A 1

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

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

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

  • Count Numbers
  • General
  • Accounting
  • Number

Leave a Reply