Microsoft Excel Section 1 Page 1


1.
MS Excel is …… Program.
Database
Spread Sheet
Graphics
None of the above
Answer: Option

2.
The latest version of MS Excel is ……
Excel 2013
Excel 2019
Excel 2016
Excel 2010
Answer: Option

3.
MS Excel is a software developed by ……
Microsoft Corporation
Apple Corporation
Bill Gates Foundation
Office Systems Corporation
Answer: Option

4.
.xls is the file extension for …… 2003.
MS Word
MS XLS
MS Excel
Non of the Above
Answer: Option

5.
Which menu option can be used to split windows into two?
Format > Windows
View > Window > Split
Windows > Split
View > Split
Answer: Option

6.
Which symbol must all formula begin with in MS Excel?
#
*
=
$
Answer: Option

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

8.
How do you wrap the text in a cell?
Format, Cells, Font
Format, Cells, Protection
Format, Cells, Number
Format, Cells, Alignment
Answer: Option

9.
Excel recognizes a cell by ……
Number
Cell Name
Column Number and Row Letters
Row Letter and Column Number
Answer: Option

10.
The cell reference $C$1 is a ……
Relative Cell Reference
Absolute Cell reference
Mixed Cell Reference
None of the above
Answer: Option

11.
The formula in MS Excel start with……
Divide (/)
Plus (+)
Equal (=)
None of the above
Answer: Option

12.
What is the maximum length of formula content in MS Excel?
512 characters
8192 characters
1024 characters
16384 characters
Answer: Option

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

14.
Which of the following is not valid data type in MS Excel?
Number
Character
Label
Date/Time
Answer: Option

15.
The default header for a worksheet is ……
Username
Date & Time
Sheet Tab Name
None of the above
Answer: Option

16.
How many characters can be typed in a single cell in excel?
256
1024
32767
65535
Answer: Option

17.
Conditional count can be done in MS Excel by using the …… formula.
=count
=ifcount
=iffcount
=countif
Answer: Option

18.
What is the correct way to refer the cell A1 on sheet2 from sheet1?
"=sheet2!A1"
"=sheet1!A1"
"=sheet3:A1"
"=A1"
Answer: Option

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

20.
Types of charts available in excel are ……
Bar Chart
Pie Chart
Column Chart
All of the above
Answer: Option

21.
In MS Excel, we can print……
A single worksheet
A range of cells
Entire workbook
All of the above
Answer: Option

22.
Which is not a data type in MS Excel cell?
Label
Value
Formula
Comment
Answer: Option

23.
What is the shortcut key to hide entire row?
Ctrl + H
Ctrl + R
Ctrl + 9
Ctrl + -
Answer: Option

24.
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
Answer: Option

25.
The intersection of row and column is called……
An equation
Data, Form
A field
A Cell
Answer: Option

#buttons=(Ok, Go it!) #days=(20)

Our website uses cookies to enhance your experience. Check Now
Ok, Go it!