Ashoka Public School IT Question Bank Class 5 PDF

**ASHOKA PUBLIC SCHOOL SARANGARH (C.G.)** **TERM - II QUESTION BANK (2024-25)** **CLASS - V** **SUBJECT -- INFORMATION TECHNOLOGY ( IT )** **CHAPTERS -- 5, 6, 7 & 9** **Question Pattern:** A\) Fill in the blanks -- 10 \* 0.5 = 5 B\) Tick (✓) the correct statement and cross (×) out the wrong o...

**ASHOKA PUBLIC SCHOOL SARANGARH (C.G.)** **TERM - II QUESTION BANK (2024-25)** **CLASS - V** **SUBJECT -- INFORMATION TECHNOLOGY ( IT )** **CHAPTERS -- 5, 6, 7 & 9** **Question Pattern:** A\) Fill in the blanks -- 10 \* 0.5 = 5 B\) Tick (✓) the correct statement and cross (×) out the wrong one -- 10 \* 0.5 = 5 C\) Match the following -- 6 \* 0.5 = 3 D\) Choose the correct answer -- 10 \* 0.5 = 5 E\) One Word Answer -- 5 \* 1 = 5 F\) Full Forms -- 5 \* 1 = 5 G\) Answer the following questions -- 12 \* 1 = 12 **M.M. -- 40** **A) Fill in the blanks**. 1. Total number of rows in a worksheet are . 2. Total number of columns in a worksheet are . 3. An [Active Cell] is also called the current cell. 4. [Formula Bar] displays the data and formula that we enter in an active cell. 5. [Shift + Spacebar] is a shortcut key to select an entire row. 6. [Ctrl + Spacebar] is a shortcut key to select an entire column. 7. [Shift cells down] option is the default option in Insert dialog box in a worksheet. 8. [Entire Row] option in Delete dialog box deletes the entire row in a worksheet. 9. [Entire Column] option in Delete dialog box deletes the entire column in a worksheet. 10. Ctrl + plus (+) is shortcut key to insert a [row] and [column] in Excel. 11. Ctrl + minus (-) is shortcut key to delete a [row] and [column] in Excel. 12. The default height of the row in a worksheet is [12.75]. 13. The default width of the column in a worksheet is [8.43]. 14. We can specify the width of column from 0 to . 15. We can specify the height of row from 0 to . 16. [Internet] is a collection of computers connected to each other all over the world. 17. A [Web browser] is used to open the websites. 18. [WWW] is a way of accessing information over the medium of the internet. 19. To open a website, type website address in address bar, in a web browser and press [Enter] key. 20. Clicking [Home] button on a web browser window takes you to the home page of the website. **B) Tick (✓) the correct statement and cross (×) out the wrong one.** 1. You can add rows & columns in a table. True (✓) 2. You cannot add rows & columns in a table. False (×) 3. Using Grid option, we can insert a table of maximum **10 columns & 8 rows**. True (✓) 4. Using Grid option, we can insert a table of maximum 8 columns & 10 rows. False (×) 5. Table tools contain some predefined sets of table designs & layouts. True (✓) 6. Table tools do not contain any predefined sets of table designs & layouts. False (×) 7. On the text in the table, you can apply text formatting. True (✓) 8. On the text in the table, you cannot apply text formatting. False (×) 9. After creating a table unwanted rows & columns cannot be deleted. False (×) 10. After creating a table unwanted rows & columns can be deleted. True (✓) 11. In a worksheet, rows are arranged horizontally. True (✓) 12. In a worksheet, rows are arranged vertically. False (×) 13. In a worksheet, columns are arranged vertically. True (✓) 14. In a worksheet, columns are arranged horizontally. False (×) 15. In Excel, formulas are instructions to perform calculations. True (✓) 16. If a cell displays "1.23E+11", it means the value is too long to fit in the cell. True (✓) 17. By default, text is left aligned in a cell. True (✓) 18. By default, text is right aligned in a cell. False (×) 19. By default, number is right aligned in a cell. True (✓) 20. By default, number is left aligned in a cell. False (×) 21. Formula Bar displays the data and formula of an active cell. True (✓) 22. Formula Bar does not display the data and formula of an active cell. False (×) 23. Clicking anywhere in the worksheet removes the selection of the pasted cells. True (✓) 24. Clicking anywhere in the worksheet does not remove the selection of the pasted cells. False (×) 25. Using AutoFill tool, a series of data can be entered automatically. True (✓) 26. AutoFill feature is used to fill data in adjacent cells quickly. True (✓) 27. Using AutoFill tool, a series of data cannot be entered automatically. False (×) 28. You cannot insert a blank cell in a worksheet. False (×) 29. You can insert a blank cell in a worksheet. True (✓) 30. Ctrl+D shortcut key is used to copy contents and format of the topmost cell of a selected range into the cells below. True (✓) 31. Pressing the Alt key removes the moving dashed lines from the selected cells. False (×) 32. Pressing the Esc key removes the moving dashed lines from the selected cells. True (✓) 33. You can delete / remove rows & columns in a table. True (✓) 34. You cannot delete / remove rows & columns in a table. False (×) **C) Match the following.** 1) +-----------------------+-----------------------+-----------------------+ | **COLUMN -- I** | | **COLUMN - II** | +-----------------------+-----------------------+-----------------------+ | 1. Move to last | | a. Select content of | | column | | current cell | +-----------------------+-----------------------+-----------------------+ | 2. Delete selected | | b. Alt + End | | column | | | +-----------------------+-----------------------+-----------------------+ | 3. End, then Shift + | | c. Shift + Delete | | Home | | | +-----------------------+-----------------------+-----------------------+ | 4. Select current | | d. Move current row | | cell | | up | +-----------------------+-----------------------+-----------------------+ | 5. Move to one row | | e. Shift + End | | down | | | +-----------------------+-----------------------+-----------------------+ | 6. Alt + Shift + Up | | f. Down Arrow | | Arrow | | | +-----------------------+-----------------------+-----------------------+ 2) +-----------------------+-----------------------+-----------------------+ | **COLUMN -- I** | | **COLUMN - II** | +-----------------------+-----------------------+-----------------------+ | 1. Moves to the | | a. → | | first cell of the | | | | current column | | | +-----------------------+-----------------------+-----------------------+ | 2. Total number of | | b. 16384 | | characters a cell | | | | can contain | | | +-----------------------+-----------------------+-----------------------+ | 3. Total number of | | c. Ctrl + → | | columns | | | +-----------------------+-----------------------+-----------------------+ | 4. To move last cell | | d. 32767 | | of current row | | | +-----------------------+-----------------------+-----------------------+ | 5. Moves to the one | | e. Ctrl + ↑ | | column right | | | +-----------------------+-----------------------+-----------------------+ 3\) **COLUMN - I** **COLUMN - II** a\. Ctrl + C i. Redo\ b. Ctrl + Y ii. Inserting a Row\ c. Ctrl + R iii. Paste\ d. Select row & press Ctrl + plus (+) iv. Copy\ e. Ctrl + V v. Copying contents & format of the leftmost cell of a select range into cells to the right.\ [Answer:] 1\) 1 - b, 2 - c, 3 - a, 4 - e, 5 - f, 6 - d\ 2) 1 - e, 2 - d, 3 - b, 4 - c, 5 - a\ 3) 1 - d, 2 - a, 3 - e, 4 - b, 5 - c **D) Choose the correct answer.** 1\) A cell is the intersection of.......... and...........\ a) Height, width b) **Row, column**\ c) Column, page d) None of these \ 2) A table can be drawn using.......... method.\ a) Grid option b) Insert Table dialog box\ c) Draw Table d) **All of these** \ 3) Shortcut key for moving to the first row in a table is...........\ a) **Alt + Page Up** b) Alt + Page Down\ c) Home d) None of these \ 4) MS Excel is a.......... program.\ a) **Spreadsheet** b) Word Processor\ c) Painting d) None of these 5\) MS Word is a.......... program.\ a) Spreadsheet b) **Word** **Processor** \ c) Painting d) None of these 6\).......... are labelled using letters such as A, B, C, D in MS Excel.\ a) Rows b) Cells\ c) **Columns** d) None of these\ 7).......... are labelled using numbers such as 1, 2, 3, D4 in MS Excel. a\) **Rows** b) Cells c\) Columns d) None of these 8\).......... is a group of contiguous cells.\ a) Cell name b) **Cell range** \ c) Cell Reference d) None of these\ 9).......... are the types of data that can be entered in MS Excel.\ a) Label b) Values \ c) Formulas d) **All of these**\ 10) Shortcut key to insert a new worksheet is...........\ a) Shift+Ctrl+F11 b) Ctrl+F11 \ c) Ctrl+F11+Shift d) **Shift+F11**\ 11).......... indicates a cell range from A4 cell to D5 cell.\ a) **A4:D5**  b) A4 to D5\ c) FROM A4 to D5.  d) None of these\ 12) Width of a column can be adjusted by...........\ a) Double-click on right border of column header. \ b) Using AutoFit Column Width\ c) Click and drag column border \ d) **All of these**\ 13) Ctrl + minus (-) is the shortcut key to delete a.......... in Excel.\ a) Row  b) Column\ c) **Both a) and b)**  d) None of these\ 14) Ctrl + plus (+) is the shortcut key to add/insert a.......... in Excel. a\) Row b) Column c\) **Both a) and b)** d) None of these 15\) The default column width is.......... characters.\ a) **8.43**  b) 84.3\ c) 4.83  d) 3.84\ 16) The default row height is.......... characters. a\) **12.75** b) 127.5 c\) 7.125 d) 5.127 17\) We can specify a row height from 0 to..........\ a) 408  b) **409**\ c) 410  d) 411\ 18) We can specify a column width from 0 to.......... a\) 254 b) **255** c\) 256 d) 257 19\) Online.......... is also known as distance learning.\ a) **Education** b) Shopping \ c) News d) None of these\ 20).......... is exploration with a definite objective of the WWW.\ a) Surfing b) Online shopping \ c) **Browsing** d) All of these\ 21).......... is just trying to find the information on internet.\ a) Browsing b) **Searching** \ c) Testing d) All of these\ 22).......... is an example of search engine.\ a) www.**bing**.com b) www.eduitspl.com \ c) www.close.nic.in d) www.gmail.com 23\).......... is / are an example(s) of search engine(s).\ a) www.google.com b) www.yahoo.com\ c) www.bing.nic.in d) **All of these** \ 24).......... is an example of online dictionary.\ a) www.google.com b) www.**dictionary**.com\ c) www.facebook.com d) www.yahoo.com 25\).......... is / are an examples of web browser(s). a\) Google Chrome b) Mozilla Firefox c\) Safari d) **All of these** **E) Answer the following questions.**\ 1) What is a table?\ A table is way to represent the data in rows and columns.\ 2) Define the following:\ i. Rows: Rows are horizontal series of cells.\ ii. Columns: Columns are vertical series of cells.\ iii. Cell: The intersection of a row and column.\ 3) Write the shortcut keys to delete a row and a column in a table.\ Shift + Delete.\ 4) Merging cells:\ Merging cells means combining two or more cells.\ 5) Cell splitting:\ Dividing a cell is called cell splitting.\ 6) To move to one row down:\ Down Arrow key\ 7) To select an entire table:\ Alt + 5\ 8) To select a row:\ Alt + Shift + End\ 9) To select a column:\ Alt + Shift + Page Down\ 10) Explain any two advantages of MS Excel.\ (i) numbers and calculations are managed efficiently. \(ii) data can easily be created, analyzed and maintained.\ 11) How can we open Excel using Run window?\ i) Press **Windows + R** key and type '**excel**'. ii) Click on **OK** button.\ 12) Name any 2 components of MS Excel window.\ Quick Access toolbar, Ribbon, Cell Name box, Active Cell, Formula bar, Rows, Columns, Sheet tab and Status bar.\ 13) Define the following : a\) Workbook : An Excel file is known as a workbook. It can hold many worksheets.\ b) Worksheet : A worksheet is a collection of cells.\ c) Cell reference : Cell reference is the column letter and the row number. d\) Formula Bar : It displays the data and formula. It can also be used for entering and editing data. e\) Active cell : It is the current cell in a worksheet. It is displayed with a bold border.\ 14) Distinguish between copying and moving the data.\ Copying refers to duplicating the data, while moving refers to moving the data from its current location to another location.\ 15) What do you mean by the AutoFill feature?\ It is a tool that is used to fill a predefined series of data in adjacent cells quickly.\ 16) Name the options available in the Insert dialog box.\ i) Shift cells right. ii\) Shift cells down iii\) Entire row iv\) Entire column\ 17) Distinguish between undo and redo command.\ Undo command reverses the last action while Redo command reverses the Undo command.\ 18) Write the shortcut keys to insert a row and a column.\ Ctrl + plus (+)\ 19) What is a web browser?\ A browser is an application software which is used to open websites.\ 20) What is Internet surfing?\ Surfing the internet is an undirected type of exploration of the WWW.\ 21) Write a few words about Online Education. (Any 1 point)\ Online Education is a cheap and easy way to get education. It is also known as distance learning. It consists of taking classes through the Internet.\ 22) Write the shortcut keys to save a web page. Ctrl + S\ 23) Online Shopping:\ Using online shopping various products can be purchased.\ 24) Video Conferencing:\ This is the way to communicate with others on internet using web camera, microphone, speakers, etc.\ 25) News and Information :\ These are the facilities to get information about online news and other various topics such as science, technology, sports and education, etc. **F) Full Forms:** 1\. MS -- MICROSOFT 2\. INTERNET -- INTERCONNECTED NETWORK 3\. URL -- UNIFORM RESOURCE LOCATOR 4\. WWW -- WORLD WIDE WEB 5\. GOOGLE -- GLOBAL ORGANIZATION OF ORIENTED GROUP LANGUAGE OF EARTH 6\. YAHOO -- YET ANOTHER HIERARCHICAL OFFICIOUS ORACLE or YET ANOTHER HIERARCHICALLY ORGANISED ORACLE 7\. AOL - AMERICA ONLINE 8\. WOW -- WORLD OF WARCRAFT **G) One Word Answer.** 1. Intersection of row and column. Cell 2. Used to represent a given data in the form of rows and columns. Table 3. Horizontal series of cells in a table. Row 4. Vertical series of cells in a table. Column 5. Combining two or more cells into one cell. Merging cells 6. Dividing a single cell into multiple cells. Cell splitting 7. Spreadsheet program. MS Excel, Calc, Google Sheets (Any one) 8. Word Processor program. MS Word, Writer, Google Docs (Any one) 9. Labelled using letters such as A, B, C, D in MS Excel. Columns 10. Labelled using numbers such as 1,2,3,4 in MS Excel. Rows 11. Group of contiguous cells. Cell range 12. One of the types of data that can be entered in MS Excel. Label or Values or Formulas (Any one) 13. Total number of rows in a worksheet. 1048576 14. Total number of columns in a worksheet. 16384 15. Also called the current cell. Active cell 16. Displays the data and formula of an active cell. Formula Bar 17. Each excel file. Workbook 18. It can hold many worksheets. Workbook 19. Collection of cells in the form of rows and columns. Worksheet 20. Column letter and the row number that identifies a single cell. Cell Reference 21. It can also be used for entering and editing data. Formula Bar 22. Default column width. 8.43 23. Default row height. 12.75 24. Tool used to fill a predefined series of data in adjacent cells quickly. AutoFill 25. Duplicating the data. Copying 26. Reverses last action. Undo 27. Reverses undo command. Redo 28. Also known as distance learning. Online education 29. Consists of taking classes through the internet. Online education or Distance Learning (Any one) 30. Application software which is used to open websites. Web browser 31. Undirected type of exploration of the WWW. Surfing 32. Exploration with a definite objective but without a planned search strategy. Browsing 33. Just trying to find the information on internet. Searching 34. Example of a search engine. Google, Yahoo, Bing (Any one) 35. Example of an online dictionary. hindienglishdictionary.org, dictionary.com, a-z-dictionaries.com, online-dictioanry.biz, shabdkosh.com, yourdictionary.com, oxforddictionaries.com (Any one) 36. Example of a web browser. Chrome, Firefox, Safari (Any one) 37. Collection of computers connected to each other all over the world. Internet 38. Way of accessing information over the medium of the internet. WWW