Take Exam - MS Excel

Question 1: Which tab is used to insert charts?

Insert Data View Formulas

Question 2: Which function returns the weekday number?

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

Question 3: Which key is used to recalculate formulas?

F5 F9 F7 F8

Question 4: Which function replaces text?

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

Question 5: Which key combination shows formulas?

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

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

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

Question 7: Which function returns future value?

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

Question 8: Which option changes number format?

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

Question 9: Which option helps sort data?

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

Question 10: The default alignment for numbers is?

Left Right Center Justify

Question 11: Which function finds the square root?

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

Question 12: The shortcut key to open an existing workbook is?

Ctrl + N Ctrl + O Ctrl + P Ctrl + S

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

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

Question 14: Which feature is used to lock specific cells?

Data Validation Freeze Panes Protect Sheet Lock Sheet

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

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

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

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

Question 17: Which function returns the nth smallest value?

SMALL() MIN() LOW() RANK()

Question 18: Which chart is best for showing proportions?

Line Chart Pie Chart Bar Chart Column Chart

Question 19: Which feature suggests text as you type?

AutoFill AutoText AutoComplete SmartFill

Question 20: The active cell is identified by?

Blue border Bold border Green border Black border

Question 21: Which function joins text strings together?

MERGE() CONCAT() JOIN() LINK()

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

Cell Table Field Box

Question 23: Which key combination inserts current time?

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

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

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

Question 25: Which function returns the nth largest value?

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

Question 26: In Excel, columns are labeled as?

1, 2, 3 A, B, C A1, A2, A3 I, II, III

Question 27: Which function converts text to numbers?

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

Question 28: Which operator is used for power?

^ % * /

Question 29: Which function calculates compound interest?

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

Question 30: Which function converts numbers to text?

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

MS Excel

Your Information