Microsoft Excel Mcqs
Q.1: Currency figures in Excel can be changed from US Dollars to the:@
A. Yuan
B. Euro
C. All Listed
D. All Listed
Q.2: The standard name of each cell is based on its ___________ and __________I
A. Level and priority
B. Row and column
C. Age and sequence
D. Height and width
Q.3: What is the formula used to multiply cell A1 by cell C1?8
A. =A1XC1
B. = A*C,1
C. =A1*C1
D. = A1/AC
Q.4: Which of the following is NOT a way to align a cell?4
A. Align Left
B. Align Reverse
C. Align Center
D. Align Right
Q.5: You can change the color of the following in Excel:3
A. Background
B. Font
C. All Listed
D. All Listed
Q.6: All forumulas in Excel begin with the following symbol6
A. +
B. #
C. =
D. %
Q.7: True or False: Frequency is an array function..
A. False
B. True
C. No Option
D. No Option
Q.8: What does the function FV stand for?$
A. Current Value
B. Present Value
C. Future Value
D. Future Variety
Q.9: Which of the following is a "Lookup and Reference" function?<
A. Sumif
B. Iferror
C. VLookup
D. VLookup
Q.10: lookup _value argument is the value that is searched for in the first column of the table array_
A. True
B. False
C. No Option
D. No Option