Computer Skills 1: Basic Formulas
and Functions Questions with Verified
Answers
Formula - ANSWERSAn equation that is entered in a cell.
Define Function - ANSWERSA function is a predefined formula that performs a
calculation based on values that are entered in the function.
Why do formulas make spreadsheets more powerful? - ANSWERSFormulas allow you
to calculate additional information that helps analyze already existing data.
Describe the three parts of a function - ANSWERSEqual sign: The equal sign must be
the first character in the cell. It tells the spreadsheet a calculation is to be performed.
Function name: Indicates the operation to be performed, such as sum.
Arguments: Contains the information you want to use in the function's calculation.
Arguments can refer to both individual cells and cell ranges. Depending on the function,
it can include one argument or multiple arguments.
Describe the three parts of a formula - ANSWERSEqual sign: must be the first character
in the cell. It tells the spreadsheet a calculation is to be performed.
Operand: values or data used in the formula's calculation.
Operator: indicates the type of calculation to be done.
Describe each of the following functions - ANSWERSa. SUM: Adds all the values in a
range of cells.
b. AVERAGE: Calculate the average of the values in a range of cells by summing the
cells and dividing by the number of cells used to find the sum.
c. COUNT: Counts the cells with numerical values in a range of cells.
d. MAX: Finds the largest value included in a range of cells.
e. MIN: Finds the smallest value included in a range of cells.
Define the following operators: +,-,*, and / - ANSWERSA + is for addition
A - is for subtraction
A * is for multiplication
A / is for division
and Functions Questions with Verified
Answers
Formula - ANSWERSAn equation that is entered in a cell.
Define Function - ANSWERSA function is a predefined formula that performs a
calculation based on values that are entered in the function.
Why do formulas make spreadsheets more powerful? - ANSWERSFormulas allow you
to calculate additional information that helps analyze already existing data.
Describe the three parts of a function - ANSWERSEqual sign: The equal sign must be
the first character in the cell. It tells the spreadsheet a calculation is to be performed.
Function name: Indicates the operation to be performed, such as sum.
Arguments: Contains the information you want to use in the function's calculation.
Arguments can refer to both individual cells and cell ranges. Depending on the function,
it can include one argument or multiple arguments.
Describe the three parts of a formula - ANSWERSEqual sign: must be the first character
in the cell. It tells the spreadsheet a calculation is to be performed.
Operand: values or data used in the formula's calculation.
Operator: indicates the type of calculation to be done.
Describe each of the following functions - ANSWERSa. SUM: Adds all the values in a
range of cells.
b. AVERAGE: Calculate the average of the values in a range of cells by summing the
cells and dividing by the number of cells used to find the sum.
c. COUNT: Counts the cells with numerical values in a range of cells.
d. MAX: Finds the largest value included in a range of cells.
e. MIN: Finds the smallest value included in a range of cells.
Define the following operators: +,-,*, and / - ANSWERSA + is for addition
A - is for subtraction
A * is for multiplication
A / is for division
