MS Excel and PowerPoint Long Answer Type Questions Part 7

MS Excel and PowerPoint Long Answer Type Questions Part 7

MS Excel and PowerPoint Long Answer Type Questions Part 7

Question 1.
What is Cell Reference?
Answer:
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

Question 2.
Define Chart
Answer:
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.

Question 3.
How to delete a chart in Excel?
Answer:
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

Question 4.
How do you Print Worksheet? Explain
Answer:
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.

MS Excel and PowerPoint Long Answer Type Questions Part 7 1

  • 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.

MS Excel and PowerPoint Long Answer Type Questions Part 7 2

  • 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.

MS Excel and PowerPoint Long Answer Type Questions Part 7 3

Question 5.
Write a short notes on Slide Layouts.
Answer:
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

MS Excel and PowerPoint Long Answer Type Questions Part 7 4

  • The Slide Layout Gallery will display.

MS Excel and PowerPoint Long Answer Type Questions Part 7 5

  • 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.

Question 6.
Write a short notes on Slide Master.
Answer:
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.

MS Excel and PowerPoint Long Answer Type Questions Part 7 6

  • 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.

Question 7.
Discuss about Slide Sorter View.
Answer:
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.

MS Excel and PowerPoint Long Answer Type Questions Part 7 7

  • The slides will appear as shown in the illustration below.

MS Excel and PowerPoint Long Answer Type Questions Part 7 8

  • 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.

MS Excel and PowerPoint Long Answer Type Questions Part 6

MS Excel and PowerPoint Long Answer Type Questions Part 6

MS Excel and PowerPoint Long Answer Type Questions Part 6

Question 1.
Write about Resizing and Scaling of an Object.
Answer:
After inserting an AutoShape or image into your slide, very precise modification to that object may be necessary to achieve the desired effect. For example, after entering text into an AutoShape, you may want to reshape that object without modifying the text.

Resizing AutoShapes to Fit Text
If you have an AutoShape containing text, you may desire automatic resizing whenever the text size changes. You can adjust the AutoShape size to fit the text inside. Then, if you reduce the size of your text, the AutoShape will automatically resize to fit around the text.

Scaling Objects
The Scale command allows you to enlarge or reduce an AutoShape or image by very precise amounts while retaining its original proportions.

  • Select the object to be scaled
  • From the Format menu, select the option according to the object selected
    • For shapes, select AutoShape…
    • For images, select Picture…
  • The Format AutoShape or Format Picture dialog box appears, respectively.
  • Select the Size tab

MS Excel and PowerPoint Long Answer Type Questions Part 6 1

  • Under Scale, in the Height and Width text boxes, type the desired percentage of scaling
  • To maintain the formatted height and width percentages whenever you resize the object, select Lock aspect ratio
  • To find the percentage relative to the size of the original object, select Relative to original picture size
  • To find the best size of your object compared to the slide, select Best scale for slide show
  • To preview the changes, click PREVIEW
  • To accept the changes, click OK (OR) To go back to the original proportions, click RESET

Question 2.
Discuss about Slide Transition in MS PowerPoint.
Answer:
Transitions are motion effects that occur when a presentation moves from slide to slide in Slide Show view and affect how content is revealed.

These transitions determine what will happen when a new slide is displayed during the presentation. There are several different types of transitions available in PowerPoint. To see what each of the transitions look like before applying them, move the mouse pointer over the transition. A Live Preview of the transition will appear in the window.

  • Click the Transitions Tab.
  • In the Transition to this Slide Group, move the mouse pointer over the transitions in the transitions gallery.

MS Excel and PowerPoint Long Answer Type Questions Part 6 2

  • A Live Preview of the transition will appear in the window.
  • Click the More Button to locate additional transitions.
  • Click the up or down arrows at the end of the gallery of transitions to move through the gallery one line at a time.
  • In the Timing Group, select any of the options below to format the transition.

MS Excel and PowerPoint Long Answer Type Questions Part 6 3

    • To apply a sound to the transition, click the Sound arrow and choose a sound.
    • To change the speed for the transition, click the Duration arrows to increase or decrease the speed.
    • Click the Apply to All button to apply the selected / Transition Effects to all the slides in the presentation.
    • To decide how the transition will be activated, click one of the following:
      • On Mouse Click – The slide will change when the mouse is clicked.
      • Automatically After – Click this check box to determine how many seconds the slide should appear on the screen before moving to the next slide.

Question 3.
Explain the animation schemes in MS-PowerPoint.
Answer:
This tab can be used to set animations for the PowerPoint presentation. Animations determine how the bullets, pictures, images, and other objects will enter the slide during a presentation. The following paragraphs provides description of each of the groups and buttons on the ribbon associated with this tab.

MS Excel and PowerPoint Long Answer Type Questions Part 6 4

Preview Group:
Preview: This option is used to display an animation or slide transition after it has been applied to a slide.

Animations Group:
Animation Gallery: To select an animation effect for the selected element in a slide, click one of the options in this group. Click the More button in the bottom right comer of the gallery to view more options.

Effect Options: Click this button to apply additional effect options to the object, such as changing the direction of the animation.

Advanced Animation:
Add Animation: This is a method for adding additional animation to a slide object. The animation will be added after any animation already applied to the object.

Animation Pane: To open the Animation Pane, click this button, A list of animations that have been applied to the selected object will appear in the pane. When the arrow to the right of the animation object is selected, a list of options for working with the animation will appear

Trigger: This option is used to set a special start condition for an animation. The trigger can be set to have the animation start when another item is clicked or to have a media element play when the slide reaches a bookmark.

Animation Painter: Once an animation has been created, this button can be used to apply the same animation to other objects in the presentation. To apply the animation to more than one object, double-click the button and then click each of the objects to which the animation is to be applied.

Timing:
Start (On Click): This option is used to specify when an animation should start to play. The options are On Click, With Previous, and After Previous.

Duration: Click the spinner arrows for this option to specify how long the animation should play.

Delay: Use this option to specify how many seconds to wait before the animation starts to play.

Reorder Animation: The two options below are used to determine the order of the animations in a selected slide.

Move Earlier: Click this option to move the animation so that it will play earlier than the current position.

Move Later: To move the animation to later in the presentation, click this option.

Question 4.
How can you customize a presentation? (OR) Explain in detail Color Schemes & Text Animation.
Answer:

  • Click the Design Tab,
  • In the Variants Group, click the More button. This is the button in the bottom right corner of the Variants Gallery.
  • Select Colors from the list that appears.

MS Excel and PowerPoint Long Answer Type Questions Part 6 5

  • A gallery of different Theme Colors will display.
  • Move the mouse pointer over each of the Color Schemes to see the different colors that can be applied to the theme.
  • To create a new theme, click the Customize Colors link.
  • The Create New Theme Colors dialog box will display.

MS Excel and PowerPoint Long Answer Type Questions Part 6 6

  • Under the Theme Colors list, click each of the arrows to choose new colors for the theme.
  • A gallery of Theme Colors will display.
  • To apply a theme color to the object, click any of the colors in the Theme Colors gallery.
  • To select a standard color, click a color in the Standard Colors row.

MS Excel and PowerPoint Long Answer Type Questions Part 6 7

  • To select additional colors, click the More Colors button.
  • The Colors gallery will display.
    • Click any of the colors on the Standard tab to select it.
    • To make changes to the color, click the Custom tab.
  • After making all the changes, click the Save button.

Question 5.
Discuss about Slide Show in Power point.
Answer:
PowerPoint provides several tools that allow for presentation of a slide show to audiences everywhere. PowerPoint accommodates the following situations:

  • Presenting to a large audience in a conference room or an auditorium.
  • Showing a presentation on a computer that doesn’t have PowerPoint installed.
  • Broadcasting a presentation over an intranet or the Internet.
  • Meeting with a remote audience over the Internet in “real time.”
  • Participating in a Web discussion about a presentation.

Start a Slide Show:
Before a presentation is shown to an audience, it should be checked to make sure all the slides are in order, that the transitions work properly, and that all the timings are correct. A slide show can be viewed at any time during the creation process. There are several ways to view a Slide Show.

  • Click the Slide Show button on the View Toolbar.
  • Click the Slide Show Tab and in the Start Slide Show Group click one of the available buttons.
    • From Beginning — This option is used to start the presentation at the first slide.
    • From Current Slide – Use this option to start the presentation from the slide where the insertion point is located.
  • Press the F5 function key.

Navigate a Slide Show:
There are several ways to navigate through a slide show. The following table explains the keyboard and mouse shortcuts that may be used to navigate a slide show during a presentation. Mouse and Keyboard Shortcut Keys:

Action Used to
Left Mouse Click Move to the next slide.
Press Enter Move to the next slide.
Press Home Move to the first slide in the show.
Press End Move to the last slide in the show.
Press Page Up Move to the previous slide.
Press Page Down Move to the next slide.
Press a slide number and then press Enter Move to the slide number specified.
Press Esc Exit Slide Show view.

Question 6.
Inserting/Deleting Rows or Columns in Excel.
Answer:
Insert or delete a column

  • Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
  • Alternatively, right-click the top of the column, and then select Insert or Delete.

Insert or delete a row

  • Select any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.
  • Alternatively, right-click the row number, and then select Insert or Delete.

Question 7.
How to Inserting and Removing Page Breaks in MS-Excel?
Answer:
Excel makes page break decisions automatically, but sometimes you’ll want to force new pages elsewhere. Do this by. activating the cell beneath and to the right of where you want a page break, and then choose Set Page Break from the Insert menu. Dark dashed lines will mark the new page breaks.

To remove breaks, activate the cell below and to the right of the break lines and choose Remove Page Break, the command that replaces Page Break on the Insert menu.

Question 8.
What is a worksheet?
Answer:
A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Microsoft Excel or Google Sheets. A workbook is the name given to an Excel file and contains one or more worksheets. When you open an electronic spreadsheet program it loads an empty workbook file consisting of one dr more blank worksheets for you to use.

A worksheet is used to store, manipulate, and display data. The basic storage unit for data in a worksheet is a rectangular-shaped cell arranged in a grid pattern in every worksheet. Individual cells of data are identified and organized using the vertical column letters and horizontal row numbers of a worksheet which create a cell reference, such as A1, D15, or Z467.

Question 9.
What is work book? What is work sheet? Also explain their differences.
Answer:
Excel Workbook: An Excel workbook is just like a file or a book, which consists of one or more worksheets, having various sort of related information. It also enables you to create and maintain as many worksheets as required with no defined upper cap. The fundamental objective is to organize relevant data in a single place, but in different categories (worksheet). For instance, if a college were to maintain records of students, various worksheets could be one of student personal information record, one for their attendance, one for their fee deposit information, etc.

Excel Worksheet: An Excel worksheet is a single spreadsheet that is a matrix of rectangular cells, organized in a tabular form of rows and columns. In totality, it contains 1,048,576 rows and 16,384 columns, which simply means there are 17,179,869,184 cells in a single page of excel’s spreadsheet where you can write, edit, and manipulate your data. As per the naming convention followed, rows are referred to as natural numbers starting from 0 and columns are referred by alphabet(s) beginning from A. Practically, there is as such no limit of worksheets which you can keep in a workbook. It simply depends on the memory of the system used.

Differences

  • Establishing a link between two worksheets is much easier than linking two workbooks. Linking workbooks many a times create data security issues.
  • Data manipulation and analysis is only possible with worksheets and not workbooks. The workbook is just a cover page or face of entire data.
  • It is easy to add multiple worksheets in a workbook, where adding a workbook to another workbook isn’t an easy task.
  • Worksheet is just a subset of a workbook.

Question 10.
Explain CUT, COPY, PASTE, PASTE SPECIAL in Ms-Excel.
Answer:
CUT: Moving data in Excel is commonly used to relocate functions, formula, charts, and other data. The new location can be on the same worksheet, in a different worksheet, or even in a completely different workbook.

To move data using shortcut keys:

  • Click on a cell or multiple cells to highlight them.
  • Press and hold down the Ctrl key on the keyboard.
  • Press and release the X without releasing the Ctrl key.
  • The selected cell(s) should be surrounded by a moving black border show that the data in the cell or cells is being copied.
  • Click on the destination cell — when moving multiple cells of data, click on the cell located in the top left comer of the destination range.
  • Press and hold down the Ctrl key on the keyboard.
  • Press and release the V key without releasing the Ctrl key.
  • The selected data should now be present in the destination location only.

COPY: Copying data in Excel is commonly used to duplicate functions, formula, charts, and other data. The new location can be on the same worksheet, in a different worksheet, or even in a completely different workbook.

To copy data using shortcut keys:

  • Click on a cell or multiple cells to highlight them.
  • Press and hold down the Ctrl key on the keyboard.
  • Press and release the C key without releasing the Ctrl key.
  • The selected cell(s) should be surrounded by a moving black border to show that the data in the cell or cells is being copied.
  • Click on the destination cell — when copying multiple cells of data, click on the cell located in the top left comer of the destination range.
  • Press and hold down the Ctrl key on the keyboard.
  • Press and release the V key without releasing the Ctrl key.

PASTE: There are two ways to paste specific cell contents or attributes like a formula, format, or comment copied from another cell. You can either pick a specific paste option directly from the Paste menu or click Paste Special, and pick an option from the Paste Special box.

  • Select the cell with the attribute you want to copy and press Ctrl+C.
  • Click the upper-left cell of the paste area and use either the Paste options or the Paste Special options.
  • Click Home > Paste and pick the specific paste option you want.

PASTE SPECIAL:

  • To use options from the Paste Special box, click Home > Paste > Paste Special.
  • Keyboard Shortcut: Press Ctrl+Alt+V.

MS Excel and PowerPoint Long Answer Type Questions Part 6 8

  • In the Paste Special box, pick the attribute you want to paste.

Question 11.
How to Hide Rows and Columns in MS-Excel?
Answer:
You can hide rows or columns without destroying their contents then reveal them later when you want to see or edit them.

  • Select the row(s)or column (s) you want to hide
  • Choose the appropriate Hide and Unhide commands on the Format menu’s Row and Column choices.

To hide a row click on the row header, select Format —> Row -» Hide Command. This option hides the row from sight but the numbers in the row heading will show that there is a row missing. Display a hidden row. Highlight cells above and below the hidden row. Choose Format—»Row—»Unhide Command.

To hide rows with the mouse, select the row or rows of interest

  • Place the mouse pointer beneath the heading of the row or rows you want to hide, For instance, if you want to hide rows 3 and 4, select both rows.
  • Point beneath the appropriate number at the left edge of the worksheet.
  • You’ll see the pointer shape that indicates your ability to change row height.
  • Drag up until the rows are so thin that they disappear.

Question 12.
Explain Trend Lines?
Answer:
Trend lines are used to plot the direction of data in series. We can add trend lines to excel column area and scatter chart.

Creation:

  • Double click on a chart object if necessary to select it.
  • Select the data series for the trend line by double clicking on one of its markers.
  • Go to chart menu click on Add Trendline option.

MS Excel and PowerPoint Long Answer Type Questions Part 6 9

  • After it displays the following Trend line dialog box,
  • Click on ‘Trend/Regression Type’ on dialog box and dick on ok.
  • If necessary click the options tab it displays the following options.
    • Trend line name
    • Forward or backward
    • Display equation on chart

Display R-Squared valued on chart

MS Excel and PowerPoint Long Answer Type Questions Part 5

MS Excel and PowerPoint Long Answer Type Questions Part 5

MS Excel and PowerPoint Long Answer Type Questions Part 5

Question 1.
Explain the procedure to Create a Presentation. (OR) Explain different ways to Create Presentation.
Answer:
When the PowerPoint window first displays, a gallery of presentation templates will display. This gallery is used to create a new presentation. This document explains how to create a new presentation when another presentation has already been displayed. New slides can be added using the Slide Pane, the Outline Pane, or by inserting slides from other presentations.

Create New Presentation:

  • Click the File Tab.
  • The Backstage View window will display.
  • Click the New button in the left pane of Backstage View.

MS Excel and PowerPoint Long Answer Type Questions Part 5 1

  • Available templates and presentations will appear.
  • Click the Blank Presentation icon in the window.
  • A new blank presentation will appear in the PowerPoint window.
  • Click the Click to add title text in the first placeholder.
  • Input the text for the title of the presentation.
  • Click the Click to add subtitle text for the subtitle of the presentation.
  • The first slide of the presentation is completed.

Create a New Slide in Slide View:

  • Click the New Slide button in the Slides Group under the Home Tab.
  • The Slide Layout will automatically default to the Title and Content layout.
  • Input information for the Next slide (Slide 2) in the Presentation window by clicking on the Placeholder for each item.

MS Excel and PowerPoint Long Answer Type Questions Part 5 2

  • Hit Enter after inputting the first bulleted item and then input the second one.
  • Continue this process until all the bullet items have been added.
  • Click the New Slide list arrow.
  • Select one of the layouts from the gallery of Slide Layouts.
  • Another new slide will be inserted into the presentation.
  • Continue this process until all slides have been added.

MS Excel and PowerPoint Long Answer Type Questions Part 5 3

Create a Slide in Outline View:

  • Click the View Tab.
  • In the Presentations View Group, click the Outline View button.

MS Excel and PowerPoint Long Answer Type Questions Part 5 4

  • Click to the right of the New Slide Number.
  • Input a Title for the slide.
  • Press the Enter key on the keyboard.
  • Press the Tab key on the keyboard or click the Decrease List Level button in the Paragraph Group.

MS Excel and PowerPoint Long Answer Type Questions Part 5 5

  • Input the text for the first bullet.
  • Press Enter to add another bullet.
  • Continue this process until all the bullets have been entered.
  • Press Enter.
  • Press Shift + Tab or the Decrease List Level button in the Paragraph Group to create a new slide.
  • Input the information as described above.
  • Continue this process until all slides have been added.

