MS EXCEL TEST

0%
0 votes, 0 avg
0

MS EXCEL Quiz

MS EXCEL TEST

1 / 50

Microsoft Excel 2019 files have a default extension of___________?

2 / 50

How many sheets are there, by default, when we create a new Excel file ?

3 / 50

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

4 / 50

In a computer spreadsheet rows are labeled ________ ?

5 / 50

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

6 / 50

Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

7 / 50

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

8 / 50

How we can view a cell comment?

9 / 50

Which of the following is not true regarding Conditional Formatting?

10 / 50

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

11 / 50

Microsoft Office Suite spreadsheet program is _________?

12 / 50

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

13 / 50

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

14 / 50

Which of these keys is used in MS Excel to copy formula from above cell?

15 / 50

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

16 / 50

How can you remove borders applied in cells?

17 / 50

In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?

18 / 50

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

19 / 50

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

20 / 50

Which one is example of spreadsheet software?

21 / 50

Which function in Excel tells how many numeric entries are there?

22 / 50

When a range is selected, how can you activate the previous cell?

23 / 50

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

24 / 50

You can check the conditions against __________ when applying conditional formatting

25 / 50

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

26 / 50

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

27 / 50

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

28 / 50

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

29 / 50

In excel columns are labeled as____________?

30 / 50

In MS-Excel__________ short cut key is used for hiding rows.

31 / 50

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

32 / 50

If you press ___, the cell accepts your typing as its -contents?

33 / 50

What do you use to create a chart?

34 / 50

Which function calculates the largest value in a set of numbers?

35 / 50

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

36 / 50

Excel displays the current cells address in the __________?

37 / 50

What is maximum zoom level in MS Excel.

38 / 50

An excel workbook is a collection of __________?

39 / 50

To open an existing workbook, click the open button on the ___________ toolbar?

40 / 50

The term chart wizard data in MS is referring to_________?

41 / 50

How many rows are in one Microsoft Excel sheet?

42 / 50

Which of these will not select all the cells in a document?

43 / 50

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

44 / 50

What is minimum zoom level in MS Excel.

45 / 50

The first cell in excel worksheet is labeled as _________?

46 / 50

Functions and formulas in MS Excel must begin with ___

47 / 50

A formula in excel starts with _________ ?

48 / 50

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

49 / 50

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

50 / 50

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

Leave a Comment