Q.

Explain the different elements of word user interface

1. File Tab: Main menu for managing files, including opening, saving, and printing.
2. Ribbon: Toolbar at the top with commands organized into tabs and groups for easy access.
3. Quick Access Toolbar: Customizable toolbar for frequently used commands.
4. Title Bar: Displays the title of the current document or application.
5. Groups Category: Organizational sections within the ribbon tabs for related commands.
6. Dialogue Box Launcher: Small arrow or button in some goups that opens additional options
or settings..
7. Status Bar: Displays information about the current document, such as page number or word
count.
8. View Toolbar: Toolbar for changing the document's view settings, like zoom level or layout
1. . Zoom Button: Controls for adjusting the zoom level of the document.
2. The Ruler: Horizontal and vertical guides for aligning and formatting text and objects.
3. Vertical and Horizontal Scroll Bars:Controls for navigating through the document vertically
and horizontally.
4. Key Tips: Keyboard shortcuts displayed when you press the Alt key to access commands
without using the mouse.
5. Screen Tips: Informational pop-ups that appear when you hover over buttons or options.
6. Mini Toolbar: Floating toolbar that appears when text is selected, offering formatting
options.
7. Contextual Tabs: Additional tabs that appear in the ribbon when certain objects or tasks are
selected, providing relevant commands.

Q. Briefly explain the preparation process of worksheets to printer.

Excel has the facility to print the entire workbook, a worksheet or a selected portion of a worksheet.
To print a worksheet, perform the following steps.
1. Open the work sheet you want to print
2. Click File → Print option
3. From the settings box choose any option - Print active sheets/Print entire
Workbook/Print Selection.
4. If you want to print some pages enter starting and ending pages in the From and To Boxes
5. Choose other options like Print one sided/ Print on Both sides, Paper orientation, Paper size,
Margins etc.
6. After specifying the options click Print button.

Q. Write a note on charts in Excel 2013.

Charts are graphical representation of numeric data. The different types of charts are:-
Column charts
A column chart shows data changes over a period of time or illustrates comparisons among item
Column charts have the following sub types:

Clustered Column: This type of chart compares values across categories. It is also available with a 3-D
visual effect.
Stacked Column: This type of chart shows the relationship of individual items to the whole,
comparing the contribution of each value to a total across categories. It is also available with a 3-D
visual effect.
100% Stacked Column: This type of chart compares the percentage each value contributes to a total
across categories. It is also available with a 3-D visual effect.
3-D Column: This type of chart compares data points along two axes. For example, in the following 3-
D chart, you can compare four quarters of sales performance in Europe with the performance of two
other divisions.
Bar charts
A bar chart illustrates comparisons among individual items. Bar charts have the following chart sub-
types:
• Stacked Bar: This type of chart shows the relationship of individual items to the whole. It is also
available with a 3-D visual effect.
• 100 % Stacked Bar: This type of chart compares the percentage each value contributes to a total
across categories. It is also available with a 3-D visual effect.
• Clustered Bar: This type of chart compares values across categories. It is also available with a 3-D
visual effect.

Line Chart
A line chart shows trends in data at equal intervals. Line charts can display continuous data over
time, set against a common scale, and are therefore ideal for showing trends over time. Line charts
have the following chart sub-types:

Stacked Line: This type of chart displays the trend of the contribution of each value over time or
categories. It is also available with markers displayed at each data value.
100% Stacked Line: This type of chart displays the trend of the percentage each value contributes
over time or categories. It is also available with markers displayed at each data value.
3-D Line: This is a line chart with a 3-D visual effect.
This type of chart displays trends over time or categories. It is also available with markers displayed
at each data value.

Pie chart
A pie chart shows the size of items that make up a data series, proportional to the sum of the items.
It always shows only one data series and is useful when you want to emphasize a significant element
in the data. Pie charts have the following chart sub-types

