Take Exam - MS Excel

Question 1: Which function returns the remainder?

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

Question 2: Which function returns the nth largest value?

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

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

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

Question 4: Which key is used to recalculate formulas?

F5 F9 F7 F8

Question 5: Which function returns the weekday number?

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

Question 6: The cell address A$1 refers to?

Relative reference Mixed reference Absolute reference Row fixed

Question 7: Which function returns the smallest number?

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

Question 8: Which function calculates loan interest rate?

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

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

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

Question 10: The extension of an Excel file is?

.docx .xls or .xlsx .pptx .txt

Question 11: Which operator is used for concatenation?

& + #

Question 12: Which feature is used to lock specific cells?

Data Validation Freeze Panes Protect Sheet Lock Sheet

Question 13: Which function reverses logical value?

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

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

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

Question 15: Which key combination inserts current time?

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

Question 16: Which function counts numeric values?

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

Question 17: Which key combination is used to redo?

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

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

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

Question 19: Which tab contains data validation?

Data Home Insert Formulas

Question 20: Which function returns the nth smallest value?

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

Question 21: Which key combination is used to cut?

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

Question 22: The function used for logical test is?

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

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

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

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

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

Question 25: Which tab contains the AutoSum feature?

Home Insert Formulas Data

Question 26: Which function finds the average of numbers?

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

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

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

Question 28: Which function converts text to numbers?

TEXT() VALUE() NUM() CONVERT()

Question 29: Which symbol is used for absolute reference?

$ # & @

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

1 3 5 10

MS Excel

Your Information