Практикум
  • формат pdf
  • размер 1,22 МБ
  • добавлен 22 марта 2013 г.
Методические указания - Advanced Excel Training
Virginia Beach, VA: Regent University, 2007. – 12 p.
(Автор не указан).
Рассматривается версия MS Excel 2007.
Contents:
Create worksheet of economic data.
Auto-format the table.
Change cell formats to include dollar signs ($) where needed.
Add a comment in cell.
Set a formula to calculate year to year growth.
Use conditional formatting to highlight years with growth.
Use absolute references to calculate the percentage of the total gross domestic product.
Freeze panes so that row and column labels are fixed as you scroll.
Create a chart and link it to PowerPoint.