Excel Exam Sample

A green triangle will appear beside a cell if the cell is a ‘text format’ while it contains numbers.

• True

• False

The user can be prevented from creating a layout or a macro, moving or copying worksheets, or making any modifications, whether deleting or adding.

• True

• False

You can change the values or the cells content from horizontal to vertical using paste special.

• True

• False

The NOW function returns the serial number for the current date.

• True

• False

Using a cell reference instead of dealing with the cell value directly in the formula allows the formula to automatically update its result by updating the cell value.

• True

• False

Excel allows merging more than one worksheet, and thus calculations can be performed across these sheets.

• True

• False

To move the chart to a new sheet or another file, choose 'move chart' from the 'Design' tab.

• True

• False

You can control the content of a cell through ...

You can control the content of a cell through ...

You can modify the formatting of cell content through ... tab.