1) What is the intersection of a column and a row on a worksheet called ? a) Column b) Address c) Value d) Cell 2) What type of chart is useful for comparing values over categories ? a) Pie Chart b) Line Chart c) Dot graph d) Column Chart 3) Statistical calculations and preparation of tables and graphs can be done using a) Adobe Photoshop b) Power Point c) Notepad d) Excel 4) Functions in MS Excel must begin with ___ a) An Equal Sign b) An () sign c) A Plus Sign d) A > Sign 5) Which functionin Excel checks whether a condition is true or not ? a) COUNT b) IF c) SUM d) AVERAGE 6) In Excel, Columns are labelled as ___ a) A, B, C, etc b) 1,2,3 etc c) $A$1, $A$2, etc d) A1, A2, etc 7) The Greater Than sign (>) is an example of _____ operator. a) Arithmatic b) Conditional c) Logical d) Greater 8) The process of arrenging the items of a column in some sequence or order is known as : a) Arrengin b) Sorting c) Autofill d) Filtering 9) The ____ feature of MS Excel quickly completes a series of data a) Auto Complete b) Fill Handle c) Auto Fill d) Sorting 10) The basic unit of a worksheet into which you enter data in Excel is called a__________ a) Box b) Table c) Column d) Cell 11) In Excel, which one denoted a range from B1 through E5______ a) B1 - E5 b) B1:E5 c) B1 to E5 d) B1$E5 12) An Excel file is generally called a / an : a) E-Spreadsheet b) Workbook c) Woorksheet d) Sheet 13) It is a collection of data that is stored electronically as a series of records in a table. a) Spreadsheet b) Presentation c) MS Word d) Database 14) How will you graphically represent expenditure in different departments ? a) Column Chart b) Pie Chart c) Dot chart d) Line Chart 15) What type of chart is good for single series of data ? a) Pie Chart b) Column Chart c) Dot Chart d) Line Chart

MS EXCEL 2010

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?