Create better lessons quicker
My Profile Page
Edit personal details
Language and Location
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
Log in required
This leaderboard is currently private. Click
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Similar activities from
More formats will appear as you play the activity.