Current Affairs PDF

Computer Quiz : Microsoft Excel Set – 9

By
Aruna
-

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP Click Here

Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in Microsoft Excel. It will be useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.

  1. To override the order of operations, use ________
    A. brackets
    B. asterisks
    C. quotes
    D. parentheses
    D. parentheses

  2. _________ cells involves creating a single cell by combining two or more selected cells.
    A. formatting
    B. merging
    C. embedding
    D. splitting
    B. merging

  3. ___________ is used to eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry.
    A. Auto Complete
    B. Auto Fit
    C. Auto Sum
    D. None of the above
    B. Auto Fit

  4. ______ is a type of page orientation in which the page is taller than it is wide
    A. Portrait orientation
    B. Landscape Orientation
    C. Both (A) and (B)
    D. None of the above
    A. Portrait orientation

  5. You press the _____ key on the keyboard to display a Key Tip badge.
    A. ESC
    B. CTRL
    C. ALT
    D. Home
    C. ALT

  6. ______ is a type of page orientation in which the page is wider than it is tall, so that text spans the widest part of the page.
    A. Portrait orientation
    B. Landscape Orientation
    C. Both (A) and (B)
    D. None of the above
    B. Landscape Orientation

  7. An alternative for clicking the Paste button is to _______.
    A. click the Drop button
    B. click the Move button
    C. press the Enter key
    D. press the down arrow
    C. press the Enter key

  8. The worksheet entries that determine the size of the slices in a pie chart are called the________.
    A. data series
    B. pie data
    C. data collection
    D. chart data
    A. data series

  9. What error code does excel display if a range name is mis-typed or deleted?
    A. #REF!
    B. #Name?
    C. #Value
    D. #N/A
    B. #Name?

  10. A cell range that is comprised of two or more separate adjacent ranges is known as __________
    A. adjacent Range
    B. Non adjacent Range
    C. Both (A) and (B)
    D. None of the above
    B. Non adjacent Range





RELATED ARTICLESMORE FROM AUTHOR