MCQ’s About MS Excel 07

Posted by

MCQ’s About MS Excel PART-07

151. In Excel circular reference is
(A) Geometric modeling tool
(B) A cell that points to a drawing object
(C) A formula that either directly or indirectly depends on itself
(D) Always erroneous

152. In Excel when you insert an excel file into a word document. The data are
(A) Hyperlinked placed in a word table
(B) Linked
(C) Embedded
(D) Use the word menu bar and toolbars

153. In Excel the following is not information you can specify using the solver
(A) Input cells
(B) Constraints
(C) Target cell
(D) Changing cells

154. In Excel 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. In Excel you can enter which types of data into worksheet cells?
(A) Labels, values, and formulas
(B) Labels and values but not formulas
(C) Values and formulas but not labels
(D) Formulas only

156. In Excel all worksheet formula
(A) Manipulate values
(B) Manipulate labels
(C) Return a formula result
(D) Use the addition operator

157. In Excel which of the following is a correct order of precedence in formula calculation?
(A) Multiplication and division exponentiation positive and negative values
(B) Multiplication and division, positive and negative values, addition and subtraction
(C) Addition and subtraction, positive and negative values, exponentiation
(D) All of above

158. In Excel the Paste Special command lets you copy and paste
(A) Multiply the selection by a copied value
(B) Cell comments
(C) Formatting options
(D) The resulting values of a formula instead of the actual formula

159. In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?
(A) None of these
(B) Select Format > Money from the menu
(C) Click the Currency Style button on the formatting toolbar
(D) You have to retype everything and manually add the dollar signs, commas, and decimals.

160. In Excel which of the following is not a valid data type in excel
(A) Number
(B) Character
(C) Label
(D) Date/time

161. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
(A) Option buttons
(B) List boxes
(C) Text boxes
(D) Combo boxes

162. In Excel which of the following options is not located in the Page Setup dialog box?
(A) Page Break Preview.
(B) Page Orientation
(C) Margins
(D) Headers and Footers

163. In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use?
(A) Pie chart
(B) Row chart
(C) Line chart
(D) Column chart

164. In Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
(A) Press Ctrl +Home
(B) Press Home
(C) Press Shift + Home
(D) Press Alt + Home

165. Which of the following methods cannot be used to edit the contents of a cell In Excel?
(A) Press the Alt key
(B) Clicking the formula bar
(C) Pressing the F2 key
(D) Double clicking the cell

166. In Excel 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

167. In Excel default style for new data keyed in a new workbook is
(A) Comma
(B) Currency
(C) Normal
(D) Per cent

168. In Excel LEN function does what?
(A) Compares the content in two cells
(B) Counts the numbers of characters in a cell
(C) Deletes extra space in text
(D) All of above

169. In Excel this function converts miles to kilometers, kilograms to pounds, and so on
(A) Convert
(B) Product
(C) Change
(D) All of above

170. In Excel you can use the drag and drop method to
(A) Copy cell contents
(B) Delete cells contents
(C) Add cell contents
(D) All of above

171. In Excel to balance your checkbook, your best method is
(A) Copy your check amounts into Excel so that you’ll have a neat printout to work on
(B) Use Excel to check your arithmetic
(C) Download the Checkbook register templates from Templates on Microsoft Office Online
(D) All of above

172. In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
(A) Count
(B) Average
(C) Sum
(D) None of above

173. In Excel to name a constant, you use the …… dialog box
(A) Create names
(B) Define name
(C) Paste name
(D) Format cells

174. In Excel to cancel the marquee, press
(A) Ctrl + End
(B) End
(C) Esc
(D) Shift + Esc

175. In Excel the function calculates depreciation at the same amount each year over an asset’s useful life
(A) DB (fixed-declining balance)
(B) SLN (straight line)
(C) DDB (double-declining)
(D) All of above

176. In Excel the following is not an underline option in the format cells dialog box
(A) Double
(B) Single Engineering
(C) Single Accounting
(D) Double Accounting

177. In Excel 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

178. In Excel when integrating Ms-Word and Excel, Word is usually the
(A) Server
(B) Source
(C) Client
(D) None

179. In Excel 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) Both (B) and (C)

180. In Excel 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