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