Which of the following methods cannot be used to enter data in a cell
Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
Correct Answer :
C. Pressing the Esc key
Related Questions
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
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
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
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
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Which of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
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 menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
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
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
Excel files have a default extension of
Xls
Xlw
Wk1
123
When you want to insert a blank imbedded excel object in a word document you can
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
Which tool you will use to join some cells and place the content at the middle of joined cell?
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
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
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
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Which is not the function of Edit, Clear command?
Delete contents
Delete notes
Delete cells
Delete formats
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
The Name box on to the left of formula bar
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
How can you find specific information in a list?
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
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
The active cell:
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B