ECDL Excel

A workbook is a file that contains pictures.

• True
• False

Which function should be used to calculate the smallest number in a range of cells?

• max
• sum
• avg
• min

Which is the correct formula to add cells A1 to A5?

• =SUM(A2+A5)
• =SUM(A1:A5)
• =A1+A2+A3
• =SUM(A1:A4)

What is a function?

• sum
• average
• minimum and maximum
• all of the choices are functions

What symbol prepares a cell for the entry of a formula?

• +
• -
• /
• =

Which function should be used to find the highest value in a range of cells?

• max
• sum
• min
• avg

This instructs the software to perform a calculation

• label
• function
• formula
• value

Which is an example of a cell reference?

• A1
• CD
• 7D
• 77

What are cells (in a spreadsheet)?

• individual locations in a spreadsheet
• individual locations in a jail
• individual locations in a classroom
• individual locations in a document

This is used to align multi-line text within a cell...

• merge cells
• wrap text
• column width
• text size