Format -> Window
View -> Window-> Split
Window -> Split
View > Split
C. Window -> Split
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
Press the Alt key
Press Tab
Press Enter
None of above
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
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
standard formulas
array formula
complex formulas
smart formula
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
The Alt key
The Tab key
The Enter key
None of the above
Pie chart
Row chart
Line chart
Column chart
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
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
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
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
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
Validation
Formats
Formulas
All of above
3
8
255
none of above
Title bar
Formula bar
Menu bar
Sheet tabs
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
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
Goal seek
Solver
Scenario manager
Auto Outline
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
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
Solver
Goal seek
Scenario Manager
All of above
Delete contents
Delete notes
Delete cells
Delete formats
sheet3!A10
sheet1!A10
Sheet3.A10
A10
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates