1401. With which of the following all formulas in excel starts ?
comments icon0

A. /

B. *

C. =

D. $

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

A. Calculations

B. Formulas

C. Functions

D. Relative addressing

1403. 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
1404. In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?
comments icon0
A. Counting

B. Length

C. Counter

D. Count

1405. Main window in a computer spreadsheet is called ___________ ?
comments icon0

A. Work

B. Work book

C. Work sheet

D. Account book

1406. How many columns are in one Microsoft Excel sheet?
comments icon0
A. 16,384

B. 65,536

C. None of Above

D. 1,048,576

1407. 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

1408. 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
1409. In a computer spreadsheet rows are labeled ________ ?
comments icon0

A. by symbols

B. by letters

C. by numbers

D. by cell references

1410. Microsoft Excel 2019 files have a default extension of___________?
comments icon0

A. .Xls

B. .Xlsx

C. .excel

D. 0.123

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

A. 300

B. 500

C. 100

D. 10

1412. 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

1413. Which Operation cant be performed by Queue?
comments icon0
A. Traversing

B. Deletion

C. Insertion

D. Retrieving

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

A. Microsoft PowerPoint

B. Microsoft Excel

C. Microsoft Word

D. None of these

1415. 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

1416. 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

1417. Which of the following you can paste selectively using Paste Special Command?
comments icon0

A. mulas

B. l of above

C. mats

D. idation

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

A. Worksheets

B. Charts

C. Worksheets and Charts

D. Workbooks

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

A. F4 Key

B. F3 Key

C. F2 Key

D. F1 Key

1420. 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

1421. 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

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

A. Sodium

B. Calcium

C. Phosphorus

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

A. Alt+Enter

B. Tab

C. Ctrl+Enter

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

B. Negative number

C. Text values

D. Zero values

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

B. Accessing

C. Functioning

D. Updating

1426. How many rows are in one Microsoft Excel sheet?
comments icon0
A. 1,048,576

B. 65,536

C. None of Above

D. 16,384

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

A. Row headings

B. None of these

C. Formula bar

D. Name box

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

A. Location

B. Workbook

C. Formula

D. Worksheet

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

A. Hyperlink

B. Rows

C. Transpose

D. Index

1430. 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

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

A. label

B. All of these

C. Formula

D. Value

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

B. Space

C. Shift

D. None of these

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

A. Insert

B. View

C. Home

D. Page Layout

1434. Which of these keys are used in Ms Excel to copy value from above cell?
comments icon0

A. Ctrl+ E

B. Ctrl +

C. Ctrl+ D

D. Ctrl+ E

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

A. Workbook

B. Notesheet

C. Notebook

D. Worksheet
1436. 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

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

A. Column

B. Range

C. Function

D. Workbook

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

A. Workbook

B. Active cell

C. Menu bar

D. Pencil work
1439. 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+

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

A. Design

B. File

C. Insert

D. None of Above

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

A. Drawing

B. Formatting

C. standard

D. form

1442. 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

1443. 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
1444. 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

1445. 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

1446. 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
1447. User developed instruction for excel are called__________?
comments icon0

A. All of these

B. Procedured

C. Progrms

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

A. Currency

B. Percent

C. Comma

D. Normal
1449. 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.
1450. Which one is example of spreadsheet software?
comments icon0

A. None of these

B. MS POWERPOINT

C. MS EXCEL

D. MS WORD