Excel Questions

0 votes, 0 avg
5

Excel Questions

1 / 15

1. What is the collection of worksheets called?

2 / 15

2. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

3 / 15

3. Which function is used to trap and handle errors?

4 / 15

4. When you insert an Excel file into a Word document, the data are

5 / 15

5. The total number of rows in a worksheet?

6 / 15

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

7 / 15

7. Under which Tab, the chart options are available in MS Excel?

8 / 15

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

9 / 15

9. Which symbol is used to specify the fixed columns or rows in the formula?

10 / 15

10. _____ are equations that perform calculations on values in your worksheet.

11 / 15

11. What function will result in the total number of entries in the cell range B5 to B14

12 / 15

12. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?

13 / 15

13. Statistical calculations and preparation of tables and graphs can be done using

14 / 15

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

15 / 15

15. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE?

Your score is

The average score is 53%