How are charts created in Excel? Write the steps. -Technology

1 Answer

Answer :

Creating a Chart:Here is a worksheet that shows the marks of students in a class subject wise. To create a chart, do the following:1. Select the data that you want to show, including the column titles and the row labels.2. Then click the Insert tab and in the Charts group, click the Column button. You could select another chart type, but column charts are commonly used to compare items.3. After you click Column, you’ll see a number of column chart types to choose from. Click Clustered Column, the first column chart in the 2-D Column list.A ScreenTip displays the chart type name when you rest the pointer over any chart type. The ScreenTip also provides a description of the chart type and gives you information about that, when to use each one.If you want to change the chart type after you create your chart, click inside the chart. On the Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

Related questions

Description : Write down the importance of legend in charts. -Technology

Last Answer : With the help of legend, each data series can be uniquely identified by assigning a unique color or pattern.

Description : Displaying dates on a PC using excel 2010 to create charts and graphs?

Last Answer : Never mind. I figured it out. If anyone else needs to know this is how you do it: you must enter the date in a different format. I originally entered the date by writing September 1 etc the computer ... entered 9/1 , 9/5 etc and this resulted in a simple display of the dates I enetered only!

Description : What is a good software package to make VERY quality charts and graphs to submit to academic journals (i.e., better than Microsoft Excel)

Last Answer : If you’re on a mac, iWork ‘09 make some incredibly nice looking charts.

Description : In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views

Last Answer : Charts

Description : For what purpose pie charts are useful? -Technology

Last Answer : Pie charts are useful for the following purposes:1. They convey approximate propositional relationship at a point in time.2. They compare part of a whole at a given point in time.3. Exploded portion of a pie chart emphasizes a small proportion of parts.

Description : What are the various types of charts? Explain each. -Technology

Last Answer : The various types of charts in Excel are given below:Line Chart:Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. Line charts can display continuous data ... data that represents profit over time can be plotted in an area chart to emphasize the total profit.

Description : Which of the following charts is used for comparing the changes in data over a period of time? -Technology

Last Answer : (d) Line chart emphasizes on a rate of change rather than volume of change over time.

Description : Write the steps to design a database. -Technology

Last Answer : Steps to Design a DatabaseThere are various steps to design a database which are as follows:Step 1 Determine the purpose of your database The first step of designing a database is to determine the ... that the database structure meets the goals you needed, add all your existing data to the tables.

Description : Write down the steps to insert a new row into the table. -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1 When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3 When you have finished adding records in the datasheet, save it and close it.

Description : Write the steps to rename and delete a folder. -Technology

Last Answer : Steps to delete a folder(a) Step 1:Locate your folder. ,(b) Step 2:Right click on the folder icon.(c) Step 3: Choose Delete option from the drop down menu.(d) Step 4: A Delete Folder dialog box will ... Recycle Bin? (e) Step 5:Choose Yes.(f) Step 6:The folder is deleted and moved to the Recycle Bin.

Description : Write the steps to make the text bold. -Technology

Last Answer : Steps to make a text bold are as follows:(a) Step 1: Select the text.(b) Step 2: Click the Bold button in the Font group on the Home tab.

Description : Write the steps to create a new document. -Technology

Last Answer : Steps to create a new blank document are as follows:(a) Step 1: Click the Microsoft Office button.(b) Step 2: Select New, the New Document dialog box will appear as shown below:(c) Step 3: ... (It will be highlighted bydefault).(d) Step 4: Click Create button, a new blank document will appear.

Description : Write the steps to compress a picture. -Technology

Last Answer : Steps to compress a picture in a document are as follows:(a) Step 1: Select the picture.(b) Step 2: Click the Picture Tools Format tab.(c) Step 3: Click the Compress Pictures in the ... Compression options: as per the requirement.(g) Step 7: Click OK button in the Compression Settings dialog box.

Description : Which feature is provided by Word to customise the look of a custom shape? Write down the steps involved. -Technology

Last Answer : Drawing Custom ShapesBy using the three freehand drawing tools, i.e. Curve, Freeform and Scribble desired shapes can be created.Curve lets you draw shapes that have different curves. Freeform lets you draw ... your object, to turn off Edit Points, click anywhere on the page outside of the shape.

Description : Write down the steps for Mail Merge operation. -Technology

Last Answer : Sometimes you may need to send similar letter to a large number of people. But, each version of letter is not exactly same so, you may need to sit for hours to draft each letter individually. ... of merging the main text document and the data source which is also refer to as finished documents.

Description : Write the steps of inserting picture in a slide. -Technology

Last Answer : Pictures and ClipArt can be inserted into a Microsoft Office PowerPoint 2007 presentation from sources such as ClipArt Website providers, Web pages or files on a computer. These pictures can be used ... an Office PowerPoint 2007 presentation, switch to Notes view and then do the above same procedure

Description : A sales manager creates a presentation he add the same slide transition to all the slide. Write steps, -Technology

Last Answer : Creating a slides show:Using PowerPoint, a wide range of special effects, such as transition and animation can be added in a presentation to provide visual interest to the presentation and grab ... Transitions to a Slide2. Add Sound to Slide Transitions3. Animating Text and Objects4. Rehearse Timing

Description : What are the different ways in which you can start creating a new presentation? Write steps for each. -Technology

