computer MCQs – Page 29

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.

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

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 __________ ?
comments icon0

A. workbook

B. row

C. column

D. cell
1403. Which Excel function counts the cells containing numbers in a selected range?
comments icon0

A. COUNTA

B. COUNTIF

C. SUM

D. COUNT
1404. Main window in a computer spreadsheet is called ___________ ?
comments icon0

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?
comments icon0
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 __________ ?
comments icon0

A. Decoration

B. Data appearance

C. Charting

D. Functions

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

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?
comments icon0

A. Symbols

B. Letters

C. Numbers

D. Cell references

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

A. .xls

B. .xlsx

C. .excel

D. .xlsm

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

A. 300

B. 500

C. 100

D. 10

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

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?
comments icon0
A. Traversing

B. Deletion

C. Insertion

D. Retrieving

1413. Microsoft Office Suite spreadsheet program is _________?
comments icon0

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?
comments icon0
A. Pressing the Esc key

B. Pressing the Tab Key

C. Both of these

D. None of above

1415. Microsoft Office InterConnect is:
comments icon0

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?
comments icon0

A. Formulas

B. All of the above

C. Formats

D. Validation rules

1417. An excel workbook is a collection of __________?
comments icon0

A. Worksheets

B. Charts

C. Worksheets and Charts

D. Workbooks

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

A. F4 Key

B. F3 Key

C. F2 Key

D. F1 Key

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

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?
comments icon0

A. Shift

B. Tab

C. Space

D. Esc

1421. Which element is deficient in milk _________?
comments icon0

A. Sodium

B. Calcium

C. Phosphorus

D. Iron
1422. If you press ___, the cell accepts your typing as its contents ?
comments icon0

A. Alt+Enter

B. Tab

C. Ctrl+Enter

D. Enter
1423. In a computer spreadsheet, first part of number format describes __________ ?
comments icon0
A. Positive number

B. Negative number

C. Text values

D. Zero values

1424. Getting data from a cell located In a different sheet is called ___________?
comments icon0
A. Referencing

B. Accessing

C. Functioning

D. Updating

1425. What is the maximum number of rows in a modern Microsoft Excel worksheet?
comments icon0
A. 1,048,576

B. 65,536

C. 16,384

D. 1,000,000

1426. What displays the content of active cell?
comments icon0

A. Row headings

B. None of these

C. Formula bar

D. Name box

1427. Title bar in MS-Excel displays name of the __________ ?
comments icon0

A. Location

B. Workbook

C. Formula

D. Worksheet

1428. Which function displays row data into column or column data into row?
comments icon0

A. Hyperlink

B. Rows

C. Transpose

D. Index

1429. When you insert an Excel file into a word document, the data are?
comments icon0
A. linked

B. placed in a word table

C. Hyperlinked

D. embedded

1430. In a computer spreadsheet, each cell contain a __________ ?
comments icon0

A. label

B. All of these

C. Formula

D. Value

1431. Move to next cell in row in Ms Excel:
comments icon0
A. Tab

B. Space

C. Shift

D. None of these

1432. In MS Excel, Conditional Formatting is in ______ tab?
comments icon0

A. Insert

B. View

C. Home

D. Page Layout

1433. Actual working area of Computers Microsoft Excel is ________ ?
comments icon0

A. Workbook

B. Notesheet

C. Notebook

D. Worksheet
1434. The term chart wizard data in MS is refer to_________?
comments icon0
A. Horizontal axis

B. Vertical axis

C. Bar data

D. None of these

1435. In a computer spreadsheet, block of cells is called __________ ?
comments icon0

A. Column

B. Range

C. Function

D. Workbook

1436. Which of following is not an element of computer spreadsheet interface?
comments icon0

A. Workbook

B. Active cell

C. Menu bar

D. Pencil work
1437. Which of these keys are used in Ms Excel to copy formula from above cell?
comments icon0

A. Ctrl+:

B. Ctrl+ ;

C. . Ctrl+

D. Ctrl+

1438. In Ms Excel Ready made templates are available under _______ tab ?
comments icon0

A. Design

B. File

C. Insert

D. None of Above

1439. Top open an existing workbook, click the open button on the___________toolbar?
comments icon0

A. Drawing

B. Formatting

C. standard

D. form

1440. in MS-Excel__________ short cut key is used for hiding rows.
comments icon0

A. None of the above

B. Ctrl+7

C. Ctrl+9

D. Ctrl+H

1441. In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is __________ ?
comments icon0

A. 1.5

B. 2

C. 12

D. 7
1442. Which of these will not select all the cells in a document ?
comments icon0
A. Clicking three times with the right mouse button in the spreadsheet

B. None of These

C. Pressing Ctrl + A on the keyboard

D. Using the Edit Select All menu

1443. In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key?
comments icon0

A. you will be in the cell A1

B. you will be in the cell B5

C. you will be in the cell B3

D. you will be in the cell B6

1444. Which of the following is the latest version of MS Excel?
comments icon0

A. Excel 2017

B. Excel 2016

C. Office 365

D. Excel 2019
1445. User developed instruction for excel are called__________?
comments icon0

A. All of these

B. Procedured

C. Progrms

D. Macros
1446. The default style for new data keyed in a new workbook is ___________?
comments icon0

A. Currency

B. Percent

C. Comma

D. Normal
1447. In excel columns are labelled as____________?
comments icon0

A. 1, 2, 3,etc.

B. $A$1, $A$2, etc.

C. A1,A2,A3, etc.

D. A,B, C,etc.
1448. Which one is example of spreadsheet software?
comments icon0

A. None of these

B. MS POWERPOINT

C. MS EXCEL

D. MS WORD

1449. Microsoft Office Accounting is:
comments icon0

A. None of these

B. A tool for managing business finances

C. Diagram and flow-charting software

D. Project management software to keep track of events and to create network charts and Gantt charts

1450. Which key is used for help in Ms Excel?
comments icon0

A. F3

B. None of these

C. F2

D. F1