Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge | Entering and Formatting Data
Excel Essentials
course content

Contenido del Curso

Excel Essentials

Excel Essentials

1. Introduction to Excel
2. Entering and Formatting Data
3. Basic Formulas and Functions
4. Advanced Formulas and Functions
5. Data Management and Analysis
6. Visualizing Data with Charts and Graphs
7. Working with Worksheets and Workbooks

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the second section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on Row 3 & drag the boundary to show the title header in full.
  • Click on Column B. Double click the boundary on the right to automatically adjust the width.
  • Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
  • Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
  • Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
  • Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
  • Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
  • Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
  • Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.
  • Select cell B3. Go to the Font style drop-down menu and choose a font from the list.
  • Select cell B3. Click on the Font size button and choose 14.
  • Click on B3. Go to the Font section, click on the Font color and select one.
  • Select cells from B5 to B8. Go to the Font section and choose a different font.
  • Select cells from B11 to I11 and click the Bold button. Or use the shortcut Ctrl + B.
  • Click on G5 and click the Underline and Italic buttons.
  • Select cells B11 to I11. Go to the Orientation button and choose Rotate Text Up.
  • Select cells B12 to B18. Go to Number section then More Number Formats and choose English (US).
  • Select cells C20 to I21. Go to Number section then Number Format. Click Currency and select the dollar symbol.
  • Select cells C12 to I18. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter 0.00.

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on Row 3 & drag the boundary to show the title header in full.
  • Click on Column B. Double click the boundary on the right to automatically adjust the width.
  • Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
  • Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
  • Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
  • Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
  • Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
  • Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
  • Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.
  • Select cell B3. Go to the Font style drop-down menu and choose a font from the list.
  • Select cell B3. Click on the Font size button and choose 14.
  • Click on B3. Go to the Font section, click on the Font color and select one.
  • Select cells from B5 to B8. Go to the Font section and choose a different font.
  • Select cells from B11 to I11 and click the Bold button. Or use the shortcut Ctrl + B.
  • Click on G5 and click the Underline and Italic buttons.
  • Select cells B11 to I11. Go to the Orientation button and choose Rotate Text Up.
  • Select cells B12 to B18. Go to Number section then More Number Formats and choose English (US).
  • Select cells C20 to I21. Go to Number section then Number Format. Click Currency and select the dollar symbol.
  • Select cells C12 to I18. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter 0.00.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 2. Capítulo 4

Elige tu plan

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the second section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on Row 3 & drag the boundary to show the title header in full.
  • Click on Column B. Double click the boundary on the right to automatically adjust the width.
  • Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
  • Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
  • Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
  • Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
  • Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
  • Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
  • Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.
  • Select cell B3. Go to the Font style drop-down menu and choose a font from the list.
  • Select cell B3. Click on the Font size button and choose 14.
  • Click on B3. Go to the Font section, click on the Font color and select one.
  • Select cells from B5 to B8. Go to the Font section and choose a different font.
  • Select cells from B11 to I11 and click the Bold button. Or use the shortcut Ctrl + B.
  • Click on G5 and click the Underline and Italic buttons.
  • Select cells B11 to I11. Go to the Orientation button and choose Rotate Text Up.
  • Select cells B12 to B18. Go to Number section then More Number Formats and choose English (US).
  • Select cells C20 to I21. Go to Number section then Number Format. Click Currency and select the dollar symbol.
  • Select cells C12 to I18. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter 0.00.

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on Row 3 & drag the boundary to show the title header in full.
  • Click on Column B. Double click the boundary on the right to automatically adjust the width.
  • Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
  • Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
  • Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
  • Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
  • Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
  • Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
  • Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.
  • Select cell B3. Go to the Font style drop-down menu and choose a font from the list.
  • Select cell B3. Click on the Font size button and choose 14.
  • Click on B3. Go to the Font section, click on the Font color and select one.
  • Select cells from B5 to B8. Go to the Font section and choose a different font.
  • Select cells from B11 to I11 and click the Bold button. Or use the shortcut Ctrl + B.
  • Click on G5 and click the Underline and Italic buttons.
  • Select cells B11 to I11. Go to the Orientation button and choose Rotate Text Up.
  • Select cells B12 to B18. Go to Number section then More Number Formats and choose English (US).
  • Select cells C20 to I21. Go to Number section then Number Format. Click Currency and select the dollar symbol.
  • Select cells C12 to I18. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter 0.00.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 2. Capítulo 4

Elige tu plan

Challenge

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the second section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on Row 3 & drag the boundary to show the title header in full.
  • Click on Column B. Double click the boundary on the right to automatically adjust the width.
  • Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
  • Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
  • Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
  • Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
  • Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
  • Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
  • Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.
  • Select cell B3. Go to the Font style drop-down menu and choose a font from the list.
  • Select cell B3. Click on the Font size button and choose 14.
  • Click on B3. Go to the Font section, click on the Font color and select one.
  • Select cells from B5 to B8. Go to the Font section and choose a different font.
  • Select cells from B11 to I11 and click the Bold button. Or use the shortcut Ctrl + B.
  • Click on G5 and click the Underline and Italic buttons.
  • Select cells B11 to I11. Go to the Orientation button and choose Rotate Text Up.
  • Select cells B12 to B18. Go to Number section then More Number Formats and choose English (US).
  • Select cells C20 to I21. Go to Number section then Number Format. Click Currency and select the dollar symbol.
  • Select cells C12 to I18. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter 0.00.

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on Row 3 & drag the boundary to show the title header in full.
  • Click on Column B. Double click the boundary on the right to automatically adjust the width.
  • Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
  • Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
  • Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
  • Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
  • Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
  • Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
  • Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.
  • Select cell B3. Go to the Font style drop-down menu and choose a font from the list.
  • Select cell B3. Click on the Font size button and choose 14.
  • Click on B3. Go to the Font section, click on the Font color and select one.
  • Select cells from B5 to B8. Go to the Font section and choose a different font.
  • Select cells from B11 to I11 and click the Bold button. Or use the shortcut Ctrl + B.
  • Click on G5 and click the Underline and Italic buttons.
  • Select cells B11 to I11. Go to the Orientation button and choose Rotate Text Up.
  • Select cells B12 to B18. Go to Number section then More Number Formats and choose English (US).
  • Select cells C20 to I21. Go to Number section then Number Format. Click Currency and select the dollar symbol.
  • Select cells C12 to I18. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter 0.00.

¿Todo estuvo claro?

Quiz

It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.

Note

If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.

Completing the Workbook

Having completed the second section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier. If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:

Tarea

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

  • Click on Row 3 & drag the boundary to show the title header in full.
  • Click on Column B. Double click the boundary on the right to automatically adjust the width.
  • Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
  • Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
  • Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
  • Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
  • Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
  • Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
  • Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.
  • Select cell B3. Go to the Font style drop-down menu and choose a font from the list.
  • Select cell B3. Click on the Font size button and choose 14.
  • Click on B3. Go to the Font section, click on the Font color and select one.
  • Select cells from B5 to B8. Go to the Font section and choose a different font.
  • Select cells from B11 to I11 and click the Bold button. Or use the shortcut Ctrl + B.
  • Click on G5 and click the Underline and Italic buttons.
  • Select cells B11 to I11. Go to the Orientation button and choose Rotate Text Up.
  • Select cells B12 to B18. Go to Number section then More Number Formats and choose English (US).
  • Select cells C20 to I21. Go to Number section then Number Format. Click Currency and select the dollar symbol.
  • Select cells C12 to I18. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter 0.00.

Sección 2. Capítulo 4
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
We're sorry to hear that something went wrong. What happened?
some-alt