Insert Slides From Another Presentation:
When this option is chosen, the slides from the other presentation will be inserted after the slide where the insertion point is located. To insert the slides at the end of the presentation, select the last slide in the presentation.

  • In the Slides Group, click the New Slide list arrow.
  • Click the Reuse Slides option.
  • The Reuse Slides Task Pane will display.
  • Do one of the following:
    • Click the Browse button and then select Browse File.
    • Click the Open a PowerPoint File link.
  • The Browse dialog box will display.
  • Scroll to the folder where the presentation is stored.
  • Select the presentation and then click the Open button.
  • The slides in this presentation will appear in the Reuse Slides Task Pane.

MS Excel and PowerPoint Long Answer Type Questions Part 5 6

  • Move the mouse pointer over one of the slides.
  • A larger view of the slide will appear in the window.
  • To add all the slides to the presentation:
    • Right-click one of the slides.
    • Click Insert All Slides.
  • To add only selected slides to the presentation, click each slide.
  • The slides will be inserted into the current presentation.
  • To keep the design of the presentation when it is inserted into the New Presentation, click the Apply Theme to All Slides option.
  • To keep the design of the presentation for selected slides, select the option Apply Theme to Selected Slides.
  • A blank slide may appear at the end of the presentation.
  • That slide can be removed by clicking on the slide in the Slide Pane and then clicking the Delete key.

Question 2.
What is Slide? Discuss in detail Working with Slides.
Answer:
A slide is a single page or image shown in a slideshow. Understanding slides and slide layouts:
When you insert a new slide, it will usually have placeholders to show you where content will be placed. Slides have different layouts for placeholders, depending on the type of information you want to include. Whenever you create a new slide, you’ll need to choose a slide layout that fits your content.

MS Excel and PowerPoint Long Answer Type Questions Part 5 7

Placeholders can contain different types of content, including text, images, and videos. Many placeholders have thumbnail icons you can click to add specific types of content.

To insert a new slide:
Whenever you start a new presentation, it will contain one slide with the Title Slide layout. You can insert as many slides as you need from a variety of layouts.

  • From the Home tab, click the bottom half of the New Slide command.
  • Choose the desired slide layout from the menu that appears.

MS Excel and PowerPoint Long Answer Type Questions Part 5 8

  • The new slide will appear. Click any placeholder and begin typing to add text. You can also click an icon to add other types of content, such as a picture or a chart.
    • To change the layout of an existing slide, click the Layout command, then choose the desired layout.
    • To quickly add a slide that uses the same layout as the selected slide, click the top half of the New Slide command.

Organizing slides:
PowerPoint presentations can contain as many slides as you need. The Slide Navigation pane on the left side of the screen makes it easy to organize your slides. From there, you can duplicate, rearrange, and delete slides in your presentation.

Duplicate slides:

  • If you want to copy and paste a slide quickly, you can

MS Excel and PowerPoint Long Answer Type Questions Part 5 9

  • To duplicate slides, select the slide you want to duplicate,
  • right-click the mouse,
  • choose Duplicate Slide from the menu that appears.
  • You can also duplicate multiple slides at once by selecting them first.

Move slides:
It’s easy to change the order of your slides. Just click and drag the desired slide in the Slide Navigation pane to the desired position.

Delete slides:
If you want to remove a slide from your presentation, you can delete it. Simply select the slide you want to delete, then press the Delete or Backspace key on your keyboard.

  • To delete slides, select the slide you want to delete
  • right-click the mouse,
  • choose Delete Slide from the menu that appears.
  • You can also delete multiple slides at once by selecting them first.

To copy and paste slides:
If you want to create several slides with the same layout, you may find it easier to copy and paste a slide you’ve already created instead of starting with an empty slide.

  • Select the slide you want to copy in the Slide Navigation pane, then click the Copy command on the Home tab. Alternatively-, you can press Ctrl+C on your keyboard.
  • In the Slide Navigation pane, click just below a slide (or between two slides) to choose a paste location. A horizontal insertion point will appear.
  • Click the Paste command on the Home tab. Alternatively, you can press Ctrl+V on your keyboard.

The slide will appear in the selected location.

Question 3.
Explain the following (a) Slide Numbering (b) Saving – Presentation (c) Printing a Presentation (d) Closing Presentation.
Answer:
(a) Slide Numbering:
To Insert Slide numbers to PowerPoint Slides, do the following.

  • Choose Header and Footer command from View menu, Following Header and Footer dialog box will appear.
  • In Header and Footer Dialog box. Select the appropriate options for your presentation.
  • Check the box for Slide Number
  • Most presentations do not show a number on the title slide. Check the option Don’t show on title slide if that is appropriate.
  • Click the apply to all button.

MS Excel and PowerPoint Long Answer Type Questions Part 5 10

Slide numbers will now automatically appear on all PowerPoint slides in the bottom right comer. One nice feature about letting PowerPoint number your slides is that if you rearrange the slides into a different order, PowerPoint renumbers the slides to display the new correct slide number

(b) Saving Presentation:
When saving your PowerPoint files, using the Save command versus Save As is an important distinction. The Save As command allows you to name your PowerPoint file every time it is chosen while the Save command saves the PowerPoint file under the existing name.

However, many users become confused because the first time a file is saved, both commands prompt you to name the file by opening the Save As Dialog Box.

The usual save as dialogue box will appear, prompting you to supply a name and location for the presentation Here is that dialogue box, for those who haven’t seen it before:

Think of a meaningful name for your presentation and type it into the File name input box. Try to avoid names like Presentation as you will soon forget what the purpose of the presentation is. It’s better to use names like “Introducing Science” etc. Once you have named your presentation, navigate to allocation on your computer’s hard drive and save it there.

MS Excel and PowerPoint Long Answer Type Questions Part 5 11

There is a quicker way of saving presentations using keyboard shortcuts. You can also perform a file save by pressing Ctrl-S. If this is the first time you have saved your presentation, you will again be prompted to name it and find a place for it to be stored. Thereafter, you can periodically press ctrl-s and your changes will be saved immediately.

(c) Printing a Presentation
In PowerPoint you can print notes pages, slides (one slide per page) and handouts of your presentation. A presentation that has been printed out allows your audience to follow along as you give your presentation and to gives them a record to refer to after the presentation. Before you print anything, you need to prepare your presentation by setting the slide size, page orientation, and starting slide number. Click File → Page Setup, and in the Page Setup dialogue we can change things like the slide orientation (portrait or landscape) and also the dimensions of the printable area.

MS Excel and PowerPoint Long Answer Type Questions Part 5 12

The Slides sized for drop down list allows you to select some commonly used sizes for printouts, but you can also change the width and height manually using their respective input boxes. If you want to print an overhead transparency, select overhead from the Slides sized for list. The Number slides from box allows you to change what page number prints on the very first slide or handout.

By default, PowerPoint slide layouts appear in landscape orientation but you can change this using the Page Setup or Slide Orientation button.

Printing the Presentation:
Once you have made all the preliminary preparations outlined above, you are ready to print. Click File > Print

MS Excel and PowerPoint Long Answer Type Questions Part 5 13

On this dialog you can specify how many copies you want to print and using what printer. If you want to print only a selection of slides in the presentation, you can use the Print Range select one of:

  • All
  • Current Slide
  • Print Selection (only prints the slides you have selected)
  • Custom Range (then use the Slides input box below to type in the page numbers you want to print)

The remaining selections allow you to choose whether to collate your printouts and whether to print in colour, grayscale or in black and white. There is also a sneaky little link at the bottom for editing header and footer details. Once all the settings have been addressed, click the big Print button at the top.

(d) Closing Presentation.
After you have finished working on a presentation and saved it, you can close it and open another file or you can exit the program. To close a presentation and exit PowerPoint, you can:

  • Use the File menu and choose to close or exit.
  • Use keyboard shortcuts. [Ctrl]+[W] closes a presentation and [Alt]+[F4] exits PowerPoint.
  • Use the Close button in the upper-right comer of the window.

Question 4.
How to Insert Picture/Clipart to a Power Point Presentation.
Answer:
Photo graphic images add impact to a presentation. It also helps the audience to visualize the message you are trying to convey.

  • Click where the picture is to be inserted.
  • Click the Insert Tab.

MS Excel and PowerPoint Long Answer Type Questions Part 5 14

  • In the Images Group click the Pictures button.
  • The Insert Picture dialog box will display with the Pictures Library folder selected.

MS Excel and PowerPoint Long Answer Type Questions Part 5 15

  • If the Picture is not in this folder, scroll to the folder where the image is located.
  • Do one of the following:
    • Double-click the image that is to be used.
    • Click the image and then click Insert.
  • Format the picture as desired.

Add Online Pictures:
Online pictures are copyright-free images of ClipArt, Photographs, Audio, and Video clips. Clips may be used to enhance any Office document. They may be inserted from the Bing Image Search.

Insert Pictures:

  • Click the slide in the presentation where the clip will be inserted.
  • Click the Insert Tab.
  • In the Illustrations Group, click the Online Pictures button.

MS Excel and PowerPoint Long Answer Type Questions Part 5 16

  • The Online Pictures window will display.

Bing Image Search:

  • In the Insert Pictures window, click the Bing Image Search box.

MS Excel and PowerPoint Long Answer Type Questions Part 5 17

  • Input the type of image to search for.
  • Click the Search button.
  • The Bing Image Search page will display.
  • Click an image to select it. A check mark will display at the top of the image.
  • Continue this process to select additional images.
  • Click the Insert button to add the image(s) in the slide.

Question 5.
How to Insert Other Objects, audio and Video in Power Point Presentation.
Answer:
You can import content from other programs into your presentation. This includes files created by other Microsoft Office programs, as well as files from other programs that support Object Linking and Embedding (OLE).

There are two ways to insert content objects into a PowerPoint presentation:
1. Linked objects: A linked object is updated if its source file is changed. For example, a linked chart built from data in Microsoft Excel is changed if the source Excel .data changes. The source file must be available on your computer or network to maintain the link between the inserted object and the source data. Inserting a linked object is recommended if the source data set is large or complex.

2. Embedded objects: The source data is embedded in the presentation. You can view the embedded object on another computer, because the source data is part of the presentation file. Embedded objects typically require more disk space than linked objects.

Inserting Audio Clip into Presentation:
PowerPoint presentations can be enhanced by adding Audio files. An Audio file can be set to play one time and then stop. A file can be set to loop, which means it will play continuously until a new slide is displayed. The audio can also be set to play across all slides in a presentation. Two, options are available for inserting Audio into a presentation.

Audio on My PC:

  • This option enables audio dim such as music, narration, or audio bites to be inserted into the presentation.
  • Compatible audio file formats include .mid or .midi, mp3, and .wav.
  • Sounds from CDs can be played by “ripping” the sound using Windows Media Player and saving it to your PC.

Record Audio:

  • This option is used to record a message for your audience.
  • A headset with a microphone is needed to insert this type of sound.

Audio on my PC:

  • This option is used to insert Audio clips such as narration, music, sounds taken from a CD, or audio bites into a presentation.

Insert the Audio File:

  • Go to the slide in the presentation where the sound is to be inserted.
  • Click the Insert Tab.
  • In the Media Group, click the Audio button.

MS Excel and PowerPoint Long Answer Type Questions Part 5 18

  • Select Audio on My PC.
  • The Insert Audio window will display.
  • Look for the folder where the audio clip is stored.
  • Select the Audio Clip.
  • Click the Insert button.
  • The Audio icon will appear in the window.

MS Excel and PowerPoint Long Answer Type Questions Part 5 19

  • Click the Audio Tools, Playback Tab to display the Playback Ribbon.

MS Excel and PowerPoint Long Answer Type Questions Part 5 20

  • Select the options on this ribbon that should be applied to this Audio Clip.

Inserting Video into Presentation :
With PowerPoint, it is possible to insert, size, and move videos. Videos can be formatted by applying styles and effects. With the video editing features in PowerPoint 2016, you can trim parts of a video and have the video fade in and out during a presentation.

Insert a Video from File:

  • Insert a new slide or go to the slide where the video is to be inserted.
  • Change the Layout for the slide to Blank or Title and Content.
  • Click the Insert Tab.
  • In the Media Group, click the Video button.
  • From the list that appears, select Video on my PC.
  • The Insert Video window will display.

MS Excel and PowerPoint Long Answer Type Questions Part 5 21

  • On the left side of the window, click the folder where the video is stored.
  • Select the Video.
  • Click Insert.
  • The video will display in the center of the slide.
  • Playback and volume controls will display below the video.

MS Excel and PowerPoint Long Answer Type Questions Part 5 22

  • Video formatting and editing tools display on the Video Tools, Format Ribbon.
  • Click the Play/Pause button below the video (This is the button on the far left side, the larger triangle shape).
  • On the Format Tab in the Size Group, click the Video Height box, input the size.
  • Press Enter to adjust the height and width of the video proportionally.
  • Click the Align button in the Arrange Group.

MS Excel and PowerPoint Long Answer Type Questions Part 5 23

  • Select Align Center from the list of options.
  • The video should appear centered on the slide.

MS Excel and PowerPoint Long Answer Type Questions Part 4

MS Excel and PowerPoint Long Answer Type Questions Part 4

MS Excel and PowerPoint Long Answer Type Questions Part 4

Question 1.
Discuss about Sort data in MS-Excel?
Answer: When sorting data, it is possible to sort by one field at a time or by multiple fields. For example, you might want to sort by Department and within that department by Last Name and then by First Name. To do this, you would choose to sort by multiple columns.

Sort by One Column:

  • Place the insertion point in the column that is to be sorted.
  • Click the Home Tab, if necessary.
  • In the Editing Group, click the Sort and Filter button.
  • Click one of the following options:
  • Sort A-Z – This will sort the data from the lowest to the highest value.
  • Sort Z-A – Click this option to sort the data from the highest to the lowest value.

MS Excel and PowerPoint Long Answer Type Questions Part 4 1
(OR)

  • Place the insertion point in the column that is to be sorted.
  • Click the Data Tab.
  • In the Sort and Filter Group, click one of the options.
    • AZ – To sort the data from the lowest to highest, click this button.
    • ZA – Use this button to sort the data from the highest to the lowest value.

Sort by Multiple Columns:

  • Move to any cell in the database.
  • Click the Data Tab.
  • In the Sort and Filter Group, click the Sort button.
    (OR)
  • Click the Home Tab.
  • In the Editing Group, click the Sort and Filter button.
  • In the list that appears, click Custom Sort.
  • The Sort dialog box will display.
  • In the Sort by box, select the first column for which the data is to be sorted.
  • In the Sort On box, leave the default of Values. The other options are Cell Color, Font Color, or Cell Icon

MS Excel and PowerPoint Long Answer Type Questions Part 4 2

  • In the Order box, select from:
    • A to Z – This option is used to sort the data from the lowest to highest value.
    • Z to A – Use this box to sort the data from the highest to lowest value.
    • Custom Lists – To specify a custom list for the sort, click this button.
  • Click the Add Level button to add a second level to the sort.
  • The Then by box will display.
  • In this box, select the second sort level.
  • Continue .this process until all the sort criteria have been specified.
  • To remove a sort level from the list:
    • Select the level that is to be removed.
    • Click the Delete Level button.
  • Click the Copy Level button to copy the same criteria for another level.
  • Click the Up and Down arrows to move the level of sort criteria up or down in the grid.
  • If the data that is being sorted has a header row, make sure a check mark appears in the My data has headers box.
  • Click the Options button to specify additional criteria for the sort.
  • The Sort Options dialog box will display.

MS Excel and PowerPoint Long Answer Type Questions Part 4 3

  • Under the Orientation section, select from one of the following:
    • Sort Top to Bottom – This option is used to sort the data by columns. This is the default for all sorts that are performed in an Excel database.
    • Sort Left to Right – Use this option to sort the data by-rows instead of by columns.
  • When all the options have been selected, click the OK button.
  • In the Sort dialog box, click the OK button to accept the sort criteria.

Question 2.
Discuss about the Basics of Excel
Answer:
What is Excel?

  • Excel is a computerized spreadsheet that allows you to:
    • organize data.
    • complete calculations.
    • make decisions.
    • graph data.
    • develop professional-looking reports.
    • convert Excel files for use on the Web.
  • It is an important business and educational tool that helps analyze and evaluate information.
  • It is used for recording and figuring grades and attendance, cash flow analysis, budgeting, decision-making, cost estimating, inventory management, and financial reporting.

Three Major Parts of Excel
Worksheets:

  • Worksheets allow you to enter, calculate, manipulate, and analyze data such as numbers and text.
  • These are sometimes referred to as spreadsheets instead of worksheets.

Charts:

  • Charts are a pictorial representation of data.
  • This feature can be used to draw a variety of two-dimensional and three-dimensional charts.
  • Excel makes it easy to create charts in several different varieties, such as bar charts, line charts, or column charts.

Databases:

  • Databases are used to manage data.
  • With this feature, you can sort data entered into a worksheet.
  • It is also possible to search for specific data using a database.
  • When using the database feature in Excel, it is possible to filter information to select data that meets specific criteria.
  • The database function is also used to add subtotals to cells that meet specified criteria.

Open Excel

  • Click the Search box next to the Start button.
  • Input Excel 2016.
  • Click the link at the top of the Start Menu.
    or
  • Click Start on the Task Bar. This is the button that appears in the bottom left comer of the computer window.
  • Scroll down to locate and select the link for Excel 2016.

Tabs/Ribbons:

  • The Tabs and Ribbons are used to access commands in the Excel program.
  • Under each tab, there are ribbons that contain groups of buttons that are needed to perform the operations for working with the workbooks.
  • Each of these tabs is described in separate documents within the Excel 2016 Training Web page.