Pie: This type of chart displays the contribution of each value to a total. It is also available with a 3-D
visual effect,
Exploded Pie: This type of chart displays the contribution of each value to a total while emphasizing
individual values. It is also available with a 3-D visual effect.
Pie of Pie: This is a pie chart with user-defined values extracted and combined into a second pie

Area Chart
An area chart emphasizes the magnitude of change over time.
Area charts have the following chart sub-types

Area: This type of chart displays the trend of values over time or categories. It is also available with a
3-D visual effect.
Stacked Area: This type of chart displays the trend of the contribution of each value over time or
categories. It is also available with a 3-D visual effect.
100% Stacked Area: This chart type displays the trend of the percentage each value contributes over
time or categories. It is also available with a 3-D visual effect.

XY (Scatter) charts
XY (Scatter) charts and Line charts look very similar, especially when a Scatter chart is displayed with
connecting lines. However, there's a big difference in the way each of them displays data. The main
difference is the way each of these chart types plots data on the x-axis.
A Scatter chart has two value axes, showing one set of numerical data along the x-axis and another
along the y-axis. It combines these values into single data points and displays them in uneven
intervals, or clusters.
Q.Explain different formating options in pagemaket

The Font Group

Bold, Italicize and Underline Text To bold text in Microsoft Excel:
1. Select the cell or cells in which you wish to bold the text.
2. On the HOME tab, in the Font group, click the Bold command.
To italicize text in Microsoft Excel:
1. Select the cell or cells in which you wish to italicize the text.
2. On the HOME tab, in the Font group, click the Italic command.
To underline text in Microsoft Excel:
1. Select the cell or cells in which you wish to underline the text.
2. command.
On the HOME tab, in the Font group, click the Underline
Add Borders to Cells
To add borders and boxes to cells in Microsoft Excel:
1.Select the cell or cells to which you wish to add borders.
2.On the HOME tab, in the Font group, click the arrow to the right of the Borders command.
3. Select the type of border /box you wish to add from the drop down menu: /box

Change Text and Cell Colors

To change the color of text in cells in Microsoft Excel:
1. Select the cell or cells in which you wish to change the color of the text.
2. On the HOME tab, in the Font group, click the arrow to the right of the Font Color command.
3. Select a color from the drop down menu:
To change the fill (i.e., background) color of cells in Microsoft Excel:
1. Select the cell or cells in which you wish to change the fill color.
2. On the HOME tab, in the Font group, click the arrow to the right of the Fill Color command.
3.Select a color from the drop down menu:
Set Font and Font Size
To change the font of text or numbers in cells in Microsoft Excel:
1.Select the cell or cells in which you wish to change the font.
2.On the HOME tab, in the Font group, click the arrow to the right of the Font command.
3.Select a font from the drop down menu:

To change the size of the font of text or numbers in cells in

Microsoft Excel:
1. Select the cell or cells in which you wish to change the font size.
2. On the HOME tab, in the Font group, click the arrow to the right of the Font Size command.
3. Select a font size from the drop down menu:
Align Text
Text within cells in Microsoft Excel can be aligned both vertically (top, center and bottom) and
horizontally (left, center and right).
To align text vertically within a cell or cells in Microsoft Excel:
1. Select the cell or cells in which you wish to align the text.
2. On the HOME tab, in the Alignment group, click either the Top Align, Middle Align or Bottom Align
command:
To align text horizontally within a cell or cells in Microsoft Excel:
1. Select the cell or cells in which you wish to align the text.
2. On the HOME tab, in the Alignment group, click either the Align Text Left, Center or Align Text
Right command:
Indent Text
Indenting text is a way of showing that one item is a sub-item of another, as demonstrated here:

Instead of indenting sub-headings with spaces, you can do so using the Increase Indent command,
which makes it a lot easier to keep all indented text equally indented.
To indent text within a cell or cells in Microsoft Excel:
1. Select the cell or cells in which you wish to indent text.
2. On the HOME tab, in the Alignment group, click the Increase Indent command:
3. You can click Increase Indent as many times as you want to achieve the indentation you desire.
4. To decrease an indent, simply click the Decrease Indent command:

