Tuesday, 25 February 2014

Microsoft Excel 14

131. To center worksheet titles across a range of cell, you must
a. Select the cells containing the title text and use the fill handle to center the text across a range of cells
b. Widen the columns
c. Select the cells containing the title text and use the fill handle to center the text across a range of cells
d. Widen the column

132. When integrating Ms-Word and Excel, Word is usually the
a. Server                                                 b. Source
c. Client                                                   d. None

133. 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

134. The Name box
a. Shows the location of the previously active cell
b. Appears t the left of the formula bar
c. Appears below the status bar
d. Appears below the menu bar

135.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

136. 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

137. Hyperlinks cannot be
a. Special shapes like stars and banners 
b. Drawing objects like rectangles ovals
c. Pictures
d. All can be hyperlinks

138. 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

139. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of 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

140. 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

No comments:

Post a Comment