A. Labels, values, and formulas
B. Labels and values but not formulas
C. Values and formulas but not labels
D. Formulas only
✅ The correct answer is option A.
MS Excel MCQs
You can use drag-and-drop to embed excel worksheet data in a word document
A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D. None of above
✅ The correct answer is option A.
Rounding errors can occur
A. When you use multiplication, division, or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places that the calculated results
✅ The correct answer is option A.
A worksheet can have a maximum of ________ number of rows.
A. 256
B. 1024
C. 65535
D. 1048576
✅ The correct answer is option D.
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.
An excel workbook is a collection of
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts
✅ The correct answer is option D.
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.
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.
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.
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.