MS Excel Quiz-1

0%
2

MS Excel Quiz-1

1 / 50

Merge cells option can be applied from

2 / 50

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

3 / 50

____ is the intersection of a row with a column.

4 / 50

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

5 / 50

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

6 / 50

Functions in MS Excel must begin with ___

7 / 50

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

8 / 50

Excel is a program that is used to prepare a

9 / 50

Another name for a pre-programmed formula in Excel is

10 / 50

____ sign is used to create an absolute cell reference.

11 / 50

Cuts the selected cells

12 / 50

A formula in Excel always begins with an ____

13 / 50

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

14 / 50

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

15 / 50

An Excel file is generally called a / an :

16 / 50

How can you remove borders applied in cells?

17 / 50

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

18 / 50

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

19 / 50

Formatting a cell in Number format you can?t set

20 / 50

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

21 / 50

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

22 / 50

______ inserts a new worksheet.

23 / 50

Formatting a cell in Currency, you can specify

24 / 50

In ______ tab you will find AutoSum button.

25 / 50

By default the cell content alignment is

26 / 50

In A3 cell edit = A1 + A2 refers to

27 / 50

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

28 / 50

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

29 / 50

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

30 / 50

____ appear at the bottom of the Excel window.

31 / 50

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

32 / 50

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

33 / 50

# VALUE! Refers to ___

34 / 50

____ returns the least common multiple.

35 / 50

In Excel, Columns are labelled as ___

36 / 50

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

37 / 50

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

38 / 50

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

39 / 50

____ was the first spreadsheet on a microcomputer.

40 / 50

On an Excel sheet, the active cell is indicated by

41 / 50

Formulas in Excel are made up of ___

42 / 50

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

43 / 50

DOS based spreadsheet package is

44 / 50

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

45 / 50

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

46 / 50

How will you graphically represent expenditure in different departments ?

47 / 50

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

48 / 50

In Excel, Rows are labelled as ______

49 / 50

Excel documents are stored as files called

50 / 50

___ operator, combines multiple references into one reference.

Provide Your Information

Your score is

The average score is 81%

0%

Qunoot e Nazilah
Dua e Hajat
4 Qul
6 Kalma
Dua-e-Akasha
Darood Akbar
Surah Fatiha
Dua-e-Ganj Ul Arsh
Dua-e-Jamilah
Ayat-ul-Kursi