Take Exam - MS Excel

Question 1: Which function counts based on a condition?

COUNTIF() SUMIF() IF() COUNTA()

Question 2: Which function returns true if all conditions are true?

IF() AND() OR() NOT()

Question 3: Which function removes extra spaces from text?

TRIM() CUT() CLEAN() REMOVE()

Question 4: Which function searches horizontally?

VLOOKUP() HLOOKUP() MATCH() INDEX()

Question 5: Which function returns the nth largest value?

LARGE() MAX() BIG() RANK()

Question 6: Which key combination inserts current time?

Ctrl + Shift + ; Ctrl + : Ctrl + ; Ctrl + D

Question 7: Which function calculates internal rate of return?

IRR() NPV() RATE() PMT()

Question 8: Which key combination is used to cut?

Ctrl + C Ctrl + X Ctrl + V Ctrl + D

Question 9: The active cell is identified by?

Blue border Bold border Green border Black border

Question 10: The default column width is?

8.43 10 12 14

Question 11: Which function returns the integer part of a number?

ROUND() TRUNC() INT() MOD()

Question 12: Which function converts numbers to text?

TEXT() VALUE() STRING() CONVERT()

Question 13: Which function replaces text?

CHANGE() REPLACE() SUBSTITUTE() MODIFY()

Question 14: The cell reference A$1 is?

Relative Absolute Mixed Fixed

Question 15: Which key combination inserts current date?

Ctrl + ; Ctrl + : Ctrl + Shift + ; Ctrl + D

Question 16: Which function returns current system date and time?

NOW() TODAY() DATE() TIME()

Question 17: Which function is used to count cells with text?

COUNT() COUNTA() COUNTIF() COUNTBLANK()

Question 18: Which function calculates present value?

PV() FV() PMT() RATE()

Question 19: Which function returns the smallest number?

SMALL() MIN() LOW() LEAST()

Question 20: Which function returns future value?

FV() PV() PMT() RATE()

Question 21: Which function counts numeric values?

SUM() COUNT() AVERAGE() MAX()

Question 22: Which function counts blank cells?

BLANK() COUNT() COUNTBLANK() COUNTA()

Question 23: Which function returns the remainder?

MOD() ROUND() QUOTIENT() TRUNC()

Question 24: Which function converts text to lowercase?

UPPER() LOWER() PROPER() SMALL()

Question 25: Which function returns the payment amount?

PMT() PV() FV() RATE()

Question 26: Which function returns the weekday number?

WEEKDAY() DAY() DATE() NOW()

Question 27: Which tab contains sorting and filtering options?

Data Insert Review Home

Question 28: Which function returns the largest number?

MAX() MIN() LARGE() BIG()

Question 29: Which option is used to freeze rows/columns?

View ? Freeze Panes Home ? Freeze Data ? Freeze Insert ? Freeze

Question 30: Which function calculates net present value?

NPV() IRR() PV() PMT()

MS Excel

Your Information