Computer Applications and IT, Accounting

Once data is entered into a cell, can't be edited?

• True

• False

The intersection of a row and a column is called a ________

• worksheet

• chart

• sum

• cell

The #REF! Error value occurs when a cell reference is invalid.

• True

• False

Which formula can add all the numeric values in a range of cells?

• add

• total

• Average

• sum

The formula = ((A2+B5)*5% is valid.

• True

• False

Which of the following is mixced cell reference?

• P72

• G$9

• $K356

• $F$8

Inserting Page Number means is inserting Header and Footer.

• True

• False

If cells: A1=10 A2=20 A3=30 A4=40 what will be your formula if you are going to get the total? ________________________

In order to exponent items in Excel, you would use:

• ^

• *

• /

• #

The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

• A1- J15

• A1.J15

• A1; J15

• A1:J15