Last Answer : Creating New Presentation:For creating a new presentation in MS-PowerPoint, there are two options available to make a selection of creating new presentation:1. Creating Blank PresentationFor creating a blank presentation, ... name box, enter a new name to save the file.3. Then, click Save button

Description : Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Last Answer : Animating Text and Objects:We can give sound effects or visual effects, including movement to the text or objects in a presentation. Animation can be used to focus on important points, to control the ... to animate the object.Effects appear in the Custom Animation list in the order that you add them

Description : Write the steps to print handouts in PowerPoint presentation. -Technology

Last Answer : Printing Slide Handouts:We have already studied about the handouts view of presentation, it could help the audience in getting idea of your's easily. A presentation can be printed in the form of ... orientation, click the arrow under Orientation and .then click Landscape or Portrait.5. Click Print.

Description : Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. -Technology

Last Answer : An active cell is a cell with heavy black color boundary.

Description : In Excel, how many ways are there to express/format a number? -Technology

Last Answer : Numbers in Excel can be expressed in many different formats like date, time, percentage or decimals.

Description : What is the use of the COUNT() function in Excel? -Technology

Last Answer : Excel’s COUNT() function can be used to total the number of cells in a selected range. The COUNT() function will add up the number of cells in a selected range that contains numbers.

Description : By default, a workbook in Excel contains how many worksheets? -Technology

Last Answer : (b) 3 worksheets are present in every workbook by default.

Description : The simplest way to move data from one location to another in Excel is ……………… -Technology

Last Answer : (d) We can move data using cut and paste and also drag and drop method is the easiest one.

Description : The default page orientation in Excel is (a) Landscape -Technology

Last Answer : (c) The default page orientation in Excel is Portrait.

Description : In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Last Answer : (c) Text displayed at data points to indicate the specific category is called data label.

Description : The sample of an Excel worksheet on the screen can be seen by ……………….. -Technology

Last Answer : (a) Print preview enables you to view the sample of worksheet before printing it on a paper.

Description : For selecting the entire worksheet in Excel, you need to press ………………. -Technology

Last Answer : (b) You need to press Ctrl + Shift + Spacebar for selecting the entire worksheet in Excel.

Description : Excel is a ………………. software package. -Technology

Last Answer : Excel is aspreadsheetsoftware package.

Description : Any formula in Excel starts with an …………….. -Technology

Last Answer : Any formula in Excel starts with anequal (=) sign.

Description : If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Last Answer : If you enter 15 + 30 in a cell, Excel will display15 + 30.

Description : You cannot open two different workbooks in Excel simultaneously. -Technology

Last Answer : False You can open two different workbooks in Excel simultaneously.

Description : If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

Last Answer : False It will be treated as non-numeric data because it contains letters along with numbers.

Description : Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Last Answer : answer:Okay, my answer is gonna get moderated, but this drives me nuts. Every company I've ever worked at, managers all want to use Excel as if it was a word processor. Excel is not a word processor! ... column to become wide), or causing the text to continue to the into the next cell to the right.

Description : What charts (1) the cost to your organization of the unavailability of information and technology and (2) the cost to your organization of recovering from a disaster over time? a. Disaster recovery plan b. Hot site c. Cold site d. Disaster recovery cost curve

Last Answer : d. Disaster recovery cost curve

Description : Can a newer version of Excel read a file created in an older version of Excel correctly?

Last Answer : Should work in newer versions.

Description : What type of file is created by Excel program ?

Last Answer : Worksheet files are created by the Excel program.

Description : Which chart can be created in Excel a. Area b. Line c. Pie d. All of the above

Last Answer : d. All of the above

Description : Which chart can be created in Excel a. Area b. Line c. Pie d. All of the above

Last Answer : d. All of the above

Description : What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Last Answer : b) A 2 dimensional column chart

Description : What are the four steps in debugging? -Technology

Last Answer : The four steps in debugging are as follows:1. Discovering of the bug2. Isolation of the bug3. Finding the bug4. Fixing the bug

Description : What are shortcuts? Explain the steps to create shortcut. -Technology

Last Answer : Steps to Create a ShortcutStep 1:Right click on the desktop or the area where you want to place the shortcut. In the right click menu, point to New and then, select Shortcut.Step 2: The Create ... of the shortcut in the Type a name for this shortcut:' field and finally, click Finish button.

Description : What are the steps to insert a readymade shape in a document? (a) I. Select the Insert tab. -Technology

Last Answer : (a) I. Select the Insert tab.II. In the Illustrations group, click on Shapes and select desired shape.III. Click and hold the mouse, where you want to draw the shape and drag the mouse pointer keeping the mouse pressed.IV. Release the mouse button.

Description : Why should different steps of library classification be followed while classifying a document? -Technology

Last Answer : These steps provide the tool to translate the titles into specific notationTo identify specific subject of the content of the materialTo assign appropriate class number

Description : What steps should Shikha perform to enlarge the image of the Medical prescription of her -Technology

Last Answer : Step 1: Click on Image-> Scale Image Step 2: Set the required width and height and click on scale.

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

Description : A relationship cannot be created with the help of a table. -Technology

Last Answer : False A relationship is a connection between two tables of data.

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

Description : The small area network created around a bluetooth device is called ………….. -Technology

Last Answer : The small area network created around a bluetooth device is calledPAN (Personal Area Network).