MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel which of the following is not a worksheet design criterion

a) Auditability

b) Efficiency

c) Clarity Correct Answer:

d) Description

Question : 2

In Excel you can edit a cell by

a) Selecting Edit>Edit Cell from the menu

b) Clicking the formula button

c) Double clicking the cell to edit it in-place

d) None of above

Question : 3

In Excel when you use the fill effects in the format data series dialog box, you cannot

a) Select a fore ground color

b) Select a pattern

c) Select a background color

d) Rotate text on the chart

Question : 4

In Excel using the F11 shortcut key to create a chart on chart sheet creates

a) A 2-dimensional column chart

b) A default chart

c) A 3-dimensional line chart

d) A 2-dimensional bar chart

Question : 5

In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu

a) Format

b) Edit

c) View

d) Tools

Question : 6

In Excel to activate the previous cell in a preselected range, press

a) The Enter key

b) The Alt key

c) The Tab key

d) None of the above