Take Exam - MS Excel

Question 1: Which feature removes duplicate values?

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

Question 2: Which operator is used for concatenation?

& + #

Question 3: Which key combination switches between worksheets?

Ctrl + PgUp/PgDn Alt + Tab Shift + Tab Ctrl + Tab

Question 4: In Excel, rows are labeled as?

A, B, C 1, 2, 3 A1, B1, C1 X, Y, Z

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

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

Question 6: Which tab is used to insert charts?

Insert Data View Formulas

Question 7: Which function calculates net present value?

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

Question 8: Which function converts text to uppercase?

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

Question 9: Which option filters data?

Data ? Filter Insert ? Filter Home ? Filter View ? Filter

Question 10: Which tab contains the AutoSum feature?

Home Insert Formulas Data

Question 11: Which option changes number format?

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

Question 12: Which feature changes cell contents automatically?

AutoFormat AutoFill AutoCorrect AutoAdjust

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

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

Question 14: Which key combination is used to paste?

Ctrl + C Ctrl + V Ctrl + X Ctrl + P

Question 15: Which function returns the nth largest value?

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

Question 16: The function to find current time is?

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

Question 17: Which function returns the remainder?

MOD() ROUND() QUOTIENT() TRUNC()

Question 18: Which chart is best for comparing values?

Line Chart Column Chart Pie Chart Area Chart

Question 19: A group of cells is called?

Range Block Matrix Table

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

Cell Table Field Box

Question 21: Which function reverses logical value?

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

Question 22: Which function counts blank cells?

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

Question 23: Which tab contains sorting and filtering options?

Data Insert Review Home

Question 24: The default row height is?

12.75 15 18 20

Question 25: Which function joins text strings together?

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

Question 26: The default alignment for text is?

Left Right Center Justify

Question 27: The default column width is?

8.43 10 12 14

Question 28: Which function returns the payment amount?

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

Question 29: The active cell is identified by?

Blue border Bold border Green border Black border

Question 30: Which tab contains chart options?

Insert Home Data Formulas

MS Excel

Your Information