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
Correct Answer :
B. Click the column heading letter
Related Questions
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 many characters can be typed in a single cell in Excel?
256
1024
32000
65535
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 area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
It is acceptable to let long text flow into adjacent cells on a worksheet when
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
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
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
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 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
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
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
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
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
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
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 row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
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
In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
How many worksheets can a workbook have?
3
8
255
none of above
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above