MS excel set 3 Detailed Explanation And More Example

Question : 1

In Excel how do you select an entire column?

a) Select Edit > Select > Column from the menu

b) Click the column heading letter

c) Hold down the shift key as you click anywhere in the column.

d) Hold down the Ctrl key as you click anywhere in the column

Question : 2

How do you tell one cell from another?

a) By numbers

b) By letters

c) By its address

d) by color

e) None of these

Question : 3

What do you mean by a Workspace?

a) Group of Columns

b) Group of Worksheets

c) Group of Rows

d) Group of Workbooks

e) None of these

Question : 4

How do you change column width to fit the contents?

a) Single-click the boundary to the left to the column heading

b) Double click the boundary to the right of the column heading

c) Press Alt and single click anywhere in the column

d) All of above

e) None of these

Question : 5

In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button

a) nothing will print because some cells with data have been omitted

b) only the cells with gray background will print

c) the whole sheet will print

d) only the cells with white background will print

Question : 6

In Excel you can add a hyperlink to your worksheet by pressing

a) Alt + K

b) Ctrl + H

c) Ctrl + K

d) Ctrl + Shift + K