Microsoft word 2016 basics unit 1 worksheet answers free

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Не обращайте на него внимания, – засмеялась.  – Он просто расстроен. Но он получит то, что ему причитается.

❿
 
 

❿

 

Microsoft word 2016 basics unit 1 worksheet answers free – Get writing help when you need it most

 
Bihar Police SI.❿
 
 

Word help & learning – Microsoft word 2016 basics unit 1 worksheet answers free

 
 

HP Police Constable. Assam Police Constable. Punjab Police Head Constable. Delhi District Court Group C. Madras High Court Office Assistant. Punjab Police Jail Warder. DHS Assam Grade 3. Assam Animal Husbandry Veterinary. Telangana AMVI. DHS Assam Grade 4. Punjab Police. HP Forest Guard. Goa Police Constable. SCCL Clerk. Telangana High Court Copyist.

Kerala Beat Forest Officer. Kerala High Court Assistant. Goa Police Sub Inspector. Maharashtra Agricultural Officer. PMC Clerk. AP Police Constable. UP Police Constable. Bihar Police SI. WB Police Constable. UP Police Jail Warder. WB Police SI. UP Police.

Bihar Police Driver. Bihar Police Forest Guard. WB Police. LIC Assistant. ESIC Stenographer. GIC Assistant Manager. NCL Staff Nurse. BHU Staff Nurse. FCI Stenographer. FCI Assistant Grade 3. FCI Manager. FCI Watchman. CWC Junior Superintendent. AMD Security Guard. India post Postman. India Post MTS. India Post Mail Guard. India Post. Puducherry UDC. Tech Mahindra. CAT Exam. CMAT Exam.

JEE Main. English English. Word processor. Electronic spreadsheet Presentation software Database management system. India’s Super Teachers for all govt. Get proficient with the Computer Awareness concepts with detailed lessons on the topic Microsoft Office among many others.

Microsoft Office Question 1 Detailed Solution. The correct answer is option 4. Concept: Microsoft Access: Microsoft Access is a relational database management application that allows you to save information for reference, reporting, and analysis.

MS Access supports both flat-file databases and relational databases. Access is a commercial and enterprise application that is part of the Microsoft package. A flat-file database is used to store data in a single table structure. A relational database is used to store data in a multiple-table structure. A flat-file database can be accessed by a variety of software applications like MS access. What is DBMS? Database Management System DBMS is software for storing and retrieving users’ data while considering appropriate security measures.

It consists of a group of programs that manipulate the database. The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other third-party software to store and retrieve data. DBMS allows users to create their own databases as per their requirements. It provides an interface between the data and the software application.

Since there are so many database management systems available, it is important for there to be a way for them to communicate with each other. For this reason, most database software comes with an Open Database Connectivity ODBC driver that allows the database to integrate with other databases. Get Started for Free Download App. Trusted by 3. Microsoft Office Question 2 Detailed Solution. The correct answer is AVG. A minimum of two cells have to select to perform the SUM function.

A minimum of two cells have to select to perform the MAX function. A minimum of two cells have to select to perform the MIN function. Thus the correct answer is AVG. Additional Information MS Excel, a spreadsheet program, is widely used for different kinds of functions, as a result, the info is simple to avoid wasting time, and data is accessible and removed with zero discomforts and less labour.

Given below area unit some necessary advantages of exploitation MS Excel: Easy To Store Data: Since there’s no limit to the number of data that may be saved in an exceeding program. MS Excel is widely accustomed to saving or analysing information.

Filtering info in stand out is simple and convenient. Easy To Recover Data: If the data is written on a bit of paper, finding it should take longer, however, this is often not the case with Excel spreadsheets.

Finding convalescent information is simple. Application of Mathematical Formulas: Doing calculations has become more accessible and less time-taking with the formulas possibility in MS Excel.

More Secure: These spreadsheets are countersigned and secured in an exceedingly portable computer or laptop computer; therefore, the chance of losing them is much lesser than information written in registers or pieces of paper. Data at One Place: Earlier, information was to be unbroken in several files and registers once the work was done.

Now, this has become convenient as over one worksheet is accessible in an exceedingly single MS Excel file. Neater and Clearer Visibility of Information: Once the info is saved within the type of a table, analysing it becomes easier. Thus, info may be a program that’s a lot of legible and comprehensible. Microsoft Office Question 3 Detailed Solution. The correct answer is MS Excel. Key Points MS Word: Microsoft Word is recognised as a word processing software which means that a user can rewrite, erase or modify a document as per the requirement.

The documents created in MS Word are very high in quality. MS Word is used for creating reports, stories, letters, resumes etc. It allows users to edit or modify the new or existing document with colour or any other formats like bold, italic and underline.

In MS Word, the users can write the stories in paragraph format. The file extension used in MS Word is. MS PowerPoint has unique features like animation, slide shows and so on. Animations can only be applied to selected Slides objects in an MS-Powerpoint presentation.

