Q.A. Answer The following question.
1) Write note-
a) Constant and variables.
b) If-then else statement.
c) Write the common chart types.
d) Work sheet and its component's.
e) Itself with end if statement.
Answers
Answer:
A. A constant does not change its value and it remains the same forever. A variable, on the other hand, changes its value from time to time depending on the equation.
Answer:
(a)Constant is a value that cannot be altered by the program during normal execution, i.e., the value is constant. ... This is contrasted with a variable, which is an identifier with a value that can be changed during normal execution, i.e., the value is variable.
(b)The If...Then... Else statement allows conditional execution based on the evaluation of an expression. ... The thenpart is executed if condition is true; if condition is false, then elsepart is executed. If the Else clause is not present, control passes to the next statement in the program.
(3)Common Data Chart Types:
Clustered Bar Chart. Clustered or grouped bar charts are similar to stacked bar graphs in that they let you show subcategories in addition to regular categories:
on your chart. ...
Histogram. ...
Line Graph. ...
Pie Chart. ...
Area Charts.
(4) Components of a WorkSheet
Active cell.
Column heading.
Formula bar.
Name box.
mouse pointer.
Row heading.
Sheet tabs.
Task Pane.
(5)An IF statement is executed based on the occurrence of a certain condition. IF statements must begin with the keyword IF and terminate with the keyword END. Components within IF statements can be connected with the keywords AND or OR.