Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Correct Answer :
C. Fill down in the selection
Related Questions
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
An Excel Workbook is a collection of .......
Workbooks
Worksheets
Charts
Worksheets and Charts
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
The chart wizard term data series refers to
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
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
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
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
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
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
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
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
What will be the output if you format the cell containing 5436.8 as #,##0.00'?
5430
5436.80
5436.8
6.8
A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
How many worksheets can a workbook have?
3
8
255
none of above
Which of the following is not the correct method of editing the cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
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
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
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
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
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
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
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
Concatenation of text can be done using
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&