Take Exam - MS Excel

Question 1: Which symbol is used for absolute reference?

$ # & @

Question 2: Which operator is used for concatenation?

& + #

Question 3: Which function finds the square root?

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

Question 4: The default row height is?

12.75 15 18 20

Question 5: Which function converts text to uppercase?

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

Question 6: Which operator is used for power?

^ % * /

Question 7: Which key combination is used to redo?

Ctrl + Y Ctrl + Z Ctrl + R Ctrl + H

Question 8: The default alignment for numbers is?

Left Right Center Justify

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

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

Question 10: Which chart is best for comparing values?

Line Chart Column Chart Pie Chart Area Chart

Question 11: Which function rounds numbers?

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

Question 12: The default alignment for text is?

Left Right Center Justify

Question 13: Which key combination is used to cut?

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

Question 14: Which function returns the nth largest value?

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

Question 15: Which function calculates loan interest rate?

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

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

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

Question 17: Which tab contains the AutoSum feature?

Home Insert Formulas Data

Question 18: Which function returns the weekday number?

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

Question 19: Which option helps sort data?

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

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

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

Question 21: The active cell is identified by?

Blue border Bold border Green border Black border

Question 22: Which function calculates internal rate of return?

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

Question 23: Which tab is used to insert charts?

Insert Data View Formulas

Question 24: The extension of an Excel file is?

.docx .xls or .xlsx .pptx .txt

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

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

Question 26: Which function counts blank cells?

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

Question 27: Which function returns the smallest number?

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

Question 28: Which function returns the payment amount?

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

Question 29: Which function searches horizontally?

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

Question 30: Which function replaces text?

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

MS Excel

Your Information