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