Excel courses

Training to learn EXCEL for office use


Télécharger Training to learn EXCEL for office use

★★★★★★★★★★3.5 étoiles sur 5 basé sur 1 votes.
Votez ce document:

Télécharger aussi :


Training to learn EXCEL for office use

...

Exercise 1

  1. Open a new Excel file. Delete the worksheets: Sheet2 and Sheet3.
  2. Create the worksheet shown above in Sheet1 and rename it as Coral.
  3. Set the column widths as Columns A, B: 9; Columns C& D: 11.
  4. Set the Height of Row 2 as 40.
  5. Align all column labels horizontally and vertically at the center.
  6. After entering the data, insert a new row between rows 2 & 3.
  7. Format column F to include $ sign and 2 decimal places.
  8. Apply border to the cells.
  9. Center the worksheet vertically and horizontally on the page.
  10. Save the file with the name Excel 1.

Exercise 2

  1. Create the worksheet shown above.
  2. Set the column widths appropriately.
  3. Enter a formula to find Sales Price for the first item.

Sale Price = List Price-Discount. Copy the formula

to the remaining items.

  1. Enter a formula to find Sales Tax for the first Item.

Sale Tax = Sales Price * 0.05. Copy the formula to t

he remaining items.

  1. Enter a formula to find Total Price for the first item.

Total Price = Sales Price + Sales Tax. Copy the

formula to the remaining items.

  1. Set the columns labels alignments appropriately.
  2. Create a Header that includes Your Name in the left section, Date in the center section, and Your ID number in the right section.
  3. Create Footer with Page Number in the center section.
  4. Center the worksheet vertically and h

orizontally on the page.

  1. Save the file with the name Excel 2.

Exercice 3



  1. Create the worksheet shown above and rename it as Commission Report.
  2. Set the column widths appropriately.
  3. Use any AutoFormat to your worksheet.
  4. Set the Cell Range A6:A11 to Number.
  5. Find COMM. (Commission), where COMM = SALES * COMM. RATE.
  6. Find the BONUS. If SALES greater than or equal to 500000, bonus is 0.5% on SALES, otherwise enter zero.
  7. Find TOTAL COMPENSATION which is equal to COMM. + BONUS.
  8. Calculate the TOTAL, HIGHEST, and LOWEST values as shown above.
  9. Format Column E to include % and 2 decimal places.
  10. Format Column H to include $ and 3 decimal places.
  11. Center the worksheet vertically and horizontally on the page.
  12. Save the file with the name Excel 6

Exercice 4:

  1. Create the worksheet shown above.
  2. Find MARKUP, where MARKUP = SELLING PRICE – UNIT COST.
  3. Find %MARKUP, where %MARKUP = MARKUP/UNIT COST.
  4. Format Column F to include % and 3 decimal places.
  5. Calculate the TOTALS and COUNTS shown above using appropriate functions.
  6. Save the file with the name Excel 7.

II:

  1. Create the worksheet shown above and rename it as Grades.
  2. Find Grade which is equal to Midterm1 + Midterm2 + Project + Final.
  3. Find Status for each student, any student with a grade better than or equal to 80 is called "Distinct", all other students are called "Fulfilled".
  4. Use the auto format as shown in the figure.
  5. Create a Column chart based on the columns Student Name, Final and

Grade.

  1. Save the file with the name Excel 8.

III:

  1. Create the worksheet shown above and rename it as OSCAR.
  2. Name the cell range A22:B26 as Grade.
  3. Find Commission. Commission = Sales * Commission Rate.
  4. Find Car Allowance. Employees with grade D will get a Car Allowance BD 100 and others will get a zero.
  5. Find Social Insurance Cut which is Basic Salary * Social Insurance Rate.
  6. Find Monthly Salary which is Base Salary + Commission + Car Allowance – Social Insurance Cut.
  7. Using VLOOKUP, Find Position based on Grade.
  8. Save the file with the name Excel 9.

… … …



An Excel file is called a workbook?

A) True

B) False

What keystrokes would you press to bring up the “Excel Help” window?

class="c1">A) F4

B) F3

C) F1

D) F9

If you press the “Tab” key it moves one cell to the left.

A) True

B) False

You can format text in a cell in Excel.

A) True

B) False

Excel automatically adjusts row height to accommodate the size of data in a row.

A) True

B) False

To add color to a row or column you click the ___.

A) Click the font color button.

B) Fill color button (paint pail)

C) Set a colored border

You can create mixed references by placing a dollar sign in front of only the column letter or only the row number.

A) True

B) False

You can insert a row by right clicking a column heading.

A) True

B) False

You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press _________; to paste, press

__________.

A) CTRL+X and CTRL+V

B) CTRL+C and CTRL+V

C) CTRL+A and CTRL+V

D) CTRL+V and CTRL+X

Which function can you use to capture the contents of an open window?

A) Icon Set

B) Clip Art

C) SmartArt

D) Screenshot

A SmartArt graphic provides an audible representation of information.

A) True

B) False

“Values” can include numbers, formulas, and functions.

A) True

B) False

The “Fill handle” is a small square in the lower-left corner of a selected cell or range of cells.



A) True

B) False

=A7+A9 will subtract the two cells?

A) True

B) False

The shortcut key to “undo” an action in Excel 2010 is:

A) CTRL+PAGE UP

B) CTRL+HOME

C) CTRL+Z

D) CTRL+C

What is the default file extension when you save a workbook for Excel 2010?

A) .xls

B) .xlsx

C) .excel

D) .xlav

When you have selected a range of cells and then you press CTRL+P. Excel will automatically print the selected range.

A) True

B) False

Excel offers the “Spell Check” function.

A) True

B) False

<p> To use the Spell check function you go to the “View” tab on the ribbon.

A) True

B) False

Excel provides the following functions to be used except:

A) AVERAGE

B) MIN

C) MAX

D) HIGH

You can move a chart in a workbook from one sheet to another.

A) True

B) False

You can add Axis titles to a chart.

A) True

B) False



18