Microsoft Excel

True or false questions 1. All functions use a range of cells for the argument. There are no single cell referenced formulas? 2. When Excel calculates averages, blank cells or cells containing text are ignored? 3. The NOW function can be used to display the current date, time, or a combination of the two in several differen ...continues

Microsoft Excel

13. A new workbook will initially contain only three worksheets; more can be added later if needed. 14. If you inadvertently delete a worksheet, you can restore it by clicking the Undo button 15. You can move and copy worksheets to another workbook only if that workbook is open? 16. If a range of sheets is referenced in a for ...continues

Microsoft excel

28. What is the first step that should be taken when creating a chart? A. providing a name for the chart B. selecting the chart type C. selcting the range of cells that contain the data the chart will use D. choosing the data labels that will be used on the chart 29. If you want to print only the chart in a worksheet, wh ...continues

Microsoft excel

Predefined formatting attributes that can be applied to a cell are called? A. designs B. themes C. styles D. schemes If a worksheet is saved as a Web Page, and you want to jump from the worksheet to another file or location on the internet, you need to insert which of the following into the worksheet? A. Hyperlink B. ...continues

Microsoft Excel

You are Sam Vestering, manager of North American Distribution for Worldwide Enterprises. You are preparing a projected distribution revenue schedule for Marquee Productions' latest films Two by Two, to be released February 14, 2003. Create a new workbook that will estimate Worldwide's projected revenue using the following inform ...continues

Microsoft Excel S1-P1

1. You have received a message from Melissa Gehring of First Choice Travel with quoatations for return airfare, hotel, and airport transfers for the film crew to travel to Toronto for the location shoot July 7 to August 29, 2003. This information is summarized below: • Return Air Fare is $533.20 per person • Melissa has negoti ...continues

Excel S3-P4

Cal Rubine, chair of the Theatre Arts Division at Niagara Peninsula College, has asked you to create charts from the grades analysis report to present at a divisional meeting. After reviewing the grades, you decide to create a line chart depicting the grades for all of the courses and a pie chart summarizing the total grades. ...continues

Excel S3-P5

1. Melissa Gehring, manager of the Los Angeles office for First Choice Travel, has prepared a worksheet listing European destinations and the current package pricing options. Melissa has requested that you enhance the worksheet with clip art and formatting before she presents it at the next staff meeting. 2. Insert an appropria ...continues

Excel S2-P1

1. Dana Hirsch, manager of The Waterfront Bistro, has asked you to review the Inventory Units Purchased report and modify it to make it more readable and to view as much data as possible in one window. 2. Make the following changes: a. Freeze panes so you can scroll the worksheet without losing the column and row headings. ...continues

Excel S2-P3

1. Complete the invoice using the following information: a. Key the current date in G6 October 5,2005 b. Each custom costume fee is $2,500.00. Enter this value in F15:F19 c. Total the costume fees in F20 d. A transportation and storage container for each of the five costumes is $75.00. Enter the appropriate formula ...continues