Which of the following you can paste selectively using Paste Special Command?

Related Mcqs:

1. Which of the following is the latest version of MS Excel?

   A. Excel 2016
   B. Excel 2017
   C. Excel 2021
   D. Office 365

   Submitted by: Malik Asghar Hussain

2. In Ms Excel, which of the following special function keys allow the content in cell?

   A. Shift
   B. Esc
   C. Tab
   D. Space

   Submitted by: Malik Asghar Hussain

3. which of the following is not a valid Zoom percentage in Excel?

   A. 10
   B. 100
   C. 300
   D. 500

   Submitted by: Taimur Gulzar

4. Which of the following will not enter data in a cell?

   A. Pressing the Esc key
   B. Pressing the Tab Key
   C. Both of these
   D. None of above

   Submitted by: Asif Ali Hakro

5. Which of following is not an element of computer spreadsheet interface?

   A. Pencil work
   B. Active cell
   C. Menu bar
   D. Workbook

   Submitted by: Rashid Mehmood

6. With which of the following all formulas in excel starts ?

   A. /
   B. *
   C. $
   D. =

   Submitted by: H@yii

7. Which among following is not associated with spelling dialogue box?

   A. Edit
   B. Ignore All
   C. Ignore
   D. Change

   Submitted by: H@yii

8. In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

   A. TRIM
   B. SUBSTITUTE
   C. CLEAN
   D. REPT

   Submitted by: Malik Sanwal

9. In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value?

   A. =LARGE(A:A, 2)
   B. =LARGE(UNIQUE(A:A), 2)
   C. =INDEX(SORT(UNIQUE(A:A), , -1), 2)
   D. =SMALL(UNIQUE(A:A), 2)

   Submitted by: Malik Sanwal

10. Which of these keys are used in Ms Excel to copy value from above cell?

    A. Ctrl + “
    B. Ctrl+ E
    C. Ctrl+ E
    D. Ctrl+ D

    Submitted by: FAWAD MATLOOB