CS/IT MCQ Collections

Objective Questions on Ms Excel in Ms Office set-2

Pinterest LinkedIn Tumblr
In this set of objective questions on Ms Excel in MS office includes MCQ questions of basic step in creating a worksheet, formatting of data level, entering values and formulas, embedded chart, worksheet design criterion, data marker on a chart, absolute cell reference in ms excel and short-cut key to create a chart on chart sheet.

1) You can insert labels for
A. All the data makers on a chart
B. A data series
C. A selected data marker
D. All of the above

2) Which of the following is not a basic step in creating a worksheet ?
A. Save the workbook
B. Modify the worksheet
C. Enter text and data
D. Copy the worksheet

3) Data can be arranged in a worksheet in an easy to understand manner using
A. Auto Formatting
B. Applying Styles
C. Changing fonts
D. All of these

4) Chart tips can
A. Show the formatting of data level
B. Show the name of a data series
C. Show the value of data point
D. Both B and C

5) Tab scrolling buttons ..
A. Allow you to view different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Allow you to view additional sheet tabs

6) Which area in an excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard tool bar

7) A data map is helpful
A. When you have too much data to chart
B. To show a geographic distribution of data
C. To compare data points
D. To show changes in data over time

8) Documentation should include
A. Destination and users of the output data
B. Source of input data
C. Information on the purpose of the workbook
D. All of the above

9) Multiple calculations can be made in a single formula using
A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula

10) You can print only an embedded chart by .
A. Moving the chart to a chart sheet before
B. Formatting the chart before you print
C. Selecting the chart before you print
D. Both A and C

11) Which of the following is not a worksheet design criterion?
A. Efficiency
B. Audibility
C. Description
D. Clarity

12) Which of the following methods cannot be used to enter data in a cell?
A. Pressing an arrow key
B. Pressing the TAB key
C. Pressing the ESC key
D. Clicking on the formula bar

13) Data marker on a chart are linked to data points in a worksheet, therefore,
A. You can automatically apply formatting to data series
B. You can change the position of a data marker and automatically change the data point in the worksheet.
C. You can change a data point valued and automatically are draw the chart
D. Both A and B

14) We can select the column heading
A. Click on column heading
B. Edit choose the select than click on column
C. Both of the above
D. None of the above

15) The name box
A. Shows the location of the previously active cell
B. Appears to the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar

16) To select an individual data markers or data label, you must
A. Double click the data series
B. Right click selected marker
C. Click once to select the series markers or levels and click the designed marker or label again
D. Double click on the marker or label

17) Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #A#1
D. A1

18) You can use the formula palette to
A. Format cells containing numbers
B. Create and edit formulas containing functions
C. Enter assumptions data
D. Copy a range of cells

19) Using the F11 short-cut key to create a chart on chart sheet creates
A. A default chart
B. A 2-dimensional column chart
C. A 2-dimensional bar chart
D. A 3-dimensional line chart

20) You can use formula palette to
A. Format cells containing numbers
B. Create and edit formulas containing functions
C. Enter assumptions data
D. Copy a range of cells

Answers:

1) D. All of the above
2) D. Copy the worksheet
3) D. All of these
4) D. Both B and C
5) D. Allow you to view additional sheet tabs
6) C. Formula bar
7) B. To show a geographic distribution of data
8) D. All of the above
9) B. Array Formula
10) D. Both A and C
11) C. Description
12) C. Pressing the ESC key
13) B. You can change the position of a data marker and automatically change the data point in the worksheet.
14) C. Both of the above
15) B. Appears to the left of the formula bar
16) D. Double click on the marker or label
17) B. $A$1
18) B. Create and edit formulas containing functions
19) B. A 2-dimensional column chart
20) B. Create and edit formulas containing functions

Read More: MCQ Questions on Microsoft Excel in Ms Office set-3

Author

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 8 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.

Comments are closed.