Prev 1 2 3 4 5 Next
11. How many hyperlinks can be there in a worksheet?
A. 32,767
B. 32,768
C. 65,530
D. 65,535
ANSWER:C
SOLUTION : There can be a maximum of 65,530 hyperlinks in a worksheet.
12. How many times undo levels can be used in a worksheet?
A. 25
B. 50
C. 75
D. 100
ANSWER:D
SOLUTION: There are 100 undo levels in a worksheet.
13. How many users can open the Excel file at the same time?
A. 64 users
B. 128 users
C. 256 users
D. 512 users
ANSWER:C
SOLUTION: A total number of 256 users can open the excel file at the same time. For this, the “Allow changes by more than one user…” setting should be enabled.
14. The intersection of a column and a row in a worksheet is called ____.
A. Box
B. Cell
C. Range
D. Page Break
ANSWER:B
SOLUTION: The intersection of a column and a row in a worksheet is called a “Cell”.
15. The fill function can be ____ to complete formulas in a range.
A. Single clicked
B. Double-clicked
C. Triple clicked
D. Right clicked
ANSWER:B
SOLUTION: The fill function can be double-clicked to complete formulas in a range.
16. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
A. OR
B. AND
C. IF
D. ANDIF
ANSWER:B
SOLUTION :The AND() function is used to test multiple conditions and returns TRUE if all arguments evaluate TRUE; FALSE if not.
17. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?
A. OR
B. AND
C. IF
D. ANDIF
ANSWER: A
SOLUTION:The OR() function is used to test multiple conditions and returns TRUE if one or more evaluates to TRUE, and returns FALSE if all arguments evaluate to FALSE.
18. The Excel ____ function returns the Boolean value FALSE.
A. TRUEFALSE(0)
B. FALSE()
C. Both of the above
D. There is no such function
ANSWER:B
SOLUTION: The Excel FALSE() function returns the Boolean value FALSE.
19. Which function is used to trap and handle errors?
A. IFERROR()
B. ERROR()
C. IFNA()
D. IFTRAP()
ANSWER:A
SOLUTION: The IFERROR() function is used to trap and handle errors.
20. Which function is used to get a date n working days in the future or past?
A. WORKDAY()
B. DAY()
C. WORKDATE()
D. DAYM()
ANSWER:A
SOLUTION: The WORKDAY() function is used to get a date n working days in the future or past.