Formatting Cells, Microsoft Excel

Formatting Cells

Question: How to create series of cells in a row to column?
A
Format

B
Formula

C
Transpose

D
Paste

Note: Not available
1. Report
Question: “=a1*a15”is a ……………in MS Excel
A
Formula

B
Function

C
Both of above

D
None of above

Note: Not available
1. Report
Question: When a range is selected, how can you activate the previous cell?
A
Press the Alt key

B
Press Tab

C
Press Enter

D
None of above

Note: Not available
1. Report
Question: You can set Page Border in Excel from
A
From Border tab in Format Cells dialog box

B
From Border tool in Formatting toolbar

C
From Line Style tool in Drawing toolbar

D
You cannot set page border in Excel

Note: Not available
1. Report
Question: How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A
F8

B
F9

C
F10

D
F11

Note: Not available
1. Report
Question: Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?
A
Work sheet

B
Chart sheet

C
Macro sheet

D
Data sheet

Note: Not available
1. Report
Question: Long text can be broken down into many lines within a cell. You can do this through
A
Wrap Text in Format > Cells

B
Justify in Edit > Cells

C
Text Wrapping in Format > Cells

D
All of above

Note: Not available
1. Report

Question: How to create series of cells in a row to column?