| Q:1 | What is the intersection of a column and a row on a worksheet called ? |
| Ans:1 | a.) Column b.) Value c.) Address d.) Cell |
| Q:2 | What type of chart is useful for comparing values over categories ? |
| Ans:2 | a.) Pie Chart b.) Column Chart c.) Line Chart d.) Dot Chart |
| Q:3 | Which functionin Excel tells how many numeric entries are there ? |
| Ans:3 | a.) NUM b.) COUNT c.) SUM d.) CHKNUM |
| Q:4 | A features that displays only the data in column (s) according to specified criteria |
| Ans:4 | a.) Formula b.) Sorting c.) Filtering d.) Pivot |
| Q:5 | Statistical calculations and preparation of tables and graphs can be done using |
| Ans:5 | a.) Adobe Photoshop b.) Excel c.) Notepad d.) Power Point |
| Q:6 | What type of chart will you use to compare performance of two employees in the year 2016 ? |
| Ans:6 | a.) Column Chart b.) Line Chart c.) Pie Chart d.) Dot Chart |
| Q:7 | Which one is not a Function in MS Excel ? |
| Ans:7 | a.) SUM b.) AVG c.) MAX d.) MIN |
| Q:8 | Functions in MS Excel must begin with ___ |
| Ans:8 | a.) An () sign b.) A Plus Sign c.) An Equal Sign d.) A > Sign |
| Q:9 | Which functionin Excel checks whether a condition is true or not ? |
| Ans:9 | a.) SUM b.) COUNT c.) IF d.) AVERAGE |
| Q:10 | In Excel, Columns are labelled as ___ |
| Ans:10 | a.) A, B, C, etc b.) 1,2,3 etc c.) A1, A2, etc. d.) $A$1, $A$2, etc. |
| Q:11 | The Greater Than sign (>) is an example of _____ operator. |
| Ans:11 | a.) Arithmatic b.) Logical c.) Conditional d.) Greater |
| Q:12 | What type of chart is useful for showing trends or changes over time ? |
| Ans:12 | a.) Pie Chart b.) Column Chart c.) Line Chart d.) Dot Graph |
| Q:13 | The process of arrenging the items of a column in some sequence or order is known as : |
| Ans:13 | a.) Arrengin b.) Autofill c.) Sorting d.) Filtering |
| Q:14 | The ____ feature of MS Excel quickly completes a series of data |
| Ans:14 | a.) Auto Complete b.) Auto Fill c.) Fill Handle d.) Sorting |
| Q:15 | What type of chart is useful for comparing parts of a whole ? |
| Ans:15 | a.) Pie Chart b.) Column Chart c.) Line Chart d.) Dot Graph |
| Q:16 | In Excel, Rows are labelled as ______ |
| Ans:16 | a.) A, B, C, etc b.) 1,2,3 etc c.) A1, A2, etc d.) $A$1, $A$2, etc. |
| Q:17 | What do you use to create a chart? |
| Ans:17 | a.) Pie Wizard b.) Excel Wizard c.) Data Wizard d.) Chart Wizard |
| Q:18 | How will you graphically represent expenditure in different departments ? |
| Ans:18 | a.) Column Chart b.) Line Chart c.) Pie Chart d.) Dot Chart |
| Q:19 | What type of chart is good for single series of data ? |
| Ans:19 | a.) Column Chart b.) Line Chart c.) Pie Chart d.) Cone Chart |
| Q:20 | The basic unit of a worksheet into which you enter data in Excel is called a |
| Ans:20 | a.) cell b.) table c.) box d.) column |
| Q:21 | How many sheets are there, by default, when we create a new Excel file ? |
| Ans:21 | a.) 1 b.) 3 c.) 5 d.) 10 |
| Q:22 | In Excel, which one denoted a range from B1 through E5 |
| Ans:22 | a.) B1 – E5 b.) B1:E5 c.) B1 to E5 d.) B1$E5 |
| Q:23 | An Excel file is generally called a / an : |
| Ans:23 | a.) E-Spreadsheet b.) Woorksheet c.) Workbook d.) Sheet |
| Q:24 | It is a collection of data that is stored electronically as a series of records in a table. |
| Ans:24 | a.) spreadsheet b.) presentation c.) database d.) MS Word |
| Q:25 | What type of chart will you use to compare performance of sales of two products ? |
| Ans:25 | a.) Column Chart b.) Line Chart c.) Pie Chart d.) Both A and B |
