Excel Questions

0 votes, 0 avg
173

Excel Questions

1 / 15

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

2 / 15

2. Getting data from a cell located in a different worksheet is called?

3 / 15

3. What command allows you to highlight the cell(s) in a data table that matches your set-up information?

4 / 15

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

5 / 15

5. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”?

6 / 15

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

7 / 15

7. Which programming language is used to write a Macro in MS Excel?

8 / 15

8.  Excel is a ____ program developed by Microsoft.

9 / 15

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

10 / 15

10. Which function is used to get the location of text in a string in MS Excel?

11 / 15

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

12 / 15

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

13 / 15

13. Which function is used to get days, months, or years between two dates?

14 / 15

14.  Which is not a Text function in MS Excel?

15 / 15

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

Your score is

The average score is 43%

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