In MS Excel, which of the following can be used to copy the value of a cell to another where the value of the source cell was derived through a formula?

A Copy, Value
B Paste, Value
C Copy, Paste Special, Value
D Copy, paste, value

Correct Answer: Copy, Paste Special, Value

In Ms Excel, Copy, Paste special, value can be used to only the value of a cell to another where the value of the source cell was derived through a formula.
Bissoy MCQ
#Computer and Information Technology #United Commercial Bank Ltd (UCB) #United Commercial Bank Ltd - Probationary Officer - 17.02.2017

Related Questions

In MS Excel, which of the following can be used to copy only the value of a cell to another where the value of the source cell was derived through a formula?
A Copy, Value
B Paste, Value
C Copy, Paste Special, Value
D Copy, Paste Value
At a photocopy center , the first 10 copies cost x taka each. Each of the next 50 copies costs 2 taka less per copy . From the 61 st copy on, the cost 1 Taka per copy, In terms of x how much does it cost in. Taka to have 200 copies made/
A 10x+240
B 50x-10
C 50(x-5)
D 60x+140
Suppose the value of cell E5 in MS-Excel sheetis 3500. If we apply the formula = IF ( E5 20000,E5 * 10%, E5 * 20%) , what will be the result ?
A 700
B 350
C 3500
D 500
Suppose the value of cell E5 in MS-Excel sheet is 3500. If we apply the formula =IF(E520000,E5*10%,ES*20%), what will be the result ?
A 350
B 3500
C 700
D 500
A machine can copy six pages in 9 seconds. How many pages can it copy in 24 minutes?
A 12
B 16
C 36
D 960
Which of the following is the excel formula for adding five numbers placed in cell c1 to c5?
A = ADD(C1:C5)'
B Total (c1+c2+c3+c5) '
C =SUM(c1: c5) '
D None of these
which of the following is the excel formula for adding two number placed in cell c4 and c5 ?
A '=SUM(C4 : C 5) '
B =ADD(C4 : C 5 ) '
C Total (C4 + C5)
D None of these
In order to tell Excel that we are entering a formula in cell, we must begin with an operator such as -
A =
B $
C @
D #
In order to tell Excel that we are entering a formula in cell, we must begin with an operator such as-
A $
B =
C @
D #
One copy machine can make 20 copies a minute , and a second copy machine makes 15 copies a minute. If the two copiers work together, how long would it take them to make 2100 copies?
A 60 minutes
B 105 minutes
C 122 minutes
D 140 minutes

Next steps