MS Excel mcq Questions and Answer | Microsoft Excel-10

1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-10

excel-10

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
There are 40 questions to complete.
List
Return
Shaded items are complete.
12345
678910
1112131415
1617181920
2122232425
2627282930
3132333435
3637383940
Return

Leave a Reply

Your email address will not be published.

Previous Story

MS Excel mcq Questions and Answer | Microsoft Excel-9

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-11

Latest from Blog