MS Excel Test

0%
17
Created on

MS Excel Test

Welcome to MS Excel Test. Please attend the quiz in a quite place and with a stable internet connection. An use of unauthorized medium or any unfairness will violate the exam policy.

1 / 25

Category: Uncategorized

Q1: To select an entire column in MS-EXCEL, press?

2 / 25

Category: Uncategorized

Q2: Which is not the function of “Edit, Clear” command?

3 / 25

Category: Uncategorized

Q3: What does COUNTA () function do?

4 / 25

Category: Uncategorized

Q4: In the formula, which symbol specifies the fixed columns or rows?

5 / 25

Category: Uncategorized

Q5: Which would you choose to create a bar diagram?

6 / 25

Category: Uncategorized

Q6: Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

7 / 25

Category: Uncategorized

Q7: What is the correct way to refer the cell A10 on sheet3 from sheet1?

8 / 25

Category: Uncategorized

Q8: We can save and protect the workbook by

9 / 25

Category: Uncategorized

Q9: You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?

10 / 25

Category: Uncategorized

Q10 To record a sequence of keystrokes and mouse actions to play back later we use:

11 / 25

Category: Uncategorized

Q11: In order to perform a calculation in a spreadsheet, you need to use a:

12 / 25

Category: Uncategorized

Q12 A function inside another function is called _______

13 / 25

Category: Uncategorized

Q13: A features that displays only the data in column (s) according to specified criteria

14 / 25

Category: Uncategorized

Q14: In Excel 3-D reference in a formula

15 / 25

Category: Uncategorized

Q15 In MS-Excel numeric value can be treated as a label value if it precedes with

16 / 25

Category: Uncategorized

Q16: ____ returns the least common multiple.

17 / 25

Category: Uncategorized

Q17: This is not a function category in Excel.

18 / 25

Category: Uncategorized

Q18: Typed text showed in active cell and also in ___

19 / 25

Category: Uncategorized

Q19: Excel documents are stored as files called

20 / 25

Category: Uncategorized

Q20: What refers to the horizontal cells which can contain information?

21 / 25

Category: Uncategorized

Q21: To minimize the currently selected window, press

22 / 25

Category: Uncategorized

Q22: Which of the following is the comparison operator?

23 / 25

Category: Uncategorized

Q23: Workbook is a collection of

24 / 25

Category: Uncategorized

Q24: Which Excel feature enables predefined layouts to selected tables in the worksheet?

25 / 25

Category: Uncategorized

Q25: Which function displays row data in a column or column data in a row?

Your score is

The average score is 35%

0%

error: Content is protected !!