ms-excel question bank with answer - updated

Name

Emp ID

Start Time

End Time

Duration 0:00

Team MPMA_CPU

Update the required information above and GoTo Next Sheet to start your Test….!!!

All the Best !

S.No Question Choice1-1. Comments put in cells are called ….. A

BCD

* Select Your Answer ===========>1-2. Comments can be added to cells using ….. A

BCD

* Select Your Answer ===========>1-3. Which menu option can be used to split windows into two A

BCD

* Select Your Answer ===========>1-4. Getting data from a cell located in a different sheet is call A

BCD

* Select Your Answer ===========>1-5. Which of the following is not a valid data type in Excel? A

BCD

* Select Your Answer ===========>1-6. Which elements of a worksheet can be protected from acci A

BCD

* Select Your Answer ===========>1-7. A numeric value can be treated as label value if …… precede A

BCD

* Select Your Answer ===========>1-8. Concatenation of text can be done using A

BCD

* Select Your Answer ===========>1-9. Which area in an Excel window allows entering values an A

BCD

* Select Your Answer ===========>1-10. . Multiple calculations can be made in a single formula usi A

BCD

* Select Your Answer ===========>2-1. An Excel Workbook is a collection of ……. A

BCD

* Select Your Answer ===========>2-2. What do you mean by a Workspace? A

BCD

* Select Your Answer ===========>2-3. MS-EXCEL is based on ……….? A

BCD

* Select Your Answer ===========>2-4. In EXCEL, you can sum a large range of data by simply selec A

BCD

* Select Your Answer ===========>2-5. To select an entire column in MS-EXCEL, press? A

BCD

* Select Your Answer ===========>2-6. To return the remainder after a number is divided by a di A

BCD

* Select Your Answer ===========>2-7. Which function is not available in the Consolidate dialog A

BCD

* Select Your Answer ===========>2-8. Which is not the function of “Edit, Clear” command? A

BCD

* Select Your Answer ===========>2-9. Microsoft Excel is a powerful……….. A

BCD

* Select Your Answer ===========>2-10. . How do you rearrange the data in ascending or descendi A

BCD

* Select Your Answer ===========>3-1. Which Chart can be created in Excel? A

BCD

* Select Your Answer ===========>3-2. What will be the output if you format the cell containing 5 A

BCD

* Select Your Answer ===========>3-3. How do you display current date and time in MS Excel? A

BCD

* Select Your Answer ===========>3-4. How do you display current date only in MS Excel? A

BCD

* Select Your Answer ===========>3-5. How do you wrap the text in a cell? A

BCD

* Select Your Answer ===========>3-6. What does COUNTA () function do? A

BCD

* Select Your Answer ===========>3-7. What is the short cut key to highlight the entire column? A

BCD

* Select Your Answer ===========>3-8. In the formula, which symbol specifies the fixed columns A

BCD

* Select Your Answer ===========>3-9. Excel displays the current cell address in the ………. A

BCD

* Select Your Answer ===========>3-10. . What is the correct way to refer the cell A10 on sheet3 f A

BCD

* Select Your Answer ===========>4-1. Which language is used to create macros in Excel? A

BCD

* Select Your Answer ===========>4-2. Which of the following is not a term of MS-Excel? A

BCD

* Select Your Answer ===========>4-3. How many worksheets can a workbook have? A

BCD

* Select Your Answer ===========>4-4. Which would you choose to create a bar diagram? A

BCD

* Select Your Answer ===========>4-5. Which setting you must modify to print a worksheet using A

BCD

* Select Your Answer ===========>4-6. What do you call the chart that shows the proportions of A

BCD

* Select Your Answer ===========>4-7. The spelling dialog box can be involved by choosing spelli A

BCD

* Select Your Answer ===========>4-8. Which key do you press to check spelling? A

BCD

* Select Your Answer ===========>4-9. To record a sequence of keystrokes and mouse actions to p A

BCD

* Select Your Answer ===========>4-10. . We can save and protect the workbook by A

BCD

* Select Your Answer ===========>5-1. The first cell in EXCEL worksheet is labeled as A

BCD

* Select Your Answer ===========>5-2. What happens when dollar signs ($) are entered in a cell A

BC

D* Select Your Answer ===========>

5-3. What are the tabs that appear at the bottom of each work ABCD

* Select Your Answer ===========>5-4. What is represented by the small, black square in the lower A

BCD

* Select Your Answer ===========>5-5. In Excel, a Data Series is defined as what? A

B

CD

* Select Your Answer ===========>5-6. In Excel, the Fill Color button on the Formatting toolbar is A

BCD

