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