Formula Bar

  • This bar is used to display the contents of the active cell.

MS Excel and PowerPoint Long Answer Type Questions Part 4 4

  • Cells can contain content such as Text, Numbers, Formulas, and Functions.
  • The data entered into a worksheet cell is displayed in the Formula
  • Bar before it is displayed in the cell.

Name Box:

  • This box appears at the left of the Formula Bar.
  • It is used to display the cell reference for the active cell, for example Al.
  • If Range Names have been created within the workbook, they can be accessed by clicking the list arrow at the end of this box.
  • These tabs can be renamed to reflect what is contained in the worksheet.
    • Right-click the tab and select Rename.
    • Double-click the Tab and then input a new name.
  • The color of the tab can also be changed.
    • Right-click the tab.
    • Move the mouse pointer over the Tab Color option.
    • Select a color from the gallery of colors.
  • New sheet tabs may be added to a workbook.
  • Click the New Sheet button at the bottom of the window.
    or
  • Click the Home Tab.
  • In the Cells Group, click the Insert arrow.
  • Click Insert Sheet.

MS Excel and PowerPoint Long Answer Type Questions Part 4 5

Sheet Tab Scroll Buttons:

  • These buttons are used to scroll through the sheet tabs.
  • They are located on the bottom-left side of the window.
  • Right-click – This option is used to open the Activate window. This window displays a list of the sheets in the workbook window. Click a sheet and then click OK. The selected sheet will be displayed.

Workbook:

  • The workbook is organized like a notebook.

MS Excel and PowerPoint Long Answer Type Questions Part 4 6

Status Bar:

  • This bar displays at the bottom of the screen.
  • It is used to display:
    • A brief description of the command selected.
    • The current activity mode that is in progress.
    • What mode you are operating in such as Ready mode or Edit mode.

MS Excel and PowerPoint Long Answer Type Questions Part 4 7

    • The views for the document. These are from left to right; Normal, Page Layout, and Page Break Preview.
    • The Zoom Bar. This bar is used to enlarge or reduce the size of the current view. The plus and minus signs are used to change the zoom range.

Pointer:

  • This is the indicator that moves on the screen when the mouse is moved.
  • It changes shape to reflect the type of task being performed.

Sheet Tabs:

  • These tabs are used to identify the name of the worksheet.
  • They are displayed at the bottom left side of the workbook window.
  • To select a tab, click on the desired sheet name, such as Sheet 1.

MS Excel and PowerPoint Long Answer Type Questions Part 4 8

  • Inside each workbook are sheets called worksheets.
  • Each name for the worksheet appears on a sheet tab.

Worksheet:

  • A worksheet is organized into a rectangular grid.
  • The worksheet contains columns and rows.
  • Letters identify the columns. There are more than 16,000 columns.
  • Numbers identify the rows. There are more than one million rows.

Cell:

  • This is the intersection of each column and row.
  • It is the area where the data is entered.

Cell Reference:

  • This is the unique address of a cell.
  • The column letter is specified first.
  • The row number is specified second
  • Examples of cell references are A1 and Bl.

Active Cell:

  • This is the cell where the data may be entered.
  • A black border appears around the Active Cell.

Active Cell Reference:

  • This information is displayed immediately above column A in the Name Box.
  • The column letter and row number of the cell that is active becomes darker.
  • It makes it easier to identify the cell reference.

Gridlines:

  • These are the horizontal and vertical lines in a worksheet.
  • It makes it easy to see and identify cells.
  • This option can be turned off so the gridlines don’t display.
  • The gridlines DO NOT show when the worksheet is printed unless that option is selected in the workbook.

Text:

  • Text is a combination of letters, symbols, numbers, and spaces.
  • Text is used to describe data.
  • It is also used to label columns and rows.
  • Text entries automatically align to the left in the column.

Values (Numbers):

  • Values represent a quantity.
  • Examples of values are 378, 25.275, -55.
  • By default, values are right-justified in the cell.
  • The justification can be changed to left or center.
  • Values can contain any digits zero through nine.
  • Values can also contain any of the following special characters; + -(),/. $%Ee

Formulas:

  • These are the arithmetic operators used to calculate values.
  • They always begin with an equal (=) sign. Arithmetic operators are:
    • Addition (=B1+B2).
    • Subtraction (=B1-B2). .
    • Multiplication (=09*69).
    • Division (C9/B9).
    • Exponentiation (=B5A3).

Function:

  • This is a predefined or built-in formula.
  • Functions are shortcuts for commonly used calculations.
    • The SUM function totals values in rows or columns.
    • The AVERAGE function finds the average of the numbers in rows or columns.
  • Functions can be defined for a range of cells or for a single cell.
  • All functions begin with an equal (=) sign.
  • A range is a group of cells which can be either a rectangular block of cells or a single cell.

MS POWERPOINT

Question 3.
What is PowerPoint? Explain its Features.
Answer:
PowerPoint is a complete presentation graphics program that can be used to present professional looking presentations called Slide Shows. Several features that make it easy to create a slide show are available. These tasks and options are readily available to the user. Diagrams, tables, pictures, video, sound, transitions, and animation effects can be added to the presentation. The features, listed below can be used when creating a PowerPoint presentation.

Feature of PowerPoint:
Word Processing: When working with a PowerPoint slide, it is possible to create bulleted and numbered lists, combine words and images, find and replace text, and use multiple fonts and font sizes. Tables created in Word can be imported into a PowerPoint slide or tables can be created directly in the PowerPoint program.

Outlines: Word outlines can be imported into the PowerPoint presentation to create slides. It is also possible to add text to a presentation using the outline feature in PowerPoint.

Charts: It is possible to create charts in PowerPoint. Once the chart has been created, it is possible to change or add chart elements. It is also possible to import charts from an Excel workbook. Different types of formatting may be added to a chart.

Draw: PowerPoint provides options for inserting different shapes such as rectangles, lines, arrows, circles, action buttons, and diagrams into a slide. These shapes and diagrams can be formatted and grouped.

Insert Multimedia: Videos and sounds, as well as animations, can be inserted into a slide Bing Search and YouTube can be used to locate hundreds of media files that may be inserted into a presentation.

Save to the Web: It is possible to save a presentation to the Web in HTML format. The presentation can then be displayed on the Internet or an Intranet. When a presentation is saved in HTML format, people viewing the presentation are not required to have PowerPoint installed.

Email: A presentation can be emailed as a PowerPoint attachment or as a PDF file attachment in an email message.

Collaborate: PowerPoint presentations can be shared with friends and coworkers. The slides can be reviewed by friends and coworkers and comments can be inserted with suggestions for enhancing the presentation.

Prepare Delivery: It is possible to rehearse the timing of a presentation so that it will be coordinated with the presenter’s speech. It is also possible to show only selected slides in the presentation and to package a presentation for a CD.

Question 4.
Explain Different Components of PowerPoint Window?
Answer:
This window consists of a variety of components to make creating a presentation more efficient. Some of these components are common to other Microsoft Office programs such as Word or Excel. Some of the components are unique to PowerPoint.

Comments Button: To insert a Comment into a presentation slide, click this button. When the button is clicked, the Comment Task Pane will appear. This pane can be used to insert a Comment or respond to a Comment.

File Tab: When this tab is clicked, the Backstage View will display. Contained within this area are commands for managing PowerPoint documents as a whole such as Print, Save, or Open. It also contains the link to the PowerPoint Options area, where global changes to the Power Point program can be made.

Fit Slide to Current Window Button: If a PowerPoint slide is larger than the current window, this button resizes the slide so it will fit in the current window.

MS Excel and PowerPoint Long Answer Type Questions Part 4 9

Next/Previous Slide Buttons: These buttons are used to move from one slide to another in the presentation. Each time the button is clicked, a new slide will appear on the screen.

Notes Button: Click this button to display the Notes Pane below the current slide. In this area, it is possible to insert speaker notes. These notes can be printed and used during a presentation.

Quick Access Toolbar: This toolbar is located above the Ribbon. The default buttons on this toolbar are the Save, Undo, and Redo buttons. The toolbar can be customized to contain any of the commands that you use frequently such as Open and Close.

Ribbon: The ribbon contains the commands that make it possible to use the different options in the PowerPoint program. The ribbon can be customized to meet individual needs. However, the default tabs and buttons cannot be changed. New tabs may be added and additional groups and buttons may be added to a group.

Scroll Arrow: Click this arrow to move from one slide to another. Each time the arrow is clicked, a new slide will appear on the screen. There is a scroll arrow at the top and the bottom of the Scroll Bar. .

Scroll Bar: This bar is used to display different slides in the document window. When a second slide is added to the presentation, this bar will appear in the PowerPoint window.

Scroll Box: The Scroll Box is used to move from one slide to another. When the bar is moved, a screen tip will display indicating which slide is to be viewed. When the mouse pointer is released, the slide number shown in the screen tip will display.

Slide Pane: This is the area of the PowerPoint window that shows the current slide as it will look during the Slide Show presentation

Slides Pane: To see a visual representation of several slides at one time, click this tab. This tab shows a thumbnail of each of the slides in a column along the left side of the PowerPoint window.

Status Bar: This bar provides information about the current document. To turn off the display of an item, right-click the status bar and then click on that item.

Text Placeholders: These placeholders are used to insert text into a presentation. There are also placeholders for images, SmartArt, Clip Art, and other objects used in the PowerPoint presentation.

Title Bar: This bar displays the name of the program that is open, along with; the document name. The minimize, maximize- restore, and close buttons are located at the right end of this bar.

View Toolbar: This toolbar is used to change to different views in PowerPoint. These are Normal View, Slide Sorter View, Reading View, and Slide Show View.

Zoom Buttons: These buttons are located on the far right of the status bar. With these buttons, it is possible to change the size of the view of the slides in the Slide Pane.

MS Excel and PowerPoint Long Answer Type Questions Part 3

MS Excel and PowerPoint Long Answer Type Questions Part 3

MS Excel and PowerPoint Long Answer Type Questions Part 3

Question 1.
What is a cell Reference? Explain the various types of Cell References.?
Answer:
The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column C and row 10 is CIO. In other words, A cell reference indicates a cell’s location. Cell references are often used in formulas to calculate values stored in the worksheet.

MS Excel and PowerPoint Long Answer Type Questions Part 3 1

Relative Reference: Whenever a formula is copied from one part of the worksheet to the other, the address of the cell changes, relative to the row or column into which the formula is copied as shown in the following fig.

This ability to change the formula to match the location where you copy it is called Relative Referencing (or Relative Addressing). The formula is always adjusted relative to its location.

Absolute Reference: An absolute reference is a cell reference that does not change when you copy or more a formula. To create an absolute reference, Insert dollar sign ($) in front of each column number and row number, like this =$B$5. You can copy this formula to any cell, and it will always reference cell B5. Thus, in absolute referencing, both row and column are fixed.

Mixed Reference: Mixed Reference is a combination of relative and absolute reference. That is, one part of the cell address is absolute and the other is relative. For example, in $B5 the column is absolute but the row is relative. Therefore, if you copy the formula ($B5) across the screen, it remains unaltered. Whereas if you copy the formula vertically, the row number automatically changes. Similarly in B$5, the column letter is relative but the row number is absolute.

Question 2.
How to change the font color, size, or type in Excel
Answer:
In Microsoft Excel, a user can change the properties of text in any cell, including font type, size, color, and make it bold, italic, or underlined. A user can also change the color of a cell’s background and the border around a cell. The following picture is a graphic illustration of the font and cell format bar in Excel with a description of each option.

Changing font type
To change the text font within a Microsoft Excel spreadsheet, follow the steps below.

  • Select the cell containing the text you want to change.
  • Click the down arrow next to the font field on the format bar. (If you want to change the font to bold, italic, or underlined, click the B, I, or U on the format bar.)
  • After clicking the down arrow for the font, select from each of the installed fonts on your computer. Click the font you want to use, and the text in the selected cell changes.

MS Excel and PowerPoint Long Answer Type Questions Part 3 2

Changing font size
To change the text size within a Microsoft Excel spreadsheet, follow the steps below.

  • Select the cell containing the text you want to change.
  • Click the down arrow next to the size box on the format bar. Usually, the default size is 11 or 12, as shown in the above example.
  • After clicking the down arrow for the size, there is a selection of different sizes to choose. Some fonts may not scale properly, so they may have limited size options.

Changing font color
To change the text color within a Microsoft Excel spreadsheet, follow the steps below.

  • Select the cell containing the text you want to change.
  • Click the down arrow next to the text color icon. It is usually displayed as the letter “A” with a red underline, as shown in the example above.
  • After clicking the down arrow for the text color, select the color you want to make the text.

Question 3.
Discuss about Charts and their Types in Excel?
Answer:
A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers,, and they make showing comparisons and trends much easier.

MS Excel and PowerPoint Long Answer Type Questions Part 3 3

Before creating a chart, it is important to plan the information that the chart is to show and how it is to look. Use the following guidelines when planning a chart.

  • Determine the purpose of the chart.
  • Identify the data relationships that are to be communicated visually.
  • Determine the results that are to be seen.
  • Decide which chart type is most appropriate to use.
  • Identify the worksheet data that the chart is to illustrate.
  • Sketch the chart and then use the sketch to decide where the chart elements should be placed.

Chart Types:
Column: This type of chart is useful for showing data changes over a period of time. It is also useful for illustrating comparisons among items. Data that is arranged in columns or rows on a worksheet can be plotted in a column chart. Categories are typically organized along the horizontal axis and i values along the vertical axis.

Line: This type of chart is used to display continuous data over a period of time. It is useful for showing trends in data at equal intervals. Category data is distributed evenly along the horizontal axis and the vertical axis. Data that is arranged in columns and rows in a worksheet can be plotted..

Pie or Doughnut: These chart types are used to display the contribution of each item to the total. Data for the chart can be selected either before or after the chart is created.

Bar: These charts are used to illustrate comparisons among individual items. This type of chart should be used when the axis labels are long or when the values shown are durations. Data that is arranged in columns or rows in a worksheet can be plotted in a bar chart.

Area: Area charts are used to emphasize the magnitude of change over time. They can be used to draw attention to the total value across a trend. These charts can also be used to show the relationship of parts to a whole.

Scatter (XY) or Bubble Chart: These chart types are used to compare pairs of values. To insert these two chart types, click * this button. Data for the chart can be selected either before or after the chart is created.

Stock, Surface, or Radar: This button is used to view a gallery of different types of stock, surface, or radar charts.

Combo Chart: This chart type is used to highlight different types of information. It can be used when range of data in the chart varies widely or when a wide range of mixed data is used.

Question 4.
Discuss about Chart elements in Excel
Answer:
There are several different elements to a chart. Each of the elements can be selected and formatted separately. The following paragraphs provides you with an illustration and explanation of each of these elements.

MS Excel and PowerPoint Long Answer Type Questions Part 3 4

Category (X) Axis: This is the horizontal or X-axis of the grid. It explains what each of the data series on the chart represents. The bars in a column chart represent a data series. It is possible to change the line, scale, font, number, and alignment attributes of this axis.

Chart Area: This is the entire area the chart covers. It is the background of the chart. When a chart is created, this area is usually white. The pattern used for the chart area can be changed, a border can be added, or a different font can be used.

Chan Title: This is the explanatory heading at the top of the chart. The title identifies the purpose of a chart.

Data Marker: This is a chart object, such as a circle, dot, or square that denotes a data point. In the chart in the illustration, the data points are the bars in the plot area of the chart.

Data Series: This element is a range of related data points in a chart, such as bars, columns, or pie slices. Each data series is represented with a certain color, identified in the legend. The outline and color used for each series, which axis the data are plotted on, the labels used, the series order, and the overlap and gap width between each series or point, can be changed.

Gridlines: These are the vertical and horizontal lines that appear in a chart. They are displayed in the plot area. A different line style, color, and weight can be used. It is also possible to select a different scale.

Handles: These are small circles that appear around the perimeter of a selected object, indicating that the object can be moved, resized, copied, or deleted.

Legend: This is the key to the chart, which shows by color plot what each series represents. The outline and color of the legend can be changed, as well as the font and place. For example, the legend can be moved to the top, bottom, comer, or left of the chart.

Plot Area: This is the area where the data series are plotted or graphed. It is the area that appears directly behind the data series; the rectangular shapes that are different colors. The pattern and color used can be changed, as well as the border of the plot area.

Value (Y) Axis: This is the vertical or Y-axis of the grid. This area represents the values that are being plotted in the worksheet. The values are determined by the cells selected in the worksheet when the chart is created. The pattern of the line, the format of the tick marks, the tick mark labels, the scale, the font, the number format, and the alignment of the axis labels can be changed.

Question 5.
Explain the steps to create a chart using chart wizard.
Answer:
A chart is also called a graph. It is a visual representation of selected data in a worksheet. A well-designed chart draws the reader’s attention to important data by illustrating trends and highlighting significant relationships between numbers.

  • For this exercise, you will use the High Tech Stock Club- Chart workbook shown below:

MS Excel and PowerPoint Long Answer Type Questions Part 3 5

    • This Column Chart will be used to compare the Initial Price and the Current Price.
    • With a Column Chart, either one data series or multiple data series may be selected.
    • In order to specify the Legend in a Column Chart, the column headings have to be selected.

Create Chart:

  • To create the Column Chart:
    • Select the range A2 through A7.
    • Hold down the Control key and select the following ranges:
      • E2 through E7.
      • G2 through G7.
    • When holding down the Ctrl key, it is possible to select a range of non-contiguous cells.

