Take Exam - MS Excel

Question 1: Which operator is used for concatenation?

& + #

Question 2: Which key combination inserts a new worksheet?

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

Question 3: The default column width is?

8.43 10 12 14

Question 4: Which function returns the nth smallest value?

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

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

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

Question 6: Which feature finds and replaces text?

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

Question 7: Which key combination is used to paste?

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

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

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

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

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

Question 10: Which tab contains chart options?

Insert Home Data Formulas

Question 11: Which key combination shows formulas?

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

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

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

Question 13: Microsoft Excel is an example of?

Word Processor Spreadsheet Software Presentation Software Database Software

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

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

Question 15: The function used for logical test is?

TEST() CHECK() IF() LOGICAL()

Question 16: Which function finds the square root?

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

Question 17: Which chart is best for showing proportions?

Line Chart Pie Chart Bar Chart Column Chart

Question 18: The default alignment for text is?

Left Right Center Justify

Question 19: The default number of worksheets in a workbook is?

1 3 5 10

Question 20: The cell reference A$1 is?

Relative Absolute Mixed Fixed

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

Cell Table Field Box

Question 22: Which function calculates net present value?

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

Question 23: Which function counts based on a condition?

COUNTIF() SUMIF() IF() COUNTA()

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

F1 F2 F3 F4

Question 25: Which function returns the largest number?

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

Question 26: Which function calculates loan interest rate?

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

Question 27: Which option filters data?

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

Question 28: Which function finds the average of numbers?

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

Question 29: A group of cells is called?

Range Block Matrix Table

Question 30: The shortcut key to create a new workbook is?

Ctrl + N Ctrl + O Ctrl + C Ctrl + W

MS Excel

Your Information