Q.List down the new specific features of Ms word 2013

New Look for Word
The first change you'll see when you launch Word 2013 is a
startup screen rather than a blank document, as in older versions of Word. In the left pane, you'll see
a list of your most recent Word documents as well as the option to open other Microsoft Word 2013
Easy Graphic Alignment and Layout Options
The new Alignment Guides in Word 2013 make lining up images and other objects an easy task. They
are a visual way to show when the object, such as an image, chart, or SmartArt illustration, is aligned
with the top of a paragraph or to a heading or other elements on the page.
Improved Reading in Read Mode
If you use Word more to read documents than to create them, you'll like Word 2013's new Read
Mode which is clean and distraction free. Switch to the Read Mode and the Ribbon collapses as for
most of the tabs. This new view automatically resizes a document to the full window and displays
your documents in easy-to-read columns.
Open and Edit PDFs inside Word
Opening and editing PDFs is finally a full-fledged feature in Word 2013. In past versions, you could
save a Word document as a PDF, but you couldn't edit a PDF without converting it to a Word
document first. Now you simply open a PDF as if it is a Word document and edit it as usual.
Improved Table FeaturesWord 2013
finally addresses the frustration of formatting different width and style borders in a Word table. The
handy Border Painter tool and Border Styles feature simplify and speed up formatting
Better Management of Long DocumentsLong documents
can become unruly to manage especially if you're working in just a small portion of it. New
Expand/Collapse options in Word 2013 let you collapse and expand the headings of a document to
make it easier focus only on the portion you need.
Multimedia Magic
If you design newsletters, flyers, brochures, or other graphical documents in Word, you can now add
web photos and videos directly into a Word document. To add a video, choose Online Video from the
Insert tab in the Ribbon.
Get on the Cloud
Like other programs in the new Office suite, Word 2013 is connected to the cloud anytime you're
online. One Drive, Microsoft's cloud-based file storage service, is integrated into Word and is now the
default save location.
Touch Screen Functionality
Microsoft Word 2013, along with the entire Office suite, is built with touch screens in mind. A touch
screen isn't required for Word, but if you're using it on a Windows tablet or touch-enabled monitor,
you'll find the navigation is simple and straightforward
4. Smarter Collaboration Reviewing documents with Tracked Changes and comments is easier now
with Word 2013's new Simple Markup view. From Simple Markup, complex markups are hidden and
the final document is displayed.
Q.Explain the methods to print a document, the configurations settings in the print menu and the
print preview options in Word 2013.

To print a document
1. Click the File tab and then click Print.
2. Do the following:
• Under Print, in the Copies box, enter the number of copies you want.
• Under Printer, make sure the printer you want is selected.
• Under Settings, the default print settings for your printer are selected for you. If you want to
change a setting, just click the setting you want to change and then select a new setting.
3. When you're satisfied with the settings, click Print.

Configuring Documents to Print

The Print window gives you access to several printing and page layout options. You will also see a
preview of how your document will print.

Print Document Sections

You can choose to print only document sections, instead of an entire document. To print document
sections, on the Print page got by clicking in File, under Settings, select the first drop-down list, and
then select Custom Print and specify the sections.

PRINTING AND PRINT PREVIEW

In Office, you can print and preview files from the same location by clicking File and then Print (or
pressing CTRL+P).
1. Click File>Print. On the right, you'll see a preview of your presentation. On the left, you'll see the
Print button and the configurable Settings.
2.To see each page, click the arrow at the bottom of the preview, and if the text is too small to read,
use the zoom slider to adjust it.
Tip: If you'd like to preview multiple pages side by side, use the
zoom slider to zoom out.
3. Click (<-)
to return to your document without printing it.
If you're ready, then print your document.
 1. Write Detailed notes on Frame Object in Page Maker 7.0

