Exploring Spreadsheets Quiz

The Formula bar shows the result of a Formula.

• True

• False

When writing a cell address, we write the row heading and then column heading.

• True

• False

The Function MAX is used to find the highest value in a range.

• True

• False

The AUTOSUM feature calculates the lowest value in the list.

• True

• False

It is not important to type '=' before a formula of a function.

• True

• False

The ________________chart is called the Column chart in MS-Excel.

• Pie chart

• Tally chart

• Bar chart

• Pictogram

The ____________helps you to access commands quickly no matter which tab you are in.

• File tab

• Ribbon

• Menu

• Quick Access Toolbar

The _____________tab has options to Open, Save and Print a worksheet.

• File

• Home

• View

• Insert

The______________ Function is used to find the minimum value in a range of cells.

• MIN

• MAX

• AUTOSUM

• AVG

Write the difference between Formula and Function in MS-Excel.