MS Excel and PowerPoint Long Answer Type Questions Part 3 6

  • Click the Insert Tab.
  • In the Charts Group, click the Column chart link.
  • A gallery of different styles of Column charts will appear.
  • Click the first option under 2-D Column. .
  • The Column Chart will appear in the window. The Chart Tools tabs will display.

MS Excel and PowerPoint Long Answer Type Questions Part 3 7

MS Excel and PowerPoint Long Answer Type Questions Part 3 8

Move Chart To Different Location Within Worksheet:

  • Move the mouse over the chart until the mouse pointer changes to a four-headed arrow.
  • Drag the chart to the desired location.

Resize Chart:

  • Select one of the resizing areas along the edge or comers of the chart.
  • Move the mouse button to one of these areas.
  • Click and drag the mouse pointer until the chart is resized appropriately.

Move the Chart to Different Sheet:

  • Click the Design Tab under the Chart Tools Contextual Tab.
  • Click the Move Chart button in the Location Group.
  • The Move Chart dialog box will display.
  • The choices in this dialog box are:
    • As new sheet – This option will insert a new sheet into the workbook. It will be titled Chart 1 unless otherwise specified.
    • As object in – Use this option to insert the chart directly into the worksheet that the chart is based on.

MS Excel and PowerPoint Long Answer Type Questions Part 3 9

  • Click the New Sheet option box.
  • Input a name for the Chart Sheet.
  • Click the OK button.
  • The chart will appear in its own window.
  • The tab will appear with the rest of the sheet tabs at the bottom of the window.

Question 6.
Discuss about Chart Editing and Formatting in Excel.
Answer:
Change the Chart Style:
When a Chart is created, it appears with a pre-formatted style. The colors in the Chart can be changed by using the Chart Styles feature.

  • Click the Chart Tools Design Tab.
  • In the Chart Styles Group, click the Change Colors button.

MS Excel and PowerPoint Long Answer Type Questions Part 3 10

  • Move the mouse pointer over each of the items to see a Live Preview of the colors.
  • Click one of the options to apply it to the Chart.
    or
  • Click one of the Styles in the Chart Styles gallery.
  • To see additional Styles click the More button.
  • Move the mouse pointer over each of the options to see a Live Preview of the Style.
  • Click one of the Styles to apply it to the Chart.

Format the Chart Title:

  • Click the Chart Title. A box with handles will display around the Chart Title.
  • Click the Home Tab.
  • In the Font Group, click the Font Size arrow.
  • Select a size of your choice to change the Font Size of the Title.
  • In the Font Group, click the Font Color button list arrow.
  • Choose a color from the Font Color palette.

Format the Chart Labels:

  • Click one of the data labels at the bottom of the chart.
  • A box will appear around the labels.
  • Click the Increase Font Size button in the Font Group, until the size changes to the desired size
  • Change the Font Color to the same color as the Title.
  • Click the Bold button in the Font Group to apply bold formatting to the labels.

Format the Chart Legend:

  • Click the Legend at the bottom of the chart.
  • Click the Increase Font Size button in the Font Group, until the size changes to 14 point.
  • Change the Font Color to the same color as the Title.
  • Click the Bold button in the Font Group to apply bold formatting to the Legend.
  • Click the Chart Tools Design Tab.
  • In the Chart Layouts Group, click the Add Chart Element button.
  • Move the mouse pointer over Legend.
  • Select a location for the Legend from the list.

Question 7.
Explain the procedure to Create Pie Chart in MS-Excel
Answer:
A pie chart is an easy way to show the relationship of items to the whole. In this exercise, you will be creating a Pie Chart that will show the relationship between the computer companies in the High Tech Stock Club. The difference between a Pie Chart and a Column Chart is that a Pie Chart can have only one data series while a Column Chart can have one or more.

MS Excel and PowerPoint Long Answer Type Questions Part 3 11

Create the Chart:

  • To create a Pie Chart, select the range A3 through A7, the names for the four computer companies. Notice for this chart that you don’t select the column heading.
  • Hold down the Control key and select the range H3 through H7, the data in the Current Value column.
  • Click the Insert Tab.
  • In the Charts Group, dick Pie.
  • A gallery of available 2-D and 3-D Pie Chart subtypes will display.
  • Click the 3-D Pie option.
  • The chart will appear in the worksheet

MS Excel and PowerPoint Long Answer Type Questions Part 3 12

  • Click the buttons along the right edge of the selected Chart to change different areas of the chart. The Chart Tools Contextual Tabs will appear.

Move the Chart:

  • Click the Design Tab under the Chart Tools Contextual Tab.
  • Click the Move Chart button in the Location Group.

MS Excel and PowerPoint Long Answer Type Questions Part 3 13

  • The Move Chart dialog box will display.
  • The choices in this dialog box are:
    • As new sheet – This option will insert a new sheet into the workbook. It will be titled Chart 1 unless otherwise specified.
    • As object in – Use this option to insert the chart directly into the worksheet that the chart is based on.
  • Click the New sheet option box.
  • Input a name for the Chart Sheet.
  • Click the OK button.
  • The chart will appear in its own window.

MS Excel and PowerPoint Long Answer Type Questions Part 3 14

Question 8.
Write about AutoFill option in MS-Excel
Answer:
Auto Fill is a process that allows the user to automatically number data in a column or row. It is an easy process to add sequential numbers to rows of data by filling a column with a series of numbers or by using the Row function

Fill Column with Series of Numbers:

  • Select the first cell in the range that is to be filled.
  • Type the starting value for the series, such as the number 1.
  • Type a value in the next cell to establish a pattern.
  • For example, if the series is to be 1, 2, 3. 4,…, type the number 1 in the first cell and then a number 2 in the second cell.
  • Select the two cells that contain the numbers.
  • The pointer wall turn to a black box with a little square in the right corner (see illustration).
  • Move the mouse pointer over the box by the little square until the mouse pointer turns to a black plus (+) sign (see illustration).

MS Excel and PowerPoint Long Answer Type Questions Part 3 15

  • Hold down the mouse button and drag down in the column until the desired cells are filled with numbers.
  • The cells should be numbered in consecutive order starting with number 1.
  • It is also possible to number the list non-consecutively. For instance, if you wanted to number the rows 2, 4, 6, 8…, type the number 2 in the first cell and the number 4 in the second cell.
  • Select the two cells and use the fill handle to copy the numbers down to the additional cells.

Fill Column or Rows with Month, Day, or other Series:
The process for filling columns or rows with the month or days is the same as for filling numbers. The only difference is that you input the day of the week or the month of the year in the column. It is also possible to fill a column or row with a series of consecutive or non-consecutive dates. An illustration of each of these fill patterns is shown on the next page.

Insert Days Of Week Into Column Or Row:

  • Input the first day, like Monday, into the first cell of the series.
  • Place the mouse pointer into the cell that contains the first day of the week.
  • Use the Fill Handle to copy the days down the column or across the row.
  • The days of the week will change as the copying is done.

Insert the Month of the Year:

  • Input the first month, like January, in the first cell of the series.
  • Place the mouse pointer into the cell that contains the first month of the year.
  • Use the Fill Handle to copy the months down in the column or across the row.
  • The months will change as the copying is being completed.

Insert Consecutive Dates:

  • Input the beginning date into the first cell of the column or row.
  • Place the mouse pointer in the cell that contains the date.
  • Use the Fill Handle to copy the date down the column or across the row.
  • A different date should appear in each of the cells in the series, starting with the first date and going in consecutive order.

MS Excel and PowerPoint Long Answer Type Questions Part 3 16

Insert Non-Consecutive Dates:

  • Input the beginning date into the first cell of the column or row.
  • In the second cell of the column or row, input the second date.
    • With this option it is possible to specify a period of time between dates, such as a month in between.
    • For instance, to specify the last day of each month, you would input January 31, 2020 in the first cell and. February 28, 2020 in the second cell.
  • Select the two dates and then use the Fill Handle to copy the information to the rest of the cells in the column or row.
  • The last day of the month should display in each consecutive cell.

NOTE:

  • It is also possible to number other items using the Auto Fill feature such as Versions or periods of a year.
  • For the version. Version 1 would be inserted into the first cell and then the Fill Handle would be used to insert Version 2, Version 3, and so forth. Each item would be numbered consecutively.
  • For the periods of a year, input something like 1st year then use the Fill Handle to insert the rest of the years. The years will be inserted in consecutive order.

MS Excel and PowerPoint Long Answer Type Questions Part 2

MS Excel and PowerPoint Long Answer Type Questions Part 2

MS Excel and PowerPoint Long Answer Type Questions Part 2

Question 1.
Discuss about Number formatting in MS-Excel?
Answer:
Once the functions, formulas, and/or other numbers have been inserted into the worksheet, it may be necessary to format them.

  • Select the cells that need to be formatted.
  • Click the Home Tab.

MS Excel and PowerPoint Long Answer Type Questions Part 2 1

  • In the Numbers Group, click one of the options for formatting numbers.
    • Number Format – This option provides a list of different number formats that may be applied to the selected cells.
    • Accounting Number Format – This button is used to format the numbers with dollar signs, two decimals places, and commas in the thousands place. Clicking the list arrow allows the numbers to be formatted in a different currency, such as Euros.
    • Percent Style — When this button is clicked, the format will be changed to percentage. A percentage sign will appear at the end of the number.

MS Excel and PowerPoint Long Answer Type Questions Part 2 2

    • Comma Style ~ To format a number without dollar signs, click this button, The number will appear with two decimal places and commas in any thousands place.
    • Increase Decimal – To increase the number of decimal places for the selected numbers, click this button. Each time the button is clicked, the number of decimal places will increase by one.
    • Decrease Decimal – This button is used to decrease the number of decimal places in the selected numbers. Each time the button is clicked, the decimal place will decrease by one.
  • Click the Dialog Box Launcher button in the bottom right comer of the Numbers Group to display additional formatting options.
  • The Format Cells dialog box will display
  • Select the desired format for the numbers in the cells.
  • Once the desired format has been selected, click the OK button.
  • The number format will be applied to the selected cells.
  • Some of the number formats are described in the list below.

General:

  • Choose this format to display numbers without dollar signs, commas, or trailing decimal places.
  • This is the Excel default format.

Number:

  • This option is used for the general display of numbers.
  • It is used to set the decimal places, to determine how the negative number displays, and to decide whether or not to include a comma separator.

Currency:

  • This format is used to set the decimal places and negative number display.
  • When this format is chosen, dollar signs and comma separators will be inserted automatically.

Accounting:

  • When this format is chosen, the decimals and dollar symbol ($) will line up.
  • It is possible to choose the symbol that is to be used.
  • The number of decimal places can also be specified.

Date:

  • Use this format to set how the date or the date and time will be displayed.
  • A list of possible formats will display.
  • Click the format that is to be applied to the selected cell(s).

Time:

  • To specify how the time of day is to be displayed in the selected cells, select this button.
  • A list of possible formats will display.
  • Click the format that is to be applied to the selected cell(s).

Percentage:

  • Use this format to insert a percent sign to the right of a number.
  • The number of decimal places can be specified.

Question 2.
Write about formatting features of MS-Excel?
Answer:
There are several features available for formatting cells within a worksheet. Here we will provide the directions on how to work with the different formatting features within the Excel program.

  • Click the Home Tab, if necessary.
  • In the Cells Group, click the Format button.
  • A list of options for formatting cells will display.
  • The paragraphs below describes each of the options within the Format list.

Cell Size:
The options in this group are used to change the size of a column or row.

Row Height: Click this option to open the Row Height dialog box. In this box, it is possible to change the height of a selected row. Just place the insertion point in any cell within the row. To change the height of more than one row, select all the rows for which the height is to be changed.

MS Excel and PowerPoint Long Answer Type Questions Part 2 3

MS Excel and PowerPoint Long Answer Type Questions Part 2 4

AutoFit Row Height: This feature is used to change the height of a row to the height of the largest entry in the row. To use this feature for more than one row, select the rows that are to be changed.

Column Width: When this option is clicked, the Column Width dialog box will display. In this box, it is possible to change the width of the selected column. The insertion point can be placed in any cell of the column for .this feature to work. To change the width of more than one column, select the columns for which the width is to be changed.

AutoFit Column Width: To change the width of the selected column(s) to the longest entry in the column(s), click this option. To change the width for more than one column, select the columns.

Default Width: This option is used to change the default standard column width for worksheets in Excel. When the option is clicked, the Standard Width dialog box will display.

Visibility:
With this feature, it is possible to hide columns and rows in a worksheet.

  • Hide and Unhide: To choose the options for hiding columns or rows in a worksheet, click this option. A list of choices will be displayed. Just click on one of the options to select it.

Organize Sheets:
This group is used to decide how sheets within a workbook are organized.

  • Rename Sheet: Click this option to change the name of the active worksheet within the workbook. The sheet name will be highlighted. To change the name, just type the new name.
  • Move or Copy Sheet: To move a worksheet within a workbook to a new location or to make a copy of the current worksheet, select this option. The Move or Copy dialog box will display. Within this dialog box, it is possible to move the worksheet to a different location or to make a copy of the worksheet.
  • Tab Color: To change the color of a tab for a worksheet, move the mouse pointer over this option. A gallery of possible colors will appear. Just click the color to apply it to the sheet tab.

Protection:
The options in this group are used to protect sections of a workbook from access by others.

Protect Sheet: Click this option to apply protection to the active worksheet. The Protect Sheet dialog box will display. Within this dialog box, there are several options for protecting the worksheet. Different options can be selected by clicking the check box beside each item that is to be applied to the worksheet. A password can be set which can be used to make changes to the cells.

Lock Cell: This feature is used to lock selected cells so that changes cannot be made to them by other people. Protect Sheet must be applied before this feature can be activated.

Format Cells: This link will open the Format Cells dialog box. In this box, it is possible to make changes to the numbers in a cell, to the alignment of cells, and to other formatting features.

Question 3.
Discuss about Working with Worksheet in MS-Excel?
Answer:
Worksheet is the sub part of a Workbook. It is actual area where all the record keeping and calculation are performed. A worksheet comprises of Columns and Row and a point called Cell where a Column is intersected by a Row.

Worksheet plays a highly important role in MS Excel as all the automation in MS Excel requires worksheet as a key reference.

Selecting a Sheet:
When MS Excel is started, it automatically creates a Workbook with 3 default sheets. The default naming convention’ for worksheets is Sheet I, Sheet 2 and Sheet 3. You can select the desired sheet by simply clicking its tab below on the worksheet

You can select multiple sheets at time by keep pressing the CTRL key which clicking on the desired sheets.

Renaming Worksheets:
The default naming conventions for worksheets in Sheet in MS Excel, however, this can be changed anytime you want. Simply follow the following steps:

  • Right click on the tab below the sheet
  • Select Rename form the context menu
  • Rename the sheet
  • Press enter to apply.

MS Excel and PowerPoint Long Answer Type Questions Part 2 5

  • You can also rename a sheet by simply double clicking the sheet tab and this will put the name in editable mode. Now, you can change the name and press enter to apply.

Insert a Worksheet:
Inserting a worksheet is also quite simple in MS Excel. Simply, click add new worksheet icon adjacent to Worksheet tabs.

Move a Worksheet:
Moving a worksheet is quite simple. All you need to do is to select and drag the worksheet tab to the new position. For example, in this example you will observer that Sheet 1 has been moved next to Sheet 3. You can do this by following the steps below.

  • Click and hold the mouse button on Sheet 1
  • Drag it towards Sheet3
  • Drop it at the end of Sheet3

Delete a Worksheet:
To delete a worksheet, follow the following steps:

  • Right click on the desired tab below the sheet
  • Select Delete form the context menu
  • It will prompt for Delete Confirmation, click Delete and the Worksheet will be deleted

Copy a Worksheet:
While working in MS Excel, sometime, it happens that you need to perform the same tasks with the slight variations or maybe you need to experiment something new so the best strategy is to make a copy of your worksheet.

Making a copy is quite simple and very easy to manage in MS Excel. Follow the steps below to make a copy of your sheet.

  • Right click on the sheet and select “Move or Copy” from the context menu.
  • From the dialog box, check mark the “Create a Copy”
  • You may also select the position for this copy. In this tutorial, you will find the copy sheet at the end.
  • Click OK.

Question 4.
Discuss about Working with Rows and Columns in MS¬- Excel? OR How to Insert Rows and Columns.
Answer:
1.Inserting Row:
There are two methods of inserting a row. The first method is to select the whole row where you want to add a new row by clicking its row label. Then right click on the row label and select “Insert” from the Context Menu. This will add a row above the selected row.

MS Excel and PowerPoint Long Answer Type Questions Part 2 6

Another method is by right clicking the Cell where you want to add a row. You will then select “Insert” from the Context Menu. This time, an “Insert” pop will open with multiple options, you will select “Entire Row” and will click OK. This will add a new row.

MS Excel and PowerPoint Long Answer Type Questions Part 2 7

2. Inserting Column:
There are two methods of inserting a column. The first method is to select the whole column where you want to add a new column by clicking its column label. Then right click on the column label and select “Insert” from the Context Menu. This will add a column on the left of the selected column.

Another method is by right clicking the Cell where you want to add a column. You will then select “Insert” from the Context Menu. This time, an “Insert” pop will open with multiple options, you will select “Entire Column” and will click OK. This will add a new column.

3. Inserting Cell:
To insert a cell, right click the Cell where you want to add a new cell. You will then select “Insert” from the Context Menu. An “Insert” pop will open with multiple options. Now, if you want to add a cell in vertical order (column wise), you will select “Shift cells down” and click OK. This will move the selected cell downward and your blank cell will be inserted. However, if you want to add a cell in horizontal order (row wise), you will select “Shift Cells Right” and click OK. This will move the selected cell towards right and your blank cell will be inserted.

