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?

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. With which of the following all formulas in excel starts ?

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

   Submitted by: H@yii

5. Which function calculates the largest value in a set of numbers in Excel?

   A. Average
   B. Count
   C. Minimum
   D. Maximum

   Submitted by: UMAR ASGHAR SANDHU

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

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

   Submitted by: Wiki

7. In MS Excel to delete duplicate values which menu is used?

   A. Data
   B. Tools
   C. Formatting
   D. Layout

   Submitted by: Warraich

8. You can set page border in excel from: __________?

   A. From Border tab in Format Cells dialog box
   B. From Border tool in Formatting toolbar
   C. From Line Style tool in Drawing toolbar
   D. You can not set page border in Excel

   Submitted by: IJAZ UQAAB

9. What is the intersection of a column and row called in Excel?

   A. A cell
   B. A range
   C. A column header
   D. A row header

   Submitted by: Areesha Khan

10. To insert chart in MS Excel, which shortcut key used?

    A. Alt+F1
    B. F2
    C. F3
    D. F4

    Submitted by: Misbah Chattha