How many types of references are used in Excel:...? Mcqs

Latest MCQs

How many types of references are used in Excel:...?

(A) 3
(B) 4

(C) 5
(D) 6

Comments
Latest MCQs

How many worksheets are there in Excel by default:...?

(A) 01
(B) 03

(C) 05
(D) 07

Comments
Latest MCQs

In MS Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of...?

(A) Absolute refrence
(B) Relative reference

(C) mixed reference
(D) circular reference

Comments
Latest MCQs

Which sign is used to create an absolute cell reference in MS Excel...?

(A) $
(B) @

(C) &
(D) %

Comments
Latest MCQs

If a formula references a cell that contains text instead of a numerical value, what error does Excel display...?

(A) #NUM!
(B) #VALUE!

(C) #REF!
(D) #DIV0

Comments
Latest MCQs

What does the term "filter" refer to in Excel...?

(A) To permanently delete rows or columns
(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria
(D) To create a chart

Comments
Latest MCQs

What does the term “filter” refer to in Excel...?

(A) To permanently delete rows or columns
(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria
(D) To create a chart

Comments

Best of Luck

From ShineGk.com

Share our website's link