According to the National Examination Guideline for Computer Application Ability of Professional Personnel issued in 2010 by Examination Centre of the Ministry of Human Resources and Social Security, this book is compiled after years of studying the examination features and question-answering rules. There are 9 chapters. Chapter 0 concludes the key points in the examination and the questioning mode, providing the the examinees with an all-around review and testing strategy, after making a research into the examination guideline and the examination environment. Chapter 1-8 categorizes 8 knowledge scope according to the examination guideline for Excel2003, including basics about Excel 2003, inputting and editting data, setting and printing sheet, managing the workbook, the usage of formula and fuction, the usage of chart, management and statistics of the data. Before explaining the knowledge point, testing analysis of the contents is made and at the end of each section model drill is attached for the students to self-test.
"synopsis" may belong to another edition of this title.
Book Description paperback. Book Condition: New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Pages Number: 202 Publisher: People's Post Pub. Date :2011-09-01 version 1. Excel 2003 spreadsheet Chinese national human resources and Social Security Personnel Testing Center in 2010 promulgated the National professional and technical personnel computer applications Proficiency Test Syllabus based on years of research and problem-solving characteristics of the test propositions on the basis of the law written in. Excel 2003 spreadsheet Chinese nine chapters. Chapter 0 in-depth study and examination syllabus based on the environment. summarizes the focus of the examination content and style of questions for the candidates to provide a comprehensive review. test-taking strategies. Chapter 1 - Chapter 8 Excel 2003 subjects according to syllabus requirements. grouped together in eight areas of knowledge. which mainly covers the basics of Excel 2003. input and edit data. setup and print worksheets. manage workbooks. formulas and function used. the use of charts. data management and statistical analysis. In the chapters to explain the contents of this chapter before the test sites were analyzed. and the end of each section provides simulation exercises for candidates-on self-test exercises. CD-ROM. this book not only provides the simulation environment on the machine and 12 sets of test questions (480 questions). it also provides study guides. practice simultaneously. Shitijingjie and material used in the book and so on. Book is suitable for professional and technical staff apply for the National Computer Test for Excel 2003 spreadsheet Chinese subject of the candidates to use. but also as a large. colleges relevant professional counseling to all kinds of books or materials related to training. Contents: Chapter 0 Analysis and test-taking strategies syllabus 0.1 exam examination form 10.1.2 Introduction 10.1.1 10.1.3 exam examination examination subjects 10.2 20.3 content review method 40.3.1 40.3.2 familiar form of a comprehensive and detailed examination review. focusing on machine operation 40.3.3 collate appropriate experience and skills examination Memory 40.4 50.4.1 50.4.2 test done to know the details of the first multi-problem method techniques 50.4.3 Operation Notes 7 Chapter 1. the basics of Excel 2003 Excel 2003 1.1 Start and Exit Start Excel 2003 81.1.2 81.1.1 exit Excel 2003 101.1.3 Self practice and problem-solving ideas 101.2 Excel 2003 work window 101.2.1 111.2.2 menu bar title bar toolbar 121.2.4 111.2.3 151.2 bar. 5 151.2.6 Excel Workspace task pane status bar 171.2.8 151.2.7 171.2.9 checklist shortcut menu and problem-solving ideas for creating Excel workbooks 171.3 181.3.1 181.3.2 with new blank workbook template to create a workbook 181.3.3 workbook template to create your own set workbook file attributes 191.3.4 191.3.5 Self practice and problem-solving ideas to save the Excel workbook 201.4.1 201.4 using the Save command 201.4.2 use the Save As command 211.4.3 Set the workbook exercises and self-test to save the password problem-solving ideas 211.4.4 221.5 231.5.1 to open and close the workbook open the workbook 231.5.2 251.5.3 Self closing the workbook exercises and problem-solving ideas 251.6 for Excel Help 251.6.1 251.6.2 Use the Office Assistant Excel Help task pane 271.6.3 use the dialog box to help self-test exercises and problem-solving ideas 281.6.4 29 Chapter 2 2.1 input and edit data in the choice of 302.1 cells .1 recognize cell address 302.1.2 312.1.3 select a single cell selected row or column cell select the cell range 322.1.5 312.1.4 of positioning command to select the cell 332.1.6 named cells and ranges 342.1.7 self-test exercises and problem-solving ideas 352.2 352.2.1 input input data input date and time values ??362.2.2 372.2.3 372.2.4 enter text input sequence sequences 412.2.6 382.2.5 custom cell type in the number of 422.2.7 the same data type in the drop-down list. select the data t. Bookseller Inventory # LH7092
Book Description paperback. Book Condition: New. Paperback. Pub Date: 2011 09 Pages: 202 in Publisher: People's Posts and Telecommunications Press national professional and technical personnel computer application proficiency examinations tutorial: in Excel 2003 Chinese spreadsheet promulgated by the National Human Resources and Social Security Department of Personnel Testing Center 2010 National professional and technical personnel computer application ability exam exam outline based on years of research on the basis of the characteristics. Bookseller Inventory # CC019642