0
Login

MS Excel

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 11 - 20 of 336 Questions

77 Details Computer Science MS Excel Easy

1What is the shortcut key to hide entire row?

A CTRL + H
B CTRL + R
C CTRL + 9
D CTRL + –
Correct Answer

Option C: CTRL + 9

Discussion
81 Details Computer Science MS Excel Easy

If the cell B1 contains the formula = $A$1, which of the following statements is true

A There is a relative reference to cell A1
B There is an absolute reference to cell A1
C Further changes in value of A1 will not affect the value of B1
D Further changes in value of B1 will affect the value of A1
Correct Answer

Option B: There is an absolute reference to cell A1

Discussion
75 Details Computer Science MS Excel Easy

If particular workbook have to open each time Excel started, where that workbook should be placed?

A AUTOEXEC Folder
B AUTOSTART Folder
C EXCELSTART Folder
D XLSTART Folder
Correct Answer

Option D: XLSTART Folder

Discussion
78 Details Computer Science MS Excel Easy

How to fit long texts in a single cell with multiple lines?

A Start typing in the cell and press the Enter key to start another line
B Use the Wrap Text option in the Format -> Alignment menu
C Use the Shrink to Fit option in the Format -> Cells -> Alignment menu
D All of above
Correct Answer

Option B: Use the Wrap Text option in the Format -> Alignment menu

Discussion
89 Details Computer Science MS Excel Easy

If the values in A1 is “MCQ” and B1 is “Questions”, which function will return [email protected] in cell C1?

A =A1 + [email protected] + B1
B =A1 # [email protected] # B1
C =A1 & [email protected] & B1
D =A1 $ [email protected] $ B1
Correct Answer

Option C: =A1 & [email protected] & B1

Discussion
71 Details Computer Science MS Excel Easy

If 4/6 entered in a cell without applying any formats, Excel will treat this as

A Fraction
B Number
C Text
D Date
Correct Answer

Option D: Date

Discussion
80 Details Computer Science MS Excel Easy

Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?

A 2 Rows will be inserted after Row 4
B 2 Rows will be inserted after Row 5
C 2 Rows will be inserted after Row 6
D 2 Rows will be inserted after Row 7
Correct Answer

Option A: 2 Rows will be inserted after Row 4

Discussion
89 Details Computer Science MS Excel Easy

Which of the following is correct syntax in Excel?

A =IF(LogicalTest, TrueResult, FalseResult)
B =IF(LogicalTest, (TrueResult, FalseResult))
C =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
D =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)
Correct Answer

Option A: =IF(LogicalTest, TrueResult, FalseResult)

Discussion
75 Details Computer Science MS Excel Easy

Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

A Enclose the number is brackets
B Place the character T before the number
C Place the character TX before the number
D Apply the Text format in the cell and type the numbers
Correct Answer

Option D: Apply the Text format in the cell and type the numbers

Discussion
75 Details Computer Science MS Excel Easy

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 the formatting of the cell is changed
Correct Answer

Option C: the data in the cell is changed or deleted

Discussion


Computer Science

WhatsApp Support