MS PowerPoint is used for presenting reports and stories in an attractive manner. MS Excel: MS Access: Additional Information MS Excel, a spreadsheet program, is widely used for varied functions, as a result, the info is simple to avoid wasting time, and data is accessible.

Given below area unit some necessary advantages of exploitation MS Excel: Easy To Store Data: Since there’s no limit to the number of data that may be saved in an exceeding program, MS Excel is widely accustomed to saving or analysing information.

More Secure: These spreadsheets are countersigned and secured in an exceedingly portable computer or laptop computer and therefore the chance of losing them is much lesser as compared to information written in registers or pieces of paper.

Image editor Database Word processor File manager. Microsoft Office Question 4 Detailed Solution. Important Points Although you might not be aware of it, some Microsoft Office applications, like Word, PowerPoint, and Publisher, come with image editing features.

It includes a word processor Word , spreadsheet and presentation software Excel and PowerPoint , email software Outlook , a database management system Access , and a desktop publishing package Publisher. There are various versions of Office produced for various end-users and computing settings.

When adding images to your documents, Microsoft Office provides improved photo editing options that can be helpful.

You can alter a picture’s brightness or contrast, erase the background, add a border, rotate, crop, or resize it. You can even employ artist effects. The process of creating, editing, saving, and printing documents on a computer is referred to as word processing. A database is a device for gathering and arranging data. Databases can store data about people, things, orders, and other things. Microsoft Office Question 5 Detailed Solution.

Add titles and data labels to a chart To help clarify the information that appears in your chart, you can add a chart title, axis titles, and data labels.

Add a legend or data table You can show or hide a legend, change its location, or modify the legend entries. In some charts, you can also show a data table that displays the legend keys and the values that are presented in the chart. Apply special options for each chart type Special lines such as high-low lines and trendlines , bars such as up-down bars and error bars , data markers, and other options are available for different chart types.

Instead of manually adding or changing chart elements or formatting the chart, you can quickly apply a predefined chart layout and chart style to your chart. Word provides a variety of useful predefined layouts and styles that you can select, but you can fine-tune a layout or style if it is needed by making manual changes to the layout and format of individual chart elements, such as the chart area, plot area, data series, or legend of the chart.

When you apply a predefined chart layout, a specific set of chart elements such as titles, a legend, a data table, or data labels are displayed in a specific arrangement in your chart. You can select from a variety of layouts that are provided for each chart type.

When you apply a predefined chart style, the chart is formatted based on the document theme that you have applied, so that your chart matches your organization’s or your own theme colors a set of colors , theme fonts a set of heading and body text fonts , and theme effects a set of lines and fill effects.

You cannot create your own chart layouts or styles, but you can create chart templates that include the chart layout and formatting that you want. In addition to applying a predefined chart style, you can easily apply formatting to individual chart elements such as data markers, the chart area, the plot area, and the numbers and text in titles and labels to give your chart a custom, eye-catching look.

You can apply specific shape styles and WordArt styles, and you can also format the shapes and text of chart elements manually. Fill chart elements You can use colors, textures, pictures, and gradient fills to help draw attention to specific chart elements. Change the outline of chart elements You can use colors, line styles, and line weights to emphasize chart elements.

Add special effects to chart elements You can apply special effects, such as shadow, reflection, glow, soft edges, bevel, and 3-D rotation to chart element shapes, which gives your chart a finished look. Format text and numbers You can format text and numbers in titles, labels, and text boxes on a chart as you would text and numbers on a worksheet.

To make text and numbers stand out, you can even apply WordArt styles. When you create a chart, you can then apply the chart template just as you would any other built-in chart type. In fact, chart templates are custom chart types — you can also use them to change the chart type of an existing chart.

If you use a specific chart template frequently, you can save it as the default chart type. You can add a chart to your Word document in one of two ways: insert a chart by embedding it into your Word document, or paste an Excel chart into your Word document that is linked to data in an Office Excel worksheet.

The main differences between embedded charts and linked charts are where the data is stored and how you update the data after you place it in the Word document. Note: Some chart types require a specific data arrangement in the Excel worksheet. For more information, see Arrange the Excel worksheet data. When you embed an Excel chart, information in the Word file doesn’t change if you modify the source Excel file. Embedded objects become part of the Word file and, after they are inserted, they are no longer part of the source file.

Because the information is totally contained in one Word document, embedding is useful when you don’t want the information to reflect changes in the source file, or when you don’t want the document recipients to be concerned with updating the linked information.

Select the type of chart you want, such as column or pie chart, and click OK. Enter your data into the spreadsheet that automatically opens with the chart. The chart will update to match the data after you finish typing data into one cell and move to the next. Important: Office is no longer supported. Upgrade to Microsoft to work anywhere from any device and continue to receive support. Upgrade now. On the Insert tab, in the Illustrations group, click Chart.

