Take Exam - MS Excel

Question 1: Which function converts numbers to text?

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

Question 2: Which key combination inserts current time?

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

Question 3: The default row height is?

12.75 15 18 20

Question 4: Which feature finds and replaces text?

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

Question 5: Which function returns the largest number?

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

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

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

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

Relative reference Absolute reference Mixed reference Error

Question 8: The cell reference A$1 is?

Relative Absolute Mixed Fixed

Question 9: Which tab contains data validation?

Data Home Insert Formulas

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

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

Question 11: Which key combination is used to cut?

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

Question 12: Which chart is best for showing proportions?

Line Chart Pie Chart Bar Chart Column Chart

Question 13: Which key combination inserts a new worksheet?

Shift + F11 Ctrl + N Ctrl + W Alt + F1

Question 14: Which key is used to recalculate formulas?

F5 F9 F7 F8

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

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

Question 16: Which key combination repeats the last action?

F4 Ctrl + Y Ctrl + Z Alt + R

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

F1 F2 F3 F4

Question 18: Which function returns the smallest number?

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

Question 19: Which operator is used for power?

^ % * /

Question 20: Which feature removes duplicate values?

Data ? Remove Duplicates Insert ? Data Home ? Data Tools View ? Remove

Question 21: Which function calculates compound interest?

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

Question 22: Which function finds a value from a range?

VLOOKUP() HLOOKUP() MATCH() SEARCH()

Question 23: Which key combination opens the Format Cells dialog?

Ctrl + 1 Ctrl + 2 Ctrl + F Alt + Enter

Question 24: Which symbol is used for absolute reference?

$ # & @

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

Data Validation Freeze Panes Protect Sheet Lock Sheet

Question 26: A group of cells is called?

Range Block Matrix Table

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

Cell Table Field Box

Question 28: Which function calculates net present value?

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

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

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

Question 30: Which chart shows trends over time?

Line Chart Pie Chart Bar Chart Doughnut Chart

MS Excel

Your Information