1. The Default row height in an MS Excel worksheet is ……points.
a. 10.75
b. 12.75
c. 13.75
d. 15.75
2. Which of the following formula is true in MS Excel?
a. B6 + C6
b. =B6+C6
c. A6+B6=
d. A6+C6=
3. The operator used to combine text from two cells into one cell.
a. & (ampersand)
b. = (Equal sign)
c. (Space)
d. All of the above
4. Which symbol is used before a number to make it into a label in MS-Excel?
a. “(Quote)
b. = (Equal)
c. _ (Underscore)
d. ^ (apostrophe)
5. Which of the following is not a valid data type in MS Excel?
a. Number
b. Character
c. Label
d. Data/time
6. In MS Excel, comments put in cells are called ……
a. Smart tip
b. Cell tip
c. Web tip
d. Soft tip
7. A workbook is a collection of:
a. Cells
b. Worksheets
c. Workspaces
d. Projects
8. Shortcut key to bring the format cell dialog box is:
a. Ctrl + F
b. Ctrl + E
c. Ctrl + 1
d. Ctrl + D
9. The cell reference $A$5 is a ……
a. Relative cell reference
b. Absolute cell reference
c. Mixed cell reference
d. None of the above
10. ‘OR’ operator shows ‘TRUE’ value when…
a. All conditions are false
b. Any one condition is true
c. Both conditions are true
d. Both B & C
11. XLS is the file extension for …… 2003.
a. MS Word
b. MS Xls
c. MS Excel
d. None of the above
12. The formulas in MS Excel start with ……
a. / (divide)
b. + (Plus)
c. = (Equal)
d. None of the above
13. The advantage of using the spreadsheet is:
a. Calculations can be done automatically
b. Changing data automatically updates calculations
c. More flexibility
d. All of the above
14. These are the three types of data found in spreadsheets:
a. Data, words, numbers
b. Equations, data, numbers
c. Words, Numbers, labels
d. Numbers, formulas, labels
15. To merge a cell, which tab do you use from the format menu?
a. Number tab
b. Alignment tab
c. Font tab
d. Merge tab
16. How do you rearrange the data in ascending or descending order?
a. Data, sort
b. Data, form
c. Data, table
d. Data, subtotal
17. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #A#1
d. A1
18. Which symbol formula begins with?
a. =
b. +
c. (
d. @
19. To add two cells (A1 and A2) together, you use the following formula:
a. =A1+A2
b. =add (A1+A2)
c. =together (A1:A2)
d. A1 plus A2
20. On the Excel sheet, the active cell is indicated by:
a. A dark, wide border
b. A dotted border
c. A blinking border
d. None of the above
21. You can create hyperlinks from the Excel workbook to:
a. A webpage on the company intranet
b. A webpage on the internet
c. Other Office 97 application documents
d. All of the above
22. The cell labeled F5 refers to:
a. Function key F5
b. Row F column 5
c. Column F row 5
d. Functions available in the cell
23. In MS Excel 2007 or later, comments can be added to cells using:
a. Insert Tab → New Comment
b. Review Tab → New Comment
c. Data Tab → New Comment
d. Formula Tab → New Comment
24. How to display the current date and time in MS Excel?
a. Time()
b. Date()
c. Today()
d. Now()
25. In MS Excel, B7:B9 indicates:
a. Cell B8 only
b. Cell B7 and cell B9 only
c. Cell B7 through B9
d. None of the above
26. In MS Excel, what happens when dollar signs ($) are entered in a cell address (e.g., $B$2:$B$10)?
a. The status bar does not display the cell address
b. An absolute cell address is created
c. Cell address will change when copied to another cell
d. The sheet tab is changed
27. In MS Excel, what is a workspace?
a. Group of workbooks
b. Group of columns
c. Group of worksheets
d. Group of rows
28. Which of the following is a popular DOS-based spreadsheet package?
a. Lotus 1-2-3
b. Word
c. Smart cell
d. Excel
29. The intersection of a row and column is called:
a. An equation
b. Data
c. A field
d. A cell
30. Which of the following is the latest version of Excel?
a. Excel 2000
b. Excel 2002
c. Excel 2019
d. Excel 2013
31. How many characters can be typed in a single cell in Excel?
a. 256
b. 1024
c. 32,000
d. 65,535
32. In MS Excel 2003, a worksheet can have a maximum of ___ number of rows.
a. 256
b. 1024
c. 32,000
d. 65,536
33. In MS Excel 2003, a typical worksheet has ___ number of columns.
a. 128
b. 256
c. 512
d. 1024
34. In MS Excel 2003, comments can be added to cells using:
a. Edit → Comments
b. Insert → Comment
c. File → Comments
d. View → Comments
35. Which menu option can be used to split windows into two?
a. Format → Window
b. View → Window → Split
c. Window → Split
d. View → Split
36. Getting data from a cell located in a different sheet is called ___.
a. Accessing
b. Referencing
c. Updating
d. Functioning
37. Which elements of a worksheet can be protected from accidental modification?
a. Contents
b. Objects
c. Scenarios
d. All of the above
38.  Data can be arranged in a worksheet in an easy-to-understand manner using:
a. Auto Formatting
b. Applying Styles
c. Changing fonts
d. All of these
39. Which area in an Excel window allows entering values and formulas?
a. Title Bar
b. Menu Bar
c. Formula Bar
d. Standard Tool Bar
40. Multiple calculations can be made in a single formula using:
a. Standard Formulas
b. Array Formula
c. Complex Formulas
d. Smart Formula
41. In Excel, when the result is too long to fit in a cell, what will be displayed?
a. #N/A
b. #Num
c. Err
d. ####
42. To organize data in a list alphabetically, numerically, or chronologically is known as:
a. Filter
b. Sort
c. Match
d. Drag
43. What is the correct syntax of the TRUNC function?
a. TRUNC(number,[num_digits])
b. TRUNC(number)
c. TRUNC(number, num_digits, type)
d. None of the above
44. Which is a spreadsheet package?
a. Lotus
b. Excel
c. Quattro Pro
d. All of the above
45. Which is the shortcut key for row hide?
a. Ctrl+9
b. Ctrl+F9
c. Ctrl+Shift+F9
d. Shift+F9
46. How many sheets are there in an Excel workbook?
a. 3
b. Many
c. 2
d. 1
47. What is the function of a workspace?
a. Contains multiple workbooks
b. Contains multiple worksheets
c. Contains multiple cells
d. All
48. What is the name of an Excel file?
a. Workbook
b. Worksheet
c. Spreadsheet
d. Spreadbook
49. Category is written in:
a. X-axis
b. Y-axis
c. Both
d. None
50. What is the function of a filter?
a. Display the records that meet the criteria
b. Display only one record to delete
c. Modify all the records at once
d. All of the above
Click here to practice MS Excel Set-1, Set-2