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