PVG’S College of Engineering and

S.S Dhamankar Institute of Management, Nashik

Subject: - Ms-Excel (Question Bank)
1. under which menu, we can insert Header and Footer on the sheet?
A. Format
B. Review
C. Data
D. Insert
Answer: D) Insert

2. How to remove borders applied in Cells?

A. Select None on the Border tab of Format cells

B. Open the list on the Border tool in the Format Cell toolbar then choose the first tool
(none)
C. Both of above
D. None of above

Answer: D) None of the above

3. _____ is not a valid data type in MS Excel.

A. Number
B. Character
C. Label
D. Date/ Time

Answer: B) Character

4. What is MS Excel?

A. Spreadsheet
B. Database Management
C. Presentation
D. Workbook

Answer: A) Spreadsheet

5. What is the row limit of MS Excel 2019?

A. 4,81,0576
B. 1,048,576
C. 1,57,648
D. 1,63, 84

Answer: B) 1,048,576

6. In Microsoft Excel spreadsheets, rows are designated as _______.

A. 1, 2, 3,...
B. A, B, C,...
C. A1, B1, C1, ....
D. I, II, III,...

Answer: A) 1, 2, 3, ....

7._____ logical function indicates TRUE only if all arguments are assessed as TRUE, and
FALSE otherwise.

A) OR

B) AND

C) IF

D) ANDIF

Answer: B) AND

8. The intersection of a column and a row in a worksheet is called____

A. Column
B. Address
C. Value
D. Cell

Answer: D) Cell

9. The Greater Than sign (>) exemplifies a/an _____ operator.

A. Arithmetic
B. Conditional
C. Logical
D. Greater

Answer: C) Logical
10. ____ is the correct syntax of IF() Function.

A. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

B. =IF (logical_test, [value_if_true], [value_if_false])
C. =IF (logical_test, {[value_if_true]}, {[value_if_false]})
D. =IF (logical_test: [value_if_true], [value_if_false])

Answer: B) =IF (logical_test, [value_if_true], [value_if_false])

11. ____ type of chart is good for a single series of data.

A. Column chart
B. Cone chart
C. Line chart
D. Pie chart

Answer: D) Pie chart

12. What do Excel formulas start with?

A) /

B) f

C) =

D).–

Answer: C) =

13. Name the keyboard shortcut to use to switch between open Excel windows.

A) CTRL + TAB

B) ALT + TAB

C) CTRL + ALT + TAB

D) None of the above

Answer: A) CTRL + TAB

14. What is an Excel feature that displays only the data in column (s) according to specified
criteria?

A. Filtering
B. Sorting
C. Formula
D. Pivot

Answer: A) Filtering

15. ____ is not a function in Excel.

A. SUM
B. MIN
C. SUBTRACT
D. MAX

Answer: C) SUBTRACT()

16. _____ Excel function returns TRUE or FALSE based on two or more conditions

A. =AVERAGEIFS
B. =CONCAT
C. =COUNTA
D. =AND

Answer: D) =AND

17. Why is the =COUNTIF function in Excel used?

A. Counts cells as specified

B. Counts blank cells in a range
C. Counts cells with numbers in a range
D. Returns values based on a TRUE or FALSE condition

Answer:

A) Counts cells as specified

18. In MS Excel, the keyboard shortcut “Ctrl+S” can be used to_______

A. Save As
B. Save
C. Start new workbook
D. Switch between the opened tab

Answer: B) Save

19. Which keyboard shortcut is used to easily switch open workbooks?

1. Alt+S
2. CTRL+S
3. CTRL+Alt
4. CTRL+Tab

Answer: D) Ctrl+D

20. ____ happens when you select a cell in MS Excel and type “=B25”

A. The selected cell will show an error message

B. Selected cells will show “=B24”
C. Selected cells will show the same value as in B25
D. Selected cells will be blank

Answer: C)

Selected cells will show the same value as in B25

21. Microsoft Excel uses the _________ function to calculate the results in the data table
A. ‘RESULT’

B. ‘CALTAB’

C. ‘TABLE’

D. ‘AUTOSUM

Answer: C) TABLE
22. Which one is not a function in ms excel?
A. PROPER

B. AVERAGE

C. COUNT

D. CLEAR

Answer: D) CLEAR