PageMaker includes a special kind of object called a frame.

A Frame is a container for text or graphics that can be in a variety of shapes. You can turn any
object you've created with the PageMaker drawing tools into a frame by selecting it then going
to the Element menu, choosing Frame... then choosing Change to Frame.
You can also draw a frame with the Frame Tool

Creating Frames
Select the shape of the frame you want to use from the Toolbox.
Click on the document where you want the frame to be located and drag until you are satisfied with
the size. The frame is now ready to receive content.
To add text, click on the Text Tool and then click inside the frame. Start typing your text and it will
wrap accordingly. You can also use the Place command (File menu), to put a graphic or text inside a
frame. The text takes the particular shape you have selected.
PageMaker enables you to configure three types of frames:
› Rectangular
• Oval
• Polygonal
Polygons can be created by a click-and-move method. Instead of clicking a point and then dragging
out a polygonal shape at the start, simply click from point to point.
A freeform page is one in which the symmetry between elements is not apparently rigidly structured,
but structured more upon the perceived "weights" of the elements involved. Weights refer to their
apparent density (blackness).
Text can be attached to any type of frame.
Frames can also be used as inline graphics in a text block

To turn a basic shape into a frame:

Create a PageMaker-drawn shape.
Select the shape
Choose Element > Change to Frame.
The shape preserves its fill, line weight, and other object attributes.
To attach existing text or graphics to a frame:
Create a Frame
Write the text
Select the Frame (by using the pointer tool)
Press Shift and select the text block you want to add to the frame.
Choose Element > Frame > Attach Content.
To import text or graphics into a frame:
Create a Frame
Select the frame.
Choose File > Place.
Select the file you want to place, and then click OK.
To detach / separate content from a frame:
Select the frame which contains text or graphics.
Choose Element > Frame > Separate Content.
To delete content from a frame:
Select the frame which contains some content.
Choose Element > Frame > Delete Content.
25. Comment on templates in Excel 2013 and how to create worksheet templates.

Templates in Excel 2013 are pre-designed spreadsheets that offer predefined formats and structures
for various types of documents like budgets, calendars, and invoices. They save time by providing a
starting point that users can customize. Templates ensure consistency across documents and simplify
complex tasks by offering built-in formulas and formatting options. They are accessible through
Excel's New Workbook dialog box, can be downloaded from Microsoft's website, or created by users
themselves. Overall, templates enhance productivity and streamline the creation of professional-
looking spreadsheets.

To create a worksheet template:-

Open the workbook that you want to use as a template → Then click Save As option → In the File
name box, type the name that you want to use for the template In the Save as type box, click Excel
Template → Click Save button.

Q.Using examples explain the sorting and filtering methods in Excel.

To sort data in Excel:

Select a cell in the column you want to sort.
In the Data tab, go to the Sort & Filter group. Then you have two options.
To sort values in ascending or descending order based on Excel's interpretation of the column, click
the Sort Ato Zor Sort Zto Aicons.
For more sorting options, click the Sort button. User can then specify the Column, what to Sort On,
and Order. With the Add Level option, user can perform a secondary level of sorting if needed.

To create a filter in Excel

Select the data.
Select Data > Filter from the ribbon menu.
At the top of your selection, select the column header arrow (grey box with downwards arrow).
Select Text Filters o r Number Filters, and then select a comparison, such a s Between.
Enter the filter criteria and select OK
Q.Explain the methods to draw tables along with the different formatting options available with
them.

Method 1: To Insert Tables Side By Side In A Word Document

1. On the Page Layout tab, in the page Setup group, click Columns and select Two
2. Select the Insert tab, and in the Tables group, click Tables and select an option to insert a
table.
3. Place the insertion point below the first table and create another table.
4.Drag the table created in point 3, and move it adjacent to the first
table.
5.The resultant is that you now have two tables placed side by side in your word document.

