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 |