[amp_mcq option1=”Cell names” option2=”Column numbers and row letters” option3=”Column letters and row numbers” option4=”Cell locator coordinates” correct=”option3″]
Ms excel
2. The auto calculate feature A. Can only add values in a range of cells B. Provides a quick way to view the result of an arithmetic operation on a range of cells C. Automatically creates formulas and adds them to a worksheet D. A and C
[amp_mcq option1=”Can only add values in a range of cells” option2=”Provides a quick way to view the result of an arithmetic operation on a range of cells” option3=”Automatically creates formulas and adds them to a worksheet” option4=”A and C” correct=”option2″]
3. 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
[amp_mcq option1=”Auto formatting” option2=”Applying styles” option3=”Changing fonts” option4=”all of above” correct=”option4″]
4. 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
[amp_mcq option1=”By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key” option2=”By dragging a range of excel data to the word button on the taskbar while pressing Shift key” option3=”By dragging a range of excel data to the word button on the taskbar while pressing Alt key” option4=”None of above” correct=”option1″]
5. Concatenation of text can be done using A. Apostrophe (‘) B. Exclamation (!) C. Hash (#) D. Ampersand (&)
[amp_mcq option1=”Apostrophe (‘)” option2=”Exclamation (!)” option3=”Hash (#)” option4=”Ampersand (&)” correct=”option4″]
6. A numeric value can be treated as a label value if it precedes with A. Apostrophe (‘) B. Exclamation (!) C. Hash (#) D. Ampersand (&)
[amp_mcq option1=”Apostrophe (‘)” option2=”Exclamation (!)” option3=”Hash (#)” option4=”Ampersand (&)” correct=”option1″]
7. Tab scrolling button A. Allow you to view a different worksheet B. Allow you to view additional worksheet rows down C. Allow you to view additional worksheet columns to the right D. Allow you to view additional sheets tabs
[amp_mcq option1=”Allow you to view a different worksheet” option2=”Allow you to view additional worksheet rows down” option3=”Allow you to view additional worksheet columns to the right” option4=”Allow you to view additional sheets tabs” correct=”option1″]
8. A worksheet range is a A. A command used for data modeling B. A range of values such as from 23 to 234 C. A group of cells D. A group of worksheets
[amp_mcq option1=”A command used for data modeling” option2=”A range of values such as from 23 to 234″ option3=”A group of cells” option4=”A group of worksheets” correct=”option3″]
9. 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
[amp_mcq option1=”A chart legend” option2=”A collection of chart data markers” option3=”A set of values you plot in a chart” option4=”A data label” correct=”option2″]
10. Which of the following is not an example of a value? A. 350 B. May 10, 2001 C. 0.57 D. Serial Number 50771
[amp_mcq option1=”350″ option2=”May 10, 2001″ option3=”0.57″ option4=”Serial Number 50771″ correct=”option4″]