MS Excel and PowerPoint Long Answer Type Questions Part 7
What is Cell Reference?
In Excel, a cell reference identifies the location a cell or group of cells in the spreadsheet. Sometimes referred to as a cell address, a cell reference consists of the column letter and row number that intersect at the cell’s location. Note that when listing a cell reference, the column letter is always listed first.
- Cell references are used in formulas, functions, charts, and other Excel commands.
- While references often refer to individual cells such as Al, B38, or Z345, they can also refer to a group or range of cells.
- Ranges are identified by the cell references of the cells in the upper left and lower right comers of the range.
- The two cell references used for a range are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points.
- An example of a range of adjacent cells would be B5:D10
Charts are visual representations of worksheet data. Charts often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.
How to delete a chart in Excel?
In Microsoft Excel, charts are used to make a graphical representation of any set of data. A chart is a visual representation of data, in which the data is represented by symbols such as bars in a bar chart or lines in a line chart.
Excel provides you different types of charts that suit your purpose. Based on the type of data, you can create a chart. You can also change the chart type later.
Excel offers the following major chart types:
- Column Chart
- Line Chart
- Pie Chart
- Doughnut Chart
- Bar Chart
- Area Chart
Deleting Chart Sheet:
- Display the chart sheet.
- Choose Delete Sheet from the Edit menu. Excel asks, if you are sure you want to delete the sheet.
- Click on OK. The chart sheet is deleted
How do you Print Worksheet? Explain
The setup for a worksheet or chart sheet can be changed when accessing the Print window. Every time the Print option is selected, Print Preview will be activated.
- Click the File Tab.
- Click Print on the left side of the window to open the Print Window.
- Click the Page Setup link at the bottom of the window.
- The Page Setup dialog box will display
- Choose the Page tab and change the Orientation to either Portrait or Landscape.
- Click the Header and Footer tab.
- Choose either Custom Footer or Custom Header.
- The Custom Header or Custom Footer dialog box will display
- Input the information for the Header or Footer.
- Using the buttons above the Header or Footer boxes to insert items such as Date, Page, Time, File Name, or Sheet Name.
- When the Header or Footer has been specified, click the OK button to return to the Page Setup window.
- To change the Margins for the worksheet, click the Margins tab.
- Click the spinner arrows for each Margin to make changes.
- To center the worksheet on the page both vertically and horizontally, click the check boxes for each of these items.
- Click the Chart tab to choose whether to print the Chart in Draft Quality and/or in Black and White. A Chart must be selected in order for this tab to display in the dialog box.
- To specify other Page Setup options, click the Options button.
- After all the changes have been made, click OK to close the Page Setup dialog box.
Write a short notes on Slide Layouts.
A presentation is a collection of slides that convey information to the audience. The name of each slide layout is displayed below the image in the Layout gallery. The first nine layouts in the illustration are the most popular and may be the only ones available on your computer. If there isn’t a layout available that meets a specific need, a custom layout can be created.
- Click the Home Tab.
- Do one of the following:
- In the Slides Group, click the arrow at the bottom of the New Slide button.
- In the Slides Group, click the Layout button
- The Slide Layout Gallery will display.
- To apply the layout, click the layout in the gallery.
- The table below provides a description of the each of the slide layouts.
Title Slide: This is the default slide layout when a new presentation is created. It provides placeholders for the title and subtitle of the presentation.
Title and Content: With this layout, it is possible to insert bulleted lists as well as other objects such as Tables, Charts, Pictures, Clip Art, Smart Art Graphics, and Media Clips. A placeholder is provided for adding a title to the slide.
Section Header: This slide layout contains placeholders for a title and a subtitle. It is used to start a new section in a presentation. The layout for the slide is slightly different than the title slide layout.
Two Content: To create a slide with two columns, select this slide layout. The slide has two placeholders where text or other objects may be inserted. There is also a placeholder for inserting a title for the slide.
Comparison: This slide layout is used when a comparison between two items needs to be made. The layout contains an additional text box at the top of each column where a heading for bo% of the columns can be inserted. There is also a placeholder for inserting a slide title.
Title Only: Use this slide layout when the content to be added isn’t one of the designated objects. This is a good layout to use when shapes or other objects are being inserted into a slide. The only placeholder on this slide is the one for the slide title.
Blank: This, is a good layout to use when an Excel chart or a Word table is being inserted into the presentation. This layout does not contain any placeholders.
Content with Caption: When a slide needs to contain content as well as a caption regarding the content, choose this slide layout. The slide will contain placeholders for the caption as well as for inserting text or objects.
Picture with Caption: To insert a picture as well as a caption, select this slide layout. The slide contains a placeholder for inserting the picture on the right side of the slide as well as placeholders for inserting captions on the left side of the slide.
Write a short notes on Slide Master.
The slide master is used to change the appearance of each instance of a slide element. If you apply a new design template, modify the color or size of the master text, or change the background color on the slide master, all slides in the presentation that have that layout reflect the change. If you add a graphic to the design slide master, it appears on every slide in the presentation. Likewise, if you modify the layout of the title master, the slides you’ve designated as title slides also change.
To display the slide master, do the following:
- Click the View Tab.
- In the Master Views Group, click the Slide Master button.
- The Master slides for the open presentation will appear in the pane on the left.
- The slide master for the slide where the insertion point is located will be highlighted.
- Scroll to the top of the slide masters to display the design slide master.
- Click the Design Slide Master thumbnail.
- This is the top master in the gallery on the left; the one that is larger than all the others.
- Move your mouse over the master to display the name of the master.
- The following adjustments can be made to any of the Slide Masters.
- Make another set of slide masters available to the presentation.
- Add a new layout with the same background, title, and footer style.
- Delete a layout.
- Specify which placeholders will be displayed on a slide layout.
- Select the theme for the master set.
- Fine tune the theme for the master set.
- Control the background color, font, texture, and graphics in the master slide.
- Set the default page setup for the presentation.
- Set animations for the content area of the slide master and for other elements in the presentation.
Discuss about Slide Sorter View.
This view gives an overview of the whole presentation with miniature slides. The slides appear in the order they were created. Slides may be moved by clicking and dragging the slide to a new location.
- To display Slide Sorter View, do one of the following:
- Click the View Tab.
- In the Presentation Views Group, click the Slide Sorter button. (or)
- Click the Slide Sorter button on the Views Toolbar.
- The slides will appear as shown in the illustration below.
- Move the mouse pointer over the slide to be moved.
- Press and hold down the left mouse button.
- Drag the slide to the desired location.
- A line will appear while you are dragging, showing where the slide is being moved.
- When the vertical line appears in the proper location, release the mouse button.
- The line needs to appear to the left of where the slide is to be inserted.
- The slide should be placed in the proper position.
- Slides may be rearranged in Normal, Outline View by clicking on the Slide icon and then dragging the slide to the desired position.
- Slides may also be rearranged in Normal, Slides view by clicking on the Slide and dragging it to the desired location.
- You may also use cut, copy, and paste to move slides to a new location.