MS EXCEL TEST

0%
0 votes, 0 avg
0

MS EXCEL Quiz

MS EXCEL TEST

1 / 50

Getting data from a cell located in a different sheet is called ___________?

2 / 50

What is maximum zoom level in MS Excel.

3 / 50

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

4 / 50

You can check the conditions against __________ when applying conditional formatting

5 / 50

Which of the following you can paste selectively using Paste Special Command?

6 / 50

Which one is example of spreadsheet software?

7 / 50

Which of the following is the latest version of MS Excel?

8 / 50

Actual working area of Computer’s Microsoft Excel is ________ ?

9 / 50

Which of these keys are used in MS Excel to insert current time In workbook?

10 / 50

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

11 / 50

What type of chart is good for single series of data?

12 / 50

How many columns are in one Microsoft Excel sheet?

13 / 50

What displays the content of active cell?

14 / 50

When you insert an Excel file into a word document, the data are?

15 / 50

In a computer spreadsheet, each cell contain a __________ ?

16 / 50

Which of these keys are used in MS Excel to copy value from above cell?

17 / 50

Zoom level controll is provided in _____________ in MS Excel.

18 / 50

Microsoft Excel 2019 files have a default extension of___________?

19 / 50

The Greater than sign (>) is an example of _____ operator.

20 / 50

Which function in Excel checks whether a condition is true or not?

21 / 50

How we can view a cell comment?

22 / 50

Which of the following is not true regarding Conditional Formatting?

23 / 50

A formula in excel starts with _________ ?

24 / 50

Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?

25 / 50

In MS Excel to delete duplicate values which Tab is used?

26 / 50

Which function displays row data into column or column data into row?

27 / 50

What is the intersection of a column and a row on a worksheet called ?

28 / 50

User developed instruction for excel are called__________?

29 / 50

In a computer spreadsheet, block of cells is called __________ ?

30 / 50

Ctrl+Shift+1 shortcut Key in excel are used to __________?

31 / 50

An Excel file is generally called_________

32 / 50

What type of chart is useful for comparing parts of a whole?

33 / 50

The Greater Than sign is an example of ________ operation?

34 / 50

Which of the following is not a valid Zoom percentage in Excel?

35 / 50

What do you use to create a chart?

36 / 50

Which of the following will not enter data in a cell?

37 / 50

Where can you set the shading color for a range of cells in Excel?

38 / 50

Title bar in MS-Excel displays name of the __________ ?

39 / 50

What is minimum zoom level in MS Excel.

40 / 50

The term chart wizard data in MS is referring to_________?

41 / 50

In a computer spreadsheet rows are labeled ________ ?

42 / 50

The process of arranging the items of a column in some sequence or order is known as

43 / 50

In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of _____ ?

44 / 50

Which of following is not an element of computer spreadsheet interface?

45 / 50

What type of chart will you use to compare performance of two employees in the year 2016 ?

46 / 50

Main window in a computer spreadsheet is called ___________ ?

47 / 50

The first cell in excel worksheet is labeled as _________?

48 / 50

Move to next cell in row in MS Excel:

49 / 50

In a computer, element which is not a part of chart is ___________ ?

50 / 50

Which among following is not associated with spelling dialogue box?

Leave a Comment