Which of the following is the latest version of Excel
Excel 2000
Excel 2002
Excel ME
Excel XP
Correct Answer :
D. Excel XP
Related Questions
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
The Chart wizard term data categories refers to;
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
A numeric value can be treated as a label value if it precedes with
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Concatenation of text can be done using
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
Which of the following is not the correct method of editing the cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
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
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
Which of the following is not true about Find and Replace in Excel
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
You can move a sheet from one workbook into new book by
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above