41. A worksheet can have a maximum of ________ number of rows.
A. 256
B. 1024
C. 65535
D. 1048576
✅ The correct answer is option D.
MS Excel MCQs
42. To copy formatting from one area in a worksheet and apply it to another area you would use:
A. The Edit > Copy Format and Edit>Paste Format commands form the menu
B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
C. There is no way to copy and apply formatting in Excel – You have to do it manually
D. The Format Painter button on the standard toolbar
✅ The correct answer is option D.
43. An excel workbook is a collection of
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts
✅ The correct answer is option D.
44. Data can be arranged in a worksheet in a easy to understand manner using
A. Auto formatting
B. Applying styles
C. Changing fonts
D. all of above
✅ The correct answer is option D.
45. Which of the following is not an example of a value?
A. 350
B. May 10, 2001
C. 0.57
D. Serial Number 50771
✅ The correct answer is option D.
46. To create a formula, you can use:
A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
✅ The correct answer is option D.
47. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A. Unfreeze panes command on the window menu
B. Freeze panes command on the window menu
C. Hold titles command on the edit menu
D. Split command on the window menu
✅ The correct answer is option B.
48. All worksheet formula
A. Manipulate values
B. Manipulate labels
C. Return a formula result
D. Use the addition operator
✅ The correct answer is option C.
49. The chart wizard term data series refers to
A. A chart legend
B. A collection of chart data markers
C. A set of values you plot in a chart
D. A data label
✅ The correct answer is option B.
50. Files created with Lotus 1-2-3 have an extension
A. DOC
B. XLS
C. 123
D. WK1
✅ The correct answer is option C.