Microsoft Excel Questions for Interview and Examination
Includes Short Questions and Multiple Choice Questions
Short Questions about Microsoft Excel
1.
Define the Spreadsheet program.
A spreadsheet is a software application that enables a user to
enter, save, calculate, analyze, sort and manage data in arranged form of rows
and columns.
2. Enlist some well-liked Spreadsheet Programs.
·
Microsoft Excel
·
Google Sheets
·
iWork Numbers
·
Lotus Symphony
·
Calc à
Open Office
3. Define the Microsoft Excel
Microsoft Excel is general-purpose electronic
spreadsheet software used to organize, sort calculate, and analyze data.
4. What is use of
Microsoft Excel?
The task you can complete with Excel ranges
from preparing a simple family budget, preparing a purchase order, checking
account information, budgets, transactions, billing invoices, create an
elaborate 3-D chart, or managing a complex accounting ledger for a medium size
business.
Teachers
can use spreadsheets to track students, calculate grades, and identify relevant
data, such as high and low scores.
5. Write the procedure to
start MS Excel
If you have an icon
on the desktop for Excel, then double-click it to open Excel.
OR
Click Start à (All) Programs à Microsoft Office à Microsoft Office Excel
6. Define the Name box in
MS Excel.
The Name
Box is the box to the left of the formula bar that displays the cell name that is
currently selected in the spreadsheet. Usually a cell name is combination of
column name and row number.
7. Define the
Formula Bar.
The
formula bar is a section in Microsoft Excel that shows the contents of the
current cell and allows you to create and view formulas.
8. Define the
Row Headings and Column Headings in MS Excel.
The row
headings are the numbers at the left side of the screen that
identify each row by number. The column heading are
the letters across the top of the worksheet grid that identify each column by
one or more letters.
9. Define the
Cell in MS Excel.
The main area of Microsoft Excel is made of cells. A cell is
the intersection of a column and a row. A cell is identified by its name and
every cell has a name.
10. Define the
Active Cell.
The active cell is the cell in which text and numbers appear
when you type. It has heavy or colored
border.
11. Define the Worksheet Tabs.
Each worksheet has a tab at the bottom that you can click to
display the worksheet. The tabs in each new worksheet have standard names
(Sheet1, Sheet2, and so on), but you can give the tabs descriptive names to
help you easily identify your worksheets.
12. Define the Workbook.
A workbook is an Excel file that contains one or more
worksheets. Each of the workbook's worksheets are in separate tabs on the
bottom of the Excel window.
13. Define the Worksheet.
An Excel worksheet is a single spreadsheet that contains
cells organized by rows and columns. A worksheet begins with row number one and
column A. Each cell can contain a number, text or formula.
14. How the data can be
entered in MS Excel worksheet?
Data can be entered in a
worksheet by two ways
1. Manual:
entered by user
2. Automatic:
where data is imported from some other systems or sources, like from
Access, SQL Server or from web etc.
15. What type of data can be
entered in MS Excel worksheet?
The data that can be entered
may be the numbers, text, dates, or
times.
16. How to accept the entered
data in MS Excel?
To accept the data, press [Enter] or an [Arrow Key] or [Tab Key] or you
can also click the check mark on the formula bar.
17. How to enter data on a new line within a cell?
To enter data on a new line within a cell, enter a line
break by pressing [Alt] + [Enter].
18. What is the right way to enter date in MS Excel?
To enter a date, use a slash mark or a hyphen to separate
the parts of a
date; for example, type 9/6/2016
or 19-Sep-2016.
19. What is the keyboard shortcut to enter current date
in MS Excel cell?
To enter the current date and time, press CTRL+;
20. What is the keyboard shortcut to enter current time
in MS Excel cell?
To enter the current date and time, press CTRL+SHIFT+;
21. Define the
formulas in MS Excel Sheets.
Formulas are equations that
perform calculations on values in your worksheet. A formula always starts with
an equal sign (=). For example, the following formula multiplies 2 by 3 and
then adds 5 to the result.
=5+2*3
22. What are arithmetic operators used in MS Excel?
Following are
the arithmetic operators
·
+ (plus
sign) for addition
·
- (minus
sign or hyphen) for subtraction
·
* (asterisk)
for multiplication
·
/ (slash)
for division
·
^ (caret)
for raising a number to an exponential power
23. Give an
example of arithmetic operations using constants
Example formula What it does?
=7+3 Adds 7 and 3
=8-2 Subtracts 2 from 8
=6/4 Divides 6 by 4
=3*2 Multiplies 3 times 2
=9^2 Raises 9 to the 2nd power
24. Give an
example of arithmetic operations using cell reference.
Example formula What it does?
=A2+B2 Adds the values in cells A2 and B2
=A3-B3 Subtracts the value in cell A3 from the value in B3
=A4/B4 Divides the value in cell A4 by the value in B4
=A5*B5 Multiplies the value in cell A5 times the value in B5
=A6^B6 Raises the value in cell A6 to the exponential value
specified
in B6
25. Define the
functions.
Functions
are predefined formulas that can be a more efficient way of performing
mathematical operations than formulas. Specifically, in many cases, a function
will simplify formulas that you can type in manually, such as average or sum.
26. What are
the categories of functions in MS Excel?
Following are
the categories of functions in MS Excel
·
Financial
·
Logical
·
Text
·
Date & Time
·
Lookup & Reference
·
Math & Trigonometric
·
Miscellaneous
27. Define
the cell range.
A
group of cells is known as a cell range. Rather than a
single cell address, you will refer to a cell range using
the cell addresses of the first and last cells in the cell
range, separated by a colon. For example, a cell range that included
cells A1, A2, A3, A4, and A5 would be written as A1:A5.
28. Give an example of SUM function
syntax.
Function
|
Example
|
Description
|
SUM
|
=SUM(A1:A15)
|
Finds
the sum of cells A1 through A15.
|
29. Give an example of Average
function syntax.
Function
|
Example
|
Description
|
AVERAGE
|
=AVERAGE(A1:G1)
|
Finds
the average of the cells A1 through G1
|
30. Give an example of Square Root
function syntax.
Function
|
Example
|
Description
|
SQRT
|
=SQRT(A5)
|
Finds
the square root of the value in A5.
|
31. Give an example of Power
function syntax.
Function
|
Example
|
Description
|
POWER
|
=POWER(B3,
2)
|
Returns
the result of a number (B3) raised to
power 2
|
32. Give an example of
Trigonometric functions syntax.
Function
|
Example
|
Description
|
SIN
|
=SIN(60) or
=SIN(B2)
|
Returns
the sine of given angle
|
COS
|
=COS(30) or
=COS(C2)
|
Returns
the cosine of the given angle
|
TAN
|
=TAN(number)
or
=TAN(D2)
|
Returns
the tangent of the given angle
|
33. Give an
example of Log function syntax.
Function
|
Example
|
Description
|
LOG
|
=LOG(number,
base) or
=LOG(50,10)
|
Returns
the logarithm of a number to the base you specify.
Logarithm
of 50 with base 10
|
34. Give an example of Count
Function syntax.
Function
|
Example
|
Description
|
COUNT
|
=COUNT(A1:C10)
|
Counts
the number of cells A1 through C10 that contain numbers
|
35. How a cell entry can be
edited?
You can edit cell entry by
doing one of the following
1. Double-click the cell that
contains the data that you want to edit.
2. Click the cell that contains
the data that you want to edit, and then press F2.
36. What are the cell editing
operations?
The table below is
showing the cell editing operations
Editing
Operation
|
Description
|
Insert characters
|
Click in the cell where you want to insert
them, and then type the new characters.
|
Delete characters
|
Click in the cell, and then press BACKSPACE,
or select the characters and then press DELETE.
|
Cancel edits
|
Press ESC to cancel any edits that you made
to the cell contents.
|
37. Define the cell formatting.
Formatting of cells in Excel
means, we change the appearance of a number
without changing the number itself. We can apply a number format (0.8, $0.80,
80%, etc) or other formatting (alignment, font, border, etc).
38. Define the Number Tab of
Format Cells dialogue box.
By using this tab, we can change the number in decimals,
provide the desired format in terms of numbers, numbers with currency symbol
& dates, convert into a percentage, fractions, etc.
39. Define the Alignment Tab
of Format Cells dialogue box.
You can
position text and numbers, change the orientation, and specify text control in
cells by using the settings on the Alignment tab. Under Text alignment, you control the horizontal alignment, the vertical alignment, and the
indention of the text in a cell.
40. Define the Font Tab of
Format Cells dialogue box.
By using this tab, you can change
the font, font color, font style, and font size. You can underline the text,
can change the font effects.
41. Define the Border Tab of
Format Cells dialogue box.
By using this tab, you can create a
colorful borderline in different types of styles. If you don’t need the border
outline or inside, you can leave it blank.
42. Define the Fill Tab of
Format Cells dialogue box.
Use the settings on the Fill tab to set the background color of the
selected cells. You can also use the Pattern Color and the Pattern Style lists to apply two-color patterns or
shading for the background of the cell. Fill Effects lets you apply a gradient fill to the
background of the cell.
43. Where the new inserted column is positioned?
When you insert a column, the new column
will be positioned on the left of the column containing the active cell.
44.
Define the Clip Art.
Clip art is Microsoft Office feature lets you easily access
and insert a wide selection of graphics, photographs, movie clips, and sound.
45. What is use of Text Box
in MS Excel?
Text box gives you more flexibility to position text
accurately. You can use text boxes to create anything from labels for chart
elements to explanatory paragraphs of text.
46. What is chart?
A chart, also called a graph, is a graphical
representation of data, in which "the data is represented
by symbols, such as bars in a bar chart, lines in a line chart,
or slices in a pie chart".
47. What are the elements of
a chart?
Following are the elements
of a chart
·
Chart Title
·
Walls
·
Grid lines
·
Category Names
·
Bars
·
Chart area
·
Axis
48. What are types of charts
in MS Excel?
Following are the types of
charts used in MS Excel
·
Column Charts
·
Bar Charts
·
Line Charts
·
Pie Charts
·
Area Charts
·
Scatter Charts
·
Other Charts
49. Define the Column
Charts.
Column charts are one of the most common chart types. A
column chart displays each data point as a vertical column, the height of which
corresponds to the value. The columns chart includes 2-D Column, 3-D Column,
Cylinder, Cone, and Pyramid chart types.
50. Define the Bar Charts.
A bar chart is
essentially a column chart that has been rotated 90 degrees clockwise. One distinct advantage to use a bar chart is
that the category labels may be easier to read.
51. Define the Line Charts.
Line charts displays values as equally
spaced points connected with a line. It is often used to plot continous data and
are useful for identifying trends over time. For example, plotting daily sales
of gold and silver as a line chart may help you to identify sales fluctuations
over time.
52. Define
the Pie Chart.
A pie chart is a
circular chart divided into
sectors, each sector shows the relative size of each value. A pie chart is
suitable for a dataset that has only one series of information.
53. Define
the Area Charts.
Area charts are similar to line charts
exceps that the area underneath the line filled with color.
54. What is
keyboard shortcut to get hard copy of worksheet?
Ctrl + P is the
keyboard shortcut to get hard copy of worksheet.
Multiple Choice Questions about Microsoft Excel
1. Spreadsheet is an electronic document
in which data is arranged in the
________________.
a. Rows b. Columns c. Both a & b d. None of these
2. Example of
Spreadsheet program is _______________.
a. MS Excel b. Google Sheets c. iWork Numbers
d. All of above
3. MS Excel is
type of _______________ software.
a. application b.
counting c. system d. firmware
4. MS Excel is
_______________software.
a. word processor b. spreadsheet c. database
d. graphic
5. The box
where the cell name displays is called __________________.
a. Cell Box b. Name Box c. Row Box
d. Column Box
6. The ____________is
the bar where the users can create and view formulas.
a. Formula Bar b. Function Bar c. Expression Bar
d. Method Bar
7. In Excel
every formula is starts with _______________ symbol.
a. # b. @ c. = d. %
8. In Excel
sheet every column heading at the top is identified by _________.
a. numbers b. symbols c. letters d. None of these
9. In Excel
sheet every row heading at the left is identified by ____________.
a. numbers b.
symbols c. letters d. None of these
10. In Excel,
Columns are labeled as ______________.
a. A, B, C, etc. b. 1, 2, 3, etc. c. A1, A2, A3, etc.
d. $A$1, $A$2, etc.
11. In Excel,
Rows are labeled as ______________.
a. A, B, C, etc. b. 1, 2, 3, etc. c. A1, A2, A3, etc.
d. $A$1, $A$2, etc.
12. How many
sheets are there, by default, when you create a new Excel file?
a. 1 b. 5 c. 3 d. 8
13. An Excel
file is generally called a ________________.
a. spreadsheet b. workbook c. sheet d. worksheet
14. The
intersection of row and column on a worksheet is called __________.
a. column b. row c. worksheet d.
cell
15. The heavy
colored border cell in which text and numbers appear when you
type _____________.
a. Bold Cell b. Colored Cell c. Active Cell
d. Inactive Cell
16. You can
activate a cell by _______________.
a. pressing the tab key b. clicking the cell
c.
pressing an arrow key d. all of above
17. What type
of data can be entered in MS Excel?
a. numbers b.
text c.
date & time d. all of
these
18. Which key
is used to accept the cell entry?
a. Enter key b.
Arrow key c. Tab key d. all of these
19. The
default alignment of text in Excel is _______________.
a. centered b. left c. right d. justify
20. The
default alignment of numbers in Excel is ______________.
a. centered b. left c. right d. justify
21. To enter
data on a new line within a cell, the _____________ shortcut key
is used.
a. Alt + Enter b. Ctrl + Enter c. Shift + Enter
d. None of above
22. To enter
the current date and time in a cell the _______________ function
is used.
a. Now b.
Today c. Date d. None of these
23. Example of
Arithmetic operators is _________________.
a. > < = b. + - * / ^ c. And Or Not
d. None of above
24. Example of
Relational operators is _________________.
a. > < = b. + - * / ^ c. And Or Not
d. None of these
25. Example of
Logical operators is _________________.
a. > < = b. + - * / ^ c. And Or Not
d. None of these
26. Identify
the symbol for exponential power.
a. * b. / c. ^ d. =
27. Identify
the symbol for multiplication.
a. * b. / c. ^ d. =
28. Identify
the symbol for division.
a. *
b. / c. ^ d. \
29. The
correct example for addition is _________________.
a. A2 + B2 b. =add(A2,B2) c. SUM(A2,B2)
d. =A2 + B2
30. The
correct example of a cell address
a. 11 22 b. 911 c. 15A d. A15
31. When you accidentally erased a
record in a sheet, the ______________
command is used to restore.
a. Insert b. Copy c. Undo d. Replace
32. The
example of formula is _________________.
a. =A1 + A2 b. =add(A1:A2) c. A1+A2
d. SUM(A1:A2)
33. The
example of function is _________________.
a. =A1 + A2 b. =SUM(A1:A2) c. A1+A2
d. =add(A1:A2)
34. Which of
the following option is correct?
a. = Average(2,3,4) b. =Average(A2:F2)
c.
=Average(A1, B1, C1) d. All of these
35. Which of
the following is correct?
a. =Power(2^3) b. =Power(2,3) c. =Power(2#3)
d. =Power(2*3)
36. The
shortcut key to edit a cell entry is ______________.
a. F1 b. F2 c. F3 d. F4
37. The
keyboard shortcut to open Format Cells dialogue box is __________.
a. Ctrl + 1 b. Ctrl + 2 c. Ctrl + 3 d. Ctrl + 4
38. Which
types of charts can excel produce?
a. Line graphs and pie charts only b. Bar charts and line graphs
only
c. Bar charts, line graphs and pie
charts d. Only line graphs
39. Which
symbol is used in cells range?
a.
;
b. : c. “ d. ?
40. Correct
example of cells range from A1 to F10 is _______________.
a. A1-F10 b.
A1; F10 c. A1: F10 d. A1.F10
41. You can
copy cell formats from one cell to another by using the _______.
a. Backspace key b. Default c. Format painter
d. Formatting toolbar
42. A value used
in a formula that does not change is called ______________.
a. Cell address b. Constant c. Function
d. Range
43. Which
formula can add all the numeric values in a range of cells?
a. Count b. Average c. Sum d. If
44. To insert
two columns between column C and D you would ___________.
a. select column C b. select column
D
c.
select column C, D, E d. select column D, E, F
45. The
default extension of MS Excel 2007 file is ______________.
a. xlsx b. xlw c. xcl d. exl
46. A diagram
or graph that shows information in a simple way.
a. picture b.
graph c. chart d. clipart
47. Which
function in Excel tells how many numeric entries are there?
a. Num b. Count c. Sum d. PI
48. What type of chart will you use to
compare performance of two cricket
team in a match?
a. Line Chart b. Pie Chart c. Column Chart
d. Dot Chart
49. The process of arranging the items
of a column in some sequence is
known as ______________.
a. arranging b. sorting c. filtering d. auto fill
50. The
__________ feature of MS Excel quickly completes a series of data.
a. Auto Fill b. Auto Complete c. Sorting
d. Filtering
51. What type of chart will you use to
compare performance of sales of four
products?
a. Column Chart b. Line Chart c. Pie Chart
d. Bubble Chart
52. The
keyboard shortcut to get printout of an Excel sheet is _____________.
a. Ctrl + E b.
Ctrl + P c. Ctrl +
R d. Ctrl + T
53. If you
require more than one hard copies of the worksheet, then enter it
in_______________ field.
a. Number of Copies b. Copies c. Copy
d. none of above
54. You can
print ________________.
a. Selection b. An entire workbook
c. A single worksheet d. All of these
55. To exit
from MS Excel program the ________________ shortcut is used.
a. Alt + F4 b.
Ctrl + F4 c. Shift + F4
d. Alt + Ctrl + F4
Answers Key
1
|
c
|
15
|
c
|
29
|
d
|
43
|
c
|
2
|
d
|
16
|
d
|
30
|
d
|
44
|
b
|
3
|
a
|
17
|
d
|
31
|
c
|
45
|
a
|
4
|
b
|
18
|
d
|
32
|
a
|
46
|
c
|
5
|
b
|
19
|
b
|
33
|
b
|
47
|
b
|
6
|
a
|
20
|
c
|
34
|
d
|
48
|
a
|
7
|
c
|
21
|
a
|
35
|
b
|
49
|
b
|
8
|
c
|
22
|
a
|
36
|
b
|
50
|
a
|
9
|
a
|
23
|
b
|
37
|
a
|
51
|
a
|
10
|
a
|
24
|
a
|
38
|
c
|
52
|
b
|
11
|
b
|
25
|
c
|
39
|
b
|
53
|
a
|
12
|
c
|
26
|
c
|
40
|
c
|
54
|
d
|
13
|
b
|
27
|
a
|
41
|
c
|
55
|
a
|
14
|
d
|
28
|
b
|
42
|
b
|
2 Comments
Click here for CommentsUseful post
Replynyc
ReplyConversionConversion EmoticonEmoticon