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

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

1 Answer

Answer :

Charts
by

Related questions

Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Description : Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Last Answer : a) Move to the previous worksheet in the workbook

In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Description : In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Last Answer : a) Ctrl + Page Down

The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Description : The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Last Answer : b) Cell

What kind of documentation is allowed by MS - Excel default worksheet ( .xls) ?

Description : What kind of documentation is allowed by MS - Excel default worksheet ( .xls) ?

Last Answer : MS-Excel allows creation of Worksheet (.xls) documents by default worksheet ( .xls ).

(Visual) In 1971, a king used this artifact as symbol during the celebration of what he called the 2,500th anniversary of the monarchy in his country. He also offered a copy to the UN and claimed that it was the world’s first human rights charter. Historians tend to disagree and believe that it contains no more than the polite formulae by which rulers begin talking to newly acquired subjects. What artifact?

Description : (Visual) In 1971, a king used this artifact as symbol during the celebration of what he called the 2,500th anniversary of the monarchy in his country. He also offered a copy to the UN ... no more than the polite formulae by which rulers begin talking to newly acquired subjects. What artifact?

Last Answer : The Cyrus Cylinder (from Iran).

A chart is a graphical representation of worksheet data. -Technology

Description : A chart is a graphical representation of worksheet data. -Technology

Last Answer : True A chart is a graphical representation of worksheet data.

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

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!

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

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.

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

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

Last 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 ... Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

How can I pull data from one Excel worksheet to another based on matching Part Number?

Description : How can I pull data from one Excel worksheet to another based on matching Part Number?

Last Answer : answer:The Vlookup function is what you seek. Example: Book1 has a list of part numbers 1 2 3 4 5 Book2 has a list of part numbers,with product name 4 tchotchke 2 gizmo 5 trinket 3 thingy 1 doodad ... have to be in any particular order on either sheet. (if you use that FALSE argument at the end).

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

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.

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

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.

In an Excel worksheet does a column typically contain information that is similar to a list?

Description : In an Excel worksheet does a column typically contain information that is similar to a list?

Last Answer : Yes it does, like a field in a database.

The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Description : The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Last Answer : cell

The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These

Description : The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These

Last Answer : b) Visual Basic

Which among the following views in MS-Word can not display graphics: a) Printer Preview b) Page Layout View c) Normal View d) None of The Above

Description : Which among the following views in MS-Word can not display graphics: a) Printer Preview b) Page Layout View c) Normal View d) None of The Above

Last Answer : c) Normal View

Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Description : Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Last Answer : Answer : B

The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Description : The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Last Answer : (C) Visicalc

In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Description : In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Last Answer : a) Ctrl + Shift + Down Arrow Key

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Description : In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Last Answer : c) File

Ms Excel version 5 was launched in: a) 1992 b) 1993 c) 1995 d) None of These

Description : Ms Excel version 5 was launched in: a) 1992 b) 1993 c) 1995 d) None of These

Last Answer : b) 1993

.docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Description : .docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Last Answer : c) MS Word

Slides prepares in: a) MS Word b) MS Power Point c) MS Excel d) None of These

Description : Slides prepares in: a) MS Word b) MS Power Point c) MS Excel d) None of These

Last Answer : a) Data Base Management System

Presentations made on: a) MS Word b) MS Excel c) MS Power Point d) None of These

Description : Presentations made on: a) MS Word b) MS Excel c) MS Power Point d) None of These

Last Answer : c) MS Power Point

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

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

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Description : Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Last Answer : PL/SQL

Is there a way to get a visual representation of wireless networks ?

Description : Is there a way to get a visual representation of wireless networks ?

Last Answer : There used to be an App that would show Wireless connections in the area but i can not remember the name of it, the GUI was a little radar and would Bleep when it found one. But it ... looking for something different as your actually looking for networks, which sounds a bit Black Hat-ish to me

What is a visual representation of a project’s planned activities against a calendar called? a. A Gantt chart. b. A critical path network. c. A product flow diagram. d. A Pareto chart.

Description : What is a visual representation of a project’s planned activities against a calendar called? a. A Gantt chart. b. A critical path network. c. A product flow diagram. d. A Pareto chart.

Last Answer : a. A Gantt chart.

What is a visual representation of a project’s planned activities against a calendar called? a. A Gantt chart. b. A critical path network. c. A product flow diagram. d. A Pareto chart.

Description : What is a visual representation of a project’s planned activities against a calendar called?  a. A Gantt chart.  b. A critical path network.  c. A product flow diagram.  d. A Pareto chart.

Last Answer : a. A Gantt chart.

