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