MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Correct Answer :
A. WINDOWS
Related Questions
Which of the following is the latest version of Excel
Excel 2000
Excel 2002
Excel ME
Excel XP
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
work sheet
chart sheet
module sheet
data sheet
The autofill feature
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
Concatenation of text can be done using
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
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
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Which of the following is not true regarding Conditional Formatting?
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
Which of the cell pointer indicate that you can move the content to other cell?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
How do you insert a row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
When you insert an excel file into a word document. The data are
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
The spelling dialog box can be involved by choosing spelling from ________ menu.
insert
file
tools
view
Right clicking something in Excel:
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
A typical worksheet has …. Number of columns
128
256
512
1024