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
