Excel Questions

0 votes, 0 avg
173

Excel Questions

1 / 15

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

2 / 15

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

3 / 15

3. A worksheet range is a

4 / 15

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

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.  IF Statement can be written to carry out an action

7 / 15

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

8 / 15

8.  Steps for protecting a sheet by password in MS Excel?

9 / 15

9. The total number of rows in a worksheet?

10 / 15

10.  Excel is a ____ program developed by Microsoft.

11 / 15

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

12 / 15

12. Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

13 / 15

13. What is the collection of worksheets called?

14 / 15

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

15 / 15

15. Which of the following is an example of text in a spreadsheet?

Your score is

The average score is 43%

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.