Worksheets161/200
Total questions: 40
Worksheet time: 20mins
161. Returns the number of characters you specify from the right side of a string.
a) CHAR
b) LEN
c) RIGHT
d) RSTRING
162. Removes all spaces from text except for single spaces between words.
a) CODE
b) CLEAN
c) TRIM
d) SUBSTITUTE
163. What symbol is used to enter number as text?
(A) '
(B) "
(C) =
(D) +
164. Which of the following formulas will Excel Not be able to calculate?
(a) =SUM(Sales)-A3
(b) =SUM(A1:A5)*.5
(c) =SUM(A1:A5)/(10-10)
(d) =SUM(A1:A5)-10
165. Which among the following is a valid cell address in MS Excel?
(a) A:20
(b) B;15
(c) D6
(d) 10H 90
166. Microsoft excel s also called _
(a) Document
(b) Table
(c) Spreadsheet
(d) Label
167. The auto calculate feature
(a) Can only add values in a range of cells
(b) Provides a quick way to view the result of an arithmetic operation on a range of cells.
(c) Automatically creates formulas and adds them to a worksheet
(d) Both (a) and (c)
168. __ is used to display values in ascending or descending order.
(a) Filtering
(b) Sorting
(c) Numbering
(d) Formatting
169. Getting data from a cell located in a different sheet is called
(a) Accessing
(b) Referencing
(c) Updating
(d) Functioning
170. What term refers to a specific set of values saved with the workbook?
(a) Range
(b) Scenario
(c) Trend line
(d) What-if analysis
171. When you see a cell with a red triangle in the top right corner, what does this signify?
(a) There is an error in the cell
(b) There is a comment associated with the cell
(c) The font color for text in the cell is red
(d) A formula cannot be entered into the cell
172. The operator to estimate mean is
(a) =COVAR ()
(b) = MODE ()
(c) =AVERAGE ()
(d) =MEDIAN ()
173. Which tab provides the option to set chart and axis titles?
(a) Insert
(b) Layout
(c) View
(d) Design
174. _____ cells involves creating a single cell by combining two or more selected cells.
(a) Formatting
(b) Merging
(c) Embedding
(d) Splitting
175. Which of the following formula is not entered correctly?
(a) =10+5
(b) =5*9
(c) 2+4
(d) =10/2
176. Formulas built-in into a spreadsheet are called
(a) Formulas
(b) conditions
c) Functions
(d) Labels
177. The menu for locating regression in MS Excel is
(a) Format
(b) Tools
(c) Insert
(d) Data Analysis
178. In Excel, any set of characters containing a letter , hyphen, or space is considered:
(a) a formula
(b) text
(c) a name
(d) a title
179. __ refers to displaying only the rows that meet certain conditions and the remaining rows are hidden
(a) Filtering
(b) Sorting
(c) Numbering
(d) Formatting
180. The keyboard shortcut for cut command is
(a) Ctrl+C
(b) Altl+C
(c) Ctrl+X
(d) Alt+V
181. Which type of key should combine with ctrl key to create a macro key in Excel?
(A) Numeric
(B) Alphabetic
(C) Alphanumeric
(D) Special characters
182. Which tab is used to change the display of worksheet area and the data it contains?
(A) Page Layout
(B) Data
(C) Review
(D) View
183. Which function in Excel is used to find the biggest value in a range?
(A) Ceiling
(B) DMAX
(C) LEN
(D) MAX
184. Which one of the following is a ‘Date & Time’ function in Excel?
(A) FIND()
(B) MOD()9
(C) NOW()
(D) MID()
185. What is the purpose ‘Tab’ key in MS Excel?
(A) Moves cell pointer to previous column
(B) Moves cell pointer to next column
(C) Moves cell pointer previous row
(D) Moves cell pointer next row
186. What is the purpose of ‘Enter Key’ in MS Excel?
A Moves cell pointer to previous column
B Moves cell pointer to next column
C Moves cell pointer to previous row
D Moves cell pointer to next row
187. Which option in Excel is used to rearrange the rows base on the content of a particular column?
(A) Find
(B) Filter
(C) Sort
(D) Format
188. Columns in MS Excel are named in the form of ______.
(a) alphabets (A, B, C, D,…)
(b) numbers (1,2,3,4,…)
(c) roman numerals (I,II, III, IV,…)
(d) none of them
189. Rows in MS Excel are named in the form of_____
.
(a) alphabets (A, B, C, D,…)
(b) numbers (1,2,3,4,…)
(c) roman numerals (I,II, III, IV,…)
(d) none of them
190. Which of the following is an absolute cell reference?
(A) !A!1
(B) $A$1
(C) #a#1
(D) A1
191. What type of chart is useful for comparing values over categories ?
(A) Pie Chart
(B) Column Chart
(C) Line Chart
(D) Dot Graph
192. Which one is not a Function in MS Excel ?
A) SUM
(B) AVG
(C) MAX
(D) MIN
193. Functions in MS Excel must begin with ___
A) An () sign
(B) An Equal Sign
(C) A Plus Sign
(D) A > Sign
194. The ____ feature of MS Excel quickly completes a series of data
A) Auto Complete
(B) Auto Fill
(C) Fill Handle
(D) Sorting
195. The basic unit of a worksheet into which you enter data in Excel is called a
(A) cell
(B) table
(C) box
(D) column
196. It is a collection of data that is stored electronically as a series of records in a table.
(A) spreadsheet
(B) presentation
(C) database
(D) MS Word
197. Which of the following is Not one of Excel’s what-if function?
(A) Goal seek
(B) Solver
(C) Scenario manager
(D) Auto Outline
198. 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
199. To save a workbook, you:
(A) Click the save button on the standard toolbar from the menu
(B) Press Ctrl+ F5
(C) Click Save on the Windows Start button
(D) Select Edit > Save
200. Comments can be added to cells using
(A) Edit > Comments
(B) Insert > Comments
(C) File > Comments
(D) View > Comments
