What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
XY Chart
Line Chart
Pie Chart
Column Chart
Correct Answer :
C. Pie Chart
Related Questions
What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
The auto calculate feature
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
Which is not the function of Edit, Clear command?
Delete contents
Delete notes
Delete cells
Delete formats
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
Which of the following is not an example of a value?
350
May 10, 2001
0.57
Serial Number 50771
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Which of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
Which command will you choose to convert a column of data into row?
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
Which key do you press to check spelling?
F3
F5
F7
F9
Which tool you will use to join some cells and place the content at the middle of joined cell?
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Which of the following action removes a sheet from workbook?
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above