MS Excel mcq Questions and Answer | Microsoft Excel-10

excel-10

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question 1

. When you are typing an equation into a cell the first thing that must be entered is

A	(1) the first cell referenced
B	(2) parenthesis
C	(3) quotation marks
D	(4) an equal sign

Question 2

Using the AutoSum button will replace in the selected cell......

A	(1) the sum of values jn the cell's column.
B	(2). nothing until'ybu select a range of cells
C	(3) the sum of the cell's row unless you change the range
D	(4) None of these

Question 3

Bookl is an example of how …... are numbered and named during each work session

A	(1) Active cell
B	(2) Formula bar
C	(3) Menu bar
D	(4) Name box

Question 4

Which of the following displays the contents of the active cell?

A	(1) Active cell
B	(2) Formula bar
C	(3) Menu bar
D	(4) Name box

Question 5

. Graphics objects on a chart are used to

A	1) Add emphasis to chart data
B	(2) Add interest to a chart
C	(3) Help explain the chart data
D	(4) a, b, and c

Question 6

. What does SUMIF function do?

A	(1) Adds up cell values based on a condition
B	(2) Adds all the numbers in a range of cells
C	3) Returns a subtotal in a list or database
D	4) All of above

Question 7

You can insert labels for

A	(1) All the data markers on a chart
B	2) A data series
C	(3) A selected data marker
D	(4) All

Question 8

Tab scrolling buttons

A	(1) Allow you.to view a different worksheet
B	2) Allow you to view additional worksheet row down
C	(3) Allow you to view additional worksheet columns to the right
D	(4) Allow you to view additional sheet tabs

Question 9

All macro keyboard shortcuts include the...... key

A	1) Alt
B	(2) Ctrl
C	(3) F11
D	4) Shift

Question 10

To open the Format Cells dialog box, press

A	(1) Alt* 1
B	(2) Ctrl + 1
C	(3) Ctrl + Shift + 1
D	(4) Fl

Question 11

You can add a hyperlink to your worksheet by pressing

A	(1) Alt + K
B	(2) Ctrl + H
C	(3) Ctrl + K
D	4) Ctrl + Shift + K

Question 12

To" move to the previous worksheet, press

A	(1) Alt + PgUp
B	(2) Ctrl + PgUp
C	(3) Ctrl + PgDn
D	(4) Shift + Tab

Question 13

. Hyperlinks can be

A	(1) Text
B	(2) Drawing objects
C	(3) Pictures
D	(4) All of above

Question 14

. Which button do you click to add up a series of numbers?

A	(1) The autosum button
B	(2) The Formula button
C	(3) The quicktotal button
D	(4) The total button

Question 15

When the formula bar is active, you can see

A	(1) The edit formula button
B	(2) The cancel button
C	3) The enter button
D	(4) All of the above

Question 16

Which option the following can you format using buttons on the formatting toolbar?

A	Your hard drive
B	Format painting
C	Font color
D	Underlining

Question 17

Which tab is not available on left panel when you open a presentation?

A	Outline
B	Slides
C	Notes
D	All of above

Question 18

Presentation designs regulate the formatting and layout for the slide and are commonly called

A	Design templates
B	Templates
C	Placeholders
D	Blueprints

Question 19

To copy formatting from one area in a worksheet and apply it to another area you would use :

A	(1) The Edit > Copy Format and Edit>Paste Format commands form the menu.
B	(2) The Copy and Apply Formatting dialog box, located under the Formats Copy and Apply menu.
C	(3) There is no way to copy and apply formatting in Excel You have to do it manually
D	(4) The Format Painter button on the standard toolbar

Question 20

In a worksheet you can select

A	(1) The entire worksheet
B	2) Row
C	(3) Columns
D	4) All of the above

Question 21

When you link data maintained in an excel workbook to a word document

A	(1) The word document can not be edit
B	(2) The word document contains a reference to the original source application
C	(3) The word document must contain a hyperlink
D	(4) The word document contains a copy of the actual data

Question 22

Which area in an excel window allows entering values and formulas

A	(1) Title bar
B	(2) Menu bar
C	(3) Formula bar
D	(4) Standard toolbar

Question 23

. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A	(1) Unfreeze panes command on the window menu
B	(2) Freeze panes command on the window menu
C	(3) Hold titles command on the edit menu
D	4) Split command on the window menu

Question 24

Which of the following should you use if you want all the slides in the presentation to have the same look?

A	The slid layout option
B	The add a slide option
C	Outline view
D	A presentation design template

Question 25

Which of the following uses the spelling and grammar feature to indicate incorrect spelling?

A	The incorrect word appears in all capital letters
B	.The incorrect word has a wavy red line under it
C	The incorrect word appears italicized
D	.The incorrect word appears bold

Question 26

. Status indicators are located on the

A	(1) Vertical scroll bar
B	(2) Horizontal scroll bar
C	(3) Formula bar
D	(4) Standard toolbar

Question 27

Which of the following is the oldest spreadsheet package?

A	(1) VisiCalc
B	(2) Lotus 1-2-3
C	(3) Excel
D	(4) StarCalc

Question 28

Rounding errors can occur

A	(1) When you use multiplication, division, or exponentiation in a formula
B	(2) When you use addition and subtraction in a formula
C	(3) Because excel uses hidden decimal places in computation
D	(4) When you show the results of formulas with different decimal places that the calculated results

Question 29

You can copy data or formulas

A	(1) With the copy, paste and cut commands on the edit menu
B	(2) With commands on ta shortcut menu
C	(3) With buttgns on the standard toolbars
D	(4) All of the above

Question 30

. You can not link excel worksheet data to a word document

A	(1) With the right drag method
B	(2) With a hyperlink
C	(3) With the copy and paste special commands
D	(4) With the copy and paste buttons on the standard toolbar.

Question 31

Which of the following is a popular DOS based spreadsheet package?

A	(1) Word
B	(2) Smart cell
C	(3) Excel
D	(4) Lotus 1-2-3

Question 32

. An excel workbook is a collection of

A	(1) Workbooks
B	(2) Worksheets
C	(3) Charts
D	(4) Worksheets and charts

Question 33

. Excel files have a default extension of

A	(1) Xls
B	(2) Xlw
C	(3) Wkl
D	(4) 123

Question 34

You can use the format painter multiple times before you turn it off by

A	(1) You can use the format painter button only one time when you click it
B	2) Double clicking the format painter button
C	(3) Pressing the Ctrl key and clicking the format painter button
D	(4) Pressing the Alt key and clicking the format painter button

Question 35

What function displays row data in a column or column data in a row?

A	(1) Hyperlink
B	(2) Index
C	(3) Transpose
D	(4) Rows

Question 36

When you insert an Excel file into a Word document, the data are

A	(1) Hyperlinked
B	(2) Placed in a word table
C	(3) Linked
D	(4) Embedded

Question 37

. Except for the .......function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result

A	(1) IF
B	(2) AND
C	(3) OR
D	(4) NOT

Question 38

Macros are "run" or executed from the...... menu.

A	(1) Insert
B	(2) Format
C	3) Tools
D	(4) Data

Question 39

You can open the consolidate dialog box byt choosing' Consolidate from the...... menu

A	(1) Insert
B	(2) Format
C	(3) Tools
D	(4) Data

Question 40

Each excel file is called a work-book because

A	(1) It can contain text and data
B	(2) It can be modified
C	(3) It can contain many sheets including worksheets and chart sheets
D	(4) You have to work hard to create it