0
Login

MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 191 - 200 of 1111 Questions

66 Details Computer Science MS Excel Easy

A function inside another function is called a ….. function.

A Nested
B Round
C Sum
D Text
Correct Answer

Option A: Nested

Discussion
66 Details Computer Science MS Excel Easy

Which of the following is a correct order of precedence in a formula calculation?

A Multiplication and division, exponential positive and negative value
B Multiplication and division, positive and negative values, addition and subtraction
C Addition and subtraction, positive and negative values, exponentiation
D None of above
Correct Answer

Option D: None of above

Discussion
70 Details Computer Science MS Excel Easy

You can print only an embedded chart by

A Moving the chart to a chart sheet before you print.
B Formatting the chart before you print
C Selecting the chart before you print
D a and c
Correct Answer

Option D: a and c

Discussion
81 Details Computer Science MS Excel Easy

Gridlines

A May be turned off for display but turned on for printing
B May be turned on or off for printing
C The be turned off for display and printing
D a, b and c
Correct Answer

Option D: a, b and c

Discussion
70 Details Computer Science MS Excel Easy

What does the VLOOKUP function do?

A Looks up text that contain ‘v’
B Checks whether text is the same in one cell as in the next
C Finds related records
D All of above
Correct Answer

Option C: Finds related records

Discussion
72 Details Computer Science MS Excel Easy

How are data organized in a spreadsheet?

A Lines and spaces
B Layers and planes
C Rows and columns
D Height and width
Correct Answer

Option C: Rows and columns

Discussion
70 Details Computer Science MS Excel Easy

Which types of charts can excel produce?

A Line graphs and pie charts only
B Only line graphs
C Bar charts, line graphs and pie charts
D Bar charts and line graphs only
Correct Answer

Option C: Bar charts, line graphs and pie charts

Discussion
67 Details Computer Science MS Excel Easy

You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.

A Insert
B Format
C Tools
D Data
Correct Answer

Option D: Data

Discussion
67 Details Computer Science MS Excel Easy

Macros are “run” or executed from the ….. menu.

A Insert
B Format
C Tools
D Data
Correct Answer

Option C: Tools

Discussion
63 Details Computer Science MS Excel Easy

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

A IF
B AND
C OR
D NOT
Correct Answer

Option A: IF

Discussion


All Categories

WhatsApp Support