Revision ch1 and 2
Fill in the blanks
• An absolute reference is designated in a formula by addition of the ..sign.
• The .function helps in finding the maximum
number in a range of values.
• There are two basic ways to perform calculations
in excel...and .. • Any number raised to the power 0 means...
• The two states of binary values are..for on state
and .for off state.
Answer the following questions.
• Name all the number systems supported by
computer system architecture.
• What are the criteria to determine the value of
each digit in a number. • What are the characteristics of decimal number
system
• Differentiate between count and countA functions
of excel.
• Differentiate between formula and function.
• Write an example to demonstrate average
function.
• Write an example to demonstrate max func
Answers
Answer:
An absolute reference is designated in a formula by addition of the ..sign.
• The .function helps in finding the maximum
number in a range of values.
• There are two basic ways to perform calculations
in excel...and .. • Any number raised to the power 0 means...
• The two states of binary values are..for on state
and .for off state.
Answer the following questions.
• Name all the number systems supported by
computer system architecture.
• What are the criteria to determine the value of
each digit in a number. • What are the characteristics of decimal number
system
• Differentiate between count and countA functions
of excel.
• Differentiate between formula and function.
• Write an example to demonstrate average
function.
• Write an example to demonstrate max func