MS Excel Quiz-1
1 / 50
A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
2 / 50
It is a collection of data that is stored electronically as a series of records in a table.
3 / 50
_____ creates a chart of the data in the current range.
4 / 50
Excel is a program that is used to prepare a
5 / 50
Cuts the selected cells
6 / 50
How many rows are there in old version of MS Excel?
7 / 50
In Excel, Rows are labelled as ______
8 / 50
Merge cells option can be applied from
9 / 50
_____ are equations that perform calculations on values in your worksheet.
10 / 50
Excel documents are stored as files called
11 / 50
Functions in MS Excel must begin with ___
12 / 50
How will you graphically represent expenditure in different departments ?
13 / 50
A ____ is rectangular grid of rows and columns used to enter data.
14 / 50
___ operator, combines multiple references into one reference.
15 / 50
____ appear at the bottom of the Excel window.
16 / 50
In Excel, Columns are labelled as ___
17 / 50
If you need a text to show vertically in a cell. How will you achieve this?
18 / 50
In A3 cell edit = A1 + A2 refers to
19 / 50
On an Excel sheet, the active cell is indicated by
20 / 50
How many columns are there in old version of MS Excel?
21 / 50
____ is a powerful tool used to create and format spreadsheets.
22 / 50
In a spreadsheet program, the ___ contains related worksheets and documents.
23 / 50
# VALUE! Refers to ___
24 / 50
Can you set 0.5 inch left indentation for a cell in Excel?
25 / 50
In ______ tab you will find AutoSum button.
26 / 50
DOS based spreadsheet package is
27 / 50
A formula in Excel always begins with an ____
28 / 50
Formatting a cell in Currency, you can specify
29 / 50
By default the cell content alignment is
30 / 50
____ returns the least common multiple.
31 / 50
Forms that are used to organise business data into rows and columns are called
32 / 50
____ was the first spreadsheet on a microcomputer.
33 / 50
Formulas in Excel are made up of ___
34 / 50
How many sheets are there, by default, when we create a new Excel file ?
35 / 50
Pre-defined and built in formulas in Excel are known as
36 / 50
____ is the intersection of a row with a column.
37 / 50
______ moves to the previous cell in a worksheet or the previous option in a dialog box.
38 / 50
A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______
39 / 50
An Excel file is generally called a / an :
40 / 50
______ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.
41 / 50
In Excel, which one denoted a range from B1 through E5
42 / 50
In which tab wrap text feature is present in MS Excel 2007?
43 / 50
A features that displays only the data in column (s) according to specified criteria
44 / 50
______ inserts a new worksheet.
45 / 50
______ specify the type of calculation that you want to perform on the elements of a formula.
46 / 50
Another name for a pre-programmed formula in Excel is
47 / 50
How can you remove borders applied in cells?
48 / 50
____ sign is used to create an absolute cell reference.
49 / 50
In a spreadsheet, a ____ is a number you will use in a calculation.
50 / 50
Formatting a cell in Number format you can?t set
Provide Your Information
Your score is
The average score is 81%
Restart quiz
