Take Exam - MS Excel

Question 1: Which key combination inserts current time?

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

Question 2: Which key combination is used to cut?

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

Question 3: Which feature changes cell contents automatically?

AutoFormat AutoFill AutoCorrect AutoAdjust

Question 4: Which function calculates compound interest?

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

Question 5: Which function counts numeric values?

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

Question 6: Which key combination is used to redo?

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

Question 7: Which key combination repeats the last action?

F4 Ctrl + Y Ctrl + Z Alt + R

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

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

Question 9: Which function returns true if any condition is true?

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

Question 10: Which key combination inserts a new worksheet?

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

Question 11: The function used for logical test is?

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

Question 12: The default row height is?

12.75 15 18 20

Question 13: Which function returns future value?

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

Question 14: The function to find current time is?

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

Question 15: Which function counts based on a condition?

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

Question 16: Which function calculates loan interest rate?

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

Question 17: Which key combination inserts current date?

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

Question 18: Which function returns the nth smallest value?

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

Question 19: Which function converts text to lowercase?

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

Question 20: Which function reverses logical value?

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

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

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

Question 22: Which function calculates present value?

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

Question 23: Which feature suggests text as you type?

AutoFill AutoText AutoComplete SmartFill

Question 24: The active cell is identified by?

Blue border Bold border Green border Black border

Question 25: The default alignment for text is?

Left Right Center Justify

Question 26: Which function returns the payment amount?

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

Question 27: The extension of an Excel file is?

.docx .xls or .xlsx .pptx .txt

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

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

Question 29: Which function returns the weekday number?

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

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

1 3 5 10

MS Excel

Your Information

Question 1: Which key combination inserts current time?

Question 2: Which key combination is used to cut?

Question 3: Which feature changes cell contents automatically?

Question 4: Which function calculates compound interest?

Question 5: Which function counts numeric values?

Question 6: Which key combination is used to redo?

Question 7: Which key combination repeats the last action?

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

Question 9: Which function returns true if any condition is true?

Question 10: Which key combination inserts a new worksheet?

Question 11: The function used for logical test is?

Question 12: The default row height is?

Question 13: Which function returns future value?

Question 14: The function to find current time is?

Question 15: Which function counts based on a condition?

Question 16: Which function calculates loan interest rate?

Question 17: Which key combination inserts current date?

Question 18: Which function returns the nth smallest value?

Question 19: Which function converts text to lowercase?

Question 20: Which function reverses logical value?

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

Question 22: Which function calculates present value?

Question 23: Which feature suggests text as you type?

Question 24: The active cell is identified by?

Question 25: The default alignment for text is?

Question 26: Which function returns the payment amount?

Question 27: The extension of an Excel file is?

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

Question 29: Which function returns the weekday number?

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