4. Deleting Rows:
The process for deleting a row is very much similar to the process of inserting a row. Here to, you will select the row, you want to delete, by right clicking its row label and selecting “Delete” from the Context Menu. This will delete your desired row.

5. Deleting Column:
The process for deleting a column is very much similar to the process of inserting a column. Here to, you will select the column, you want to delete, by right clicking its column label and selecting “Delete” from the Context Menu. This will delete your desired column.

6. Deleting Cells:
The process for deleting a cell is very much similar to the process of inserting a cell. Here to, you will click the cell, you want to delete, by right clicking the cell and select “Delete” from the Context Menu. A “Delete” pop will appear from which you will select the desired option and click OK.

Note:
Shift Cells Up: By selecting this option, your cells will move upward within the column
Shift Cells Left: By selecting this option, your cells will move to left within the row
Entire Row: By selecting this option, you will delete the entire row containing the selected cell.
Entire Column: By selecting this option, you will delete the entire column containing the selected cell.

Question 5.
Discuss about Working with Cell in MS-Excel? OR How to Increase/Decrease Row height and Column width.
Answer:
When you open a new blank workbook, the cells are set to a default size. You have the ability to modify cells, as well as to insert and delete columns, rows, and cells as needed. The following paragraphs we will learn how to change row height and column width, wrap text in a cell, and merge cells.

By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways.

To modify column width:

  1. Position your mouse over the column line in the column heading so the white cross Cursor becomes a double arrow Double-arrow.
  2. Click and drag the column to the right to increase column width or to the left to decrease column width.
  3. Release the mouse. The column width will be changed in your spreadsheet.

Note: If you see pound signs (#######) in a cell, it means the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

To set column width with a specific measurement:

  • Select the columns you want to modify.
  • Click the Format command on the Home tab. The format drop-down menu appears.

MS Excel and PowerPoint Long Answer Type Questions Part 2 8

  • Select Column Width.
  • The Column Width dialog box appears. Enter a specific measurement.
  • Click OK. The width of each selected column will be changed in your worksheet.

Note: Select AutoFit Column Width from the format drop-down menu, and Excel will automatically adjust each selected column so ail of the text will fit.

To modify row height:

  • Position the cursor over the row line so the white cross Cursor becomes a double arrow Double-arrow.
  • Click and drag the row downward to increase row height or upward to decrease height.
  • Release the mouse. The height of each selected row will be changed in your worksheet.

To set row height with a specific measurement::

  • Select the rows you want to modify.
  • Click the Format command on the Home tab. The format drop-down menu appears.
  • Select Row Height.
  • The Row Height dialog box appears. Enter a specific measurement.
  • Click OK. The selected rows heights will be changed in your spreadsheet.

Note: Select AutoFit Row Height from the format drop-down menu, and Excel will automatically adjust each selected row so all of the text will fit.

Question 6.
Discuss about Formulas and Functions in Excel.
Answer:
Formula: A formula is an arithmetic expression that calculates the values provided in the given range. It performs the intended operation (i.e. +, *, /, etc.) on the provided values and generates the desired output.

Function: A function is a procedure defined in MS Excel to execute the formulas with more ease and efficiency. An example of a function is SUM(). Normally, if you sum the values of two cells (A1 and B1), you would write a formula like A1 + B1. Now, the same can be obtained using the SUM function. The syntax would be SUM(A1 :B1).

The advantage of using the function is when you have to calculate more number of values like for instance if you are required to sum the values of Cell A1 to Z1, it will take you some time to generate the formula however, in SUM function, you will just type SUM(A1 :Z1). This will select the whole range and will apply the SUM function to produce the desired result.

Procedure for entering formulas:
Entering formula is quite simple, as illustrated in fig. below, Value 1 and Value 2 are assigned to Cell A2 and B2, Now’, the result was required in Cell C2.

MS Excel and PowerPoint Long Answer Type Questions Part 2 9

Therefore, the formula is written in C2 as = A2 + B2, where A2 and B2 are cells containing values and is the operation to be performed Now the most important element of any formula or function is the “=” sign. This sign is the instruction point for MS Excel that anything written afterwards, will be a formula or a function and will be executed.

Now, let’s see some general step by step examples of entering formulas.

Example 1: Applying a formula
In this example, you will observe a “+” formula implementation on Cell A1 to Cell A3. The result will be shown in Cell A4

  • Enter 3 values in Cell A1 to A3
  • Select Cell A4, where the result of formula will be shown
  • Type “=” and click on Cell Al. You will observe a scrolling dashes against the cell. This refers that the cell has been marked.
  • Type “+” and click on Cell A2.
  • Again, type “+” and click on Cell A3.
  • Press “Enter” key.
  • Output of the formula will be displayed in Cell A4

Example 2: Editing a formula
In this example, you will observe a change in the formula applied in Example 1, in which, “+” operation was performed. Now, in current example, the “+” operation will be changed with formula. There are two methods in which you can make the changes in the formula.

Method 1: Editing formula in output cell.

  • Double Click on the Cell A4. This will put the cell in edit mode
  • Change the “+” symbol with symbol
  • Press Enter key

Method 2: Editing formula in Formula Bar

  • Select Cell A4
  • In formula bar, change the “+” symbol with symbol.
  • Press Enter key

Example 3: Copy/Paste a formula
Just like values in cells, MS- Excel supports copy and pasting of formula as well. The operation is performed just like any other copy and pasting operation.

In this example, you will observe that, there are 3 values entered in Cell B1 to B3 but instead of typing the formula (as, did in Example 1), a Copy function is applied on Cell A4 and Paste function is applied on B4.

  • Enter any numeric values in Cell B1 to B3
  • Select Cell A4
  • Click on “Copy” from Clipboard tab or Press “Ctrl + C”
  • Select Cell B4
  • Click on “Paste” from Clipboard tab or Press “Ctrl + V”

MS Excel and PowerPoint Long Answer Type Questions Part 2 10

Applying a function in MS Excel:
Applying function in MS Excel is as simple as applying a formula. You don’t need to do any complex tasks.

In the following example, you will observe the step by step implementation of SUM function on Cell A1 to J1 and the output result will be displayed on Cell K1.

Example 1: Application of SUM function.

  • Put numeric values in Cell A1 to J1
  • Select Cell Kl
  • Type =SUM(A1:J1)

MS Excel and PowerPoint Long Answer Type Questions Part 2 11

  • Press Enter key and the result will be shown in Cell K1

Example 2: Application of AVERAGE function
In this example you will be observing the application of AVERAGE function on the data from Example 1, The AVERAGE function will be implemented on Cell LI, This formula will be covering the values from Cell A1 to J1.

  • Select Cell L1
  • Type =AVERAGE(A 1:J1)
  • Press Enter key and the result will be output on Cell L1

MS Excel and PowerPoint Long Answer Type Questions Part 1

MS Excel and PowerPoint Long Answer Type Questions Part 1

MS Excel and PowerPoint Long Answer Type Questions Part 1

Question 1.
What are the features of MS-Excel? (or) What are the uses of Spreadsheet.
Answer:
Microsoft Excel is an integrated electronic spreadsheet program developed by Microsoft Corporation, USA that runs on Windows Environment. It includes three components – Worksheet, graph (chart) and database management. You can use Excel to organize, analyze and attractively present data, such as a budget or sales report. Excel also supports OLE.

Excel lets you create and quickly perform what-if analyses of complex, interrelated columnar reports, in workspaces called worksheets or spread sheets. Some important features of MS- EXCEL are discussed below:

Autocalc: This feature is very useful to sum a group of numbers is selected them. Their sum will automatically appear in the status area. You can even average or count the numbers by right-clicking in the status area.

Autocomplete: EXCEL now IntelliSense to anticipate , what you are going to type! Based upon entries you’ve already made, AutoComplete will try to figure out what you intend to type, once you’ve entered a few letters. You can even choose from a list of entries you’ve used already, because Excel makes this list for you automatically. You reach it with the right mouse button.

Autocorrect: Excel can support automatically correct mistakes. These include the same features you’re used to in Word and you can create your own AutoCorrect entries.

Better Drag-and-Drop: Do you want to move a group of cells? Excel’s drag-and-drop feature lets you reposition selected portions of your spreadsheet by simply dragging them with you mouse. Properly written equations automatically adapt themselves to their new locations.

Cell tips and Scroll Tips: To help you get around better with the mouse, Excel now includes Scroll Tips. When you click and drag a scroll bar, a small window tells you what row or column you are heading for. This is great for large worksheets.

Easier Document Retrieval and Management: Excel has greatly streamlined file management. You can quickly find worksheets with Fast Find, and you can easily delete or rename files right in the open dialog box. You can even preview files before opening them.

Number Formatting: It’s easy to format numbers with Excel’s new number-formatting feature. Select your numbers and choose Cells command from Format Menu. In the Number tab, choose the number style you want to use. There are many formats, including telephone numbers, dollar amounts, and dates.

Templates and Template Wizard: Excel’s template facility has been greatly enhanced. You can choose from a variety of elegantly designed templates for your home or business. You can even have Template Wizard link your worksheets to a database. Then when you make changes in the database, your worksheet can be updated automatically.

Shared Lists: You can now have worksheets that are shared simultaneously over a network. What is the technology behind this? Who knows. But it works like this. You simply save your file as a shared list. Then anyone bn the network can open it and work on it. This is also known as multi user editing. You have the options of saving or rejecting your own changes or anyone else’s.

Question 2.
Explain the parts of a Excel Window with the help of a neat diagram
Answer:
The goal of the Excel interface is to make working with a workbook more intuitive. The Live Preview feature shows the formatting changes in the window. Just move the mouse pointer over the command and the format will display in the window.

MS Excel and PowerPoint Long Answer Type Questions Part 1 1

Dialog Box Launcher:
When this button is clicked, a dialog box containing more commands for that particular group will display.

File Tab:
This tab is located in the upper left comer of the window. ‘ Contained within this tab are commands for managing Excel workbooks as a whole. For instance, this is the area where the Print, Save, Save As, Open, and Close options are located. It also contains the link to the Excel Options area, where global changes to the Excel program can be made.

Formula Bar:
The formula bar is used to display the data that is being input into a worksheet cell before it is entered into the worksheet.

Tell Me:
This Option is used to obtain help regarding a particular command. To get help, just start typing to bring information about features to your fingertips.

Name Box:
This is the box where the cell names are located. When named ranges are created, they can be accessed by clicking the arrow at the end of the name box.

New Sheet:
An Excel workbook is made up of different sheets. This button is used to add a new sheet to a workbook. The new sheet will be named Sheet 2, Sheet 3, and so forth depending on how many sheets are added.

Quick Access Toolbar:
The default buttons for this toolbar are the Save, Undo, and Redo buttons. The toolbar can be customized to contain any of the commands that you use frequently such as Open and Close.

Ribbon:
This ribbon contains the groups and buttons that make it possible to use the different commands in the Excel program. The ribbon consists of tabs which contain groups to which buttons to perform the different commands are located.

Sheet Scroll Buttons:
These buttons are used to move from one worksheet to another one in the workbook

Sheet Tabs:
Excel is a workbook with sheets similar to a book. These tabs are used to insert worksheets or charts into a workbook. A name can be applied to each tab indicating what type of data or object is located within that sheet.

Status Bar:
This bar is located at the bottom of each workbook. It is used to show the status of work within the worksheet. This is the area where the Shortcuts for viewing workbooks and the Zoom features are located.

Title Bar:
This bar displays the name of the program that is open, along with the workbook name. The help, ribbon display options, minimize, maximize/restore, and close buttons are located at the right end of this bar.

View Shortcuts:
These shortcuts are used to display a worksheet in different formats. The views are Normal, Page Layout, and Page Break Preview.

Workspace:
This is the area where data is entered into a worksheet. Formulas and Functions can also be inserted into this area of a worksheet, as well as charts, WordArt, Shapes, and other objects.

Zoom Controls:
This area is used to magnify or shrink the content of a file’ that is displayed in the workspace. The buttons on each end of the Zoom bar can be clicked to either magnify or shrink the view. The default size is 100 percent.

Question 3.
Explain the following (a) Add/Insert Worksheet (b) Creating Workbook (c) Saving Workbook (d) Opening Workbook (e) Deleting a Worksheet?
a) Add/Insert Worksheet:
When you create a new workbook, by default you are provided with 3 worksheets. You can insert additional worksheets, or delete worksheets as necessary. The maximum number of Worksheets can be inserted in excel 2003 or earlier is 255 sheets.

Using Ribbon bar:

  • Select the worksheet after where you would like the new worksheet to appear. The new worksheet appears to the left of the currently selected worksheet.
  • Click on the ‘Home’ tab available in the Ribbon bar of a workbook.
  • You will find an ‘Insert’ tab on the right side of a ribbon bar under the Home Tab.
  • Now, click on the ‘Insert’ icon available on the right side of the Ribbon bar, in order to open a drop-down list of options to be selected.
  • Now, you will find an ‘Insert Sheet’ option available at the end of the drop-down list.
  • Click on the ‘Insert Sheet’ option available at the end of the drop-down list to insert a new worksheet in excel.

Using Keyboard Short Cuts:

  • Press and hold down the SHIFT key on the keyboard.
  • Press and release the F11 key on the keyboard.
  • A new worksheet will be inserted into the current workbook.
  • To add additional worksheets continue to press and release the F11 key while holding down the SHIFT key.
  • Alternatively we can use Alt+Shift+F1 to insert new worksheet in the current workbook.

Using Mouse:

  • In a workbook, you will find a’+’ sign at the bottom of the sheet.
  • Click on the’+’ sign to insert a new worksheet in excel.

b) Creating Workbook:
On starting Excel 2003 you will be presented with a new blank workbook named Book1. The new workbook will contain 3 sheets identified by the sheet tabs in the bottom left of the worksheet.

To create a new blank workbook, click the new icon on the Standard toolbar MS Excel and PowerPoint Long Answer Type Questions Part 1 2or press Ctrl + N.

Every time a new blank workbook is created it is named Book1, Book2, Book3 and so on until saved under a more appropriate name.

Excel also provide a variety of templates to use when creating new workbooks. To use one of these templates click’ New under the File menu. The New Workbook task pane will open to the right of the screen.

c) Saving Workbook:
Every workbook created in Excel must be saved and assigned a name to distinguish it from other workbooks. It is good practice to save your workbook as soon as you can, and then to regularly save it to protect against data loss.

To save your document click Save under the File menu or press Ctrl + S. If you are saving the workbook for the first time, the Save As dialogue box will appear.

Select a location to save the workbook in and an appropriate name, which will make recognizing this workbook easy in the fixture, and click Save.

From now on whenever you save the workbook, Excel will just update the workbook previously saved.

If you need to save the workbook to a different location or under a different name, choose Save As command from the File menu and follow the procedure as before. This will create another copy of the workbook.

MS Excel and PowerPoint Long Answer Type Questions Part 1 3

d) Opening Workbook:
To begin working with an existing Workbook, first we have to open the Workbook. Excel offers three ways to open an existing Workbook. They are

Using Menu Commands:-

  • Choose Open Command from File Menu, Following Open Dialog will appear.
  • Choose the appropriate directory from Look in list and select the Workbook from the file list.
  • Click on Open Button

Using Keyboard Shortcuts

  • Press Ctrl+O, Open dialog will appear
  • Choose the appropriate directory from Look in list and select the workbook from the tile list.
  • Click on Open Button

MS Excel and PowerPoint Long Answer Type Questions Part 1 4

e) Deleting Worksheets:
You can permanently remove worksheet(s) you no longer need from your workbook. Follow these steps:

  • Click the tab of the single sheet you want to delete or press Ctrl as you click additional sheets.
  • Right Click, Short cut menu will appear
  • From Short cut menu choose Delete Command. A warning dialog box appear
  • Click OK to permanently delete the worksheet(s).

Question 4.
How to select cells in Excel?
Answer:
Before entering or editing cell contents or before you can format or move cells, they need to be selected. You can select single cell or range of cells.

Selecting cells with a mouse:

To select a single cell, simply point and click in it. It becomes the active cell.

  • Click on a row number to select the whole row
  • To select an entire column of cells, point to the column’s heading
  • Click and drag to select a range of cells
  • Click on the empty button at the top-left comer of the workbook to select the entire worksheet
  • To select noncontiguous cells, or groups of cells, hold down CTRL and do any of the aforementioned selection tricks.

Selecting cells with the keyboard:
While you will probably want to use your mouse for most selections, there are many keyboard selection tricks.

  • If you’ve already selected a range of cells, SHIFT+SPACEBAR selects the entire row or rows in which the cells are located.
  • CTRL+SPACEBAR select an entire column.
  • CTRL+SHIFT+SPACEBAR select the entire worksheet.

Question 5.
Write about entering and editing text?
Answer:
To enter the text simply activates the cell where you want the text to appear and then begin typing. The text will appear in the active cell and in the Formula bar. Pressing Enter or clicking the check mark button in the formula bar concludes the text entry and places the text in the active cell. You can type up to 255 characters per cell. After you’ve entered text, you can easily increase cell sizes later or word-wrap text to accommodate the entries.

Editing Text: Editing means changing. You can edit data in your worksheet to correct a mistakes, remove data you no longer need or update data.

Method 1:

  • Double-click the cell containing the data you want to edit. A flashing insertion point appears in the cell.
  • Make any changes to the cell contents.
  • Press the Enter key. The change will be accepted. Or to cancel your changes, press Esc key.

Method 2:

  • Click the cell that contains the data you want to edit. .
  • Press the Function key F2. Now the insertion point appears in the active cell itself.
  • Make required Changes
  • Press Enter key.

Method 3:

  • Click the cell that contains the data you want to edit.
  • Type the new text. It replaces the old data.
  • Press the Enter key.

