Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Correct Answer :
D. Ampersand ( & )
Related Questions
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
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
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
What will be the output if you format the cell containing 5436.8 as #,##0.00'?
5430
5436.80
5436.8
6.8
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
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
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
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
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
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
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
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
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
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
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
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
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
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
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
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
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
Which of the following Excel screen components can NOT be turned on or off?
Formula Bar
Status Bar
Tool Bar
None of above
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10