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

by
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?