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...? Mcqs

Latest MCQs

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

Comments
Latest MCQs

Which menu do you choose to create header in Office 365...?

(A) format, header and footer
(B) view, header

(C) insert, header and footer
(D) view, header and footer

Comments
Latest MCQs

Which of the following can you format using buttons on the formatting toolbar...?

(A) Your hard drive
(B) Format painting

(C) Font color
(D) Underlining

Comments
Latest MCQs

In MS Excel, _____ function calculates the square root of a number....?

(A) SQR
(B) SQRT

(C) SQUARE
(D) None of these

Comments
Latest MCQs

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)

Comments
Latest MCQs

Which component of computer is also considered as it "Heart"...?

(A) Monitor
(B) Keyboard

(C) Scanner
(D) Microprocessor

Comments
Latest MCQs

Which of the following execute instructions...?

(A) Motherboard
(B) Hard disk

(C) CPU
(D) None of these

Comments
Latest MCQs

In MS Word and Excel, to combine two or more cells into one is called...?

(A) Joining
(B) Merging

(C) Split
(D) None of these

Comments
Latest MCQs

Which shortcut key is used to close a tab on a browser...?

(A) Ctrl + X
(B) Ctrl + W

(C) Alt + F4
(D) Shift + F4

Comments
Latest MCQs

Which of the following file types represents a compressed version of one or more files...?

(A) EXE
(B) PDF

(C) DOC
(D) ZIP

Comments

Best of Luck

From ShineGk.com

Share our website's link