Take Exam - MS Excel

Question 1: Which function joins text strings together?

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

Question 2: Microsoft Excel is an example of?

Word Processor Spreadsheet Software Presentation Software Database Software

Question 3: Which key is used to recalculate formulas?

F5 F9 F7 F8

Question 4: Which function counts blank cells?

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

Question 5: The cell reference A$1 is?

Relative Absolute Mixed Fixed

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

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

Question 7: Which tab contains chart options?

Insert Home Data Formulas

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

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

Question 9: Which key combination repeats the last action?

F4 Ctrl + Y Ctrl + Z Alt + R

Question 10: Which function finds the average of numbers?

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

Question 11: Which symbol is used for absolute reference?

$ # & @

Question 12: The default column width is?

8.43 10 12 14

Question 13: Which chart is best for comparing values?

Line Chart Column Chart Pie Chart Area Chart

Question 14: Which option helps sort data?

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

Question 15: Which key combination is used to copy?

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

Question 16: Which function returns the weekday number?

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

Question 17: The function to find current time is?

TODAY() TIME() NOW() HOUR()

Question 18: Which function calculates internal rate of return?

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

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

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

Question 20: A group of cells is called?

Range Block Matrix Table

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

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

Question 22: Which function returns the nth smallest value?

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

Question 23: The default alignment for text is?

Left Right Center Justify

Question 24: Which function returns the nth largest value?

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

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

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

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

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

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

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

Question 28: Which function converts text to lowercase?

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

Question 29: Which function calculates compound interest?

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

Question 30: Which function calculates present value?

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

MS Excel

Your Information