Users Also Read
Read MCQ's/Objective questions
MCQ's Search Engine
Important Question
ASP.NET
Basic Computer Knowledge
Basic of Linux/Unix
C Language
C# Programming
C++ Programming
Computer Graphics
Computer Hardware
Computer Networking
Computer Security - Cyber crime & Laws
Data Structures & Algorithms
Database Management System
Digital Computer Electronics
HTML
Important File Extensions
Imp. Shortcut Keys used in Computer
Internet, Web & Email
Java - Concepts and Its Programming
Language Processors
Management Information System (MIS)
MS Access
MS Word
Operating System
Oracle, SQL & PL/SQL
PHP Basic
Power Point
Programming Languages
Software Engineering
System Analysis and Design (SAD)
System software & compiler design
Tally
VB.NET
Visual Basic
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. |
Q21 ⇒ Shortcut to close a document is ______? Ctrl + W [other wrong options] [Discuss in forum] Alt + F4 Ctrl + C Ctrl + Q |
Q22 ⇒ What is the shortcut to change the font? Ctrl + Shift + F [other wrong options] [Discuss in forum] Ctrl + F Alt + Ctrl + F Shift + Alt + F |
Q23 ⇒ Where can you find the horizontal split bar on MS Word screen? On the top of vertical scroll bar [other wrong options] [Discuss in forum] On the left of horizontal scroll bar On the bottom of vertical scroll bar On the right of horizontal scroll bar |
Q24 ⇒ 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] The text is deleted from document and you need to bring from Recycle Bin if required again. The text is hidden and cannot be returned back The text is deleted and cannot be returned back |
Q25 ⇒ What is the smallest width of a column? 0.5 [other wrong options] [Discuss in forum] 0 1 2 |
Q26 ⇒ In MS-Excel default header for a worksheet is None of these [other wrong options] [Discuss in forum] Your name The date and time date |
Q27 ⇒ MS-Excel is similar to which of the following accounting worksheets Spreadsheets [other wrong options] [Discuss in forum] Word processing Database Both (b) & (c) |
Q28 ⇒ In MS-Excel a fast way to add up data in a column is to click in the cell below the numbers and then Click the autosum button on the standard toolbar, then press enter [other wrong options] [Discuss in forum] Click subtotals on the data menu View the sum in the formula bar All of above |
Q29 ⇒ In MS-Excel data can be arranged in a worksheet in a easy to understand manner using All of above [other wrong options] [Discuss in forum] Auto formatting Applying styles Changing fonts |
Q30 ⇒ In MS-Excel you can create only a horizontal page break by first selecting >page break [other wrong options] [Discuss in forum] A cell in row 1 A cell in column A (A) and (C) |
Q31 ⇒ In MS-Excel to select a column the easiest method is to Click the column heading [other wrong options] [Discuss in forum] Double click any cell in the column Drag from the top cell in the column to the last cell in the column None of these |
Q32 ⇒ In MS-Excel you can edit a cell by Double clicking the cell to edit it in-place [other wrong options] [Discuss in forum] Clicking the formula button Selecting Edit>Edit Cell from the menu Both (b) & (c) |
Q33 ⇒ In MS-Excel To select several cells or ranges that are not touching each other, you would . . . while selecting hold down the Ctrl key [other wrong options] [Discuss in forum] hold down the Shift key hold down the Alt key None of these |
Q34 ⇒ In MS-Excel which of these will not select all the cells in a document? Clicking three times with the right mouse button in the spreadsheet [other wrong options] [Discuss in forum] Using the Edit - Select All menu Pressing Ctrl + A on the keyboard All of these |
Q35 ⇒ Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them [other wrong options] [Discuss in forum] You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried |
Q36 ⇒ How can you update the values of formula cells if Auto Calculate mode of Excel is disabled? F9 [other wrong options] [Discuss in forum] F8 F10 F11 |
Q37 ⇒ What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting [other wrong options] [Discuss in forum] The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up |
Q38 ⇒ Long text can be broken down into many lines within a cell. You can do this through Wrap Text in Format >> Cells [other wrong options] [Discuss in forum] Justify in Edit >> Cells Text Wraping in Format >> Cells, Layout tab All of above |
Q39 ⇒ Edit >> Delete command Deletes selected cells [other wrong options] [Discuss in forum] Deletes the content of a cell Deletes Formats of cell Deletes the comment of cell |
Q40 ⇒ You can check the conditions against __________ when applying conditional formatting Both of above [other wrong options] [Discuss in forum] Cell value Formula None of above |
Or |