Excel & It Fundamentals Post Test

If pound symbols (###) appear in a cell, it means that the numeric value entered is narrower than the cell.

• True

• False

• I don't know

You can use the Format Painter to copy formats, including font, font size, font style, font.

• True

• False

• I don't know

The formula "=sum(F10:F20)" adds together the values in cells F10 and F20.

• True

• False

• I don't know

A cell reference identifies a cell’s location in the worksheet, based on its row number and column letter.

• True

• False

• I don't know

Conditional formatting can change the appearance of a cell based on a specified criterion.

• True

• False

• I don't know

If you want to create a pie chart, click Pie on the Insert tab and then select the worksheet data to be used to create the chart.

• True

• False

• I don't know

When you selected data and created a pie chart, the chart was placed on the worksheet. This is referred to as an embedded chart.

• True

• False

• I don't know

The CPU main function is to perform data computation.

• True

• False

• I don't know

License theft patching method allows for vendor controlled updates, reduced user interaction, and increased security of the OS or application.

• True

• False

• I don't know

Bluetooth will allow the easiest and fastest way to share a file between 2 modern smart phones without joining the same WIFI network.

• True

• False

• I don't know