Download as ODT, PDF, TXT or read online from Scribd
Download as odt, pdf, or txt
You are on page 1/ 15
Practical-1. Create a style and apply to a pararagraph.
A paragraph style is a set of rules that define how text looks. It contains a collection of rules that define how text behaves and looks. Paragraph styles control all aspects of a paragraph's appearance Paragraph styles allow you to save and reuse the specific text formatting and the paragraph formatting Character styles affect selected text.
➢steps to create a style:
Step.1- Right-click the text on which you want to base a new style. Step.2- In the toolbar that appears, click Styles, and then click Create a Style. Step.3- In the Create New Style from Formatting dialog box, give name.
➢Steps to apply a style to a paragraph:
Step.1- Select the text you want to format. Step.2- On the Home tab, point to a style to preview it. If you don't see a style you want Step.3- Select a style Practical-2. Create a Template and create a document using the template. A template is a pattern, mold, or gauge that is used as a guide to create something. Templates can be made of metal, plastic, or paper. They can be used to make multiple copies of a shape or to help cut material accurately. A template is a form, mold or pattern used as a guide to make something. Here are some examples of templates: Website design. Creating a document.
➢steps to create a document:-
step.1-Open the Word document that you want to save as a template. Step.2-On the File menu, click Save as Template. Step.3-In the Save As box, type the name that you want to use for the new template. Step.4- In the Where box, choose a location where the template will be saved
➢A Document using a template:-
Ms. Kate Spinner store manager Farm Table Inc. 20345 Sunshine Ln Elite, TN 10046 Dear Ms. Spinner,
Please accept this letter as my official resignation effective Monday, February 3rd. If I were able, I would have provided you with at least a two-week notice, however, I accepted a job offer for a position that begins immediately. I hope you accept my apologies for such short notice.
Thank you for providing me with this opportunity and helping me to develop new leadership strategies.
Please let me know if I can make this transition easier. I have started to compile notes on important projects I am not able to complete before my departure.
Sincerely,
June Tart Practical-3. Create a table of content.
A table of contents (TOC) is a navigation tool that provides an overview of a
document's contents and organization. It's a necessary index that's usually found in long documents, books, and drafts.
Provides links to sections and subsections of the document Allows readers to go directly to a specific section of an online document Organizes the contents in a systematic manner according to topics available in the document.
➢Steps to create table of content:-
Step.1-Apply proper heading or styles for contents as explained above.
Step.2-Place your cursor on the first page. (The first page should be blank)
Step.3-Click on Insert→Indexes and Tables→Indexes and Tables. An Insert Index/Table
dialog box will appear. Practical-4. Create a subtotal Spreadsheet. A subtotal is a partial sum that is calculated before the final total is determined. It is often used in accounting, finance, and sales to refer to the calculated sum or total of a portion of a larger set of values. For example, a subtotal might be calculated for the items in a shopping cart before the taxes and shipping are added.
Subtotals can be used to break down a larger set of data into smaller, more manageable pieces. This can be helpful for analyzing the data and identifying trends.
➢steps to create a subtotal:-
Step.1-Select the range of cells that you want to calculate subtotals.
Step.2-choose Data you want to Subtotals. Step.3-In the Subtotals dialog, in the Group by list, select the column by which the subtotals need to be grouped. Step.4-A subtotal will be calculated for each distinct value in this column Practical-5. Analyse data using Consolidation. A data consolidation process involves combining data from different sources, cleaning and verifying it, and storing it in one place, such as a data warehouse. There are multiple sources and formats of data in every business. By consolidating data, it becomes easier to unify it.
This can help businesses eliminate data redundancy, achieve a unified view of data, and adopt company-wide analytics. Practical-6. Analyse data using Solver. A solver is someone who focuses on a problem and tries to synthesize information and knowledge to achieve a solution. Synonyms of solver include convergent thinker and problem solver. A solver is someone who focuses on a problem and tries to synthesize information.
➢Steps to use solver:-
Step.1-Run Excel Solver. On the Data tab, in the Analysis group, click the Solver button. Step.2-Define the problem. The Solver Parameters window will open where you have to set up the 3 primary components: … Step.3-Solve the problem. Practical-7. Analyse data using Subtotal. The SUBTOTAL function returns the subtotal value from a range of cells.It can be used instead of SUM, COUNT, and MAX to ignore hidden rows. The SUBTOTAL function can also be used to calculate the sum and use multiple arithmetics and logical operations.
➢Steps to use subtotal:-
Step.1-On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed. Step.2-In the At each change in box, click the nested subtotal column. . Step.3-In the Use function box, click the summary function that you want to use to calculate the subtotals. Step.4-Clear the Replace current subtotals check box. Practical-8. Create and use Macros in Spreadsheet.
➢steps to create a macro:-
Steps.1-Make the 'Developer' tab visible. The 'Developer' tab is a special tab in Excel that helps users access additional features and tools, like creating macros. ... Steps.2-Record the macro... Steps.3-Provide macro details... Steps.4-Perform the desired actions... Steps.5-Use your shortcut key. Practical-9. Create a spreadsheet and link it with another worksheet.
➢Steps to create a spreadsheet:-
Step.1-Click the File tab.
Step.2-Click New. Step.3-Under Available Templates, double-click Blank Workbook.
➢steps to link a worksheet with another worksheet:-
Step.1-Select and copy the range of cell to be shared. Step.2-Change to the spreadsheet that requires the link and select the place where to. Step.3-Open the Paste Special dialog, Edit > Paste Special and check the Link option . Step.4-Click OK to insert the DDE link. Practical-10. Create a blog using Blogger. A blog is a website that provides information or discussion. It is a combination of the words "web" and "log".The word "blog" is short for "weblog".A blog is an online journal or informational website run by an individual, group, or corporation that offers regularly updated content (blog post) about a topic. It presents information in reverse chronological order and it's written in an informal or conversational style.
➢Steps to create a blog using Blogger:-
Step.1-Sign in to Blogger. Step.2-On the left, click the Down arrow . Step.3-Click New blog. Step.4-Enter a name for your blog. Step.5-Click Next. Step.6-Choose a blog address or URL. Step.7-Click Save. ➢
