ISC Excel para Negocios Básico
Excel Skills for Business: Essentials - Taking Charge of Excel: Test your skills, Part 1
ASESORIA O AYUDA AL +51 998706806
-----------------------
1.
Question 1
How many rows in an Excel spreadsheet (version 2007 and later)?
1 / 1 point
16,348
50,000
More than 1 million
Infinite (no limit)
Correct
Yes - isn't that amazing? This would make one large data set!
2.
Question 2
In a blank Excel workbook, go to the Insert tab on the ribbon. Which of the following is NOT available?
1 / 1 point
Shapes
Columns (not Column chart)
Pictures
SmartArt
Correct
You are spot on! There are several ways to insert columns, using the INSERT tab is not one of them. Go back to Excel and see if you can find the button for Insert columns.
3.
Question 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).
1 / 1 point
2020-02-02
Correct
Yes, great job on using the fill-handle. Isn't it amazing what you can already do in Excel?
4.
Question 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 B7?
1 / 1 point
18.72
Correct
Yes, great job on using the fill-handle. This is such a good productivity tool.
5.
Question 5
Close your workbook without saving and open the attached workbook. What value is in cell Q101 on the Orders sheet?
1 / 1 point
49
Correct
Yes, nice navigation skills!
6.
Question 6
How many worksheets are there in this workbook?
1 / 1 point
3
Correct
Yes, spot on.
7.
Question 7
Go to the Sales 2016 worksheet. Which cell contains the heading Qtr4?
1 / 1 point
E3
Correct
Yes, that's the correct cell. Check out your grasp of Excel terminology. Well done.
8.
Question 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 #####.##)
1 / 1 point
50933.77
Correct
Yes, nice use of the Status Bar. Isn't that a handy feature of Excel?
9.
Question 9
Select the two non-contiguous ranges (not next to each other) C8:C11 and E8:E11. What is the Average showing on your status bar for the two ranges?
(Please use the number format ####.##)
1 / 1 point
5549.49
Correct
Everyone say wow! Nice selecting and navigation skills!
10.
Question 10
Change the value in C13 to be 4675.24. What is the new value in C18?
(Please use the number format #####.##)
1 / 1 point
62119.27
Correct
Nice work on entering data into a spreadsheet correctly.
18 янв 2024
