To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Correct Answer :
D. None of the above
Related Questions
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
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
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 setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
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
The short cut key Ctrl + R is used in Excel to
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
To create a formula, you can use:
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
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
It is acceptable to let long text flow into adjacent cells on a worksheet when
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
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
To view a cell comment
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
How many worksheets can a workbook have?
3
8
255
none of above
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
Hyperlinks can be
Text
Drawing objects
Pictures
All 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
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
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