MCQ’s About MS Excel 06

Posted by

MCQ’s About MS Excel PART-06

121. In Excel the cell labeled F5 refers to
(A) row F column 5
(B) column F row 5
(C) function available in cells
(D) function key F4

122. In Excel when you are typing an equation into a cell the first thing that must be entered is
(A) the first cell referenced
(B) parenthesis
(C) quotation marks
(D) an equal sign

123. In Excel using the AutoSum button will replace in the selected cell
(A) the sum of values in the cell’s column
(B) nothing until you select a range of cells
(C) the sum of the cell’s row unless you change the range
(D) a formula which will add values in the range Excel guesses you want to add

124. In Excel Book1 is an example of how … are numbered and named during each work session
(A) Active cell
(B) Formula bar
(C) Menu bar
(D) Name box

125. In Excel the following displays the contents of the active cell
(A) Active cell
(B) Formula bar
(C) Menu bar
(D) Name box

126. In Excel Graphics objects on a chart are used to
(A) Add emphasis to chart data
(B) Add interest to a chart
(C) Help explain the chart data
(D) All the above

127. In Excel to select a column the easiest method is to
(A) Double click any cell in the column
(B) Drag from the top cell in the column to the last cell in the column
(C) Click the column heading
(D) Click the column label

128. In Excel to select an individual data marker or data label, you must
(A) Double click the data series
(B) Right click selected marker
(C) Click once to select the series markers or labels and click the desired marker or label again
(D) Double click the marker or label

129. In Excel to delete and embedded object, first
(A) Double click the object
(B) Select the object by clicking it
(C) Press the Shift + Delete keys
(D) Select it and then press Delete key

130. This type of software contains rows and columns.
(A) Drawing
(B) Spreadsheet
(C) Database
(D) Word processing

131. In Excel to open an existing workbook, you can click the Open button on the …… toolbar.
(A) Drawing
(B) Formatting
(C) Forms
(D) Standard

132. In Excel you can activate a cell by
(A) Pressing the Tab key
(B) Clicking the cell
(C) Pressing an arrow key
(D) All of above

133. In Excel the following setup options cannot be set in the page setup dialog box?
(A) Printer selection
(B) Vertical or horizontal placement
(C) Orientation
(D) Row and column titles

134. In Excel term refers to a specific set of values saved with the workbook
(A) Range
(B) Scenario
(C) Trend line
(D) What-if analysis

135. In Excel got functions? No? You need the insert function dialog box. How do you get it?
(A) Right click a cell and then click insert
(B) Click the insert menu and then click function
(C) Type = in a cell
(D) All of the above

136. In Excel the following describes how to select all the cells in a single column?
(A) Right click on column and select Pick from list
(B) Use data – text to columns menu item
(C) Left click on the gray column title button
(D) Pressing Ctrl + A on the keyboard

137. In Excel when you use the fill effects in the format data series dialog box, you cannot
(A) Rotate text on the chart
(B) Select a fore ground color
(C) Select a pattern
(D) Select a background color

138. In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
(A) Rows and columns
(B) Headings
(C) Speed
(D) None

139. In Excel the following is not a basic step in creating a worksheet
(A) Save the workbook
(B) Modify the worksheet
(C) Enter text and data
(D) Copy the worksheet

140. In Excel what does SUMIF function do?
(A) Adds up cell values based on a condition
(B) Adds all the numbers in a range of cells
(C) Returns a subtotal in a list or database
(D) All of above

141. In Excel you can insert labels for
(A) All the data markers on a chart
(B) A data series
(C) A selected data marker
(D) All of the above

142. In Excel Tab scrolling buttons
(A) Allow you to view a different worksheet
(B) Allow you to view additional worksheet row down
(C) Allow you to view additional worksheet columns to the right
(D) Allow you to view additional sheet tabs

143. In Excel All macro keyboard shortcuts include the ….. key
(A) Alt
(B) Ctrl
(C) F11
(D) Shift

144. In Excel to open the Format Cells dialog box, press
(A) Alt + 1
(B) Ctrl + 1
(C) Ctrl + Shift + 1
(D) F1

145. In Excel you can add a hyperlink to your worksheet by pressing
(A) Alt + K
(B) Ctrl + H
(C) Ctrl + K
(D) Ctrl + Shift + K

146. In Excel to move to the previous worksheet, press
(A) Alt + PgUp
(B) Ctrl + PgUp
(C) Ctrl + PgDn
(D) Shift + Tab

147. In Excel you can select a single range of cells by
(A) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
(B) Pressing the Ctrl key while dragging over the desired cells
(C) Pressing the Shift key and an arrow key
(D) Dragging over the desired cells

148. In Excel which of these will not select all the cells in a document?
(A) Clicking three times with the right mouse button in the spreadsheet
(B) Using the Edit – Select All menu
(C) Pressing Ctrl + A on the keyboard
(D) Pressing Ctrl + A on the keyboard

149. In Excel you can use the formula palette to
(A) Format cells containing numbers
(B) Create and edit formulas containing functions
(C) Enter assumptions data
(D) Copy a range of cells

150. In Excel you can convert existing excel worksheet data an charts to an HTML document by using
(A) FTP wizard
(B) Internet assistant wizard
(C) Intranet wizard
(D) Import wizard