excel basics for data analysis coursera week 1 quiz answers

Practice Quiz

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

  • Storage
  • Selling stocks
  • Converting documents
  • Statistical analysis

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

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

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

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

Graded Quiz

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

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

5. How are Excel worksheet cells referenced?

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

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+End
  • CTRL+Up
  • CTRL+Down

Leave a Reply