About Microsoft Excel 2013 Assessment Test Microsoft Excel 2013 is designed in such a way to help you give professional-looking results quickly. Our Microsoft Excel 2013 test helps recruiters and hiring managers to effectively assess the Microsoft Excel 2013 skills of a candidate before an interview. Microsoft Excel 2013: Illustrated Introductory Reding, Elizabeth, Wermers, Lynn on Amazon.com.FREE. shipping on qualifying offers. Microsoft Excel 2013: Illustrated Introductory. Launching Excel 2013 Excel can be started either by selecting the program from the Windows start menu, or if there is an existing Excel shortcut available on your computer, it can be double-clicked to launch the program Open Excel by going through these steps: 1. Click the Start button 2. Select All Programs 3. Select Microsoft Office 4.
Introduction Microsoft Excel is a powerful electronic spreadsheet program you can use to automate accounting work, organize data, and perform a wide variety tasks.of Excel is designed to perform calculations, analyze information, and visualize data in a spreadsheet. Also this application includes database and charting features. Microsoft Excel 2013, Introductory. Expertly curated help for Microsoft Excel 2013, Introductory. Plus easy-to-understand solutions written by experts for thousands of other textbooks.You will get your 1st month of Bartleby for FREE when you bundle with these textbooks where solutions are available ($9.99 if sold separately.).
Home > Sample chapters > Microsoft Office > Excel
In this chapter from Microsoft Excel 2013 Step By Step, you’ll create a chart and customize its elements, find trends in your data, create a dual-axis chart, summarize data by using sparklines, create diagrams by using SmartArt, and create shapes that contain mathematical equations.
Chapter at a glance
![]()
Charts
Customizing the appearance of charts
Trendlines
Finding trends in your data
Diagrams
Creating diagrams by using SmartArt
Shapes
IN THIS CHAPTER, YOU WILL LEARN HOW TO
When you enter data into a Microsoft Excel 2013 worksheet, you create a record of important events, whether they are individual sales, sales for an hour of a day, or the price of a product. However, a list of values in cells can’t communicate easily the overall trends in the data. The best way to communicate trends in a large collection of data is by creating a chart, which summarizes data visually. In addition to the standard charts, with Excel 2013, you can create compact charts called sparklines, which summarize a data series by using a graph contained within a single cell.
You have a great deal of control over your charts’ appearance—you can change the color of any chart element, choose a different chart type to better summarize the underlying data, and change the display properties of text and numbers in a chart. If the data in the worksheet used to create a chart represents a progression through time, such as sales over several months, you can have Excel extrapolate future sales and add a trendline to the graph that represents that prediction.
In this chapter, you’ll create a chart and customize its elements, find trends in your data, create a dual-axis chart, summarize data by using sparklines, create diagrams by using SmartArt, and create shapes that contain mathematical equations.
Creating charts
With Excel 2013, you can create charts quickly by using the Quick Analysis Lens, which displays recommended charts to summarize your data. To display recommended charts, select the entire data range you want to chart, click the Quick Analysis button, and then click Charts to display the types of charts that Excel recommends.
You can display a live preview of each recommended chart by pointing to the icon that represents that chart. Clicking the icon adds the chart to your worksheet.
If the chart you want to create doesn’t appear in the Recommended Charts gallery, select the data that you want to summarize visually and then, on the Insert tab, in the Charts group, click the type of chart that you want to create to have Excel display the available chart subtypes. When you point to a subtype, Excel displays a live preview of what the chart will look like if you click that subtype.
When you click a chart subtype, Excel creates the chart by using the default layout and color scheme defined in your workbook’s theme.
If Excel doesn’t plot your data the way that you want it to appear, you can change the axis on which Excel plots a data column. The most common reason for incorrect data plotting is that the column to be plotted on the horizontal axis contains numerical data instead of textual data. For example, if your data includes a Year column and a Maintenance column, instead of plotting maintenance data for each consecutive year along the horizontal axis, Excel plots both of those columns in the body of the chart and creates a sequential series to provide values for the horizontal axis.
You can change which data Excel applies to the vertical axis (also known as the y-axis) and the horizontal axis (also known as the x-axis). To make that change, select the chart and then, on the Design tab, in the Data group, click Select Data to open the Select Data Source dialog box.
As shown in the preceding graphic, the Year column doesn’t belong in the Legend Entries (Series) pane, which corresponds to a column chart’s vertical axis. Note ify notes 1 41 download free. To remove a column from an axis, select the column’s name, and then click Remove. To add the column to the Horizontal (Category) Axis Labels pane, click that pane’s Edit button to display the Axis Labels dialog box, which you can use to select a range of cells on a worksheet to provide values for an axis.
In the Axis Labels dialog box, click the Collapse Dialog button at the right edge of the Axis Label Range field, select the cells to provide the values for the horizontal axis (not including the column header, if any), click the Expand Dialog button, and then click OK. Click OK again to close the Select Data Source dialog box and revise your chart.
After you create your chart, you can change its size to reflect whether the chart should dominate its worksheet or take on a role as another informative element on the worksheet. For example, Gary Schare, the chief executive officer of Consolidated Messenger, could create a workbook that summarizes the performance of each of his company’s business units. In that case, he would display the chart and data for each business unit on the same worksheet, so he would want to make his charts small.
To resize a chart, select the chart, and then drag one of the handles on the chart’s edges. By using the handles in the middle of the edges, you can resize the chart in one direction. When you drag a handle on the left or right edge, the chart gets narrower or wider, whereas when you drag the handles on the chart’s top and bottom edges, the chart gets shorter or taller. You can drag a corner handle to change the chart’s height and width at the same time; and you can hold down the Shift key as you drag the corner handle to change the chart’s size without changing its proportions.
Just as you can control a chart’s size, you can also control its location. To move a chart within a worksheet, drag the chart to the desired location. If you want to move the chart to a new worksheet, click the chart and then, on the Design tool tab, in the Location group, click Move Chart to open the Move Chart dialog box.
To move the chart to a new chart sheet, click New Sheet and enter the new sheet’s name in the accompanying field. Acon digital acoustica 7 1 8. Clicking New Sheet creates a chart sheet that contains only your chart. You can still resize the chart on that sheet, but when Excel creates the new chart sheet, the chart takes up the full sheet.
To move the chart to an existing worksheet, click Object In and then, in the Object In list, click the worksheet to which you want to move the chart.
In this exercise, you’ll create a chart, change how the chart plots your data, move your chart within a worksheet, and move your chart to its own chart sheet.
Intro To Excel 2013 Product
Intro To Excel 2010
Page 1 of 8Next
This chapter is from the bookRelated resources
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2021
Categories |