Excel Questions

0 votes, 0 avg
51

Excel Questions

1 / 15

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

2 / 15

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

3 / 15

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

4 / 15

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

5 / 15

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

6 / 15

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

7 / 15

7.  What is the keyboard shortcut to switch between open Excel windows?

8 / 15

8. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?

9 / 15

9. The total number of rows in a worksheet?

10 / 15

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

11 / 15

11. What is the keyboard shortcut to insert a SUM formula in MS Excel?

12 / 15

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

13 / 15

13. ____ appear at the bottom of the Excel window.

14 / 15

14.  Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?

15 / 15

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

Your score is

The average score is 53%