MS excel set 3 Detailed Explanation And More Example

Question : 1

Which button do you click to add up a series of numbers?

a) The autosum button

b) The Formula button

c) The quicktotal button

d) The total button

e) None of these

Question : 2

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

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

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

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

Question : 6

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you

a) Press the Erase key

b) Press Esc

c) Press the Enter button

d) Press the Edit Formula button

e) None of these