Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 6 of 64 pages
Question 51. Two common wildcard characters that Excel recognizes are
  1.    * and?
  2.    < and >
  3.    * and /
  4.    + and –
  5.    None of these
 Discuss Question
Answer: Option A. -> * and?
Question 52. You can open the consolidate dialog box by choosing' Consolidate from the...... menu.
  1.    Insert
  2.    Format
  3.    Tools
  4.    Data
  5.    None of these
 Discuss Question
Answer: Option D. -> Data
Question 53. In Excel Tab scrolling buttons
  1.    Allow you to view a different worksheet
  2.    Allow you to view additional worksheet row down
  3.    Allow you to view additional worksheet columns to the right
  4.    Allow you to view additional sheet tabs
 Discuss Question
Answer: Option D. -> Allow you to view additional sheet tabs
Question 54. The Name box on to the left of formula bar
  1.    shows the name of workbook currently working on
  2.    shows tne name of worksheet currently working on
  3.    shows the name of cell or range currently working on
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option C. -> shows the name of cell or range currently working on
Question 55. Which function will you use to enter current time In a worksheet cell?
  1.    =today( )
  2.    -now ( )
  3.    -time ( )
  4.    =CurrentTime ( )
  5.    None of these
 Discuss Question
Answer: Option B. -> -now ( )
Question 56. In Excel you can select a single range of cells by
  1.    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
  2.    Pressing the Ctrl key while dragging over the desired cells
  3.    Pressing the Shift key and an arrow key
  4.    Dragging over the desired cells .
 Discuss Question
Answer: Option D. -> Dragging over the desired cells .
Answer: (d)
Question 57. A data map is helpful
  1.    When you have too much data to chart
  2.    To show a geographic distribution of data
  3.    To compare data points
  4.    To show changes in data over time
  5.    None of these
 Discuss Question
Answer: Option B. -> To show a geographic distribution of data
Answer: (b)
Question 58. To copy formatting from one area in a worksheet and apply it to another area you would use:
  1.    The Edit>Copy Format and Edit>Paste Format commands form the menu.
  2.    The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
  3.    There is no way to copy and apply formatting in Excel - You have to do it manually
  4.    The Format Painter button on the standard toolbar
  5.    None of these
 Discuss Question
Answer: Option D. -> The Format Painter button on the standard toolbar
Answer: (d)
Question 59. In Excel when a label is too long to fit within a worksheet cell, you typically must
  1.    Shorten the label
  2.    Increase the column width
  3.    Decrease the column width
  4.    Adjust the row height
 Discuss Question
Answer: Option B. -> Increase the column width
Answer: (b)
Question 60. Which of the following methods can not be used to edit the contents of a cell?
  1.    Press the Alt key
  2.    Clicking the formula bar
  3.    Pressing the F2 key
  4.    Double clicking the cell
  5.    None of these
 Discuss Question
Answer: Option A. -> Press the Alt key
Answer: (a)

Latest Videos

Latest Test Papers