Computers Final
Exam: MICROSOFT
EXCEL (SPREADSHEET)
QUESTIONS AND
ANSWERS
The program we use in class to make a spreadsheet: - answer
Microsoft Office Excel
A spreadsheet would mlst likely be used to: - answer Perform
calculations
An example of a formula that adds a column of numbers: - answer
=SUM(A1:A15)
An example of a formula that subtracts numbers that are in two
different columns: - answer =C5-D5
An example of a function in a formula is: - answer AVERAGE
An example of a range of cells: - answer A1:A15
An example of a formula for multiplying numbers that are in two
columns: - answer =B4*F4
Exam: MICROSOFT
EXCEL (SPREADSHEET)
QUESTIONS AND
ANSWERS
The program we use in class to make a spreadsheet: - answer
Microsoft Office Excel
A spreadsheet would mlst likely be used to: - answer Perform
calculations
An example of a formula that adds a column of numbers: - answer
=SUM(A1:A15)
An example of a formula that subtracts numbers that are in two
different columns: - answer =C5-D5
An example of a function in a formula is: - answer AVERAGE
An example of a range of cells: - answer A1:A15
An example of a formula for multiplying numbers that are in two
columns: - answer =B4*F4