Take Exam - MS Excel

Question 1: Which function counts numeric values?

SUM() COUNT() AVERAGE() MAX()

Question 2: Which tab contains chart options?

Insert Home Data Formulas

Question 3: Which function calculates loan interest rate?

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

Question 4: In Excel, rows are labeled as?

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

Question 5: Which tab contains the AutoSum feature?

Home Insert Formulas Data

Question 6: Which key combination inserts current time?

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

Question 7: Which option changes number format?

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

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

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

Question 9: Which function capitalizes the first letter of each word?

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

Question 10: Which key combination is used to redo?

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

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

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

Question 12: The default alignment for text is?

Left Right Center Justify

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

F1 F2 F3 F4

Question 14: The shortcut to insert a new row is?

Ctrl + Shift + + Ctrl + R Ctrl + I Ctrl + Enter

Question 15: Which option helps sort data?

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

Question 16: The default column width is?

8.43 10 12 14

Question 17: Which tab contains sorting and filtering options?

Data Insert Review Home

Question 18: Which function calculates internal rate of return?

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

Question 19: Which key is used to recalculate formulas?

F5 F9 F7 F8

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

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

Question 21: Which function rounds numbers?

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

Question 22: Which function finds the average of numbers?

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

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

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

Question 24: Which function reverses logical value?

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

Question 25: A group of cells is called?

Range Block Matrix Table

Question 26: Which function calculates compound interest?

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

Question 27: Which function calculates net present value?

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

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

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

Question 29: Which feature finds and replaces text?

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

Question 30: Which function returns the smallest number?

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

MS Excel

Your Information