23. Which function is used to create a date with year, month, and day?
A. DATE()
B. DATEDIF()
C. DATEVALUE()
D. CURDATE()
Answer: A) DATE()
24. In MS Excel, 'Merge and Center' is used to ____.
A. Combine and center the content of the selected cell
B. Combine and center the content of the current row
C. Concatenate the text of the two cells and returns the text
D. None of the above
Answer: A) Combine and center the content of the selected cell
25. Which feature is used to wrap extra-long text into multiple lines in MS Excel?
A. Word Wrap
B. Letter Wrap
C. Text Wrap
D. Wrap Text
Answer: D) Wrap Text
26. ich feature is used to rotate the text diagonally or vertically of the selected cells in MS
Excel?
A. Orientation
B. Text Layout
C. Text Flip
D. Cell Orientation
Answer: A) Orientation
27. under which Tab, the chart options are available in MS Excel?
A. Data
B. Insert
C. Review
D. View
Answer: B) Insert
28. Which chart type is used to visually compare values across a few categories?
A. Area Chart
B. Bar Chart
C. Doughnut Chart
D. Hierarchy Chart
Answer: B) Bar Chart
29. Which option allows you to display all numbers which are less than 0 (negative
numbers) in red color in MS Excel?
A. Styling
B. Conditional Formatting
C. Compare Formatting
D. Special Formatting
Answer: B) Conditional Formatting
30. Show/Hide Gridlines option is available in the ____ Menu.
A. Page Layout
B. Data
C. Insert
D. Format
Answer: A) Page Layout
31. Which option is used to quickly convert a range of cells to a table with its own style
converted in MS Excel?
A. Table Styles
B. Stylish Cells
C. Format as Table
D. Cells as Table
Answer: C) Format as Table
32. Which function is used to find the position of a specific character or text within a string
of text in Excel?

a) FILTER
b) SORT
c) SEARCH
d) FIND

Answer: d) FIND.

33. Which function is used to join two or more strings of text together in Excel?

a) TEXT
b) VALUE
c) CONCATENATE
d) LEFT
Answer: c) CONCATENATE

34) ___ appear at the bottom of the Excel window.

(A) Title bar
(B) Formula bar
(C) Work sheet tabs
(D) Name box
Answer: (C) Work sheet tabs

35) Formulas in Excel are made up of ___

(A) Arithmetical operators and functions
(B) Only arithmetic operators
(C) Only symbols
(D) Only functions
Answer: (A) Arithmetical operators and functions

36) The result is a ___ value either TRUE or FALSE.

(A) Logical
(B) Arithmetic
(C) Algorithm
(D) Logarithm
Answer: (A) Logical

38) _____ are equations that perform calculations on values in your worksheet.
(A) Functions
(B) References
(C) Formulas
(D) Constants
Answer: (C) Formulas

39) In ______ tab you will find AutoSum button.

(A) Formatting tab
(B) Formulas tab
(C) Standard tab
(D) Clipboard tab

Answer: (B) Formulas tab

40) This dialog box specifies or modifies the worksheet cell range containing
data to be charted.
(A) Chart Location
(B) Chart Style
(C) Chart Options
(D) Chart Source Data
Answer: (D) Chart Source Data

41) The default file extension of MS Excel is

(A) Xlr
(B) Exe
(C) Xls
(D) Exl
Answer: (C) Xls

42) In a spreadsheet, letters are used to represent _____________

a) Cells
b) Rows
c) Columns
d) Blocks
Answer: c) Columns

43) Which of the following isn’t a part of a spreadsheet?

a) Row number
b) column number
c) column letter
d) cell address
Answer: b) column number

44) ______________ help us to see patterns.

a) Spreadsheets
b) Calculations
c) Charts
d) Graphs
Answer: c) Charts

45) The placement of information within a cell at the left edge, right edge, or centered is:
a) Indentation
b) Placement
c) Identification
d) Alignment
Answer: d) Alignment

46) What is the default file name of Microsoft Excel file?

A. Workbook.xlsx
B. Workbook1.xlsx
C. Worksheet.xlsx
D. Worksheet1.xlsx
Answer: B) Workbook1.xlsx

47) Microsoft Excel is used for?

A. Analysis
B. Data Entry
C. Data Management
D. Accounting
E. Budgeting
F. All of the above
Answer: F) All of the above

48) Select correct statement

A. Each Excel workbook can contain multiple worksheets.

B. Each Excel worksheet can contain multiple workbooks.

C. Each Excel workbook can contain multiple spreadsheets.

D. Each Excel worksheet can contain multiple spreadsheets.

Answer: A. Each Excel workbook can contain multiple worksheets.

49) The __ feature of ms excel quickly completes a series of data.

A. Auto Filter

B. Auto Complete

C. Auto Fill

D. Auto Sum

Answer: C. Auto Fill

50) _________function in MS Excel worksheet represents the total number(s) of entries in

the cell(s).
A. SUM

B. AVG

C. COUNT

D. TOTAL

Answer: C. COUNT