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
