Home⇒ Computer Engineering⇒ Ms excel
| 1-Dont try to cram or spend more time here just read it fast and cover syllabus then practice MCQ's cheptor of same topic to check your progress. . |
| 2-Wrong options are also given but dont concentrate there, Right answer is in bold format. |
| Q1 ⇒ What happens if you press Ctrl + Shift + F8? It activates the rectangular selection [other wrong options] [Discuss in forum] |
| Q2 ⇒ What is the correct combination of keys to find text on a document? Ctrl + F [other wrong options] [Discuss in forum] |
| Q3 ⇒ What is the correct combination of key to decrease the font size of selected text? Ctrl + Shift + < [other wrong options] [Discuss in forum] |
| Q4 ⇒ The keystrokes Ctrl + I is used to Applies italic format to selected text [other wrong options] [Discuss in forum] |
| Q5 ⇒ What happens if you mark on Hidden check box of Font dialog box after you select some text? The text is hidden and you need to bring it by removing the check box if needed again [other wrong options] [Discuss in forum] |
| Q6 ⇒ How much space in minimum must be provided between columns? 0 [other wrong options] [Discuss in forum] |
| Q7 ⇒ In MS-Excel you can copy cell formats from one cell to another by using the Format painter [other wrong options] [Discuss in forum] |
| Q8 ⇒ In MS-Excel following term describes explanatory text attached to a cell Comment [other wrong options] [Discuss in forum] |
| Q9 ⇒ In MS-Excel which symbol must all formula begin with? = [other wrong options] [Discuss in forum] |
| Q10 ⇒ In MS-Excel worksheet range is a A group of cells [other wrong options] [Discuss in forum] |
| Q11 ⇒ In MS-Excel to add two cells (A1 and A2) together you use the following formula =A1+A2 [other wrong options] [Discuss in forum] |
| Q12 ⇒ In MS-Excel to center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be centered and click on ' merge and center ' option from formatting bar [other wrong options] [Discuss in forum] |
| Q13 ⇒ In MS-Excel to select a column the easiest method is to Click the column heading [other wrong options] [Discuss in forum] |
| Q14 ⇒ You can use the formula pallette to create and edit formula containing functions [other wrong options] [Discuss in forum] |
| Q15 ⇒ Which of the following option is not available in Paste Special dialog box? SQRT [other wrong options] [Discuss in forum] |
| Q16 ⇒ When a row of data is to be converted into columns Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK [other wrong options] [Discuss in forum] |
| Q17 ⇒ The Delete key of keyboard is assigned to which command in Excel? Edit >> Clear >> Contents [other wrong options] [Discuss in forum] |
| Q18 ⇒ Comments can be added to cells using ...... Insert -> Comment [other wrong options] [Discuss in forum] |
| Q19 ⇒ An Excel Workbook is a collection of ....... Worksheets and Charts [other wrong options] [Discuss in forum] |
| Q20 ⇒ How do you rearrange the data in ascending or descending order? Data, Sort [other wrong options] [Discuss in forum] |
| Or |