Home » Agriculture Quiz » MS Excel Quiz-1

MS Excel Quiz-1

0%
2

MS Excel Quiz-1

1 / 50

Can you set 0.5 inch left indentation for a cell in Excel?

2 / 50

____ is the intersection of a row with a column.

3 / 50

Formulas in Excel are made up of ___

4 / 50

____ returns the least common multiple.

5 / 50

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

6 / 50

Excel documents are stored as files called

7 / 50

In a spreadsheet, a ____ is a number you will use in a calculation.

8 / 50

In ______ tab you will find AutoSum button.

9 / 50

Excel is a program that is used to prepare a

10 / 50

# VALUE! Refers to ___

11 / 50

In A3 cell edit = A1 + A2 refers to

12 / 50

How many columns are there in old version of MS Excel?

13 / 50

Merge cells option can be applied from

14 / 50

In which tab wrap text feature is present in MS Excel 2007?

15 / 50

______ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

16 / 50

_____ creates a chart of the data in the current range.

17 / 50

In Excel, Columns are labelled as ___

18 / 50

Functions in MS Excel must begin with ___

19 / 50

____ appear at the bottom of the Excel window.

20 / 50

____ was the first spreadsheet on a microcomputer.

21 / 50

Cuts the selected cells

22 / 50

______ specify the type of calculation that you want to perform on the elements of a formula.

23 / 50

Forms that are used to organise business data into rows and columns are called

24 / 50

How will you graphically represent expenditure in different departments ?

25 / 50

In Excel, Rows are labelled as ______

26 / 50

______ inserts a new worksheet.

27 / 50

On an Excel sheet, the active cell is indicated by

28 / 50

____ is a powerful tool used to create and format spreadsheets.

29 / 50

______ moves to the previous cell in a worksheet or the previous option in a dialog box.

30 / 50

____ sign is used to create an absolute cell reference.

31 / 50

Another name for a pre-programmed formula in Excel is

32 / 50

It is a collection of data that is stored electronically as a series of records in a table.

33 / 50

A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______

34 / 50

_____ are equations that perform calculations on values in your worksheet.

35 / 50

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

36 / 50

How many rows are there in old version of MS Excel?

37 / 50

By default the cell content alignment is

38 / 50

In Excel, which one denoted a range from B1 through E5

39 / 50

A formula in Excel always begins with an ____

40 / 50

Formatting a cell in Number format you can?t set

41 / 50

An Excel file is generally called a / an :

42 / 50

In a spreadsheet program, the ___ contains related worksheets and documents.

43 / 50

If you need a text to show vertically in a cell. How will you achieve this?

44 / 50

A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

45 / 50

DOS based spreadsheet package is

46 / 50

Pre-defined and built in formulas in Excel are known as

47 / 50

A ____ is rectangular grid of rows and columns used to enter data.

48 / 50

How can you remove borders applied in cells?

49 / 50

Formatting a cell in Currency, you can specify

50 / 50

___ operator, combines multiple references into one reference.

Provide Your Information

Your score is

The average score is 81%

0%

Share on facebook
Facebook
Share on twitter
Twitter
Share on whatsapp
WhatsApp
MS Office Quiz-1
MS Office Quiz-2
MS Office Quiz-3
MS Office Quiz-4
MS Office Quiz-5
MS Excel Quiz-2
MS Excel Quiz-3
MS Powerpoint Quiz-1
MS Powerpoint Quiz-2
MS Powerpoint Quiz-3

Help Concept 360 Please. We need 500 Youtube Subscriber. Please Subscribe our Youtube Channel. Click below link to subscribe Please

آپ سے گزارش ہے کہ ہمارے یوٹیوب چینل کوسبسکرائب کر کے ہماری مدد کریں جیسا کہ یہ ویب سائٹ آپکی مدد کر رہی ہے۔ شکریہ