Uncategorized Grade 9 – English Medium Online ICT Exam – Month July By Ashen-X July 25, 2021 0 Comments Results - #1. What is the intersection of a column and a row on a worksheet called ? Column Column Value Value Row Row Cell Cell Title Title #2. What type of chart is useful for comparing values over categories ? Pie Chart Pie Chart Column Chart Column Chart Dot Chart Dot Chart Line Chart Line Chart #3. Which function in Excel tells how many numeric entries are there ? NUM NUM COUNT COUNT SUM SUM CHKNUM CHKNUM COUNTIF COUNTIF #4. A features that displays only the data in column (s) according to specified criteria Formula Formula Sorting Sorting Filtering Filtering Pivot Pivot #5. Statistical calculations and preparation of tables and graphs can be done using Photoshop Photoshop Google Sheets Google Sheets LibreOffice Writer LibreOffice Writer PowerPoint PowerPoint Notepad Notepad #6. Which one is not a Function in MS Excel ? SUM SUM AVG AVG MAX MAX MIN MIN COUNT COUNT #7. Functions in MS Excel must begin with An () sign An () sign An Equal Sign An Equal Sign A Plus Sign A Plus Sign A > Sign A > Sign #8. In Excel, Columns are labelled as ___ A, B, C, etc A, B, C, etc 1,2,3 etc 1,2,3 etc A1, A2, etc. A1, A2, etc. $A$1, $A$2, etc. $A$1, $A$2, etc. #9. What type of chart is useful for showing trends or changes over time ? Pie Chart Pie Chart Column Chart Column Chart Line Chart Line Chart Dot Chart Dot Chart #10. The process of arrenging the items of a column in some sequence or order is known as : Arrange Arrange Autofill Autofill Sorting Sorting Filtering Filtering #11. The ____ feature of MS Excel quickly completes a series of data Auto Complete Auto Complete Auto Fill Auto Fill Fill Handle Fill Handle Sorting Sorting #12. What type of chart is useful for comparing parts of a whole ? Pie Chart Pie Chart Column Chart Column Chart Line Chart Line Chart Dot Graph Dot Graph #13. What is the graph indicated by red square? Column Graph Column Graph Line Graph Line Graph Bar Graph Bar Graph Pie Chart Pie Chart Scatter Graph Scatter Graph #14. Name the items shown on the image in order Tabs, Groups, Dialog Box Launcher, Command Button, Unpin the ribbon Tabs, Groups, Dialog Box Launcher, Command Button, Unpin the ribbon Tabs, Dialog Box Launcher, Groups, Command Button, Unpin the ribbon Tabs, Dialog Box Launcher, Groups, Command Button, Unpin the ribbon Tabs, Dialog Box Launcher, Groups, Unpin the ribbon, Command Button Tabs, Dialog Box Launcher, Groups, Unpin the ribbon, Command Button Groups, Dialog Box Launcher, Tabs, Command Button, Unpin the ribbon Groups, Dialog Box Launcher, Tabs, Command Button, Unpin the ribbon Tabs, Unpin the ribbon, Groups, Command Button, Dialog Box Launcher Tabs, Unpin the ribbon, Groups, Command Button, Dialog Box Launcher #15. By using Cell formatting tools which option should be selected to format date as "Tuesday, February 25, 2021"? Currency Currency Time Time Short date Short date Long date Long date Percentage Percentage #16. Select the Free and Offline Spreadsheet software from the following list. Microsoft Excel Microsoft Excel Google Sheets Google Sheets Zoho Sheets Zoho Sheets LibreOffice LibreOffice #17. Renaming a workbook affects the names of the worksheets inside a workbook. This statement is correct This statement is correct This statement is incorrect This statement is incorrect #18. Spreadsheet software is an application software. This statement is correct This statement is correct This statement is incorrect This statement is incorrect #19. From the following list which is not a use of spreadsheet software? Data Entry and Storage Data Entry and Storage Help Identify Trends Help Identify Trends Image Retouching Image Retouching Accounting and Budgeting Accounting and Budgeting Return on Investment. Return on Investment. #20. A Function is an equation designed by a user in Excel, while a Formula is a predefined calculation in the spreadsheet application. This statement is correct This statement is correct This statement is incorrect This statement is incorrect finish

## No Comments