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
Correct Answer :
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Related Questions
Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
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 Chart can be created in Excel?
Area
Line
Pie
All of the above
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All 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
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
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
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
You can copy data or formulas
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All 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
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
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
A typical worksheet has …. Number of columns
128
256
512
1024
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
The Chart wizard term data categories refers to;
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
How can you delete a record?
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar