Multiple Choice Questions and Answers on MS Excel | Page-10

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

Questions
46 A smart tag will be removed from a cell when
A the cell is moved
B the cell is hidden
C the data in the cell is changed or deleted
D None of the above

Answer: Option [C]
47 Which of the following is correct syntax in Excel ?
A =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)
B =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
C =IF(LogicalTest, (TrueResult, FalseResult))
D =IF(LogicalTest, TrueResult, FalseResult)

Answer: Option [D]
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
48 Which of the following is correct ?
A =POWER(2*3)
B =POWER(2^3)
C =POWER(2,3)
D None of the above

Answer: Option [C]
49 If 4/6 entered in a cell without applying any formats, Excel will treat this as
A Date
B Text
C Fraction
D None of the above

Answer: Option [A]
50 What is the shortcut key to insert a new comment in a cell ?
A Alt + F2
B Ctrl + F2
C Shift + F2
D None of the above

Answer: Option [C]

Random GK Questions

Q. Which one of the following statements is not correct about the Harappan civilization ?
Q. In which plan was self-reliance first emphasized
Q. The method of Impeachment of the President of India is adopted from
Q. Who appoints the Chief Election Commissioner of India?
Q. The highest and final judicial tribunal of India is :
Q. After ONGC, OIC, NTPC and SAIL the ‘Navratna’ PSU which was awarded Maharatna status is

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics