MS excel set 8 Detailed Explanation And More Example

Question : 1

In Excel you can select a single range of cells by

a) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b) Pressing the Ctrl key while dragging over the desired cells

c) Pressing the Shift key and an arrow key

d) Dragging over the desired cells

Question : 2

Comments put in cells are called

a) Smart tip

b) Cell tip

c) Web tip

d) Soft tip

e) None of these

Question : 3

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

a) AutoFill

b) Auto correct

c) Auto sum

d) Auto format

e) None of these

Question : 4

In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

a) None of these

b) Select Format > Money from the menu

c) Click the Currency Style button on the formatting toolbar

d) You have to retype everything and manually add the dollar signs, commas, and decimals.

Question : 5

Which of the following is not a term of MS-Excel?

a) Cells

b) Rows

c) Columns

d) Document

e) None of these

Question : 6

When you link data maintained in Excel workbook to a Word document

a) The Word document cannot be edited

b) The Word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data