* Select Your Answer ===========>5-7. In help menu of Excel, which of the following tabs are fou A

BCD,

* Select Your Answer ===========>5-8. A __________ is a grid with labeled columns and rows. A

BCD

* Select Your Answer ===========>5-9. The active cell: A

BCD

* Select Your Answer ===========>5-10. Which function is used to calculate depreciation, rates o A

BCD

* Select Your Answer ===========>6-1. B7:B9 indicates: A

BCD

* Select Your Answer ===========>6-2. The Cancel and Enter buttons appear in the: A

BCD

* Select Your Answer ===========>6-3. MS-EXCEL can be used to automate A

BCD

* Select Your Answer ===========>6-4. NOT, AND, OR and XOR are A

B

CD

* Select Your Answer ===========>6-5. In a report, you need to show the monthly rainfall in Nepal. A

BCD

* Select Your Answer ===========>6-6. You want to record experiment information and create a cha A

BCD

* Select Your Answer ===========>6-7. You are editing an worksheet that you had previously save A

BCD

* Select Your Answer ===========>6-8. If you want to have a blank line after the title in a workshe A

BCD

* Select Your Answer ===========>6-9. In order to arrange the countries from those with the hig A

BCD

* Select Your Answer ===========>6-10. . In order to perform a calculation in a spreadsheet, you ne A

BCD

* Select Your Answer ===========>7-1. The box on the chart that contains the name of each individu A

BCD

* Select Your Answer ===========>7-2. If you want all of the white cats grouped together in the dat A

BCD

* Select Your Answer ===========>7-3. You accidentally erased a record in the sheet. What comma A

B

CD

* Select Your Answer ===========>7-4. Where a row and a column meet, what do you call that? A

BCD

* Select Your Answer ===========>7-5. How do you tell one cell from another? A

BCD

* Select Your Answer ===========>7-6. Give me an example of a cell address. A

BCD

* Select Your Answer ===========>7-7. Which is an example of a formula? A

BCD

* Select Your Answer ===========>7-8. Which is an example of a function? A

BCD

* Select Your Answer ===========>7-9. What is the symbol for multiplying? A

BCD

* Select Your Answer ===========>7-10. What is the symbol for dividing? A

BCD

* Select Your Answer ===========>8-1. A function inside another function is called _______ A

BCD

* Select Your Answer ===========>8-2. Which of the following is not an underline option in the fo A

B

CD

* Select Your Answer ===========>8-3. Formulas in Excel start with A

BCD

* Select Your Answer ===========>8-4. The default header for a worksheet is A

BCD

* Select Your Answer ===========>8-5. Which of the following is not an option of the spelling dia A

BCD

* Select Your Answer ===========>8-6. Which of the following methods will not enter data in a cel A

BC


8-7. The cell reference for cell range of G2 to M12 is _______ ABCD

* Select Your Answer ===========>8-8. What is the keyboard shortcut for creating a chart from th A

BCD

* Select Your Answer ===========>8-9. The Software which contains rows and columns is called __ A

BCD

* Select Your Answer ===========>8-10. You can group noncontiguous worksheets with A

BCD

* Select Your Answer ===========>

9-1. What is the AutoComplete feature of Excel? A

B

C


9-2. Which of the following is correct? ABCD

* Select Your Answer ===========>9-3. Which of the following function will return a value of 8? A

BCD

* Select Your Answer ===========>9-4. How to restrict to run a macro automatically when startin A

BCD

* Select Your Answer ===========>9-5. How to remove the unwanted action from recorded macro A

B

CD

* Select Your Answer ===========>9-6. What should be add before a fraction to avoid entering it a A

BCD

* Select Your Answer ===========>9-7. Which of the following function will use to find the highe A

BCD


9-8. What does the NOW() function return? A

B

CD

* Select Your Answer ===========>9-9. What value will display if the formula = “$55.00?+5 is enter A

BCD

* Select Your Answer ===========>9-10. . What is the shortcut key to insert current date in a cell? A

BCD

* Select Your Answer ===========>10-1. Which of the following syntax is correct regarding to SUM A

BCD

* Select Your Answer ===========>10-2. What is the shortcut key to hide entire column? A

BCD

* Select Your Answer ===========>10-3. How to specify cell range from A9 to A99 in Excel? A

BCD

* Select Your Answer ===========>10-4. Selecting the Column G & H then choose Insert->Columns. A

BCD


10-5. How to restrict the values of a cell so that only whole num A

B

C


10-6. Clear the contents by pressing “DELETE” key from a keyboa AB

CD

* Select Your Answer ===========>10-7. Which of the following shortcuts can be used to insert a ne A

