In MS Excel, to create a formula, you can use:...? Mcqs

PPSC Past Papers

Latest MCQs

In MS Excel, to create a formula, you can use:...?

(A) Values but not cell references
(B) Cell references but not values

(C) Values or cell references although notboth at the same time
(D) Both value and cell references

Comments
Latest MCQs

which of these keys are used in ms excel to copy formulas from the above cell...?

(A) ctrl +
(B) ctrl +;

(C) ctrl +:
(D) ctrl +'

Comments
Latest MCQs

In MS-Excel, when the formula bar is activated, we can see:...?

(A) Enter Button
(B) Cancel Button

(C) Edit Formula Button
(D) None of these

Comments
Latest MCQs

Which symbol is used to execute formulas in MS Excel...?

(A) :
(B) =

(C) #
(D) ~

Comments
Latest MCQs

These In MS Excela formula that looks for a s for a value in Teft most column of a fable and then returns a value in the same row for specific column:...?

(A) Horizontal Lookup
(B) Vertical Lookup

(C) Average
(D) None of these

Comments
Latest MCQs

To create a formula you first...?

(A) select the cell you want to place the formula into
(B) Type the equals sign (=) to tell Excel that you’re about to enter a formula

(C) Enter the formula using any input values and the appropriate mathematical.
(D) Choose the new command from the file menu

Comments
Latest MCQs

In MS Excel, a formula that looks for a value in the leftmost column of a table and then returns a value in the same row for a specific column is called:...?

(A) Horizontal Lookup
(B) Vertical Lookup

(C) Average
(D) None of these

Comments
Latest MCQs

In which product of MS Office we can use formulas...?

(A) MS Excel
(B) MS Word

(C) MS PowerPoint
(D) None of these

Comments
Latest MCQs

Which of these keys are used in Ms Excel to copy formula from above cell...?

(A) Ctrl+ ”
(B) Ctrl+ ;

(C) Ctrl+ :
(D) Ctrl+ ‘

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link