Taking Charge of Excel: Test your skills >> Excel Skills For Business: Essential
1. How many rows in an Excel spreadsheet (version 2007 and later)?Infinite (no limit)
- 50,000
- 16,348
- More than 1 million
2. In a blank Excel workbook, go to the Insert tab on the ribbon. Which of the following is NOT available?
- Table
- Pictures
- Rows
- Shapes
3. In cell A1 type in the heading Date then press Enter. In cell A2 type in the following: 20-Jan-20. Use the fill handle to drag the date you have just typed down to row 20. What is the date in A15? Enter as shown or use Year-Month-Day format if you are not using an English version of Excel (for example 2020-01-20).2020-01-28
2020-01-28
4. In cells B1 to B3 enter the following:
Select cells B2 and B3 then use the fill handle to drag down to row 20. What is the value in B15?18.72
18.72
5.Close your workbook without saving and open the attached workbook. What value is in cell Q83 on the Orders sheet?W01-Assessment.xlsx13
13
6. How many worksheets are there in this workbook?3
3
7. Go to the Sales 2016 worksheet. Which cell contains the heading Qtr2?C3
C3
8. Still in Sales 2016, select the range B8:E10. Look at the status bar at the bottom of the screen. You should see Sum followed by a number. What is the number?(Hint: the range B8:E10 means to select all of the cells between B8 and E10. We go into this in more detail next week. Please use the number format #####.##)62272.98
62272.98
9. Select the two non-contiguous ranges (not next to each other) B4:B7 and D14:D17. What is the Average showing on your status bar for the two ranges?(Please use the number format ####.##)5549.49
5549.49
10.Change the value in C13 to be 4675.24. What is the new value in C18?(Please use the number format #####.##)62277.02
62277.02