150 very important Excel MCQs for test and interview

141. Charts tips, can:

a. Show the formatting, of a data label,

b. Show the, name of a data series,

C. Show the, value of data point,

d. b and c,

142. The Name box,

a. Shows the location, of the previously active cell,

b. Appears the, left of the formula bar,

C. Appears, below the status bar,

d. Appears, below the menu bar,

143. 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 the column,

d. All ,

144. When you, work with large worksheets, you may need to,

a. size the worksheet, to fit on the specific, number of pages

b. add and remove, page breaks,

C. specify only, certain print areas,

d. all of above

145. “Hyperlinks “cannot be:

a. Special shapes like stars. and banners

b. Drawing objects. like rectangles ovals.

C. Pictures.

d. All can be hyperlinks.

146. You can use the. horizontal and vertical. scroll bars to

a. Split a worksheet. into two panes.

b. View different. rows and columns.

C. Edit the contents. of a cell

d. View different worksheets.

147. What do we call. a computer program. that organizes data in. rows and columns of cells? You might use this. type program to keep. a record of the money you. earned moving lawns over. the summer.

a. Spreadsheet program.

b. Database program.

C. Word processor program.

d. Desktop publisher program.

148. You can add. an image to a template. by clicking the Insert. Picture From File button. on the .. Toolbar.

a. Standard.

b. Formatting.

C. Drawing.

d. Picture.

149. What function. displays row data. in a column or .column data in. a row?

a. Hyperlink.

b. Index.

c. Transpose.

d. Rows.

150. When you. insert an Excel file. into a Word document, the data. are:

a. Hyperlinked.

b. Placed in a word, table.

c. Linked.

d. Embedded.