Undo and Redo:
The Undo command is used cancel only the most recent action. To cancel several previous actions, use undo command multiple times. On other hand, the Redo command is used to Recall the actions canceled by the undo command.

Finding and Replacing Data:
When working with a lot of data in Excel, it can be difficult and time consuming to locate specific information. You can easily search your workbook using the Find feature, which also allows you to modify content using the Replace feature.

Steps to find Cell Content (Ctrl+F):

  • From the Home tab, click the Find and Select command, then select Find from the drop-down menu.
  • Selecting the Find feature
  • The Find and Replace dialog box will appear. Enter the content you want to find.
  • Click Find Next. If the content is found, the cell containing that content will be selected.
  • Clicking Find Next to locate content
  • Click Find Next to find further instances or Find All to see every instance of the search term.
  • Selecting Find Ail to locate every instance of the search term
  • When you are finished, click Close to exit the Find and Replace dialog box.

Steps to Replace Cell Content (Ctrl+F):

  • From the Home tab, click the Find and Select command, then select Replace from the drop-down menu.
  • The Find and Replace dialog box will appear. Type the text you want to find in the Find what: field.

 

MS Excel and PowerPoint Long Answer Type Questions Part 1 5

  • Type the text you want to replace it with in the Replace with: field, then click Find Next.
  • If the content is found, the cell containing that content will be selected.
  • Review the text to make sure you want to replace it.
  • If you want to replace it, select one of the replace options. Choosing Replace will replace individual instances, while Replace All will replace every instance of the text throughout the workbook.
  • Clicking replace all
  • A dialog box will appear, confirming the number of replacements made. Click OK to continue.
  • When you are finished, click Close to exit the Find and Replace dialog box.

Copying and Paste Cell Contents:
When you copy or move data, a copy of the data is placed in a temporary storage area called the Clipboard. This Clipboard allows you to copy data anywhere, even into documents created by other programs. When you copy, the original data remains in its place and a copy of it is placed where you indicate.

Steps:

  • Select the cell(s) you want to copy.
  • Click the Copy command on the Home tab, or press Ctrl+C on your keyboard.
  • Select the cell(s) where you want to paste the content.
  • The copied cells will now have a dashed box around them.
  • Click the Paste command on the Home tab, or press Ctrl+V on your keyboard.
  • The content will be pasted into the selected cells.

Moving Data:
Moving data is similar to copying except that the data is removed from its original place and placed in the new location.

Steps:

  • Select the cell(s) you want to cut.
  • Click the Cut command on the Home tab, or press Ctrl+X on your keyboard.
  • Select the cells where you want to paste the content. The cut cells will now have a dashed box around them.
  • Click the Paste command on the Home tab, or press Ctrl+V on your keyboard.
  • The cut content will be removed from the original cells and pasted into the selected cells.

Deleting Data:
To delete the data in a cell or range of cells, just select them and press Delete. However, Excel Offers additional options for deleting cells.

Basics of Computers Long Answer Type Questions Part 5

Basics of Computers Long Answer Type Questions Part 5

Basics of Computers Long Answer Type Questions Part 5

Question 1.
Write about Task Bar
Answer:
The Taskbar lies across the bottom edge of your screen. The Start button on the left provides access to all the programs, data files, and other features available on your computer. When you open a program or file, a corresponding rectangular icon will be displayed on your taskbar – even if the program has been minimized and is no longer visible on your screen. To access that program, you just need to click its icon on the taskbar.

You can customize the taskbar, including the way taskbar buttons look, how they group together when you have more than one window open, change where the taskbar is on your desktop, and decide what icons and apps are on it.

Basics of Computers Long Answer Type Questions Part 5 1

  • To rearrange the order of app buttons on the taskbar, drag a button from its current position to a different position on the taskbar. You can rearrange apps as often as you like.
  • All open files from the same app are always grouped together, even if you didn’t open them one after the other. This is so you can see all of the previews for that app at the same time.

Move the taskbar

  • Usually, you can find the taskbar at the bottom of the desktop, hut you can move it to the sides or top of the desktop. Before you can move the taskbar, you need to unlock it.
  • Press and hold or right-click an empty space on the taskbar. If Lock the taskbar has a check mark next to it, the taskbar is locked. You can unlock it by tapping or clicking Lock the taskbar, which removes the check mark.

Basics of Computers Long Answer Type Questions Part 5 2

  • To move the taskbar Do one of the following: o Tap an empty space on the taskbar, and then drag it to one of the four edges of the desktop. When the taskbar is where you want it, let go.

Change how taskbar buttons appear

  • You can choose how buttons are grouped together when there’s more than one window open, and change the size of taskbar button icons.

1. On the Taskbar tab, select one of the options from the Taskbar buttons list:

  • Always combine, hide labels: This is the default setting. Each app appears as a single, unlabeled button, even when multiple windows for that app are open.
  • Combine when taskbar is full: This setting shows each window as an individual, labeled button. When the taskbar becomes crowded, apps with multiple open windows collapse into a single app button, tap or clicking the button displays a list of the windows that are open.
  • Never combine: This setting shows each window as an individual, labeled button, and never combines them, no matter how many windows are open. As more apps and windows open, buttons get smaller, and eventually the buttons will scroll.

2. To use small taskbar button icons, select the Use small taskbar buttons check box. To use large icons, clear the check box.
3. Tap or click OK.

Pin an app to the taskbar
You can pin an app directly to the taskbar for quick and easy access.

  • Swipe in from the right edge of the screen, and then tap Search. (If you’re using a mouse, point to the upper-right comer of the screen, move the mouse pointer down, and then click Search.) In the search box, enter the name of the app you want to pin. Then on the search results page, tap or click the app to open it on the desktop.

Basics of Computers Long Answer Type Questions Part 5 3

  • On the desktop, press and hold or right-click the app’s button on the taskbar to open the app’s Jump List (a list of shortcuts to recently opened files, folders, and websites), and then tap or click Pin this program to taskbar.
  • To remove a pinned app from the taskbar, open the app’s Jump List, and then tap or click Unpin this program from taskbar.

Question 2.
Write about Control Panel.
Answer:
The Control Panel in Windows 7 is the place to go when you need to make changes to various settings of your computer system. You can control most Windows commands and features using the various options and sliders in the Control Panel.

To open the Control Panel, click the Start button on the taskbar and then click Control Panel on the Start menu. Windows 7 gives you three different views for looking at your computer’s Control Panel: To switch views, click the View By drop-down button (labeled Category by default) in the upper- right comer of the Control Panel and then choose one of the views from the button’s drop-down menu.

Category view
By default, the Control Panel is displayed in Category view, which is separated into eight categories, ranging from System and Security to Ease of Access. To open a window with the Control Panel options for any one of these categories, simply click the category’s hyperlink.

Basics of Computers Long Answer Type Questions Part 5 4

The following table gives you a description of all the Control Panel categories, including the various programs you can find by clicking each category’s hyperlink.

Click This Category: Link To Display These Groups of Links
System and Security Action Center, Windows Firewall, System, Windows Update, Power Options, Backup and Restore, BitLocker Drive Encryption, and Administrative Tools
User Accounts User Accounts, Windows Card space, Credential Manager, and Mail (32-bit)
Network and Internet Network and Sharing Center, Home group, and Internet Options
Appearance and Personalization Personalization, Display, Desktop Gadgets, Taskbar and Start Menu, Ease of Access Center, Folder Options, and Fonts
Hardware and Sound Devices and Printers, AutoPlay, Sound, Power Options, Display, and Windows Mobility Center
Clock, Language, and Region Date and Time, and Region and Language
Programs Programs and Features, Default Programs, and Desktop Gadgets
Ease of Access Ease of Access Center and Speech Recognition
Programs Used to uninstall a program

Question 3.
Write a short note on Soft Copy Devices.
Answer:
Soft copy output devices produce an electronic version of an output – for example, a file that is stored on a hard disk CD, or pen drive – and is displayed on the computer screen (monitor). The following are the features of a soft copy output:

  • The output can be viewed only when the computer is on.
  • The user can easily edit soft copy output.
  • Soft copy cannot be used by people who do not have a computer.
  • Searching for data in a soft copy is easy and fast.
  • Electronic distribution of material as soft copy is cheaper. It can be done easily and quickly.

Monitors:
The monitor is a soft copy output device used to display video and graphics information generated by the computer through the video card. Computer monitors are similar to television screens but they display information at a much higher quality. The monitor is connected to either the VGA or the digital video interface (DVI) port on the video card.

Monitors come in three variants—Cathode ray tube (CRT), liquid crystal display (LCD), and plasma

Question 4.
Write a short note on Hard Copy Devices.
Answer:
Hard copy output devices produce a physical form of output. For example, the content of a file printed on paper is a form of hard copy output. The features of hard copy output include the following:

  • A computer is not needed to see the output.
  • Editing and inserting in the hard copy is difficult.
  • Hard copy output can be easily distributed to people who do not have a computer.
  • Searching for data in a hard copy is a tiring and difficult. job.
  • Distribution of a hard copy is not only costly but slow as well.

Printers:

Basics of Computers Long Answer Type Questions Part 5 5
A printer is a device that takes the text and graphics information obtained from a computer and prints it on to a paper. Printers are available in the market in various sizes, speeds, sophistication, and costs. Usually, more expensive printers are used for higher-resolution colour printing.

Printers can be broadly classified into two groups: impact and non-impact printers as shown in Figure

Impact Printers:
These printers print characters by striking an inked ribbon against the paper. Examples of impact printers include dot matrix printers, daisy wheel printers, and most types of line printers.

Advantages:

  • These printers enable the user to produce carbon copies.
  • They are cheap.

Disadvantages:

  • Impact printers are slow.
  • They offer poor print quality, especially in the case of graphics.
  • They can be extremely noisy.
  • They can print only using the standard font.

Non-impact Printers:
Non-impact printers offer better print quality, faster printing, and the ability to create prints that contain sophisticated graphics. Non-impact printers use either solid or liquid cartridge-based ink, which is either sprayed, dripped, or electrostatically drawn onto the page. The main types of non-impact printers are inkjet, laser, and thermal printers.

Advantages:

  • Non-impact printers produce prints of good quality, and hence render sophisticated graphics.
  • They are noiseless.
  • They are fast.
  • They can print text in different fonts.

Disadvantages:

  • These printers are expensive.
  • The ink cartridges used by them are also costly.

Question 5.
Distinguish Between CRT and Flat Panel Monitors
Answer:

CRT Monitors Flat Panel Monitors
1. CRT Monitors are of larger size and occupy more area. 1. Flat Panel Monitors do not require a lot of desktop  space for there.
2. There is no such facility to hang CRT Monitors because of the shape and structure of these monitors. 2. For the sake of convenience, the flat panel monitor can be hang on a wall
3. The viewable area of CRT monitors ranges from 14 inches to 21 inches. 3. Flat Panel Monitors offer viewable areas from 14 inches to 18 inches.
4. CRT monitors came up this drawback to same extent because of better viewing angle. 4. These monitors have a restricted viewing angle.
5. Because of the structure of these monitors, there will be little distortion in the picture, reducing the clarity. 5. Because of the flat screens, they do not cause any distortions in the picture.
6. CRT monitors consume a great amount of electricity to keep the screen refreshed. 6. These monitors do not consume a lot of energy because of their tiny transistors.
7. CRT monitors emit low-level radiations. 7. These type of monitors do not emit any radiation.
8. CRT monitor is not much expensive compared to flat panel monitors. 8. Flat Panel monitors are much more expensive than CRT monitors.

Question 6.
Define Memory, and What are the types of memories.
Answer:
Memory is an internal storage area in the computer, which is used to store data and programs either temporarily or permanently. Computer memory can be broadly divided into two groups – primary memory and secondary memory. While the main memory holds instructions and data when a program is executing, the auxiliary or the secondary memory holds data and programs that are not currently in use and provides long-term storage. To execute a program, all the instructions or data that has to be used by the CPU has to be loaded into the main memory. However, the primary memory is volatile and so it can retain data only when the power is on. Moreover, it is very costlier and therefore limited in capacity.

Basics of Computers Long Answer Type Questions Part 5 6

Secondary memory stores data or instructions permanently, even when the power supply is turned off. It is cheap and can store large volumes of data. Moreover, data stored in auxiliary memory is highly portable, as the users can easily move it from one computer to another. The only drawback of secondary memory is that data access time is high when compared with the primary memory.

Question 7.
What is ROM?
Answer:
ROM is an acronym for Read-Only Memory. It refers to computer memory chips containing permanent or semi-permanent data. Unlike RAM, ROM is non-volatile; even after, you turn off your computer, the contents of ROM will remain.

Almost every computer comes with a small amount of ROM containing the boot firmware. This consists of a few kilobytes of code that tell the computer what to do when it starts up, e.g., running hardware diagnostics and loading the operating system into RAM. On a PC, the boot firmware is called the BIOS.

Originally, ROM was actually read-only. To update the programs in ROM, you had to remove and physically replace your ROM chips. Contemporary versions of ROM allow some limited rewriting, so you can usually upgrade firmware such as the BIOS by using installation software. Rewritable ROM chips include PROMs (programmable read-only memory), EPROMs (erasable read-only memory), EEPROMs (electrically erasable programmable read-only memory), and a common variation of EEPROMs called flash memory.

Question 8.
What are the difference between RAM and ROM?
Answer:

ROM RAM
1. It is a non-volatile memory It is a volatile Memory
2. The contents are permanent The contents temporary
3. Cost effective Cost is very high
4. It performs Read operations only It performs Read/Write operations only.
5. Generally the operating system programs can be stored. User defined programs can be stored at any time.

Question 9.
Differences between Cache Memory and Primary Memory.
Answer:
Primary memory is the large amount of memory your computer uses to load programs and files you work on. It is expandable up to very high amounts, which means user can load more programs and files.

Cache memory is a small amount of memory that the computer processor uses to store information, like calculations, which it then quickly retrieves, and then moves on to other calculations. It is usually located very near the processor or built into the processor.

Both are temporary memories but they vary mainly based on speed, size and cost.

  • Placement: Cache is usually present on the CPU chip itself. Primary memory (RAM) is placed on the motherboard and is connected to the CPU via the Memory Bus.
  • Speed: Because cache is closer to the CPU, it is much faster than RAM. Each read access on the primary memory has to travel via the Memory Bus while the CPU cache is right there.
  • Size: The size of the cache is much less compared to that of primary memory. The size of Primary Memory or RAM in today’s computers is a few GBs while the size of cache is a few MBs.
  • Cost: Cache is more expensive than primary memory.

Question 10.
Write about memory cards.
Answer:
a Memory card is a type of storage media that is often used to store photos, videos, or other data in electronic devices. Devices that commonly use a memory card include digital cameras, digital camcorders, handheld computers, MP3 players, PDAs, cell phones, game consoles, and printers. The picture to the right is a MicroSD flash memory card, which is just one of the types of memory cards available.

There are a handful of different types of memory cards on the market, each varying in size, compatibility, and storage capacity.

Question 11.
Mention any three types of keyboard.
Answer:
A computer keyboard is one of the primary input devices used with a computer that looks similar to those found on electric typewriters, but with some additional keys. Keyboards allow you to input letters, numbers, and other symbols into a computer that can serve as commands or be used to type text.

Standard Classification:
The standard selection of keys can be classified as follows:

  • Alphanumeric keys: The standard letters and numbers.
  • Punctuation keys: The comma, period, semicolon, and similar keys.
  • Special keys: This includes the function keys, control keys, arrow keys, caps Lock key, and so on.

Question 12.
How does a mouse works?
Answer:
When you move the mouse on a surface it senses the motion and a signal is sent to the computer. The computer then acts appropriately according to how the mouse was moved or was clicked.

Computer Mouse Technologies
Let’s take a look at the different computer mouse technologies, starting with the old-type mechanical mice:

Mechanical Mouse:
The first type of mouse around, the mechanical mouse (also known as a ball mouse), uses a moving ball to work. As you move the mouse across a surface, the ball moves too. Also inside the mouse are two rollers that roll against, two sides of the moving ball. One roller tracks the horizontal motion of the mouse, and the other roller tracks the vertical motion.

The motion of the two rollers is converted into electrical a signal which is then sent to the computer through a cord. The software on the computer then converts these electrical signals into meaningful X and Y movement of the mouse cursor that you see on-screen.

Optical Mouse:
Optical Mice are the most common computer mice in use today. An optical computer mouse works using optical technology and so don’t require any moving parts.

As you move an optical mouse over a surface, a small red LED (Light-Emitting Diode) emits light onto a surface and reads the pattern or grid on that surface. The mouse converts this surface information into meaningful motion data which is sent to the computer.

Question 13.
What is Human Ware.
Answer:
Human ware refers to the persons who design, program, and operate a computer installation. There are numerous categories of jobs, but the three principal positions required in a large computer installation are system analyst, programmer, and computer operator. People in each of these areas generally perform special-purpose tasks under the supervision of a director or manager.

The position of a systems analyst requires the broad background and extensive understanding of the above three job categories. The main task of the system analyst is to study information and processing requirements. A systems analyst defines the applications problem, determines systems specifications, recommends hardware and software changes, and designs information processing procedures.

A programmer requires a comprehensive knowledge of one or more programming languages and standard coding procedures. This position does not require the broader understanding of the structure and inner workings of an application. A programmer’s principal job is to code or prepare programs based on the specifications made by the systems analyst.

A computer operator requires the least extensive background of the three categories. A computer operator generally performs a series of well-defined tasks that will keep, the computer operating at maximum efficiency. The operational efficiency of a computer installation is dependent on the quality’ and abilities of the operational staff.

Basics of Computers Long Answer Type Questions Part 4

