NEW
Font size
WorksheetsExcel Functions
Total questions: 15
Worksheet time: 8mins
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
if statement structure is:
if(value-if-true,logical-test,value-if-false)
if(logical-test,value-if-false-value-if-true)
if(logical-test,value-if-true,value-if-false)
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
Cell address
Range
Formula
Work sheet
In Excel, columns are labeled by?
Index
Letter
Numbers
to count any fields containing numbers we use:
countIF function
countIFS function
COUNT
COUNTA
the structure of countif is:
contif(criteria,range of cells)
countif(range of cells, criteria, range of cells)
countif(range of cells, criteria)
