Take Exam - MS Excel

Question 1: Which function capitalizes the first letter of each word?

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

Question 2: Which key combination shows formulas?

Ctrl + ` Ctrl + F2 Ctrl + F3 Ctrl + Shift + F9

Question 3: Which feature finds and replaces text?

Home ? Find & Select Insert ? Find Data ? Replace View ? Edit

Question 4: The extension of an Excel file is?

.docx .xls or .xlsx .pptx .txt

Question 5: Which function reverses logical value?

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

Question 6: Which key combination repeats the last action?

F4 Ctrl + Y Ctrl + Z Alt + R

Question 7: Which chart is best for showing proportions?

Line Chart Pie Chart Bar Chart Column Chart

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

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

Question 9: Which operator is used for power?

^ % * /

Question 10: Which key is used to recalculate formulas?

F5 F9 F7 F8

Question 11: Which function converts text to numbers?

TEXT() VALUE() NUM() CONVERT()

Question 12: Which function calculates loan interest rate?

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

Question 13: Which key is used to edit a cell?

F1 F2 F3 F4

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

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

Question 15: Which function converts text to lowercase?

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

Question 16: Which symbol is used for absolute reference?

$ # & @

Question 17: The cell reference A$1 is?

Relative Absolute Mixed Fixed

Question 18: Which function is used to calculate the number of working days?

NETWORKDAYS() WORKDAYS() DAYS() DATE()

Question 19: Which function returns the smallest number?

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

Question 20: Which function calculates compound interest?

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

Question 21: Which function finds the square root?

SQRT() ROOT() POWER() MATH()

Question 22: Which function counts blank cells?

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

Question 23: Which function returns future value?

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

Question 24: Which option helps sort data?

Data ? Sort Insert ? Sort Home ? Sort View ? Sort

Question 25: The default row height is?

12.75 15 18 20

Question 26: Which function finds the average of numbers?

AVG() AVERAGE() MEAN() COUNT()

Question 27: The shortcut key to create a new workbook is?

Ctrl + N Ctrl + O Ctrl + C Ctrl + W

Question 28: Which function is used to find the sum of a range?

SUM() TOTAL() ADD() COUNT()

Question 29: Which tab contains chart options?

Insert Home Data Formulas

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

Relative reference Absolute reference Mixed reference Error

MS Excel

Your Information