Take Exam - MS Excel

Question 1: In Excel, columns are labeled as?

1, 2, 3 A, B, C A1, A2, A3 I, II, III

Question 2: Which key combination inserts current date?

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

Question 3: Which function returns a value from a specified position?

INDEX() MATCH() SEARCH() FIND()

Question 4: Which option helps sort data?

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

Question 5: Which symbol is used for absolute reference?

$ # & @

Question 6: Which function rounds numbers?

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

Question 7: Which function returns the integer part of a number?

ROUND() TRUNC() INT() MOD()

Question 8: Which key is used to recalculate formulas?

F5 F9 F7 F8

Question 9: Which function finds a value from a range?

VLOOKUP() HLOOKUP() MATCH() SEARCH()

Question 10: Which key combination is used to cut?

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

Question 11: Which tab contains the AutoSum feature?

Home Insert Formulas Data

Question 12: Which feature removes duplicate values?

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

Question 13: Which function reverses logical value?

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

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

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

Question 15: Which operator is used for power?

^ % * /

Question 16: Which function counts based on a condition?

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

Question 17: The formula in Excel always starts with?

+ - =

Question 18: A group of cells is called?

Range Block Matrix Table

Question 19: Which function returns the nth largest value?

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

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

F1 F2 F3 F4

Question 21: Which key combination is used to redo?

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

Question 22: Which function calculates loan interest rate?

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

Question 23: Microsoft Excel is an example of?

Word Processor Spreadsheet Software Presentation Software Database Software

Question 24: Which key combination inserts a new worksheet?

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

Question 25: Which key combination is used to paste?

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

Question 26: In Excel, rows are labeled as?

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

Question 27: Which operator is used for concatenation?

& + #

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

Cell Table Field Box

Question 29: Which function converts numbers to text?

TEXT() VALUE() STRING() CONVERT()

Question 30: Which tab is used to insert charts?

Insert Data View Formulas

MS Excel

Your Information