Method 2: To Insert Tables Side By Side In A Word Document

1. In the Insert tab, and in the Tables group, click Tables and select an option to insert a table.
2. Select the column you want to use to split the table
3. On the Home tab, in the Paragraph group, click Border button and from the drop-down list, select
No borders
4.Select the column without a right border, and from the Border drop-down list, select Right Border.
5.Similarly, select the column without a left border, and from the Border drop-down list, select Left
Border.
6.You now have a table sitting side by side in your Word document.

FORMATTING A TABLE
Tables in Microsoft Word, and the data within them, can be customized in many ways. We cover a
few of the more common ways below.

Inserting Columns and Rows in Tables

To insert a column or row in a table in Microsoft Word:
1. Place your cursor in a cell adjacent to where you want to add a column or row.
2. On the TABLE TOOLS LAYOUT tab, in the Rows & Columns group, click the Insert option that
accomplishes your goal:

Deleting Columns and Rows in Tables

To delete a column, row or cell in a table in Microsoft Word:
1. Place your cursor in the column, row or cell you wish to delete.
2. ⁠On the TABLE TOOLS LAYOUT tab, in the Rows & Columns group, click Delete:
1. To delete a column or row, or to delete the whole table, select that option:
2. To delete a cell or cells, click Delete Cells: Then choose whether the remaining cells should shift
left or shift up, and click OK:
Aligning Text in Tables
The text in each cell within a table can be aligned left, right, and center and also top, bottom and
center. To align text in tables:
1. Select the cell or cells for which you wish to adjust the alignment.
2. On the TABLE TOOLS LAYOUT tab, in the Alignment group, click the alignment option of your
choice:
The direction of the text in each cell is left to right by default, but can be changed to top to bottom
and bottom to top. To change the direction of text in a cell:
1. Select the cell or cells for which you wish to adjust the text direction.
2. On the TABLE TOOLS LAYOUT tab, in the Alignment group, click
Text Direction:
Q.What is mail merge write down the steps

Mail merge is a usefull tool that allows you to produce multiple letters,labels,envelopes,name tags,
and more usung information stored in a list database or spreadsheet when performing a mail merge
you will need a a word document and a recipient list,which is typically an excel wordbook

Mail merge requires following steps

Creating a Main Document and the Template:

Open Microsoft Word and create a new document.

Design the layout and content of your document, ensuring that areas where data will be inserted are
left as placeholders (merge fields).
Save this document as your main document or template, depending on whether you plan to reuse it
for future merges.
Creating a Data Source:

Prepare your data source in Excel, Access, or another compatible format.

Ensure that each column represents a different type of data you want to merge (e.g., Name, Address,
City, etc.).
Save your data source file in a location that is easily accessible.
Defining the Merge Fields in the Main Document:

Place your cursor in the main document where you want to insert data from the data source.
Go to the "Mailings" tab in the Word ribbon.
Click on "Insert Merge Field" and choose the fields from your data source that you want to insert.
Repeat this process for each piece of information you want to merge (e.g., <<First Name>>, <<Last
Name>>, <<Address>>, etc.).
Format the text and adjust spacing as needed around the merge fields to ensure the merged
documents look professional.
Merging the Data with the Main Document:

Go to the "Mailings" tab and click on "Start Mail Merge."

Select "Step-by-Step Mail Merge Wizard" to guide you through the process.
Choose the document type you want to create (e.g., Letters, Emails, Envelopes, Labels, etc.).
Select your data source by browsing to the location of your prepared data file.
Arrange your merge fields by clicking "Next: Write your letter" and customize any additional settings
as required.
Preview your merged documents to ensure everything appears correctly.
Complete the merge by clicking "Finish & Merge" and choose whether to print the documents, edit
individual documents, or save them to a new file.
Saving:

Save your main document or template with merge fields intact for future use.
Save your data source file separately to maintain a clean and organized workflow.