Take Exam - MS Excel

Question 1: The function to find the current date is?

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

Question 2: Which function returns a value from a specified position?

INDEX() MATCH() SEARCH() FIND()

Question 3: Microsoft Excel is an example of?

Word Processor Spreadsheet Software Presentation Software Database Software

Question 4: Which key combination is used to undo?

Ctrl + U Ctrl + Z Ctrl + Y Ctrl + A

Question 5: Which key combination is used to cut?

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

Question 6: Which key is used to recalculate formulas?

F5 F9 F7 F8

Question 7: Which function converts text to uppercase?

UPPER() LOWER() PROPER() CAPS()

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

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

Question 9: Which function rounds numbers?

ROUND() CEILING() FLOOR() TRUNC()

Question 10: Which function counts based on a condition?

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

Question 11: Which function adds numbers based on a condition?

COUNTIF() SUMIF() IF() ADDIF()

Question 12: Which operator is used for concatenation?

& + #

Question 13: Which function calculates present value?

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

Question 14: The shortcut key to save a workbook is?

Ctrl + S Ctrl + A Ctrl + D Ctrl + E

Question 15: The cell address A$1 refers to?

Relative reference Mixed reference Absolute reference Row fixed

Question 16: Which operator is used for power?

^ % * /

Question 17: The intersection of a row and a column is called?

Cell Table Field Box

Question 18: Which function returns true if any condition is true?

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

Question 19: Which option changes number format?

Home ? Number Insert ? Number Data ? Number Layout ? Number

Question 20: Which function returns the nth largest value?

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

Question 21: A group of cells is called?

Range Block Matrix Table

Question 22: Which function calculates internal rate of return?

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

Question 23: Which function counts blank cells?

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

Question 24: Which tab contains the AutoSum feature?

Home Insert Formulas Data

Question 25: Which function returns the number of characters in a string?

CHAR() LEN() TEXT() COUNT()

Question 26: The extension of an Excel file is?

.docx .xls or .xlsx .pptx .txt

Question 27: The function used for logical test is?

TEST() CHECK() IF() LOGICAL()

Question 28: Which function reverses logical value?