Computer Science

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 101 - 110 of 1111 Questions

In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?

A AutoFill
B Auto correct
C Auto sum
D Auto format
Correct Answer

Option C: Auto sum


Discussion

MS-EXCEL is based on ……….?

A WINDOWS
B DOS
C UNIX
D OS/2
Correct Answer

Option A: WINDOWS


Discussion

What do you mean by a Workspace?

A Group of Columns
B Group of Worksheets
C Group of Rows
D Group of Workbooks
Correct Answer

Option D: Group of Workbooks


Discussion

A numeric value can be treated as label value if …… precedes it.

A Apostrophe (‘)
B Exclamation (!)
C Hash (#)
D Tilde (~)
Correct Answer

Option A: Apostrophe (‘)


Discussion

Which elements of a worksheet can be protected from accidental modification?

A Contents
B Objects
C Scenarios
D All of the above
Correct Answer

Option D: All of the above


Discussion

Which menu option can be used to split windows into two?

A Format -> Window
B View -> Window-> Split
C Window -> Split
D View –> Split
Correct Answer

Option C: Window -> Split


Discussion

What is the short cut key to replace a data with another in sheet?

A Ctrl + R
B Ctrl + Shift + R
C Ctrl + H
D Ctrl + F
Correct Answer

Option C: Ctrl + H


Discussion

You can move a sheet from one workbook into new book by

A From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
B From Edit menu choose Move of Copy then choose (Move to end) and click OK
C From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D None of above
Correct Answer

Option C: From Edit menu choose Move or Copy then select (new book) from To Book list and click OK


Discussion

Which of the following is not true about Find and Replace in Excel

A You can search for bold and replace with italics
B You can decide whether to look for the whole word or not
C You can search in formula too
D You can search by rows or columns or sheets
Correct Answer

Option D: You can search by rows or columns or sheets


Discussion

While Finding and Replacing some data in Excel, which of the following statement is valid?

A You can Find and Replace within the sheet or workbook
B Excel does not have option to match case for find
C Both are valid
D None are valid
Correct Answer

Option A: You can Find and Replace within the sheet or workbook


Discussion



WhatsApp Support