In the Insert Chart dialog box, click a chart, and then click OK. Office Excel opens in a separate window and displays sample data on a worksheet.

In the Excel window, replace the sample data by clicking a cell on the worksheet and then typing the data that you want. Note: After you update the worksheet, the chart in Word will be updated automatically with the new data. In the Save As dialog box, in the Save in list, select the folder or drive that you want to save the worksheet to.

To save the worksheet to a new folder, click Create New Folder. You can create and copy a chart in an external Excel worksheet, and paste a linked version of the chart into your Word document. When a chart is linked, information can be updated if the external Excel worksheet is modified. Linked data is stored in the Excel worksheet.

The Word document stores only the location of the source file, and it displays a representation of the linked data. Linking is also useful when you want to include information that is maintained independently, such as data collected by a different department, and when you need to keep that information up-to-date in a Word document. For more information about creating charts in Excel, see Create a chart.

In Excel, select the chart by clicking its border, and then on the Home tab, in the Clipboard group, click Cut. On the Home tab, in the Clipboard group, click Paste. The Paste Options button indicates that the chart is linked to data in Excel. You can also create visual representations of information by using SmartArt graphics.

For more information, see Create a SmartArt graphic. For most charts, such as column and bar charts, you can plot the data that you arrange in rows or columns on a worksheet into a chart. However, some chart types such as pie and bubble charts require a specific data arrangement. The data can be arranged in rows or columns — Excel automatically determines the best way to plot the data in the chart.

Some chart types such as pie and bubble charts require a specific data arrangement as described in the following table. For multiple data series, in multiple columns or rows of data and one column or row of data labels, such as:. In columns, placing x values in the first column and corresponding y values and bubble size values in adjacent columns, like:.

Tip: If you select only one cell, Excel automatically plots all cells that contain data that is adjacent to that cell into a chart.

If the cells that you want to plot in a chart are not in a continuous range, you can select nonadjacent cells or ranges as long as the selection forms a rectangle. You can also hide the rows or columns that you do not want to plot in the chart.

Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection. Just above the Office Theme menu is an Office Background drop-down menu — here you can choose to display a pattern such as a circuit board or circles and stripes in the title bar. Each location now displays its associated email address underneath it. This is quite helpful if you use a cloud service with more than one account, such as if you have one OneDrive account for personal use and another one for business.

You’ll be able to see at a glance which is which. The biggest feature launched with Word is live collaboration that lets people work on documents together from anywhere in the world with an internet connection, a feature that Google Docs has long had. However, while Office subscribers or anyone using Word or Word Online can see the changes that other users of those versions make to a shared document in real time as they happen, Word users have to save their documents periodically to see and share changes.

Still, it does allow you to work with others on the same document at the same time. To collaborate on a document, first open it, then click the Share icon in the upper-right part of the screen. Clicking the Share button opens the Share pane on the right-hand side of the screen — this is command central for collaboration.

At the top of the pane, type in the email addresses of the people with whom you want to collaborate on the document, separated by commas. As you type, Word looks through your address book and displays the matches it finds; click the person you want to invite.

After you enter the addresses, select either “Can edit” or “Can view” in the drop-down to allow collaborators full editing or read-only privileges.

Type a message in the text box if you want. Your collaborators get an email message like this when you share a document. Click image to enlarge it. For example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures. Learn more about how to analyze trends in data using sparklines. The Quick Analysis tool available in Excel and Excel only recommends the right chart for your data and gives you a visual presentation in just a few clicks.

Click the Charts tab, move across the recommended charts to see which one looks best for your data, and then click the one that you want. Learn about other ways to create a chart.

Select a range of data, such as A1:L5 multiple rows and columns or C1:C80 a single column. The range can include titles that you created to identify columns or rows.

Click to perform an ascending sort A to Z or smallest number to largest. Click to perform a descending sort Z to A or largest number to smallest. In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically ascending or descending that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers.

For more information about how to sort data, see Sort data in a range or table. Click the arrow in the column header to display a list in which you can make filter choices. To select by values, in the list, clear the Select All check box.

This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results. For more information about how to filter data, see Filter data in a range or table. Under Save As , pick where to save your workbook, and then browse to a folder. Preview the pages by clicking the Next Page and Previous Page arrows.

The preview window displays the pages in black and white or in color, depending on your printer settings. On the File tab, choose Options , and then choose the Add-Ins category. Near the bottom of the Excel Options dialog box, make sure that Excel Add-ins is selected in the Manage box, and then click Go. In the Add-Ins dialog box, select the check boxes the add-ins that you want to use, and then click OK.

If Excel displays a message that states it can’t run this add-in and prompts you to install it, click Yes to install the add-ins. For more information about how to use add-ins, see Add or remove add-ins. Excel allows you to apply built-in templates, to apply your own custom templates, and to search from a variety of templates on Office. For more information about how to find and apply templates, see Download free, pre-built templates.

Get started. Click File , and then click New.

❿