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