Ms Excel Mcqs for ( NTS, PTS, KPPSC, FPSC,PPSC SPSC, OTS, ETEA) Set 8

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 t 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 in the column
d. All of above



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

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 

151. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
a. IF
b. AND
c. OR
d. NOT

152. Macros are “run” or executed from the ….. menu.
a. Insert
b. Frmat
c. Tools
d. Data

153. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
a. Insert
b. Format
c. Tools
d. Data

154. Each excel file is called a workbook because
a. It can contain text and data
b. It can be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it

155. Which types of charts can excel produce?
a. Line graphs and pie charts only
b. Only line graphs
c. Bar charts, line graphs and pie charts
d. Bar charts and line graphs only

156. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width

157. What does the VLOOKUP function do?
a. Looks up text that contain ‘v’
b. Checks whether text is the same in one cell as in the next
c. Finds related records
d. All of above

158. Gridlines
a. May be turned off for display but turned on for printing
b. May be turned on or off for printing
c. The be turned off for display and printing
d. a, b and c 

159. You can print only an embedded chart by
a. Moving the chart to a chart sheet before you print.
b. Formatting the chart before you print
c. Selecting the chart before you print
d. a  and c

160. Which of the following is a correct order of precedence in a formula calculation?
a. Multiplication and division, exponential positive and negative value
b. Multiplication and division, positive and negative values, addition
and subtraction
c. Addition and subtraction, positive and negative values,
exponentiation
d. None of above

Answers.
141 - d
142 - b
143 - b
144 - d
145 - d
146 - b
147 - a
148 - d
149 - c
150 - b
151 - a
152 - c
153 - d
154 - c
155 - c
156 - c
157 - c
158 - d
159 - d
160 - d