0
Login

MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 31 - 40 of 1111 Questions

76 Details Computer Science MS Excel Easy

What does the NOW() function return?

A It returns the serial number of the current date and time
B It returns the serial number of the current date
C It returns the serial number of the current time
D None of the above
Correct Answer

Option D: None of the above

Discussion
79 Details Computer Science MS Excel Easy

Which of the following function will use to find the highest number in a series of number?

A MAX(B1:B3)
B MAXIMUM (B1:B3)
C HIGH (B1:B3)
D HIGHEST(B1:B3)
Correct Answer

Option A: MAX(B1:B3)

Discussion
74 Details Computer Science MS Excel Easy

What should be add before a fraction to avoid entering it as a date?

A //
B FR
C Zero
D Zero Space
Correct Answer

Option D: Zero Space

Discussion
74 Details Computer Science MS Excel Easy

How to remove the unwanted action from recorded macro without recording the whole macro again?

A By using the Find and Edit Action Option
B By clicking on the Refresh button in the Macro toolbar
C By edit the macro in the Visual Basic Editor
D Macro cannot be edited.
Correct Answer

Option C: By edit the macro in the Visual Basic Editor

Discussion
75 Details Computer Science MS Excel Easy

How to restrict to run a macro automatically when starting Microsoft Excel?

A Hold down the SHIFT key during startup
B Hold down the CTRL key during startup
C Hold down the ESC key during startup
D Hold down the ALT key during startup
Correct Answer

Option A: Hold down the SHIFT key during startup

Discussion
71 Details Computer Science MS Excel Easy

Which of the following function will return a value of 8?

A ROUNDUP(8.4999, 0)
B ROUNDDOWN(8.4999, 0)
C ROUND(8.4999, 0)
D Only B and C
Correct Answer

Option D: Only B and C

Discussion
79 Details Computer Science MS Excel Easy

Which of the following is correct?

A =AVERAGE(4, 5, 6, 7)
B =AVERAGE(A1, B1, C1)
C =AVERAGE(A1:A9, B1:B9)
D =All of the above
Correct Answer

Option D: =All of the above

Discussion
73 Details Computer Science MS Excel Easy

What is the AutoComplete feature of Excel?

A It automatically completes abbreviated words
B It completes text entries that match an existing entry in the same column
C It completes text and numeric entries that match an existing entry in the same column
D It completes text entries that match an existing entry in the same worksheet
Correct Answer

Option B: It completes text entries that match an existing entry in the same column

Discussion
75 Details Computer Science MS Excel Easy

The cell reference for cell range of G2 to M12 is _______

A G2.M12
B G2;M12
C G2:M12
D G2-M12
Correct Answer

Option C: G2:M12

Discussion
75 Details Computer Science MS Excel Easy

Which of the following methods will not enter data in a cell?

A Pressing the Esc key
B Pressing an arrow key
C Pressing the tab key
D Clicking the enter button to the formula bar
Correct Answer

Option A: Pressing the Esc key

Discussion


All Categories

WhatsApp Support