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