1
Q
What is mixed cell reference a combination of?
A
Mixed cell reference is a combination of Relative and Absolute cell reference.
2
Q
What has to be fixed in mixed cell reference with example?
A
In mixed cell reference, either row or column has to be fixed.Example is =$A1+A$2
3
Q
When does a circular reference occur?
A
A circular reference occurs when a formula in a cell refers to its own cell directly or indirectly.
ICT UT-1!✨
flashcards
Decks in class (28)
# Cards
-
Working with formulas!13
-
Using basic formula!5
-
Using compound formula and using a range in a formula!5
-
Using formula on text!4
-
Types of cell references-Relative reference snd Absolute reference!7
-
Mixed reference and circular reference!3
-
Cell reference of another worksheet!3
-
Intro to Excel and selecting cells!5
-
Entering numbers as text!5
-
Entering date and time!5
-
Changing Cell contents9
-
Using Undo and Redo feature7
-
Inserting cells, columns and rows7
-
Deleting cells, columns and rows4
-
Changing row height and column width!3
-
Copying and moving data!10
-
Auto Fill and Flash Fill6
-
Intro to Python!10
-
Components of Python window!8
-
Python programming in Interactive mode!4
-
Using the print() function!4
-
Using IDLE as a calculator4
-
Variables6
-
Working in script mode!3
-
Data types!5
-
input() function6
-
Features of print() function4
-
Introduction to GIMP!✨4
