You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Correct Answer :
D. All of the above
Related Questions
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
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
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
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
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
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
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
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
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
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
Which of the cell pointer indicates that you can fill series?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
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
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
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
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
How many worksheets can a workbook have?
3
8
255
none of above
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
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
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )