Grade 10 2nd term Quiz Review

Microsoft __________ enables users to format, organize, and calculate data in a spreadsheet.

• Word

• Excel

• PowerPoint

• Small Basic

In any spreadsheet, each row is labeled by __________.

• letters

• numbers

• letters and numbers

• symbols

In any spreadsheet, each cell is labeled by __________.

• letters

• numbers

• letters and numbers

• symbols

The default date format in Microsoft Excel is ___________.

• MM/DD/YY

• DD/MM/YY

• YY/MM/DD

• MM/YY/DD

To insert today’s date automatically in Excel, we use the _______ function.

• Year()

• Sum()

• Day()

• Today()

The _______ formula is used when a condition is to be evaluated.

• FOR

• IF

• SUM

• Average

The condition must always compare a cell address to a _________ value.

• numerical

• alphabetical

• numerical and alphabetical

• symbol

In Excel, we can perform mathematical operations with functions.

• True

• False

In any if statement, we can join more than one condition using AND or OR.

• True

• False

In Excel, we can not merge more than one cell.

• True

• False