7Ques-Graphs

# 7Ques-Graphs - This Excel Workbook contains 2 Sheets. The...

This preview shows pages 1–4. Sign up to view the full content.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: This Excel Workbook contains 2 Sheets. The contents of these Sheets are listed These Sheets may be accessed by clicking on the Tabs at the bottom of each pa Tab Sheet # Label Sheet Contents 1 COVER SHEET Table of contents for the 3 Sheets, and Excel Instructions (scroll down on this sheet) 2 GRAPHS Problem involves: - Preparing a break-even graph- Answering the 7 CVP questions based on the- Question concerning favoribility of variable vs. fixed expenses Excel Instructions - You will need these instructions for the graphs in the &quot;GRA In order to draw lines and brackets on the graphs in this workbook you must do Note: The clicks below are ALL left mouse button clicks unless right-click is spe 1) Click on &quot;View&quot; at the top of the screen 2) Click on &quot;Toolbars&quot; on the drop-down menu 3) Click on &quot;Drawing&quot; on the secondary drop-down menu A new toolbar will appear either at the top or bottom of the screen 4) On this toolbar you will see the word &quot;Autoshapes&quot; followed by a down arrowhe- Among the graphics will be a line and an arrow. If you click on these a first ti move the cursor onto the graph where you want to draw either the arrow or t You deposit the lines on the graph by left-clicking a second time.- On this toolbar will be the word &quot;Autoshapes&quot; and an arrowhead. If you click arrowhead a menu will appear. - On this menu you should go to &quot;Basic Shapes&quot;. There you will find the right If you click once on one of these brackets you can move your cursor to the g want the brackets to appear and click there a second time. 5) until two THIN crossed lines appear. When they appear RIGHT-CLICK on them menu will appear. On this menu click on &quot;cut&quot;. BEFORE GOING TO THE NEXT TAB, PRACTICE THE ABOVE PROCEDURES IN T COLUMNS TO THE RIGHT OF THESE INSTRUCTIONS (IMPORTANT - IF YOU DO NOT KNOW HOW TO DRAW A GRAPH, AND BRACK EXCEL YOU SHOULD READ THE EXCEL INSTRUCTIONS BELOW) TO REMOVE any of these items from the graph, move the cursor over the item y d below. age. e graph APHS&quot; Tab o the following: ecified. ead and some graphics time you may then the line. k on the down t or left brackets. graph where you m and a THE EMPTY KETS, USING ) you wish to delete IT IS SUGGESTED THAT YOU PRACTICE THIS PROBLEM UNTIL YOU CAN SOLVE IT WITHOUT LOOKING AT THE SOLUTIONS You may view the instructions for this problem by using the page down (PgDn) or the page up (PgUp) keys. You may go to a BLANK GRAPH by pressing the F5 function ke and entering K1 in the window. This blank graph is provided for you to practice on an in columns K through AP to the right. Beneath this blank graph is a correctly filled-in that you should use to correct your practice graph. Read the instructions below befor attempting to prepare the graph for the following income statement....
View Full Document

## 7Ques-Graphs - This Excel Workbook contains 2 Sheets. The...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online