computer MCQs – Page 71

Practise multiple-choice questions from computer for competitive examinations and subject revision. Review each marked answer and report any item that may be outdated or unclear.

computer Mcqs

1. microsoft powerpoint 2. microsoft excel 3. microsoft word

1401. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?
0

A. Calculations

B. Formulas

C. Functions

D. Relative addressing

1402. Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?
0

A. workbook

B. row

C. column

D. cell

1403. Which Excel function counts the cells containing numbers in a selected range?
0

A. COUNTA

B. COUNTIF

C. SUM

D. COUNT

1404. Main window in a computer spreadsheet is called ___________ ?
0

A. Work

B. Work book

C. Work sheet

D. Account book

1405. What is the maximum number of columns in a modern Microsoft Excel worksheet?
0

A. 16,384

B. 256

C. 65,536

D. 1,048,576

1406. Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?
0

A. Decoration

B. Data appearance

C. Charting

D. Functions

1407. Ctrl+Shift+1 shortcut Keys in excel are used to __________?
0

A. Format number in currency format

B. Format number in time format

C. Formatnumber in dateformat

D. Formatnumber in commaformat

1408. In Excel's default A1 reference style, how are worksheet rows identified?
0

A. Symbols

B. Letters

C. Numbers

D. Cell references

1409. What is the default file extension for a standard Microsoft Excel 2019 workbook?
0

A. .xls

B. .xlsx

C. .excel

D. .xlsm

1410. which of the following is not a valid Zoom percentage in Excel?
0

A. 300

B. 500

C. 100

D. 10

1411. You can set page border in excel from: __________?
0

A. From Border tab in Format Cells dialog box

B. From Line Style tool in Drawing toolbar

C. You can not set page border in Excel

D. From Border tool in Formatting toolbar

1412. Which Operation cant be performed by Queue?
0

A. Traversing

B. Deletion

C. Insertion

D. Retrieving

1413. Microsoft Office Suite spreadsheet program is _________?
0

A. Microsoft PowerPoint

B. Microsoft Excel

C. Microsoft Word

D. None of these

1414. Which of the following will not enter data in a cell?
0

A. Pressing the Esc key

B. Pressing the Tab Key

C. Both of these

D. None of above

1415. Microsoft Office InterConnect is:
0

A. A scanning and OCR application

B. Business-relationship database

C. None of these

D. An application that supports editing scanned documents

1416. Which items can Excel paste selectively with the Paste Special command?
0

A. Formulas

B. All of the above

C. Formats

D. Validation rules

1417. An excel workbook is a collection of __________?
0

A. Worksheets

B. Charts

C. Worksheets and Charts

D. Workbooks

1418. You can edit existing Excel data by pressing the:________ key?
0

A. F4 Key

B. F3 Key

C. F2 Key

D. F1 Key

1419. Which Shortcut keys are used to strikethrough highlighted selection in Excel?
0

A. None of the above.

B. Ctrl+5

C. Ctrl+4

D. Ctrl+6

1420. In Ms Excel, which of the following special function keys allow the content in cell?
0

A. Shift

B. Tab

C. Space

D. Esc

Previous Next

Showing 1401 to 1420 of 1828 mcqs