Excel Interview Questions Part 4
01. How we can save and protect the workbook by?
Ans. Write Reservation Password, Read-only Recommended,Protection Password.
02. What are the tabs that appear at the bottom of each workbook called ?
Ans. Sheet tabs.
03. B7:B9 indicates:
Ans. Cells B7 through B9.
04. What is represented by the small, black square in the lower-right corner of an active cell or range ?
Ans. Fill handle.
05. A __________ is a grid with labelled columns and rows.
Ans. Worksheet.
06. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?
Ans. Financial.
07. NOT, AND, OR and XOR are
Ans. Logical Operators.
08. You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use ?
Ans. Save.
09. In order to perform a calculation in a spreadsheet, you need to use a: ?
Ans. formula.
10. How do you tell one cell from another ?
Ans. By its address.
11. What is the keyboard shortcut for creating a chart from the selected cell range ?
Ans. F11.
12. What is the shortcut key to insert current date in a cell ?
Ans. CTRL + ;.
13. Which of the following function will use to find the highest number in a series of number ?
Ans. MAX(B1:B3).
14. Which of the following syntax is correct regarding to SUM function in Excel ?
Ans. =SUM (A1:A9, B1:B9).
15. What is the shortcut key to hide entire column ?
Ans. CTRL + 0.
16. A smart tag will be removed from a cell when?
Ans. the data in the cell is changed or deleted.
17. is it correct syntax in Excel ? [=IF(LogicalTest, TrueResult, FalseResult)]
Ans. Yes.
18. Which of the following is correct ?
Ans. =POWER(2,3).
19. If 4/6 entered in a cell without applying any formats, Excel will treat this as
Ans. Date.
20. What is the shortcut key to insert a new comment in a cell ?
Ans. Shift + F2.
