1.
MS Excel is …… Program.
Database
Spread Sheet
Graphics
None of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
2.
The latest version of MS Excel is ……
Excel 2013
Excel 2019
Excel 2016
Excel 2010
Answer: Option
Discuss about this problem:
Discuss in Forum
3.
MS Excel is a software developed by ……
Microsoft Corporation
Apple Corporation
Bill Gates Foundation
Office Systems Corporation
Answer: Option
Discuss about this problem:
Discuss in Forum
4.
.xls is the file extension for …… 2003.
MS Word
MS XLS
MS Excel
Non of the Above
Answer: Option
Discuss about this problem:
Discuss in Forum
5.
Which menu option can be used to split windows into two?
Format > Windows
View > Window > Split
Windows > Split
View > Split
Answer: Option
Discuss about this problem:
Discuss in Forum
6.
Which symbol must all formula begin with in MS Excel?
7.
To select multiple non-adjacent cell in a worksheet you will click them by holding……
Ctrl Key
Alt Key
Shift Key
Ctrl + Shift Key
Answer: Option
Discuss about this problem:
Discuss in Forum
8.
How do you wrap the text in a cell?
Format, Cells, Font
Format, Cells, Protection
Format, Cells, Number
Format, Cells, Alignment
Answer: Option
Discuss about this problem:
Discuss in Forum
9.
Excel recognizes a cell by ……
Number
Cell Name
Column Number and Row Letters
Row Letter and Column Number
Answer: Option
Discuss about this problem:
Discuss in Forum
10.
The cell reference $C$1 is a ……
Relative Cell Reference
Absolute Cell reference
Mixed Cell Reference
None of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
11.
The formula in MS Excel start with……
Divide (/)
Plus (+)
Equal (=)
None of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
12.
What is the maximum length of formula content in MS Excel?
512 characters
8192 characters
1024 characters
16384 characters
Answer: Option
Discuss about this problem:
Discuss in Forum
13.
Function to get the sum of the cell contents of the cell A1, A2, B1, B2 is …
=SUM(A1:B2)
=ADD(A1+A2+B1+B2)
=TOTAL(A1:B2)
=SUM(A1,B2)
Answer: Option
Discuss about this problem:
Discuss in Forum
14.
Which of the following is not valid data type in MS Excel?
15.
The default header for a worksheet is ……
Username
Date & Time
Sheet Tab Name
None of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
16.
How many characters can be typed in a single cell in excel?
17.
Conditional count can be done in MS Excel by using the …… formula.
18.
What is the correct way to refer the cell A1 on sheet2 from sheet1?
"=sheet2!A1"
"=sheet1!A1"
"=sheet3:A1"
"=A1"
Answer: Option
Discuss about this problem:
Discuss in Forum
19.
In MS Excel, what is a data series ?
A type of chart
A cell reference
A collection of related data
A division of results
Answer: Option
Discuss about this problem:
Discuss in Forum
20.
Types of charts available in excel are ……
Bar Chart
Pie Chart
Column Chart
All of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
21.
In MS Excel, we can print……
A single worksheet
A range of cells
Entire workbook
All of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
22.
Which is not a data type in MS Excel cell?
23.
What is the shortcut key to hide entire row?
24.
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
Answer: Option
Discuss about this problem:
Discuss in Forum