MS excel set 1 Detailed Explanation And More Example

Question : 1

There are three types of data found in a spreadsheet

a) numbers formulas, labels

b) words, numbers, labels

c) equations, data, numbers

d) data, words, numbers

Question : 2

In Excel the following describes how to select all the cells in a single column?

a) Use data – text to columns menu item

b) Right click on column and select Pick from list

c) Pressing Ctrl + A on the keyboard

d) Left click on the gray column title button

Question : 3

In Excel which symbol must all formula begin with?

a) @

b) (

c) +

d) =

Question : 4

In Excel when you group worksheets

a) You can enter common data, formats, and formulas on multiple worksheets at one time

b) You can print more than one worksheet at a time

c) You can enter variable data on multiple worksheets at one time

d) (B) and (C)

Question : 5

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 : 6

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