MS Excel mcq Questions and Answer | Microsoft Excel-3

ms excell- 3

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

To drag a selected range of data to another worksheet in the same workbook, use the

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

Question 2

When creating a vertical page break

A	(1) The active cell must be Al
B	(2) The active cell can be anywhere in the worksheet
C	(3) The active cell must be in row 1
D	(4) The active cell must be in column A

Question 3

.To activate the previous cell in a pre-selected range press

A	(1) the Alt key
B	(2) the Tab key
C	(3) the Enter key
D	(4) none of above

Question 4

When the formula bar is activated, you can see

A	(1) The Edit Formula button
B	(2) The Cancel button
C	(3) The Enter button
D	(4) All of above

Question 5

. In a worksheet you can select

A	(1) Entire worksheet
B	(2) Rows
C	3) Columns
D	(4) a, b, and c

Question 6

. When you print preview a worksheet

A	(1) the entire worksheet is displayed
B	(2) the selected range is displayed
C	(3) the active portion of the worksheet is displayed
D	(4) a, b and c

Question 7

. You can group noncontiguous worksheets with

A	(1) The group button on the standard toolbar
B	2) The shift key and the mouse
C	(3) The Ctrl key and mouse
D	(4) The alt+enter key

Question 8

Weight refers to

A	(1) The print density of characters
B	(2) The height of the printed character
C	(3) Upright or Santed shape
D	(4) The sign and appearance f characters

Question 9

. When you link data maintained in Excel workbook to a Word document

A	(1) The Word document cannot be edited
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 10

When you see a cell with a red triangle in the top right corner, what does this signify?

A	(1) There is an error in the cell .
B	2) There is a comment associated with the cell
C	(3) The font color for text in the cell is red
D	(4) A formula cannot be entered into the cell

Question 11

To hold row and column titles in places 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 12

. To edit data in an embedded Excel worksheet object in a Word document

A	(1) Use the Excel menu bar and toolbars insjde the word application
B	(2) Edit the hyperlink
C	(3) Edit the data in a Excel source application
D	(4) Use the Word menu bar and toolbars

Question 13

. Status indicators are located on the

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

Question 14

. You can open the scenario Manager dialog box by choosing scenarios from the ..... menu.

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

Question 15

You can open the Sort dialog box by choosing Sort from the ..... menu

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

Question 16

When working in the page break preview, you can

A	(1) view exactly where each page break occurs
B	(2) add or remove page breaks
C	(3) change the print area
D	(4) all of above

Question 17

A data map is helpful

A	(1) When you have too much data to chart
B	(2) To show a geographic distribution of data
C	(3) To compare data points
D	(4) To show changes in data over time

Question 18

Hounding 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' than the calculated results

Question 19

You can copy data or formulas

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

Question 20

You can zoom a worksheet

A	(1) With the mouse pointer in Print Preview
B	(2) With the zoom button on the Print Preview toolbar
C	(3) With the Zoom command on the view menu
D	(4) All of the above

Question 21

This type of software is similar to an accountant's worksheet

A	1) Word processing
B	(2) Database
C	(3) Spreadsheets
D	4) Graphics

Question 22

which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

A	(1) Workday
B	(2) Date
C	(3) Networkdays
D	4) All of the above

Question 23

. Data marker on a chart are linked to data points in a . worksheet therefore,

A	(1) You can automatically apply formatting to a data series
B	(2) You can change the position of a data marker andautomatically change the data point value in the worksheet
C	(3) You can change a data print value and automatically are
D	(4) a and b

Question 24

When you group worksheets

A	(1) You can enter variable data on multiple worksheets at one time
B	2) You can print more than*one worksheet at a time
C	(3) You can enter common data, formats, and formulas on multiple worksheets at one time
D	(4) b, and c

Question 25

You can use the format painter , multiple times before you turn it offby

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 Alt key and clicking the format painter button

Question 26

The default header for a worksheet is

A	(1) Your name
B	(2) The date and time
C	(3) None
D	(4) The sheet tab name

Question 27

. Which of the following is an absolute cell reference?

A	(1) !A!1
B	(2) SA$1
C	(3) #a#l
D	(4) Al

Question 28

What symbol is used before a number to make it a label?

A	(1) "(quote)
B	(2) = (equal)
C	(3) _ (underscore)
D	(4) * (apostrophe)

Question 29

Which symbol must ail formula begin with?

A	(1) =
B	(2) +
C	(3) (
D	(4) e

Question 30

Which of the following formulas is not entered correctly?

A	(1) =10+50
B	(2) =B7*B1
C	(3) =B7+14
D	(4) 10+50

Question 31

Which of the following formulas will Excel Not be able to calculate?

A	(1) =SUM(Sales)-A3
B	(2) =SUM(A1:A5)*.5
C	(3) =SUM(A1:A5)/(10-10)
D	(4) =SUM(A1:A5)-10

Question 32

A typical worksheet has .... Number of columns

A	(1) 128
B	(2) 256
C	(3) 512
D	4) 1024

Question 33

How many characters can be typed in a single cell in Excel?

A	(1) 256
B	(2) 1024
C	(3) 32,000
D	(4) 65,535

Question 34

A worksheet can have a maximum of.... Number ofrows

A	(1) 256
B	(2) 1024
C	(3) 32,000
D	(4) 65,535

Question 35

. Which of the following is not an example of a value?

A	(1) 350
B	(2) May 10,2001
C	(3) 57%
D	(4) Serial Number 50771

Question 36

The chart wizard term data series refers to

A	(1) A chart legend
B	(2) A collection of chart data markers
C	(3) A set of values you plot in a chart
D	(4) A data label

Question 37

The Chart wizard term data categories refers to;

A	(1) A chart plot area
B	(2) A horizontal axis
C	(3) The organization of individual values with a chart's data series
D	(4) The data range that supply chart data

Question 38

A worksheet range is a

A	(1) A command used for data modeling
B	(2) A range of values such as from 23 to 234
C	(3) A group of cells
D	(4) A group of worksheets

Question 39

Getting data from a cell located in a different sheet is called

A	(1) Accessing
B	(2) Referencing
C	(3) Updating
D	4) Functioning

Question 40

. Tab scrolling button

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