Basics of Computers Long Answer Type Questions Part 4

Basics of Computers Long Answer Type Questions Part 4

Question 1.
Distinguish between Primary and Secondary Memories.
Answer:

Primary Memories Secondary Memories
1. Primary Memories are volatile Memories i.e. temporary Memories. Secondary Memories are non-­volatile memories i.e Permanent Memories
2. Primary memories are costlier Secondary memories are cheaper
3. The Primary memories accessing speed is high The Secondary memories accessing speed is slow.
4. The contents of main memory are accessed directly by the CPU The contents of secondary memory is accessed indirectly by the CPU.
5. Primary Memory is also called as Main Memory Secondary Memory is also called as Auxiliary Memory.
6. Primary Memories are Limited. Secondary Memories are unlimited.
7. Main memories are uses semi­conductor technology. Secondary Memories are uses Magnetic Technology.
8. The information storing procedure is very easy. The information storing procedure is very complex.
9. Memory locations are identified with the help of its unique address. Memory locations are identified with the help of side, track, sectors etc.
10. Main Memory has random access Property. Secondary memories have sequential and random access property.
11. Examples: RAM and ROM Examples: Magnetic Tape, Floppy Disk etc.

MS WINDOWS

Question 2.
Explain the features of MS-Windows.
Answer:
Windows 10 is the most recent version of the Microsoft Windows operating system. There have been many different versions of Windows over the years, including Windows 8 (released in 2012), Windows 7 (2009), Windows Vista (2006), and Windows XP (2001). While older versions of Windows mainly ran on desktop and laptop computers, Windows 10 is also designed to run equally well on tablets.

An operating system manages all of the hardware and software on a computer. Without it, the computer would be useless.

Desktop: The desktop is a fundamental part of the default GUI (graphical user interface) in Windows. It is a space where you can organize applications, folders, and documents, which appear as icons.

Start and Start menu: The Start menu is a list of applications and utilities installed on your computer. You can open it by pressing Start, on the left side of your taskbar. From the keyboard, you can open the Start menu by pressing the Windows key.

Taskbar: The Windows taskbar shows programs that are currently open, and a Quick Launch area that allows quick access to launch specific programs. The notification area is on the right side, of the taskbar, showing the date and time, and programs running in the background.

Control Panel: The Control Panel is a collection of tools to help you configure and manage the resources on your computer. You can change settings for printers, video, audio, mouse, keyboard, date and time, user accounts, installed applications, network connections, power saving options, and more.

You can start the Control Panel from the Run box. Press Win+R, type control, and press Enter.

Cortana: Cortana is a virtual assistant introduced in Windows 10 that accepts voice commands. Cortana can answer questions, search your computer or Internet, set appointments and reminders, perform online purchases, and more. Cortana has similarities to other voice-activated services, such as Siri, Alexa, or Google Assistant, with the added benefit that it can search the information on your computer. To access Cortana in Windows 10, press Win+S.

Windows search box: The Windows search box is a convenient way to search for documents, pictures, videos, applications, and more. The search box is on your taskbar by default. In Windows 10, if you don’t see the search box, right- click the taskbar and select Taskbar settings. Make sure Use small taskbar buttons is Off.

File Explorer: The File Explorer, also called Windows Explorer, provides you with a view of the files and folders on the computer. You can browse the contents of your SSD, hard drive, and attached removable disks. You can search for files and folders, and open, rename, or delete them from the File Explorer.

To open a new File Explorer window, press Win+E. You can open more than one Explorer window at the same time, which helps with viewing multiple folders at once, or copying/moving-files from one to the other.

Internet browser: Your Internet browser is one of the most important applications on your computer. You can use it to find information on the Internet, view web pages, shop and buy merchandise, watch movies, play games, and more. Microsoft Edge is the default browser in Windows 10. Internet Explorer is included as the default browser in previous versions of Windows, from Windows 95 to Windows 8.1.

Snipping Tool: This tool is used to capture an image of a screen area and then annotate it with handwritten notes. The image can be saved as a html, png, gif. or jpg file. It can also be sent by email.

Question 3.
Write about Windows Desktop.
Answer:
The Desktop is the first thing that is seen when the computer is turned on. It is also the home base, the area that is displayed after all programs have been closed. It is the initial display on the computer screen on which windows, icons, menus, and dialog boxes appear. It is used to access disk drives, network drives, files, and other resources such as printers or the Recycle Bin. The most common Windows 10 Desktop elements are described below.

Desktop Background:

  • This is what is displayed when you first log into Windows.
  • The displayed background is the default Windows 10 background.
  • This may be changed by the computer manufacturer or when Windows 10 is installed.

Basics of Computers Long Answer Type Questions Part 4 1

Desktop Icon:

  • Depending OR how Windows was configured, there could be from one to seven icons on the desktop.
  • An icon is used to identify every’ type of item on your computer, such as a file, a program, or a folder.
  • There are six standard desktop icons that represent Windows 30 elements.
  • The display of these icons can be turned on or off depending on your preferences.
  • The only icon that is displayed on the desktop by default is the one for the Recycle Bin.

Start Menu:

  • This menu is the central link to the programs, management tools, and file storage structure for the computer.
  • To open the Start Menu, do one of the following:
    • Click the Start button which appears at the left end of the Windows Taskbar.
    • Press the Windows logo key on the left or right side of the space bar.

Taskbar:

  • The Taskbar is displayed at the bottom of the Window.
  • It is used to start programs such as Word and Excel.
  • It is also used to switch among open programs and open documents.
  • The documents for each program will be grouped together.
  • They can be displayed by moving the mouse pointer over the icon.
  • The Taskbar can be customized to meet individual needs.

Question 4.
Discuss about Recycle Bin?
Answer:
When files, folders, or icons are deleted on the local computer, not the network, they are stored in the Recycle Bin. These files remain in the Recycle Bin until the bin is emptied. If a file is accidentally deleted, it may be restored to its original location.

Restore Files or Folders:

  • In order to restore a file, follow the steps below.
  • Display the Recycle Bin Window by double-clicking the Recycle Bin icon on the Desktop. The Recycle Bin window’ will display.

Basics of Computers Long Answer Type Questions Part 4 2

  • Click on the file or folder to be restored.
  • Right-click on the file and then press Restore.
  • The file will be removed from the Recycle Bin and placed into its original folder.

Restore All Items:

  • Double-click on the Recycle Bin icon.
  • Click the Restore All Items button in the Restore Group. Recycle Bin Dialog Will display.
  • Click the Yes button to restore all the files.

Restore Selected Items:

  • Select the files that need to be restored.
    • Press-the CTRL key while selecting items to select files that are not all together.
    • Press the Shift key at the beginning of a list, go to the end of the list and click the left mouse button to select items that are all together.
  • Click the Restore the selected items in the Restore Group.

Empty the Recycle Bin:
To empty the Recycle Bin, complete the steps below.

  • Double-click on the Recycle Bin icon.
  • Click the Empty the Recycle Bin button in the Manage Group.
  • A message will appear asking if the items are to be deleted.
  • Click on Yes. This confirms the deletion of the files.

Notes:

  • If only some of the files are to be removed from the Recycle Bin, hold down the CTRL key and click each file that is to be removed, then click Delete on the File menu.
  • To open a file that is in the Recycle Bin, drag the icon onto the Desktop, and then double-click it.

Question 5.
Write about Windows explorer or File Explorer.
Answer:
Windows Explorer or File Explorer is the file management application used by Windows operating systems to browse folders and files. It provides a graphical interface for the user to navigate and access the files stored in the computer.

Basics of Computers Long Answer Type Questions Part 4 3

The main way to access the File Explorer is by clicking the folder icon in the Taskbar. After clicking the icon, the File Explorer window will open.

Basics of Computers Long Answer Type Questions Part 4 4

The initial File Explorer window is comprised of the following sections –

  • The File Explorer ribbon, which resembles the ribbon featured in Microsoft Office. The ribbon contains buttons for common tasks to perform with your files and folders.
  • The Navigation Pane gives you access to your libraries of documents and pictures, as well as your storage devices. It also features frequently used folders and network devices.
  • The Frequent folders section on the right features the folders you’ve worked with recently to allow for quick access to them.
  • The Recent files section in the lower part of the window features files and documents that you’ve opened recently.

The File Explorer Ribbon
In Windows 10, the File Explorer features a new ribbon toolbar, similar to the one featured in the recent versions of Microsoft Office, This ribbon contains buttons and commands for the most common tasks.

Basics of Computers Long Answer Type Questions Part 4 5

The Ribbon features four tabs, each with different commands. Among the tasks you can perform from the Home tab are –

  • Copying and pasting files and folders from one place to another.
  • Moving files and folders to another location.
  • Copying files and folders to another location.
  • Deleting a file or folder permanently or sending it to the Recycle Bin.
  • Renaming a file or folder.
  • Creating a new folder or other new items.
  • Verifying or modifying the Properties of a document or folder.
  • Opening a file or folder.
  • Different options to select one or various files and folders.

Basics of Computers Long Answer Type Questions Part 4 6

The Share ribbon gives you different options to share your files and folders. For example –

  • E-mailing or messaging a file.
  • Compressing (“Zip”) a folder to take less space.
  • Printing or faxing documents.
  • Sharing with other users or networks.

Basics of Computers Long Answer Type Questions Part 4 7

The View ribbon allows you to change the way Windows displays your files and folders. Some of the changes you can make here are-

  • Adding additional panes to show a preview or details of your files.
  • Changing the layout of the files and folders from icons to list, and others.
  • Sorting and arranging the contents of your folder.
  • Hiding selected folders or files.

The File tab opens a menu with different options like –

Basics of Computers Long Answer Type Questions Part 4 8

  • Opening an additional File Explorer window.
  • Opening command windows for advanced users.
  • Changing or configuring options about how File Explorer behaves.

How to open Windows Explorer
There are several ways to open a new Explorer window, which vary slightly depending on which version of Windows you are running.

In all versions of Windows

  • Press Win + E (hold down the Windows key and press E).
  • Click Start and select Run (or press Win + R), then type explorer or explorer.exe and press Enter.

In Windows 10

  • Press the Win + X to open the Power User Tasks Menu, then select File Explorer (or press E).
  • Click Start, select Programs, select Accessories, then Windows Explorer or Explorer.

Question 6.
Discuss about File Management in Windows.
Answer:
File Management Can Help With The Following:

  • Organizing folders and files in a file hierarchy, or a logical order, so that information is easy to locate and use.
  • Saving files to the folder in which they w ill be stored for future use.
  • Creating a new folder in order to reorganize information.
  • Deleting files and folders that are no longer needed.
  • Finding a file when the name of the file is not remembered.
  • Creating shortcuts to files for easy access.

Copy a File or Folder:
There are occasions when a file or folder needs to be copied to another location in order for someone else to use it or for a backup copy to be made. To complete this task, complete the following steps.

  • Open File Explorer, by doing one of the following:
  • Click the folder in the left frame where the document(s) that are to be copied is located.
  • Select a file from the right frame to copy.
  • Click the Home Tab, in the Organize Group, click the Copy To button. Select the folder to copy to from the list or select Choose Location.
  • Close File Explorer.

Move a File or Folder:
It might become necessary to move a file, rather than copy it to another file or folder in order to have more space on a disk or to better organize the file system.

  • Open File Explorer, if necessary.
  • Select the file or folder you want to move.
  • Click the Home Tab, in the Organize Group, click Move to, and then select the folder where the files are to be moved.

Create a Folder:

  • Folders can be created using File Explorer.
  • Open File Explorer.
  • Click the Folder into which the New Folder is to be added.
  • Click the New Folder icon in the upper-right comer of the window.
  • The new folder appears with a temporary name, New Folder.
  • Type a name for the new folder.
  • Press Enter.

Note:
It is also possible to create a new folder by right-clicking anywhere within the list of files and folders. In the shortcut menu, move the mouse pointer over New and then click Folder.

Rename a File or Folder:

  • Open File Explorer.
  • A list of Folders will appear on the left side of the window.
  • Look for the folder where the file or folder is stored.
  • Do one of the following:
    • Click the Home Tab, in the Organize Group, click the Rename button.
    • Right-click the folder that is to be renamed and choose Rename from the Shortcut menu.
  • With the File or Folder Name selected, input a new name for the file or folder.
  • Press Enter.

Change Views of Files and Folders:

  • Click the View Tab, in the Layout Group, click the desired view option.
  • The most popular view options are: List and Details.
  • Click the More button on the right side of the list to view additional options.

Delete a File or Folder:
This operation cannot be performed with a CD, but can be done with a flash drive or a network folder or file. However, with a RW CD, it is possible to erase all the files from a disk.

  • Click the folder that is to be deleted.
  • Do one of the following:
    • Click the Home Tab, in the Organize Group, click the Delete button.
    • Right-click the file and then click Delete.
    • Press the Delete key on the keyboard.
  • Close File Explorer.

Locate a File or Folder:
The Search feature can be used to locate a file, a computer, or other items in a Windows program. To locate a file or folder, complete the following steps:

  • Open File Explorer, if necessary.
  • In the upper-right comer of the window, click the Search Documents box.
  • Input the word or phrase that you want to search for.
  • A list of the items that match the word or phrase will appear in the right frame of the window.
  • Click the link for the item that is to he opened.

Question 7.
Explain the following (a) My Computer (b) My Documents (c) Pictures (d) Music (e) Videos
Answer:
a) My Computer: This was introduced with the release of Microsoft Windows 95 and included with all versions of Windows after that. My Computer allows the user to explore the contents of their computer drives as well as manage their computer files.

Basics of Computers Long Answer Type Questions Part 4 9

In the pictures shown above, are examples of the My Computer icon in Microsoft Windows XP and just Computer, which was introduced with Windows Vista. Although the name has changed this icon still acts identical to the earlier My Computer.

How to open My computer:

  • Get to the Windows Desktop and locate the My Computer Icon. This icon is almost always located on the top-left portion of the desktop and should look similar to the icon above.
  • Double-click the My Computer icon. The following windows will appear when My Computer is open.

Using My Computer:
Once My Computer is open you’ll see all available drives on your computer. For most users you’ll only be concerned with the Local Disc (C:) drive. This is your hard drive and what stores all your files. Double-click this drive icon to open it and view of its contents.

Finding files in My Computer: If you’re having trouble finding where one of your files is stored use the Windows find feature to find the file. To do this from within My Computer either click on File and then Search or right-click on the C: drive or other folder you wish to search and click Search.

In the Search window type the name or part of the name of the file you’re looking for.

Adjust system settings with your computer:
If you wish to manage your computer or view other settings and information about your computer instead of double-clicking the My Computer icon to open it, right-click on the My Computer icon and click Properties. Performing these steps will open your System Properties.

b) My Documents: My Documents is a Microsoft Windows folder that stores documents, program settings, and other files that are used with many of the programs run on your computer. For example, when saving a file in Microsoft Word the default folder will often be My Documents. Saving all your personal files into the My Documents folder makes backing up and locating your personal files easier.

Many Microsoft Windows users should be able to locate the My Documents folder through their Desktop. However, for those users who do not have a My Documents icon on their desktop they can find the My Documents folder by following the below steps.

  • From the Desktop double-click the My Documents folder.
    or
  • Open My Computer.
  • Within My Computer double-click the xx Documents, where xx is the name of your user account. For example, if your login was named KSR, you would click on KSR’s Documents.
    or
  • Open My Computer.
  • Double-click the C: drive.
  • Within the C: drive double-click the Documents and Settings folder.
  • In Documents and Settings double-click the folder for the users My Documents you wish to see. Using the same example as above, if your login w as named “KSR” you’d click on the “KSR” folder.
  • Within your users name folder open the My Documents folder.

c) Pictures: The Pictures library is where Windows 7 consolidates all your digital photo files. These files may be physically stored in the My Pictures or Public Pictures folders, or in any subfolders within these folders.

The Pictures library looks pretty much like any other Windows Explorer folder. The big difference is that individual photo files are displayed as thumbnails of the photos themselves. For this reason, it’s better to display the Pictures library in one of the larger icon views; the larger the icons, the bigger the thumbnails. You can also view information about a file at the bottom of the Explorer window by clicking the file icon.

d) Music: The Music library is where Windows 7 consolidates all your digital music files. These files may be stored in the My Music or Public Music folders, or in any subfolders within these folders. (For example, if you’re an iPod/iPhone user, you’ll find most of your music stored in the iTunes subfolder within the My Music folder.)

Individual music tracks are typically stored in folders for the corresponding album. Album folders are stored in folders for the performing artist. It goes like this: Music folder —► Artist folder —> Album folder —► Track files.

e) Videos: We now move from still pictures to moving pictures, in the form of digital videos. In Windows 7, digital video files are consolidated in the Videos library, and physically stored in the My Videos and Public Videos folders.

Video files are displayed as “filmstrip” icons, with thumbnails from each video as part of the icon. Click a Tile to view information about that file at the bottom of the Explorer window.

There aren’t a whole lot of unique options in the Videos library. You can play any individual video by double-clicking the file icon, of course. You can also play all the videos in the library (or in any folder or subfolder) by clicking the Play All button in the Explorer toolbar.

Basics of Computers Long Answer Type Questions Part 3

Basics of Computers Long Answer Type Questions Part 3

Basics of Computers Long Answer Type Questions Part 3

Question 1.
Discuss in brief about key board and mouse.
Answer:
Keyboard: A computer keyboard is one of the primary input devices used with a computer that looks similar to those found on electric typewriters, but with some additional keys. Keyboards allow you to input letters, numbers, and other symbols into a computer that can serve as commands or be used to type text.

