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
Correct Answer :
D. data sheet
Related Questions
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
The command Edit >> Fill Across Worksheet is active only when
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Which key do you press to check spelling?
F3
F5
F7
F9
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
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
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 of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
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
Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
How many worksheets can a workbook have?
3
8
255
none of above
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
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
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0