76. Multiple calculations can be made in a single formula using :
(a) Standard Formulas
(b) Array Formula
(c) Complex Formulas
(d) Smart Formula
77. A clipboard :
(a) is used to save data on disk in the event of a power failure
(b) is able to retain the contents even when computer is switched off
(c) is available only in Microsoft Word
(d) is a temporary storage in the computers memory and temporarily stores the cut or copied data
78. In order to tell Excel that we are entering a formula in a cell, we must begin the entry with an operator such as :
(a) $
(b) @
(c) =
(d) #
79. An excel worksheet can have a maximum of …….. number of columns.
(a) 256
(b) 255
(c) 16384
(d) 258
80. In its default settings, Excel Margin tabs are set at :
(a) 1.9 inch for top and bottom margins
(b) 1.8 inch for the left and right margins
(c) 0.8 inch for header and footer
(d) All the above
Related Posts
Microsoft Excel » Exercise - 1 1. For opening and closing of the file in Excel, you can use which bar ? (a) Formatting (b) Standard (c) Title (d) Formatting or Title 2. Which of the following is the latest version of Excel : (a) Excel 2002 (b) Excel XP (c) Excel 2013 (d) Excel ME 3. In Excel the intersection of a column and a row is called : (a) Cell (b) Grid (c) Table (d) Box 4. Anything that is typed in a worksheet appears : (a) in the formula bar only (b) in the active cell only (c) in both active cell and formula bar (d) in the formula bar first and when we press ENTER it appears in active cell 5. Crtl + C is equivalent to : (a) Copy (b) Cut (c) Paste (d) Delete 6. Roman Symbol for last column in an Excel sheet is represented by : (a) XFA (b) XFB (c) XFC (d) XFD 7. Which shortcut command is used to reach the next worksheet : (a) Page down (b) Ctrl + Page down (c) Ctrl + -> (d) Tab 8. Named the shortcut key to fill the value of just above cell : (a) Ctrl + D (b) Ctrl…- Microsoft Excel » Exercise - 257. In which Menu will you get the validation command : (a) Insert (b) Data (c) Tools (d) Format
- Microsoft Excel » Exercise - 270. Which command is used to copy the formula not the value from one data to another : (a) Paste (b) Paste special (c) Ctrl + V (d) Hyperlink
- Microsoft Excel » Exercise - 123. Which command is used to copy the formula not the value from one data to another : (a) Paste (b) Paste special (c) Ctrl + V (d) Hyperlink
- Microsoft Excel » Exercise - 141. Which menu kept the Goal seek command : (a) Data (b) Tools (c) Insert (d) Format