Excel Questions

0 votes, 0 avg
29

Excel Questions

1 / 15

1.  What is the keyboard shortcut for creating a chart from the selected cell range?

2 / 15

2. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

3 / 15

3.  The ____ function is used to convert to text in a number format in MS Excel.

4 / 15

4. The NOW function calculates the difference in days between two dates.

5 / 15

5. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array

6 / 15

6. You can select the current row in MS-Excel Worksheet by pressing?

7 / 15

7. How can you remove borders applied in cells?

8 / 15

8. What is the correct value of the function? =ROUND (1.9867,2)

9 / 15

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

10 / 15

10. How can we provide a dynamic range in ‘data Source’ of pivot tables?

11 / 15

11. Shortcut key CTRL + D is used to ____.

12 / 15

12.  Under which tab and in which function group will you find the option to insert a Pivot Table?

13 / 15

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

14 / 15

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

15 / 15

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

Your score is

The average score is 58%