Test your knowledge Name Email Mobile The.......................................... function key is used to change the cell contents of a selected cell. a) F5 b) F4 c) F2 When you finish editing within a cell, Excel returns to the .........................mode. a) Edit b) Finish c) Ready To select a range , hold down the ....................................key and click on the adjacent cells. a) Shift b)Ctrl c) Alt .................................. is the shortcut key to undo the last action. a) Ctrl + Z b) Ctrl + Y c) Ctrl + X The .................................................... key combination can be used to apply the outline border around the selected cell. a) Ctrl + Shift + F9 b) Ctrl + Shift + 7 c) Ctrl + G How can you edit the data in a worksheet? How will you select a range of non-adjacent columns in a worksheet? What are the four options in the Delete dialog box? What is the Auto Fill feature? How is it useful? How can you change the row height in a worksheet? What is the use of Flash Fill feature in Excel? Ritu has created progress reports of the students of her class in excel. But she forgot to add an important column in the table. Suggest an option that will help her insert a new column without disturbing the existing table settings. Surabhi was assigned the taks to write a series of numbers from one to ten without using the keyboard. Help her complete the assignment. The appearance of date and time on a worksheet depends on the ................................... The moved or copied data is stored temporarily in a location in the computer memory called........................ ............................. identifies the data fill pattern that you use frequently in a worksheet and then fills the remaining series , accordingly.. The .................. and ....................... buttons are present on the Formula Bar. To copy the data, the ...................................... key combination can be used. Copying refers to placing data from one place to another.. True False Ctrl+ A key combination is used to select view. True False To turn on the Overtype mode, press the Insert key from the keyboard. True False Copy, Cut and Paste buttons are present in the Font group. True False To insert a new column in the Excel sheet , select the Add button on the Insert tab. True False The shortcut key for Flash Fill is Shift + E True False