BCD

* Select Your Answer ===========>10-8. What is the quickest way to select entire worksheet? A

B

C


10-9. A smart tag will be removed from a cell when ABCD

* Select Your Answer ===========>10-10. Which of the following options is appropriate to show th A

BC


Objective Answer Selected AnswerSmart TipCell TipWeb TipSoft Tip

-

Edit -> CommentsInsert -> CommentFile -> CommentsView –> Comments

-

Format -> WindowView -> Window-> SplitWindow -> SplitView –> Split

-

AccessingReferencingUpdatingFunctioning

-

NumberCharacterLabelDate/Time

-

ContentsObjectsScenariosAll of the above

-

Apostrophe (‘)Exclamation (!)Hash (#)Tilde (~)

-

Apostrophe (‘)Exclamation (!)Hash (#)Ampersand (&)

-

Title BarMenu BarFormula BarStandard Tool Bar

-

Standard FormulasArray FormulaComplex FormulasSmart Formula

-

WorkbooksWorksheetsChartsWorksheets and Charts

-

Group of ColumnsGroup of WorksheetsGroup of RowsGroup of Workbooks

-

WINDOWSDOSUNIXOS/2

-

AutoFillAuto correctAuto sumAuto format

-

CTRL + CCTRL + Arrow keyCTRL + SNone of the above

-

ROUND ( )FACT ( )MOD ( )DIV ( )

-

PmtAverageMaxSum

-

Delete contentsDelete notesDelete cellsDelete formats

-

Word processing packageSpreadsheet packageCommunication S/W PackageDBMS package

-

Data, SortData, FormData, TableData Subtotals

-

AreaLinePieAll of the above

-

5,430.005,436.805,436.806.8

-

date ()Today ()now ()time ()

-

date ()Today ()now ()time ()

-

Format, cells, fontFormat, cells, protectionformat, cells, numberFormat, cells, alignment

-

counts cells having alphabetscounts empty cellscounts cells having numbercounts non-empty cells

-

Ctrl+CCtrl+EnterCtrl+Page UpCtrl+Space Bar

-

$*%&

-

Formula barStatus BarName BoxTitle Bar

-

sheet3!A10sheet1!A10Sheet3.A10A10

-

Visual BasicCVisual C++Java

-

CellsRowsColumnsDocument

-

38255none of above

-

Edit, ChartInsert, ChartTools, ChartFormat, Chart

-

PaperMarginLayoutOrientation

-

XY ChartLine ChartPie ChartColumn Chart

-

insertfiletoolsview

-

F3F5F7F9

-

Media playerSound RecorderCalculatorMacro Recorder

-

Write Reservation PasswordProtection PasswordRead-only RecommendedAny of the above

-

AAA1AaA0

-

An absolute cell address is created.

The sheet tab is changed.

-

Reference tabsPosition tabsLocation tabsSheet tabs

-

Copy handleFill handleInsert handleBorder

-

A type of chart.A cell reference.

Cell address will change when it is copied to another cell.

The status bar does not display the cell address.

A collection of related dataA division of results

-

To insert a background.To add borders.To select a distribution of figures.To add shading or color to a cell range.

-

Contents tabAnswer Wizard tabIndex tabAll the above

-

Dialog boxWorksheetClipboardToolbar

-

is defined by a bold border around the cell.Receives the data the user enters.It is the formula bar.Only A and B.

-

LogicalMath & TrigonometryStatisticalFinancial

-

Cells B7 and cell B9 only.Cells B7 through B9.Cell B8 only.None of the above.

-

Title barFormula barMenu barSheet tabs

-

Financial statements, Business forecastingTransaction registers, inventory controlAccounts receivable, accounts payableAny of the above

-

Logical OperatorsArithmetic operators

Relational operatorsNone of the above

-

calendarphotograph of rainfallchart showing rainfall amountsdatabase of rainfall

-

word processingspreadsheetdatabasegraphics

-

NewSave AsEditSave

-

Re-format the spreadsheetInsert a rowIncrease the columnUse the spacebar

-

ascending orderdescending orderalphabetical orderrandom order

-

tableformulafieldvariable

-

celltitleaxislegend

-

Color, then GenderPet Type, then ColorPet Type, then GenderColor, then Pet Name

-

InsertCopy

UndoReplace

-

A cellA blockA boxNone of the above

-

By numbersBy lettersBy its addressby color

-

11 2591141AA21

-

=A1+A2=add(A1:A2)A1+A2SUM(A1:A2)

-

=add(A3:A4)=A3+A4=SUM(A3:A4)A1+A2

-

>/!*

-

./%&#

-

Nested functionRound functionSum functionText function

-

DoubleSingle Accounting

Double AccountingSingle Engineering

-

%=+-

-

UsernameDate and TimeSheet tab NameNone

-

IgnoreIgnore allEditChange

-

Pressing the Esc keyPressing an arrow keyPressing the tab key

Clicking the enter button to the formula bar-

G2.M12G2;M12G2:M12G2-M12

-

F2F4F8F11

-

DatabaseDrawingSpreadsheetWord processing

-

The alt+enter keyThe ctrl key and mouseThe shift key and the mouseThe group button on the standard toolbar

-

It automatically completes abbreviated words

-

=AVERAGE(4, 5, 6, 7)=AVERAGE(A3, C2, D2)=AVERAGE(A3:A11, C2:C10)=All of the above

-

ROUNDUP(8.4999, 0)ROUNDDOWN(8.4999, 0)ROUND(8.4999, 0)Only B and C

-

Hold down the SHIFT key during startupHold down the CTRL key during startupHold down the ESC key during startupHold down the ALT key during startup

-

By using the Find and Edit Action Option

By edit the macro in the Visual Basic EditorMacro cannot be edited.

-

//FRZeroZero Space

-

MAX(B1:B3)MAXIMUM (B1:B3)HIGH (B1:B3)HIGHEST(B1:B3)

-

It completes text entries that match an existing entry in the same column

It completes text and numeric entries that match an existing entry in the same column

It completes text entries that match an existing entry in the same worksheet

By clicking on the Refresh button in the Macro toolbar

It returns the serial number of the current date and time

It returns the serial number of the current date

None of the above-

$60 60“$55.00?+5$60.00

-

CTRL + DCTRL + TCTRL + ;CTRL + /

-

=SUM (A3, C2) -

=SUM (A1:C9)=SUM (A3:A11, C2:C10)All of the above

-

CTRL + -CTRL + 0CTRL + HCTRL + C

-

(A9, A99)(A9 to A99)(A9 : A99)(A9 – A99)

-

2 Columns will be inserted after Column F2 Columns will be inserted after Column G2 Columns will be inserted after Column H2 Columns will be inserted after Column I

-

-

Text OnlyFormat Only

It returns the serial number of the current time

The Settings tab under the menu Format -> Cells

The Settings tab under the menu Data -> Validation

The Settings tab under the menu Data -> Filter -> Advanced Filter

the Settings tab under the menu Format -> Conditional Formatting

Contents OnlyBoth Contents and Format

-

EnterAlt + EnterCtrl + EnterShift + Enter

-

Choose Edit -> Select all from the Menu

-

the cell is movedthe cell is hiddenthe data in the cell is changed or deletedthe formatting of the cell is changed

-

Enclose the number is bracketsPlace the character T before the numberPlace the character TX before the number

-

Click on the first column, press Ctrl, and then click on the last column

Click on the first column, press Shift, and then click on the last column

Click on the rectangle box on the upper left corner where column headings and row headings meet

Apply the Text format in the cell and type the numbers

S.No Question

1-1. Comments put in cells are called …..

Select Your Answer ===========>

1-2. Comments can be added to cells using …..


1-3. Which menu option can be used to split windows into two?

Select Your Answer ===========>1-4. Getting data from a cell located in a different sheet is called….

Select Your Answer ===========>1-5. Which of the following is not a valid data type in Excel?

Select Your Answer ===========>1-6. Which elements of a worksheet can be protected from accidental modification?

Select Your Answer ===========>1-7. A numeric value can be treated as label value if …… precedes it.

Select Your Answer ===========>1-8. Concatenation of text can be done using

Select Your Answer ===========>1-9. Which area in an Excel window allows entering values and formulas?


1-10. . Multiple calculations can be made in a single formula using…..

Select Your Answer ===========>2-1. An Excel Workbook is a collection of …….


2-2. What do you mean by a Workspace?

Select Your Answer ===========>2-3. MS-EXCEL is based on ……….?

Select Your Answer ===========>2-4. In EXCEL, you can sum a large range of data by simply selecting a tool button called

Select Your Answer ===========>2-5. To select an entire column in MS-EXCEL, press?

Select Your Answer ===========>2-6. To return the remainder after a number is divided by a divisor in EXCEL we use th

Select Your Answer ===========>2-7. Which function is not available in the Consolidate dialog box?

Select Your Answer ===========>2-8. Which is not the function of “Edit, Clear” command?


2-9. Microsoft Excel is a powerful………..

Select Your Answer ===========>2-10. . How do you rearrange the data in ascending or descending order?

Select Your Answer ===========>3-1. Which Chart can be created in Excel?

Select Your Answer ===========>3-2. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?

Select Your Answer ===========>3-3. How do you display current date and time in MS Excel?

Select Your Answer ===========>3-4. How do you display current date only in MS Excel?


3-5. How do you wrap the text in a cell?


3-6. What does COUNTA () function do?

Select Your Answer ===========>3-7. What is the short cut key to highlight the entire column?

Select Your Answer ===========>3-8. In the formula, which symbol specifies the fixed columns or rows?

Select Your Answer ===========>3-9. Excel displays the current cell address in the ……….

Select Your Answer ===========>3-10. . What is the correct way to refer the cell A10 on sheet3 from sheet1?

Select Your Answer ===========>4-1. Which language is used to create macros in Excel?

Select Your Answer ===========>4-2. Which of the following is not a term of MS-Excel?

Select Your Answer ===========>4-3. How many worksheets can a workbook have?

Select Your Answer ===========>4-4. Which would you choose to create a bar diagram?

Select Your Answer ===========>4-5. Which setting you must modify to print a worksheet using letterhead?

Select Your Answer ===========>4-6. What do you call the chart that shows the proportions of how one or more data el

Select Your Answer ===========>4-7. The spelling dialog box can be involved by choosing spelling from ________ menu.

Select Your Answer ===========>4-8. Which key do you press to check spelling?

Select Your Answer ===========>4-9. To record a sequence of keystrokes and mouse actions to play back later we use:


4-10. . We can save and protect the workbook by

Select Your Answer ===========>5-1. The first cell in EXCEL worksheet is labeled as


5-2. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10

Select Your Answer ===========>5-3. What are the tabs that appear at the bottom of each workbook called?

Select Your Answer ===========>5-4. What is represented by the small, black square in the lower-right corner of an activ

Select Your Answer ===========>5-5. In Excel, a Data Series is defined as what?


5-6. In Excel, the Fill Color button on the Formatting toolbar is used for what?

Select Your Answer ===========>5-7. In help menu of Excel, which of the following tabs are found?

Select Your Answer ===========>5-8. A __________ is a grid with labeled columns and rows.


5-9. The active cell:

Select Your Answer ===========>5-10. Which function is used to calculate depreciation, rates of return, future values a


6-1. B7:B9 indicates:

Select Your Answer ===========>6-2. The Cancel and Enter buttons appear in the:


6-3. MS-EXCEL can be used to automate


6-4. NOT, AND, OR and XOR are

Select Your Answer ===========>6-5. In a report, you need to show the monthly rainfall in Nepal. The best way to do this

Select Your Answer ===========>6-6. You want to record experiment information and create a chart that shows the rate o

Select Your Answer ===========>6-7. You are editing an worksheet that you had previously saved. If you want to save t


6-8. If you want to have a blank line after the title in a worksheet, what is the best thing

Select Your Answer ===========>6-9. In order to arrange the countries from those with the highest population to those

Select Your Answer ===========>6-10. . In order to perform a calculation in a spreadsheet, you need to use a:

Select Your Answer ===========>7-1. The box on the chart that contains the name of each individual record is called the _


7-2. If you want all of the white cats grouped together in the database, you need to sort b

Select Your Answer ===========>7-3. You accidentally erased a record in the sheet. What command can be used to resto

Select Your Answer ===========>7-4. Where a row and a column meet, what do you call that?

Select Your Answer ===========>7-5. How do you tell one cell from another?

Select Your Answer ===========>7-6. Give me an example of a cell address.

Select Your Answer ===========>7-7. Which is an example of a formula?

Select Your Answer ===========>7-8. Which is an example of a function?

Select Your Answer ===========>7-9. What is the symbol for multiplying?

Select Your Answer ===========>7-10. What is the symbol for dividing?

Select Your Answer ===========>8-1. A function inside another function is called _______

Select Your Answer ===========>8-2. Which of the following is not an underline option in the format cells dialog box?

Select Your Answer ===========>8-3. Formulas in Excel start with

Select Your Answer ===========>8-4. The default header for a worksheet is


8-5. Which of the following is not an option of the spelling dialog box?


8-6. Which of the following methods will not enter data in a cell?

Select Your Answer ===========>8-7. The cell reference for cell range of G2 to M12 is _______

Select Your Answer ===========>8-8. What is the keyboard shortcut for creating a chart from the selected cell range?

Select Your Answer ===========>8-9. The Software which contains rows and columns is called ______

Select Your Answer ===========>8-10. You can group noncontiguous worksheets with


9-1. What is the AutoComplete feature of Excel?


9-2. Which of the following is correct?


9-3. Which of the following function will return a value of 8?


9-4. How to restrict to run a macro automatically when starting Microsoft Excel?


9-5. How to remove the unwanted action from recorded macro without recording the

Select Your Answer ===========>9-6. What should be add before a fraction to avoid entering it as a date?

Select Your Answer ===========>9-7. Which of the following function will use to find the highest number in a series of


9-8. What does the NOW() function return?

Select Your Answer ===========>9-9. What value will display if the formula = “$55.00?+5 is entered into a cell?

Select Your Answer ===========>9-10. . What is the shortcut key to insert current date in a cell?

Select Your Answer ===========>10-1. Which of the following syntax is correct regarding to SUM function in Excel?

Select Your Answer ===========>10-2. What is the shortcut key to hide entire column?

Select Your Answer ===========>10-3. How to specify cell range from A9 to A99 in Excel?


10-4. Selecting the Column G & H then choose Insert->Columns. What will happen?


10-5. How to restrict the values of a cell so that only whole numbers between 9 and 99 ca

Select Your Answer ===========>10-6. Clear the contents by pressing “DELETE” key from a keyboard will clear

Select Your Answer ===========>10-7. Which of the following shortcuts can be used to insert a new line in the same cell?


10-8. What is the quickest way to select entire worksheet?

Select Your Answer ===========>10-9. A smart tag will be removed from a cell when


10-10. Which of the following options is appropriate to show the numbers 9779851089510

Choice Objective Answer Answer Check Answer

A Smart Tip NAME

B Cell Tip 0C Web TipD Soft Tip

0 B 0

A Edit -> Comments

B Insert -> CommentC File -> Comments

D0 B 0

A Format -> Window

BC Window -> SplitD View –> Split

0 C 0

A AccessingB ReferencingC UpdatingD Functioning

0 B 0

A NumberB CharacterC LabelD Date/Time

0 B 0

A ContentsB ObjectsC ScenariosD All of the above

0 D 0

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

0 A 0

A Apostrophe (‘)B Exclamation (!)C Hash (#)D Ampersand (&)

View –> Comments

View -> Window-> Split

0 D 0

A Title BarB Menu BarC Formula Bar

D Standard Tool Bar0 C 0

AB Array Formula

C Complex FormulasD Smart Formula

0 B 0

A WorkbooksB WorksheetsC Charts

D0 D 0

A Group of Columns

BC Group of Rows

D0 D 0

A WINDOWSB DOSC UNIXD OS/2

0 A 0

A AutoFillB Auto correctC Auto sumD Auto format

0 C 0

A CTRL + C

B CTRL + Arrow keyC CTRL + S

D None of the above0 D 0

A ROUND ( )

Standard Formulas

Worksheets and Charts

Group of Worksheets

Group of Workbooks

B FACT ( )C MOD ( )D DIV ( )

0 C 0

A PmtB AverageC MaxD Sum

0 A 0

A Delete contentsB Delete notesC Delete cellsD Delete formats

0 C 0

A

B

CD DBMS package

0 B 0

A Data, SortB Data, FormC Data, TableD Data Subtotals

0 A 0

A AreaB LineC PieD All of the above

0 D 0

A 5,430.00B 5,436.80C 5,436.80D 6.8

0 B 0

A date ()B Today ()C now ()D time ()

0 C 0

A date ()B Today ()C now ()

Word processing package

Spreadsheet package

Communication S/W Package

D time ()0 B 0

A Format, cells, font

B

C

D0 D 0

A

B counts empty cells

C

D0 D 0

A Ctrl+CB Ctrl+EnterC Ctrl+Page UpD Ctrl+Space Bar

0 D 0

A $B *C %D &

0 A 0

A Formula barB Status BarC Name BoxD Title Bar

0 C 0

A sheet3!A10B sheet1!A10C Sheet3.A10D A10

0 A 0

A Visual BasicB CC Visual C++D Java

0 A 0

A Cells

Format, cells, protection

format, cells, number

Format, cells, alignment

counts cells having alphabets

counts cells having number

counts non-empty cells

B RowsC ColumnsD Document

0 D 0

A 3B 8C 255D none of above

0 D 0

A Edit, ChartB Insert, ChartC Tools, ChartD Format, Chart

0 B 0

A PaperB MarginC LayoutD Orientation

0 B 0

A XY ChartB Line ChartC Pie ChartD Column Chart

0 C 0

A insertB fileC toolsD view

0 C 0

A F3B F5C F7D F9

0 C 0

A Media playerB Sound RecorderC CalculatorD Macro Recorder

0 D 0

A

B

Write Reservation Password

Protection Password

CD Any of the above

0 D 0

A AAB A1C AaD A0

0 B 0

A

B

C

D0 A 0

A Reference tabsB Position tabsC Location tabsD Sheet tabs

0 D 0

A Copy handleB Fill handleC Insert handleD Border

0 B 0

A A type of chart.B A cell reference.

C

D0 C 0

AB To add borders.

C

Read-only Recommended

An absolute cell address is created.

Cell address will change when it is copied to another cell.

The sheet tab is changed.

The status bar does not display the cell address.

A collection of related data

A division of results

To insert a background.

To select a distribution of figures.

D0 D 0

A Contents tab

BC Index tabD, All the above

0 D 0

A Dialog boxB WorksheetC ClipboardD Toolbar

0 B 0

A

B

CD Only A and B.

0 D 0

A Logical

BC StatisticalD Financial

0 D 0

A

BC Cell B8 only.

D None of the above.0 B 0

A Title barB Formula barC Menu barD Sheet tabs

0 B 0

To add shading or color to a cell range.

Answer Wizard tab

is defined by a bold border around the cell.

Receives the data the user enters.

It is the formula bar.

Math & Trigonometry

Cells B7 and cell B9 only.

Cells B7 through B9.

A

B

CD Any of the above

0 D 0

A Logical Operators

B

C

D None of the above0 A 0

A calendar

B

C

D0 C 0

A word processingB spreadsheetC databaseD graphics

0 B 0

A NewB Save AsC EditD Save

0 B 0

AB Insert a row

CD Use the spacebar

Financial statements, Business forecasting

Transaction registers, inventory control

Accounts receivable, accounts payable

Arithmetic operators

Relational operators

photograph of rainfall

chart showing rainfall amounts

database of rainfall

Re-format the spreadsheet

Increase the column

0 B 0

A ascending orderB descending order

C alphabetical orderD random order

0 B 0

A tableB formulaC fieldD variable

0 B 0

A cellB titleC axisD legend

0 D 0

A Color, then Gender

B

C

D0 B 0

A InsertB CopyC UndoD Replace

0 C 0

A A cellB A blockC A box

D None of the above0 A 0

A By numbersB By lettersC By its addressD by color

0 C 0

A 11 25B 911C 41A

Pet Type, then Color

Pet Type, then Gender

Color, then Pet Name

D A210 D 0

A =A1+A2B =add(A1:A2)C A1+A2D SUM(A1:A2)

0 A 0

A =add(A3:A4)B =A3+A4C =SUM(A3:A4)D A1+A2

0 C 0

A >B /C !D *

0 D 0

A ./B %C &D #

0 A 0

A Nested functionB Round functionC Sum functionD Text function

0 A 0

A Double

B Single Accounting

C Double Accounting

D Single Engineering0 D 0

A %B =C +D -

0 B 0

A UsernameB Date and TimeC Sheet tab NameD None

0 D 0

A IgnoreB Ignore allC EditD Change

0 C 0

A

B

C

D0 A 0

A G2.M12B G2;M12C G2:M12D G2-M12

0 C 0

A F2B F4C F8D F11

0 D 0

A DatabaseB DrawingC SpreadsheetD Word processing

0 C 0

A The alt+enter key

B

C

D0 B 0

A

Pressing the Esc key

Pressing an arrow key

Pressing the tab key

Clicking the enter button to the formula bar

The ctrl key and mouse

The shift key and the mouse

The group button on the standard toolbar

It automatically completes abbreviated words

B

C

D0 B 0

A

B

CD =All of the above

0 D 0

A

B

C ROUND(8.4999, 0)D Only B and C

0 D 0

A

B

C

D0 A 0

It completes text entries that match an existing entry in the same column

It completes text and numeric entries that match an existing entry in the same column

It completes text entries that match an existing entry in the same worksheet

=AVERAGE(4, 5, 6, 7)

=AVERAGE(A3, C2, D2)

=AVERAGE(A3:A11, C2:C10)

ROUNDUP(8.4999, 0)

ROUNDDOWN(8.4999, 0)

Hold down the SHIFT key during startup

Hold down the CTRL key during startup

Hold down the ESC key during startup

Hold down the ALT key during startup

A

B

C

D0 C 0

A //B FRC ZeroD Zero Space

0 D 0

A MAX(B1:B3)

BC HIGH (B1:B3)D HIGHEST(B1:B3)

0 A 0

A

B

C

D None of the above0 D 0

A $60 B 60C “$55.00?+5D $60.00

0 B 0

A CTRL + DB CTRL + TC CTRL + ;D CTRL + /

By using the Find and Edit Action Option

By clicking on the Refresh button in the Macro toolbar

By edit the macro in the Visual Basic Editor

Macro cannot be edited.

MAXIMUM (B1:B3)

It returns the serial number of the current date and time

It returns the serial number of the current date

It returns the serial number of the current time

0 C 0

A =SUM (A3, C2)B =SUM (A1:C9)

CD All of the above

0 D 0

A CTRL + -B CTRL + 0C CTRL + HD CTRL + C

0 B 0

A (A9, A99)B (A9 to A99)C (A9 : A99)D (A9 – A99)

0 C 0

A

B

C

D0 A 0

A

B

C

D

=SUM (A3:A11, C2:C10)

2 Columns will be inserted after Column F

2 Columns will be inserted after Column G

2 Columns will be inserted after Column H

2 Columns will be inserted after Column I

The Settings tab under the menu Format -> Cells

The Settings tab under the menu Data -> Validation

The Settings tab under the menu Data -> Filter -> Advanced Filter

the Settings tab under the menu Format -> Conditional Formatting

0 B 0

A Text OnlyB Format OnlyC Contents Only

D0 C 0

A EnterB Alt + EnterC Ctrl + EnterD Shift + Enter

0 B 0

A

B

C

D0 D 0

A the cell is movedB the cell is hidden

C

D0 C 0

A

Both Contents and Format

Choose Edit -> Select all from the Menu

Click on the first column, press Ctrl, and then click on the last column

Click on the first column, press Shift, and then click on the last column

Click on the rectangle box on the upper left corner where column headings and row headings meet

the data in the cell is changed or deleted

the formatting of the cell is changed

Enclose the number is brackets

B

C

D0 D 0

Place the character T before the number

Place the character TX before the number

Apply the Text format in the cell and type the numbers

EMP ID DURATION RIGHT ANSWER PERCENTAGE RESULT

0 0:00 0 0.00% F A ! L

B / 2 – B / 3 – C / 4 – B / 5 – B / 6 – D / 7 – A / 8 – D / 9 – C / 10 – B

1– D / 2 – D / 3 – A / 4 – C / 5 – D / 6 – C / 7 – A / 8 – C / 9 – B / 10 – A

1-D / 2 – B / 3 – C / 4 – B / 5 – D / 6 – D / 7 – D / 8 – A / 9 – C / 10 – A

1-D / 2 – B / 3 – C / 4 – B / 5 – D / 6 – D / 7 – D / 8 – A / 9 – C / 10 – A

1– A / 2 – D / 3 – D / 4 – B / 5 – B / 6 – C / 7 – C / 8 – C / 9 – D / 10 – D

1– B / 2 – A / 3 – D / 4 – B / 5 – C / 6 – D / 7 – D / 8 – B / 9 – D / 10 – D

1– B / 2 – A / 3 – D / 4 – B / 5 – C / 6 – D / 7 – D / 8 – B / 9 – D / 10 – D

1b 2B 3D 4A 5C 6B 7B 8B 9B 10B

1– D / 2 – B / 3 – C / 4 – A / 5 – C / 6 – D / 7 – A / 8 – C / 9 – D /10 – A

1– D / 2 – B / 3 – C / 4 – A / 5 – C / 6 – D / 7 – A / 8 – C / 9 – D /10 – A

1– A / 2 – D / 3 – B / 4 – D / 5 – C / 6 – A / 7 – C / 8 – D / 9 – C / 10 – B

1– A / 2 – D / 3 – B / 4 – D / 5 – C / 6 – A / 7 – C / 8 – D / 9 – C / 10 – B

1– B / 2 – D / 3 – D / 4 – A / 5 – C / 6 – D / 7 – A / 8 – D / 9 – B / 10 – C

1– B / 2 – D / 3 – D / 4 – A / 5 – C / 6 – D / 7 – A / 8 – D / 9 – B / 10 – C

1– D / 2 – B / 3 – C / 4 – A / 5 – B / 6 – C / 7 – B / 8 – D / 9 – C / 10 – D

1-D / 2 – B / 3 – C / 4 – B / 5 – D / 6 – D / 7 – D / 8 – A / 9 – C / 10 – A

1-D / 2 – B / 3 – C / 4 – B / 5 – D / 6 – D / 7 – D / 8 – A / 9 – C / 10 – A

1– B / 2 – D / 3 – D / 4 – A / 5 – C / 6 – D / 7 – A / 8 – D / 9 – B / 10 – C

ms-excel question bank with answer - updated

Documents