Default file name in MS Excel is?

Related Mcqs:

1. Microsoft Excel 2019 files have a default extension of___________?

   A. .Xlsx
   B. .Xls
   C. .excel
   D. .123

   Submitted by: Wiki

2. When you insert an Excel file into a word document, the data are?

   A. Hyperlinked
   B. placed in a word table
   C. linked
   D. embedded

   Submitted by: Mansoor Ahmed Suhag

3. The default style for new data keyed in a new workbook is ___________?

   A. Comma
   B. Normal
   C. Currency
   D. Percent

   Submitted by: H@yii

4. Ctrl+Shift+1 shortcut Keys in excel are used to __________?

   A. Format number in comma format
   B. Format number in currency format
   C. Format number in date format
   D. Format number in time format

   Submitted by: Farjan Ahmed Soomro

5. Which key is used for help in Ms Excel?

   A. F1
   B. F2
   C. F3
   D. None of these

   Submitted by: FAWAD MATLOOB

6. You can edit existing Excel data by pressing the:________ key?

   A. F1 Key
   B. F2 Key
   C. F3 Key
   D. F4 Key

   Submitted by: SYED AKASH BUKHARI NAQEEBI

7. In MS Excel, Conditional Formatting is in ______ tab?

   A. Home
   B. View
   C. Page Layout
   D. Insert

   Submitted by: Syed Nizakat Ali Shah

8. In Excel, Conditional formatting is in: ______________?

   A. Insert Tab
   B. Page layout
   C. View Tab
   D. Home Tab

   Submitted by: Farhan Rana

9. What is the function of Vlookup formula in Excel ?

   A. VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
   B. VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
   C. VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
   D. VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.

   Submitted by: Aziz Ur Rehman

10. 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