excel basics for data analysis coursera answers week 1

Introduction to Data Analysis Using Spreadsheets

Practice Quiz

1. Of the following, which one would be considered a core capability of spreadsheets?

  • Selling stocks
  • Converting documents
  • Storage
  • Statistical analysis

2. When you open an Excel workbook or spreadsheet, what kind of file is it?

  • .gsheet
  • .docx
  • .xlsx
  • .pdf 

3. According to the video, on the Excel Home tab what groups are listed?

  • Font, Alignment, Number, Styles 
  • Table, Illustrations, Add-ins, Charts
  • Font, Paragraph, Styles, Editing
  • Tools, Pens, Convert, Replay

Graded Quiz

4. Which of the following key Data Analyst tasks is typically done last?

  • Analyzing data
  • Collecting data
  • Cleaning data
  • Visualizing data

5. How are Excel worksheet cells referenced?

  • Column number first then row letter
  • Column letter first then row number
  • Row number first then column letter
  • Cell number first then row number

6. Which of the following Excel keyboard shortcuts could be used to find how many rows of data you have in a worksheet, assuming you have no empty rows in your data? Select all that apply.

  • CTRL+Home
  • CTRL+Up
  • CTRL+Down

  • CTRL+End

Leave a Reply