Standard Classification:
The standard selection of keys can be classified as follows:

  • Alphanumeric keys: The standard letters and numbers.
  • Punctuation keys: The comma, period, semicolon, and similar keys.
  • Special keys: This includes the function keys, control keys, arrow keys, caps Lock key, and so on.

Mouse:
A mouse is a small handheld input device that controls a computer screen’s cursor or pointer in conjunction with the way it is moved on a flat surface. The mouse term name originates from its likeness to a small, corded and elliptical shaped device that looks like a mouse tail. Some mouse devices have integrated features, such as extra buttons that may be programmed and assigned with different commands.

Because the mouse reduces the use of a keyboard, its invention and continuous innovation is considered one of the most important breakthroughs in computer ergonomics.

The mouse was invented in 1963 by Douglas C. Engelbart from Stanford and later pioneered in 1981 by the Xerox Corporation. Computer users were generally skeptical about the mouse invention until approximately 1984, when the original Apple Macintosh (Macintosh 128K) was released.

Early mouse devices connected to computers through a cable or cord and were characterized by a roller ball integrated as a movement sensor underneath the device. Modem mouse devices use optical technology, where cursor movements are controlled by a visible or invisible light beam. Many models feature wireless connectivity through various wireless technologies, including radio frequency (RF) and Bluetooth.

The three main mouse device types are:

  • Mechanical: Built with a trackball underneath the mouse and mechanical sensors, allowing easy movement in all directions
  • Optomechanical: Similar to the mechanical type but uses optical, rather than mechanical, sensors to detect trackball movement
  • Optical: The most expensive. Uses a laser to detect mouse movement, has no mechanical parts and reacts more precisely than other types.

Mouse Operations:
There are four basic mouse operations that you can perform:
1. Click: To select an item or choose a menu command, point the mouse at it with the pointer and the left mouse button.

2. Click and Drag: To move an item is called dragging. To complete this operation, point at the item, it and hold down the left mouse button. While holding down the left mouse button drag the item where you want it to be. Release the button.

3. Double-Click: This is a shortcut method used to access an item or to open or close a window quickly without using a menu. To complete this operation, point the mouse pointer to the item and it with the left mouse button.

4. Right-Click: When you click the right mouse button you can access a drop down menu to choose what you can do with the item, such as “copy, “paste”, etc. Every menu is specific to what you click. To perform this operation, point at the desired item or object and the right mouse button ONLY once.

Question 2.
Write a short notes on Printers?
Answer:
Generally, printers fall into- two categories : a) Impact Printers and b) Non-Impact Printers.

An impact printer creates an image by using pins or hammers to press an inked ribbon against the paper. The most common type of impact printers is the dot matrix printer Line printers, and band printer. Non-impact Printers use other means to create an image. Examples for the non-impact printers are Ink jet printers, and laser printer

Dot Matrix Printers: A dot matrix printer creates an image by using a mechanism called a print head, which contains a matrix of short pins arranged in one or more columns. On receiving instruction from the PC, the printer can push any of the pins out in any combination. By pushing out pins in various combinations, the print head can create alphanumeric characters which is show in the following figure.

Basics of Computers Long Answer Type Questions Part 3 1

The speed of dot matrix printers is measured in characters per second (CPS). The slowest dot matrix printer create 50 to 70 characters per second; the fastest print more than 500 cps. The following figure shows

Line Printers: A line printer is a special type of impact printer. It works like dot matrix printer but uses a special wide print head that can print an entire line of text at one time. Line printers do not offer high resolution but are incredibly fast; the fastest can print 3,000 lines of text per minute.

Band Printers: A band printer features a rotating band embossed with alphanumeric characters. To print a character, the machine rotates the band to the desired character, then a small hammer taps the band, pressing the character against a ribbon. A good-quality band printer can generate 2,000 lines of text per minute.

Ink Jet Printers : Ink jet printers create an image directly on the paper by spraying ink through tiny nozzles. The ink jet printers can print two to four pages per minute. Many ink jet printers use one cartridge for color printing and a separate black- only cartridge for black-and-white printing. This feature saves money by reserving colored ink only for color printing.

Laser Printers: Laser printers are more expensive than ink jet printers, their print quality is higher, and most are faster. As their name implies, a laser is at the heart of these printers. Just as the electron gun in a monitor can target any pixel, the laser in a laser printer can aim at any point on a drum, creating an electrical charged. Then with pressure and heat, the toner is transferred off the drum onto the paper.

A color laser printer works like a single color model, except that the process is repeated four times and a different toner color is used for each pass. The four colors used are Cyan, Magenta, Yellow and Black.

Plotters: A plotter is a special kind of output device, ft is like a printer because it produces images on paper, but the plotter is typically used to print large-format images, such as construction drawings created by an architect.

Question 3.
Discuss about Plotters.
Answer:
A plotter is a printing device that is usually used to print vector graphics with high print quality. They are widely used to draw maps, in scientific applications, and in CAD, CAM, and computer aided engineering (CAE). Architects use plotters to draw blueprints of the structures they are working on. A plotter is basically a printer that interprets commands from a computer to make line drawings on paper with one or more automated pens. Since plotters are much more expensive than printers, they are used only for specialized applications. Hewlett-Packard is the leading vendor of plotters worldwide. There are two different types of plotters, drum and flatbed.

Drum plotter: A drum plotter is used to draw graphics on paper that is wrapped around a drum. This type of plotter is usually used with mainframe and minicomputer systems. The drum plotter works by rotating the drum back and forth to pro-duce vertical motion. The pen, which is mounted on a carriage, is moved across the width of the paper. Hence, the vertical movement of the paper and the horizontal movement of the pen create the required design under the control of the computer.

Drum plotters can make multicolour drawings by using pens with different coloured inks. Moreover, drum plotters support very large plot sizes with paper widths of up to 1 metre.

Flatbed plotter: In a flatbed plotter, the paper is spread on the flat rectangular surface of the plotter, and the pen is moved over it. Flatbed plotters are less expensive, and are used in many small computing systems. The size of the plot is limited only by the size of the plotter’s bed. In this type of plotter, the paFcr does not move; rather, plotting is done by moving an arm that moves a pen over the paper.

In case of a flatbed plotter, pens of different colours are mounted in the pen-holding mechanism that moves on the sur-face. The microprocessor in the plotter selects the desk pen and controls its movement under the control of the computer.

Question 4.
What is Software? Explain different types of Software?
Answer: The Computer is a machine and it can not think and do its own. Since it has no intelligent quotient, it must be instructed to carry out any task. Hence it is required to specify the set of sequential instructions that the computer can perform to solve any task.

Software is basically “the set of instructions grouped into programs that make the computer to function in the desired way. It is a collection of programs to perform a particular task.

System Software:
A system software is a collection of programs designed to operate, control and extend processing capabilities of computer and which makes the operation of a computer system more effective and efficient. The system software can be divided into two types
a) Operating System
b) Language Translators/Processors

Basics of Computers Long Answer Type Questions Part 3 2

a) Operating System: An operating system plays an important role in a computer system which controls all other components of the computer system. If there is no operating system, then there is no computer. It controls the CPU, Memory, Input / Output devices etc. It is responsible for smooth functioning and efficient operation of the computer system. Some of the popular operating system are DOS, WINDOWS, UNIX and LINUX etc.

b) Language Translators/Processors: A programmer can write program in high level language because it is much easy to understand by the computer and convert into its own machine language. Language Translators converts the high level language program into machine understandable form (Machine language). The language processors are Assembler, Interpreter, Compiler.

Application Software:
Application software is a set of programs necessary to carryout operations for a specific application. These are the programs written by programers to enable computer to perform a specific task. Application software can be divided into two categories.

a) Special purpose Application Software
b) General Purpose Application Software

a) Special Purpose Application Software: This is based upon the customer requirements. This is developed to meet all the requirements mentioned by the customer. This requirement cannot be directly installed to any other user’s workspace, because requirement may differ from one customer to another customer so this software may not fulfil to everyone.

b) General Purpose Application Software: This type of software developed for general requirements for carrying out a specific task. Here many customers can use simultaneously due to filfilment of all customers.

Question 5.
What is Hardware and Software and differentiate them.
Answer:
The term hardware is applied to any of the physical equipments in the computer system, such as the machinery and equipments of itself usually containing electronic components and performing some kinds of functions in information processing. Thus the input, output, storage, processing and control devices are the hardware of the computer system. On other hand, the set of instrucitons grouped into programs that make the computer to function in the desired way. Collection of programs to perform a particular tasks is called software.

Software:

  • It is the collection of programs to perform a particular task.
  • There are so many different types of softwares available for different purposes.
  • The softwares are categorized as system softwares and application softwares.
  • Without the software, we can not do any task using the computer.
  • Sufficient training is necessary to use the software.
  • Software is continuing expenses.

Hardware:

  • It is formed as the physical components of the computer system.
  • All of the hardware parts may do different tasks such as Hard disk is for storing, Keyboard is for giving inputs etc.,
  • The hardware peripherals are also categorized such as 12GHz Microprocessors, 2GHz Microprocessors and so on,
  • Without the hardware, there is no computers.
  • Sufficient training is necessary to use the hardware.
  • Except for upgrading, it is one-time expense.

Differences between the software and hardware:

Software Hardware
1. It is collection of program to bring the computer hardware system into operation. It is the physical components of the computer system.
2. It consists of numbers, alphabets, alphanumeric symbols, identifiers, keywords, etc. It consists of electronic components like IC’s diodes, resistors, crystals boards, insulators etc.
3. This should be prepared according to the type of the software. The design can be modified according to the capacity.
4. It will vary as per the computer and its built-in function and programming language. It is almost construct for all types of computer system.
5. It is designed and developed by a experienced programmer in a high level language, which is readable by the human being. The hardware can understand only low- level language or machine language.
6. It is represented in any high level language such as BASIC, COBOL, C, C++, JAVA etc. The hardware works only on binary code as 1’s and 0’s.
7. The software is categorized as operating systems, utilities, language processors, application software etc. The hardware consists of Input, Output, Memory, ALU, Control Unit etc.

Question 6.
Define Memory? Discuss about Main Memories in detail?
Answer:
The function of the memory is to store data or programs or information are in the form of “ON” and “OFF” States. Because Computer is an electronic device which identified only two signals either “ON” and “OFF” states. That’s why all the information or data or programs are stored inside the computer are in the form of “ON” and “OFF” states. Memories further divided into two types they are a) Primary Memories and b) Secondary Memories.

a) Primary Memories: The primary memory of computer is called as main memory. The main memories are fast memories. It is used to store programs and data. The memory location of main memory is accessed directly by the CPU. Main memory uses semi-conductor technology. These memories are very costlier. It has random access property and small access time. The capacity of primary memory is limited. Each storage locations has unique address by which it can be identified. The following primary memories are commonly used in computers, (a) Magnetic Core Memory and (b) Semi-conductor Memory.

b) Magnetic Core Memory: Magnetic core memory made up of small magnetic cores with wires running through them. Depending on the direction of the electric current flows through the wires, electricity magnetizes the core in different directions. The direction of magnetization indicates certain data representation of the CPU., Since the form f memory is bulky., it lias given way to newer technologies such as semiconductor memories.

b) Semi-conductor Memory : The modem computers are made up of semi-conductor elements in the primary storage units. This type of memory is made by etching electronic circuits onto a silicon chip.

In all computers semi-conductors are used for Primary memory storage. It is divided into two portions, (i) ROM (Read Only Memory) (ii) RAM (Random Access Memory).

Basics of Computers Long Answer Type Questions Part 3 3

ROM Memory: ROM is an acronym for Read-Only Memory. It refers to computer memory chips containing permanent or semi-permanent data. Unlike RAM, ROM is non-volatile; even after you turn off your computer, the contents of ROM will remain.

Almost every computer comes with a small amount of’ ROM containing the boot firmware. This consists of a few kilobytes of code that tell the computer what to do when it starts up, e.g., running hardware diagnostics and loading the operating system into RAM. On a PC, the boot firmware is called the BIOS.

Originally, ROM was actually read-only. To update the programs in ROM, you had to remove and physically replace your ROM chips. Contemporary versions of ROM allow some limited rewriting, so you can usually upgrade firmware such as the BIOS by using installation software. Rewritable ROM chips include PROMs (programmable read-only memory), EPROMs (erasable read-only memory), EEPROMs (electrically erasable programmable read-only memory), and a common variation of EEPROMs called flash memory.

RAM Memory: Random Access Memory (RAM) provides space for your computer to read and write data to be accessed by the CPU (central processing unit). When people refer to a computer’s memory, they usually mean its RAM.

If you add more RAM to your computer, you reduce the number of times your CPU must read data from your hard disk. This usually allows your computer to work considerably faster, as RAM is many times faster than a hard disk.

RAM is volatile, so data stored in RAM stays there only as long as your computer is running. As soon as you turn the computer off, the data stored in RAM disappears.

When you turn your computer on again, your computer’s boot firmware (called BIOS on a PC) uses instructions stored semi-permanently in ROM chips to read your operating system and related files from the disk and load them back into RAM.

SDR, DDR, DDR2, and DDR3 RAM: Several types of. RAM are used in modern computers. Before 2002, most computers used single data rate (SDR) RAM. Most computers made since then use either double data rate (DDR), DDR2, or DDR3 RAM. DDR2 is able to achieve faster transfer rates to prevent limitation of your CPU’s performance, and DDR3 technology takes these advancements even further.

Question 7.
What is Cache Memory? Explain
Answer:
Cache memory is an intermediate form of storage between the CPU registers and the RAM. The CPU uses cache memory to store instructions and data that are repeatedly required to execute programs, thereby increasing the performance of the computer.

Maintaining frequently accessed data and instructions in the cache helps in avoiding the need to access the slower DRAM repeatedly. Cache memory is basically a portion of memory made of high speed static RAM (SRAM) instead of the slower and cheaper DRAM which is used for main memory. Some memory caches are in-built in the architecture of microprocessors. For example, the Intel 80486 microprocessor has an 8K memory cache, and the Pentium has a 16K cache. Such internal caches are often called level 1 (LI) caches.

Modem PCs also come with external cache memory, called level 2 (L2) caches, which are built into the motherboard outside the CPU. Although L2 caches are composed of SRAM, they are much larger in size than LI caches. Another type of cache, called level 3 (L3).

Basics of Computers Long Answer Type Questions Part 3 4

When a program is being executed and the CPU wants to read data or instructions, the following steps are performed.

  • The CPU first checks whether the data or instruction is , available in the cache memory.
  • If it is not present there, the CPU reads the data or instructions from the main memory into the processor registers and also copies it into the cache memory.
  • When the same piece of data/instruction is needed again, the CPU reads it from-the cache memory instead of the main memory.

Question 8.
Discuss about Secondary Memories in detail.
Answer:
When the computer is switched off, anything stored in the RAM is lost. To avoid this situation, magnetic disks are used to store data permanently. The data, on these disks, won’t be affected when we turn off our computer.

a) Floppy Disk:
A floppy disk is a reusable data storage device that is composed of a disk of thin, flexible (“floppy”) magnetic storage medium encased in a square or rectangular plastic shell. Also called a “diskette,” the floppy is a flexible circle of magnetic material similar to magnetic tape, except that both sides are used. The read/write head contacts the surface through an opening in the plastic shell or envelope. Floppies rotate at 300 RPM, which is from 10 to 30 times slower than a hard disk. Floppy disks basically come in three sizes, they are 8 inches, 5 ¼ inch, and 3 ½ inch.

Basics of Computers Long Answer Type Questions Part 3 5

b) Hard Disk:
A hard disk, is also a permanent storage, where we can store lot of information. Capacity of a hard disk is measured in Megabytes (MB), Gigabytes(GB) or Terabytes(TB) and they come in various different sizes. Usually every computer now a days comes with hard disk.

Basics of Computers Long Answer Type Questions Part 3 6

The information in hard disk is stored in circular magnetic disks called plates, in the form of program files and data files.

c) CD-ROM (Compact Disk – Read Only Memory):
CD-ROM is also one of the commonly used secondary storage device. The main advantage of CD-ROM is, they can store large volumes of data i.e., 700 MB to 1.4 GB and also they are cheaper and easy to handle. It is made up of small plastic disk, coated with aluminum or silver for magnetization. A layer or transparent plastic is further deposited on the disk. The data is recorded in spiral tracks and the data once recorded cannot be deleted or rewritten, but can be read any number of times.

In this technology, a high power laser beam is used to record data by burning tiny pits in the surface of the hard plastic disk. To read the data, a low power laser beam is used to scan the disk surface. The data are stored in binary digits. When the laser beam reflects from the smooth surface of the disk it is interpreted as a 1 bit and when the beam enters the tiny pits it is interpreted as a 0 bit.

Advantages:

  • High Storage Capacity
  • Easy to use in multimedia applications.
  • Handled easily.
  • Can read/Rewrite using CD-RW’s

Disadvantages:

  • CD Writing can be done carefully
  • Should be kept free from dust and heat.

d) Magnetic Tape:
Magnetic tape is the oldest form of secondary storage device. It is one of the popular storage medium for storing large amount of sequential data. It is also used as a backup storage for data stored on on-line storage devices.

The magnetic tape medium is a plastic ribbon usually 1/2 inch or 1/4 inch wide and 50 to 2400 feet long. It is coated with a magnetizable recording material such as iron-oxide or chromium dioxide. Data are recorded on the tape in the form of ^ tiny invisible magnetized and non-magnetized spots on the coated surface of the tape.

Advantages:

    • Non-volatile Memory
    • Voluminous data can be stored.

Disadvantages:

  • Only sequential data processing
  • Complex mechanism required.
  • After few days the data can be mounted to tape, we need to recall the data to store it into hard disk as and when required.

Basics of Computers Long Answer Type Questions Part 3 7