Excel Questions

0 votes, 0 avg
139

Excel Questions

1 / 15

1.  IF Statement can be written to carry out an action

2 / 15

2. Excel is a program that is used to prepare a

3 / 15

3. The intersection of a column and a row in a worksheet is called ____.

4 / 15

4.  What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

5 / 15

5. The currently selected cell address is displayed in ____.

6 / 15

6. An array is a systematic arrangement of similar objects, usually in rows and columns.

7 / 15

7.  In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the _______ menu

8 / 15

8. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

9 / 15

9. What is the correct value of the function? =ROUND (1.2345,2)

10 / 15

10. What is the correct syntax of IF() function?

11 / 15

11.  What function displays row data in a column or column data in a row?

12 / 15

12. The total number of columns in a worksheet?

13 / 15

13. Which function will you use to enter current date and time in a worksheet cell?

14 / 15

14.  Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

15 / 15

15. What dialog box allows you to change a field name in a PivotTable?

Your score is

The average score is 43%