Computer Awarness on MS Excel for competitive exams.Full description
Ms Excel FormulasFull description
Full description
Full description
Objective Questions on Core Java Language
PhysicsFull description
good
microwave engineering objective question bank
RCC-Objective-Questions civil engineering study material,eBooks,Notes CIVIL ENGINEERING COMPLETE SOLUTIONFull description
Full description
Full description
Beberapa materi pembelajaran dasar untuk penggunaan microsoft excel 2007.Full description
Ms Excel Notes completeFull description
Full description
Full description
MS-Word-Objective Questions (MCQ) With Solutions and ExplanationsDescrição completa
Objective Questions On Ms Excel In Ms Office Set-2
1) You can insert lebels 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 t he worksheet C. Enter text and data D. Copy the worksheet 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 lebel pdfcrowd.com
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 pdfcrowd.com
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
pdfcrowd.com
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 pdfcrowd.com
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 lebels 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 pdfcrowd.com
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 pdfcrowd.com
20) B. Create and edit formulas containing functions
Related Posts: Solved MCQ on Microsoft Excel in Ms Office set-1 Solved MCQ Of Microsoft Word Set-1 Solved Objective Questions on Microsoft Word set-2 Solved MCQ Questions on Microsoft Word set-3 MCQ Questions on Ms Word with Answer set-4 Microsoft Word MCQ Questions with Answer set-5 Microsoft Word Objective Questions with Answers set-6 MCQ Questions and Answers on Ms Word set-7 Interview Questions on Microsoft Word set-8 Solved Interview Questions on Ms Word set-9 Objective Questions on Microsoft Word set-10 For More Multiple Choice Questions(MCQ's): Click Here Shusil Baral Labels: Basic IT , Multiple Choice Question (MCQ)
You can download and save this post as PDF file:Download as PDF ENTER YOUR E-MAIL TO GET NOTIFIED ABOUT OUR LATEST BLOG UPDATES Enter E-mail Address...
Subscribe
Login
Comments There are no comments posted yet. Be the first one!
