File open select the samples xls open
Download
1 / 126

File→ open→ select the samples.xls → open - PowerPoint PPT Presentation


  • 132 Views
  • Uploaded on

File→ open→ select the samples.xls → open. Click new tool from the standard tool bar. File → save as → select Microsoft excel 5.0/95 work book from save as type → click save. Help → Microsoft excel help → type advanced filters → click search.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' File→ open→ select the samples.xls → open' - belva


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript










Click copy from the standard tool bar → select the Marketing worksheet → click paste from the standard tool bar



Edit → select replace → type Jane Harris in the find what → type Tom Snow in replace with → click replace all


Click the sort descending tool from the standard tool bar what → type Tom Snow in replace with → click replace all


Right click on the sales worksheet → select insert → ok what → type Tom Snow in replace with → click replace all


Right click on the Annuals worksheet → select move or copy → select Contracts from to book → select move to end from before sheet → ok


= B5-B11 → select Contracts from to book → select move to end from before sheet → ok


A#NAME? Error message → select Contracts from to book → select move to end from before sheet → ok


=B3*$C$1 → select Contracts from to book → select move to end from before sheet → ok


=sum(B2:B4)+$B$8 → select Contracts from to book → select move to end from before sheet → ok


Type = min (F5:F7) → press Enter → select Contracts from to book → select move to end from before sheet → ok


=sum(B3:B9) → select Contracts from to book → select move to end from before sheet → ok


=IF (B3>300, 10%, 0%) → select Contracts from to book → select move to end from before sheet → ok


Click on increase decimal tool from the formatting tool bar → select Contracts from to book → select move to end from before sheet → ok


Format → select cells → select currency from the category → select £ English (United Kingdom) → ok


Click on the bold tool from the formatting tool bar category → select £ English (United Kingdom) → ok



Format → select cells → select Alignment tab → in the orientation area move the red point up to the first point



Click copy from standard tool bar → select the Conference workbook → click paste from the standard tool bar





View → select Header and Footer → click custom Header → click in the center section→ click on → ok → ok



File → select print → ok the gridlines in the print section











The first CostsX put it on 110 The second X put it on Apr The second X put it on pares




=count (B4:D10) Selection





Click the arrow in the chart tool bar → select the chart area → click on the format Chart area tool → select the yellow color → ok



File→ print → ok → type Confidential


Select cell A4 and drag to cell C6 → type Confidential


pens → type Confidential


=D12-D8 → type Confidential=sum(D10:D11)-sum(D4:D7)


Click on the cut tool from the standard tool bar → select the Qtr3 sheet → select cell A1→ click on the paste tool from the standard tool bar



Right click on the Trees worksheet tab → select move or copy → check the create a copy → from the to book drop down list select the Contracts workbook → select (move to end) → ok


Format → cells → Alignment → from the drop down list of the Horizontal → select center Across Selection


=sum(D3:D5)-D6 of the Horizontal → select center Across Selection


=max(B3:B9) of the Horizontal → select center Across Selection


Type = max (F5:F7) → press enter from the keyboard of the Horizontal → select center Across Selection


#VALUE! of the Horizontal → select center Across Selection


Click on the percent style tool from the formatting tool bar of the Horizontal → select center Across Selection


Press Delete from the keyboard of the Horizontal → select center Across Selection


File → select print preview of the Horizontal → select center Across Selection






Week 7 list and select 75%


=B6 – B11 list and select 75%



$c$1 → select Contracts workbook → ok


=average(B3:B9) → select Contracts workbook → ok






File → save as → in the save as type → from the drop down list → choose text (Tab delimited) → save


Select the cell B2 → window → select freeze pane down list → choose text (Tab delimited) → save


Select the column B → insert → columns down list → choose text (Tab delimited) → save


Type = B4-C4 down list → choose text (Tab delimited) → save


File → close down list → choose text (Tab delimited) → save


View → Toolbars → Drawing down list → choose text (Tab delimited) → save


ad