Excel Quiz 9 Created on October 17, 2020 By comtutorera MS Excel Microsoft Excel is a spreadsheet software and is part of the widely used MS Office Package. Here you will find a great collection of Multiple Choice (MCQ)Questions in the category of Microsoft Excel with answers. Most of the questions are applicable to all versions of MS Excel (including Excel 97-2003, XP, 2007, 2010, etc.). Sometimes questions from this category is asked as part of the computer operation general knowledge section of the basic computer awareness test. 1 / 10 Statistical calculations and preparation of tables and graphs can be done using Adobe Photoshop Excel Notepad Power Point 2 / 10 A feature that displays only the data in column (s) according to specified criteria Formula Sorting Filtering Pivot 3 / 10 Which functionin Excel tells how many numeric entries are there ? NUM COUNT SUM CHKNUM 4 / 10 What type of chart is useful for comparing values over categories ? Pie Chart Column Chart Line Chart Dot Graph 5 / 10 What is the intersection of a column and a row on a worksheet called? Column Value Address Cell 6 / 10 The basic unit of a worksheet into which you enter data in Excel is called a cell table box column 7 / 10 What type of chart is good for single series of data ? Column Chart Line Chart Pie Chart Cone Chart 8 / 10 How will you graphically represent expenditure in different departments ? Column Chart Line Chart Pie Chart Dot Chart 9 / 10 What do you use to create a chart? Pie Wizard Excel Wizard Data Wizard Chart Wizard 10 / 10 In Excel, Rows are labelled as ______ A, B, C, etc 1,2,3 etc A1, A2, etc. $A$1, $A$2, etc. Your score is The average score is 51% LinkedIn Facebook Twitter 0% Restart quiz
