Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Question

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

A. Square

D. Divide

Correct Answer :

D. Divide

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

Edit >> Delete command

Discuss this answer

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

Discuss this answer

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Discuss this answer

Which of the cell pointer indicate that you can move the content to other cell?

Discuss this answer

Which Chart can be created in Excel?

A. Area

B. Line

C. Pie

Discuss this answer

When a range is selected, how can you activate the previous cell?

Discuss this answer

Excel uniquely identifies cells within a worksheet with a cell name

Discuss this answer

Which menu option can be used to split windows into two?

Discuss this answer

To edit in an embedded excel worksheet object in a word document

Discuss this answer

Documentation should include

Discuss this answer

The Name box on to the left of formula bar

Discuss this answer

The short cut key Ctrl + R is used in Excel to

Discuss this answer

How do you insert a row?

Discuss this answer

Getting data from a cell located in a different sheet is called ......

Discuss this answer

An Excel Workbook is a collection of .......

C. Charts

Discuss this answer

When you insert an excel file into a word document. The data are

B. Linked

Discuss this answer

Ctrl + D shortcut key in Excel will

Discuss this answer

Which menu option can be sued to split windows into two

Discuss this answer

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

Discuss this answer

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

Discuss this answer

When integrating word and excel, word is usually the

A. Server

C. Client

Discuss this answer

Comments can be added to cells using

Discuss this answer

A circular reference is

Discuss this answer

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

A. server

B. source

C. client

D. none

Discuss this answer

Which of the following options is not located in the Page Setup dialog box?

Discuss this answer

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

Discuss this answer

When a row of data is to be converted into columns

Discuss this answer

Which of the following is not a way to complete a cell entry?

Discuss this answer

Which of the following series type is not valid for Fill Series dialog box?

A. Linear

B. Growth

D. Time

Discuss this answer

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?

Discuss this answer

Answer 1

B. Percentage

Answer 2

C. Goal Seek

Answer 3

A. Deletes the content of a cell

Answer 4

B. Deletes Formats of cell

Answer 5

C. Deletes the comment of cell

Answer 6

D. Deletes selected cells

Answer 7

D. none of above

Answer 8

A. Option buttons

Answer 9

B. List boxes

Answer 10

C. Text boxes

Answer 11

D. Combo boxes

Answer 12

A. Doctors symbol (Big Plus)

Answer 13

B. small thin plus icon

Answer 14

C. Mouse Pointer with anchor at the tip

Answer 15

D. None of above

Answer 16

D. All of the above

Answer 17

A. Press the Alt key

Answer 18

B. Press Tab

Answer 19

C. Press Enter

Answer 20

D. None of above

Answer 21

A. Cell names

Answer 22

B. Column numbers and row letters

Answer 23

C. Column letters and row numbers

Answer 24

D. Cell locator coordinates

Answer 25

A. Format -> Window

Answer 26

B. View -> Window-> Split

Answer 27

C. Window -> Split

Answer 28

D. View > Split

Answer 29

A. Use the excel menu bar and toolbars inside the word application

Answer 30

B. Edit the hyperlink

Answer 31

C. Edit the data in a excel source application

Answer 32

D. Use the word menu bar and toolbars

Answer 33

A. Destination and users of the output data

Answer 34

B. Source of input data

Answer 35

C. Information on the purpose of the workbook

Answer 36

D. All of the above

Answer 37

A. shows the name of workbook currently working on

Answer 38

B. shows the name of worksheet currently working on

Answer 39

C. shows the name of cell or range currently working on

Answer 40

D. None of above

Answer 41

A. Right align the content of cell

Answer 42

B. Remove the cell contents of selected cells

Answer 43

C. Fill the selection with active cells to the right

Answer 44

D. None of above

Answer 45

A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

Answer 46

B. Select the row heading where you want to insert the new row and select Edit >Row from the menu

Answer 47

C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

Answer 48

D. All of the above

Answer 49

A. Accessing

Answer 50

B. Referencing

Answer 51

C. Updating

Answer 52

D. Functioning

Answer 53

A. Workbooks

Answer 54

B. Worksheets

Answer 55

D. Worksheets and Charts

Answer 56

A. Hyperlinked placed in a word table

Answer 57

C. Embedded

Answer 58

D. Use the word menu bar and toolbars

Answer 59

A. Open the font dialog box

Answer 60

B. Apply double underline for the active cell

Answer 61

C. Fill down in the selection

Answer 62

D. None of above

Answer 63

A. Format > window

Answer 64

B. View > window > split

Answer 65

C. Window > split

Answer 66

D. View > split

Answer 67

A. work sheet

Answer 68

B. chart sheet

Answer 69

C. module sheet

Answer 70

D. data sheet

Answer 71

B. Destination

Answer 72

D. Both b and c

Answer 73

A. Edit > Comments

Answer 74

B. Insert > Comments

Answer 75

C. File > Comments

Answer 76

D. View > Comments

Answer 77

A. Geometric modeling tool

Answer 78

B. A cell that points to a drawing object

Answer 79

C. A formula that either directly or indirectly depends on itself

Answer 80

D. Always erroneous

Answer 81

A. Page Break Preview

Answer 82

B. Page Orientation

Answer 83

C. Margins

Answer 84

D. Headers and Footers

Answer 85

A. Copy the cells in row, select the same number of cells in row and paste

Answer 86

B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

Answer 87

C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK

Answer 88

D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

Answer 89

A. Pressing enter

Answer 90

B. Pressing any arrow key on the keyboard

Answer 91

C. Clicking the Enter button on the Formula bar

Answer 92

D. Pressing spacebar

Answer 93

C. Autofill

Answer 94

A. Custom List

Answer 95

B. Auto Fill Options

Answer 96

C. Fill Across Worksheet

Answer 97

D. Fill Series

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Edit >> Delete command

How many worksheets can a workbook have?

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Which of the cell pointer indicate that you can move the content to other cell?

Which Chart can be created in Excel?

When a range is selected, how can you activate the previous cell?

Excel uniquely identifies cells within a worksheet with a cell name

Which menu option can be used to split windows into two?

To edit in an embedded excel worksheet object in a word document

Documentation should include

The Name box on to the left of formula bar

The short cut key Ctrl + R is used in Excel to

How do you insert a row?

Getting data from a cell located in a different sheet is called ......

An Excel Workbook is a collection of .......

When you insert an excel file into a word document. The data are

Ctrl + D shortcut key in Excel will

Which menu option can be sued to split windows into two

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

When integrating word and excel, word is usually the

Comments can be added to cells using

A circular reference is

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

Which of the following options is not located in the Page Setup dialog box?

Which symbol must all formula begin with?

When a row of data is to be converted into columns

Which of the following is not a way to complete a cell entry?

Which of the following series type is not valid for Fill Series dialog box?

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?

Also checkout