A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
Answer : C
Free Online Test
View More Related Question
1) The Chart wizard term data categories refers to;
A chart plot area
A horizontal axis
The organization of individual values with a chart’s data series
The data range that supply chart data
View Answer
2) Which area in an Excel window allows entering values and formulas?
3) When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
View Answer
4) To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
View Answer
5) To remove the content of selected cells you must issue ______ command