A better appreciation of variations is always obtained from______ a) energy-production relationships b) visual representation c) business process automation d) both A&C are correct

Description : A better appreciation of variations is always obtained from______ a) energy-production relationships b) visual representation c) business process automation d) both A&C are correct

Last Answer : visual representation

The next stage of monitoring process is to ____ a) study and analyze the data b) obtain a visual representation c) both a & b d) none of the above

Description : The next stage of monitoring process is to ____ a) study and analyze the data b) obtain a visual representation c) both a & b d) none of the above

Last Answer : both a & b

ee star rating label just give _______ representation of the energy consumption levels byshowing star ratings. a. Physical c. Visual b. Both a and c d. None of the above

Description : Bee star rating label just give _______ representation of the energy consumption levels byshowing star ratings. a. Physical c. Visual b. Both a and c d. None of the above

Last Answer : Visual

What provides a visual representation of any waveform applied to the input terminals?

Description : What provides a visual representation of any waveform applied to the input terminals?

Last Answer : cathode ray oscilloscope (CRO)

I'm asking for a raise, can any of you help provide helpful tips/ templates on how to ask for one?

Description : I'm asking for a raise, can any of you help provide helpful tips/ templates on how to ask for one?

Last Answer : answer:This is kind of a broad and open-ended question. At what kind of business are you employed? What is your job title? Are you full-time or part-time? Are you salaried, hourly or on commission ... reviews and salary policies firmly in place? Give me some data and I can give you some advice. SRM

Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Description : Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Last Answer : What kind of results are you looking for ? I.e. what are you comparing between test1 and test2 ? Also, I’m not sure I understand what are ‘value points’ ? And when you say ‘group all the students’ do you mean counts of students that got that level of score on the test?

MS Excel Help: Calculate Amount of Time?

Description : MS Excel Help: Calculate Amount of Time?

Last Answer : If your timestamps are in columns A and B, I'd imagine this would do the trick: =B1-A1 and then make sure to set the cell format to time, showing the difference in minutes and seconds. Just tested with this: timestamp A ... = custom: dd/mm/yyyy hh:mm:ss) =B-A: 0:29:57 (cell format = custom: h:mm:ss)

How do I automatically add the date to a MS Excel cell?

Description : How do I automatically add the date to a MS Excel cell?

Last Answer : You would want a macro, or if you hit Ctrl+; it automatically puts in the current date in the selected cell, and you can add the called left message afterward If you want to do a macro, you can record ... need to edit the macro to work for each line. So it might be easier to use the Ctrl+; shortcut

How to track timings in MS Excel?

Description : How to track timings in MS Excel?

Last Answer : Use a Custom format of ‘hh:mm:ss.000’

How do you apply a linear curve fit in MS Excel?

Description : How do you apply a linear curve fit in MS Excel?

Last Answer : answer:Right click on one of the data points. Add Trendline… Select Linear for Trendline Regression Type Close A linear trend line should appear. (Excel 2010)

I have a MS Excel file with mutliple email adresses, some are dulplicates, is there an easy way to delete the duplicates in Excel?

Description : I have a MS Excel file with mutliple email adresses, some are dulplicates, is there an easy way to delete the duplicates in Excel?

Last Answer : Yes. You’ll need to create filters. In one of the tabs (I think tools) select auto filter. Then you can sort by the column with the email addresses. When you have duplicates, you can highlight and delete the rows you don’t need. Practice on a test file first. Hope this helps.

What does decrease decimal mean in ms excel?

Description : What does decrease decimal mean in ms excel?

Last Answer : It means round the number so that fewer digits after the decimalpoint are shown.

What is listed in a formula autocomplete list MS Excel?

Description : What is listed in a formula autocomplete list MS Excel?

Last Answer : A list of valid functions, names, and text strings that matchthe letters or trigger that you have begun to type. So if you typethe equals sign and then a letter, functions that start with ... letters, that list will shorten down,maintaining the ones that still match what you have typed sofar.

What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Description : What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Last Answer : Need answer

Where can I learn MS Excel for free?

Description : Where can I learn MS Excel for free?

Last Answer : You may learn MS excel for free at this web site "Microsoft Excel Training & Word 2007 Tutorial - Learn Free Office", the site address is: www.free-training-tutorial.com.

In a modern newspaper house editing is done through computers only and the pages are made up on computers using software known as: a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Description : In a modern newspaper house editing is done through computers only and the pages are made up on computers using software known as: a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Last Answer : d) Quark Xpress

Computer software commonly used in a modern newspaper house for editing the copies is known as ---- a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Description : Computer software commonly used in a modern newspaper house for editing the copies is known as ---- a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Last Answer : d) Quark Xpress

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document