Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 2 of 64 pages
Question 11. You can enter which types of data into worksheet cells?
  1.    Labels, values, and formulas
  2.    Labe31s and values but not formulas
  3.    Values and formulas but not labels
  4.    Formulas only
  5.    None of these
 Discuss Question
Answer: Option A. -> Labels, values, and formulas
Question 12. Which menu option can be used to split windows into two
  1.    View > window > split
  2.    Format > window
  3.    Window > split
  4.    View > split
  5.    None of these
 Discuss Question
Answer: Option C. -> Window > split
Question 13. What Is entered by the function •today ()
  1.    The date value for the day according to system clock
  2.    The time value according to system clock
  3.    Today's date as Text format
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option A. -> The date value for the day according to system clock
Question 14. To copy cell contents using drag and drop press the
  1.    End key
  2.    Shift key
  3.    Ctrl key
  4.    Esc key
  5.    None of these
 Discuss Question
Answer: Option D. -> Esc key
Question 15. Ctrl +p shortcut key in Excel will
  1.    Open the font dialog box
  2.    Apply double underline for the active cell
  3.    Fill down in the selection
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option C. -> Fill down in the selection
Question 16. In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
  1.    Rows and columns
  2.    Headings
  3.    Speed
  4.    None
 Discuss Question
Answer: Option C. -> Speed
Question 17. Which of the following is not information you can specify using the solver?
  1.    Input cells
  2.    Constraints
  3.    Target cell
  4.    Changing cells
  5.    None of these
 Discuss Question
Answer: Option A. -> Input cells
Question 18. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
  1.    Use Ctrl to select all three cells, then click the paste button on the standard toolbar
  2.    Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
  3.    Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option C. -> Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
Question 19. 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 20. To select a column the easiest method is to........
  1.    Double click any cell in the column
  2.    Drag from the top cell in the column to the last cell in the column
  3.    click the column heading
  4.    click the column label
  5.    None of these
 Discuss Question
Answer: Option C. -> click the column heading

Latest Videos

Latest Test Papers