Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Correct Answer :
C. Window > split
Related Questions
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
You can edit a cell by
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
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
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
To edit in an embedded excel worksheet object in a word document
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars
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
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
Documentation should include
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
Which of the following is invalid statement?
Sheet tabs can be colored
Some picture can be applied as a background of a sheet
You can set the column width automatically fit the amount of text
The width of a row and be specified manually or fit automatically
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
Which symbol must all formula begin with?
=
+
(
@
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
To center worksheet titles across a range of cells, you must
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Square
Percentage
Goal Seek
Divide
A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1