Excel Functions

When tracing the dependence on a cell in a worksheet, how can you tell whether a dependency for that cell exists in another worksheet?

• A dotted blue line appears.

• A dotted black line points to an icon for a Sheet.

• A solid blue line appears.

• A blue arrow appears.

Which sequence will add 5 to each number in cells A1, A2, and A3?

• Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, and then select OK.

• Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+V, select Add, and then select OK.

• Enter 5 in cell A4. Select A4, select Ctrl+X, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK.

• Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK.

What is the third argument in an IF statement?

• the return value if TRUE

• the logical test

• the return value if FALSE

• the variable

What is the result of this statement: IF(5>4 AND 4>5, 1, 2)?

• TRUE

• 2

• 1

• FALSE

A project starts on Jan 15, and this date is in cell A1. Which Excel formula will calculate the end date if the project lasts 100 days, and weekends are not counted as working days?

• DAY(A1,100)

• WORKDAY(A1,100)

• NETWORKDAYS(A1,100)

• A1+100

the structure of sumif is:

• sumif(range of cells to be sdded,criteria, range of cells to be tested)

• sumif(criteria,range of cells to be tested)

• sumif(range of cells to be tested,criteria,range of cells to be added)

Use CONCATENATE to combine the text strings in cells A1, B2, and C3.

• CONCATENATE(A1:B2:C3)

• CONCATENATE(ALL)

• CONCATENATE(A1,B2,C3)

• CONCATENATE(A1B2C3)

Which function returns the number of characters in cell T4?

• TEXTLENGTH(T4)

• EXACT(T4)

• LEN(T4)

• CHAR(T4)

Cell G5 contains the text string FOOTBALL. Which function will return the text BALL?

• SEARCH(G5,5,4)

• MID(G5,5,4)

• FIND(G5,5,4)

• LAST(G5,4)

A box that holds data

• Spreadsheet

• Cell

• Row

• Data