McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Common Topics in Competitive and Entrance exams , Union Public Service Commission (UPSC) , Indian Administrative Service (IAS) .
| 1801. |
Which function will you use to enter current time in a worksheet cell? |
| A. | = today( ) |
| B. | = now ( ) |
| C. | = time ( ) |
| D. | = current Time ( ) |
| E. | None of these |
| Answer» B. = now ( ) | |
| 1802. |
Special category of Number tab in Format cells dialog box can be used to apply formats like : |
| A. | Zip Code |
| B. | Phone Number |
| C. | Postal Address |
| D. | Both (a) and (b) |
| E. | None of these |
| Answer» D. Both (a) and (b) | |
| 1803. |
Merge cells option can be applied from : |
| A. | Format Cells dialog box Alignment Tab |
| B. | Formatting toolbar |
| C. | Formatting Cells |
| D. | All of these |
| E. | None of these |
| Answer» A. Format Cells dialog box Alignment Tab | |
| 1804. |
Pre-mde sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from: |
| A. | from Format > Cells |
| B. | from Format > Auto format |
| C. | from Table > Auto format |
| D. | All of these |
| E. | None of these |
| Answer» B. from Format > Auto format | |
| 1805. |
Which of the following format you can decide to apply or not in AutoFormat dialog box? |
| A. | Number format |
| B. | Border format |
| C. | Font format |
| D. | All of these |
| E. | None of these |
| Answer» D. All of these | |
| 1806. |
How can you remove borders applied in cells? |
| A. | Choose None on Border tab of Format cells |
| B. | Open the list on Border tool in Formatting toolbar then choose first tool (no border) |
| C. | Choose remove on Border tab of Format cells |
| D. | Both (a) and (b) |
| E. | None of these |
| Answer» D. Both (a) and (b) | |
| 1807. |
Where can you set the shedding color for a range of cells in Excel? |
| A. | Choose required color form Patterns tab of Format Cells dialog box |
| B. | Choose required color on Fill color tool in Formatting toolbar |
| C. | Choose required color on Fill Color tool in Drawing toolbar |
| D. | All of these |
| E. | None of these |
| Answer» D. All of these | |
| 1808. |
You can set Page Border in Excel from: |
| A. | From Border tab in Format Cells dialog box |
| B. | From Border tool in Formatting toolbar |
| C. | From Line Style tool in Drawing toolbar |
| D. | You cannot set page border in Excel |
| E. | None of these |
| Answer» D. You cannot set page border in Excel | |
| 1809. |
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply : |
| A. | use = if ( ) function to format the required numbers red |
| B. | Apply Conditional Formatting Command on Format Menu |
| C. | Select the cells that contain number between 0 and 100 then click Red color on Text Color tool |
| D. | All of these |
| E. | None of these |
| Answer» B. Apply Conditional Formatting Command on Format Menu | |
| 1810. |
You can check the conditions against…….. when applying conditional formatting : |
| A. | Cell value |
| B. | Formula |
| C. | Alignment |
| D. | Both (a) and (b) |
| E. | None of these |
| Answer» D. Both (a) and (b) | |
| 1811. |
Which of the following is invalid statement? |
| A. | Sheet tabs can be colored |
| B. | Some picture can be applied as a background of a sheet |
| C. | You can set the column width automatically fit the amount of text |
| D. | The width of a row and be specified manually or fit automatically |
| E. | None of these |
| Answer» D. The width of a row and be specified manually or fit automatically | |
| 1812. |
What function displays row data in a column or column data in a row? |
| A. | Hyperlink |
| B. | Index |
| C. | Transpose |
| D. | Rows |
| E. | None of these |
| Answer» C. Transpose | |
| 1813. |
When you insert an Excel file into a word document, the data are : |
| A. | Hyperlinked |
| B. | Placed in a word table |
| C. | Linked |
| D. | Embedded |
| E. | None of these |
| Answer» D. Embedded | |
| 1814. |
Except for the……….function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result : |
| A. | IF |
| B. | AND |
| C. | OR |
| D. | NOT |
| E. | None of these |
| Answer» A. IF | |
| 1815. |
Macros are “run” or executed from the …………..menu. |
| A. | Insert |
| B. | Format |
| C. | Tools |
| D. | Data |
| E. | None of these |
| Answer» C. Tools | |
| 1816. |
You can open the consolidate dialog box byt choosing consolidate from the…….menu. |
| A. | Insert |
| B. | Format |
| C. | Tools |
| D. | Data |
| E. | None of these |
| Answer» D. Data | |
| 1817. |
Each excel file is called a workbook because : |
| A. | It can contain text and data |
| B. | It can be modified |
| C. | It can contain many sheets including worksheets and chart sheets |
| D. | You have to work hard to create it |
| E. | None of these |
| Answer» C. It can contain many sheets including worksheets and chart sheets | |
| 1818. |
Which types of charts can excel produce? |
| A. | Line graphs and pie charts only |
| B. | Only line graphs |
| C. | Bar charts, line graphs and pie charts |
| D. | Bar charts and line graphs only |
| E. | None of these |
| Answer» C. Bar charts, line graphs and pie charts | |
| 1819. |
How are data organized in a spreadsheet? |
| A. | Lines and spaces |
| B. | Layers and planes |
| C. | Rows and Columns |
| D. | Height and width |
| E. | None of these |
| Answer» C. Rows and Columns | |
| 1820. |
What does the VLOOKUP function do? |
| A. | Looks up text that contain ‘v’ |
| B. | Checks whether text is the same in one cell as in the next |
| C. | Finds related records |
| D. | All of these |
| E. | None of these |
| Answer» C. Finds related records | |
| 1821. |
Gridlines : |
| A. | May be turned off for display but turned on for printing |
| B. | May be turned on or off or printing |
| C. | The be turned off for display and printing |
| D. | All of these |
| E. | None of these |
| Answer» D. All of these | |
| 1822. |
You can print only an embedded chart by |
| A. | Moving the chart to a chart sheet before you print. |
| B. | Formatting the chart before you print |
| C. | Selecting the chart before you print |
| D. | Both (a) and (c) |
| E. | None of these |
| Answer» D. Both (a) and (c) | |
| 1823. |
A function inside another function is called a function |
| A. | Nested |
| B. | Round |
| C. | Sum |
| D. | Text |
| E. | None of these |
| Answer» A. Nested | |
| 1824. |
How should you print a selected area of a worksheet, if you’ll want to print a different area next time? |
| A. | On the file menu, point to print area, and then click set print area. |
| B. | On the file menu, click print, and then click selection under print what |
| C. | On the view menu, click custom views, then click add |
| D. | All of these |
| E. | None of these |
| Answer» B. On the file menu, click print, and then click selection under print what | |
| 1825. |
Your German supplier still invoices for parts in deutsche marks. |
| A. | On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign. |
| B. | On the tools menu, click Add-Ins, and select the Euro Currency Tools check box |
| C. | Apply a selected background color |
| D. | All of these |
| E. | None of these |
| Answer» B. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box | |
| 1826. |
Which function calculates your monthly mortgage payment? |
| A. | PMT (payments) |
| B. | NPER (number of periods) |
| C. | PV (present value) |
| D. | All of these |
| E. | None of these |
| Answer» A. PMT (payments) | |
| 1827. |
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature? |
| A. | Point to speech on the tools menu, and then click show text to speech toolbar. |
| B. | Click validation on the data menu |
| C. | Point to speech on the tools menu, and then click speech recognition |
| D. | All of these |
| E. | None of these |
| Answer» A. Point to speech on the tools menu, and then click show text to speech toolbar. | |
| 1828. |
Which of the following methods cannot be used to enter data in a cell? |
| A. | Pressing an arrow key |
| B. | Pressing the tab key |
| C. | Pressing the Esc key |
| D. | Clicking the enter button to the formula bar |
| E. | None of these |
| Answer» C. Pressing the Esc key | |
| 1829. |
Which of the following methods cannot be used to edit the content of cell? |
| A. | Pressing the Alt key |
| B. | Clicking the formula bar |
| C. | Pressing F2 |
| D. | Double clicking the cell |
| E. | None of these |
| Answer» A. Pressing the Alt key | |
| 1830. |
To insert three columns between columns D and E you would : |
| A. | Select column D |
| B. | Select column E |
| C. | Select columns E, F and G |
| D. | Select columns D, E, and F |
| E. | None of these |
| Answer» B. Select column E | |
| 1831. |
To enter worksheet s across a range of cell, you must : |
| A. | Select the cells containing the title text and use the fill handle to center the text across a range of cells |
| B. | Widen the columns |
| C. | Select the cells containing the title text and use the fill handle to center the text across a range of cells |
| D. | Widen the column |
| E. | None of these |
| Answer» A. Select the cells containing the title text and use the fill handle to center the text across a range of cells | |
| 1832. |
When integrating MS-Word and Excel, Word is usually the : |
| A. | Server |
| B. | Source |
| C. | Client |
| D. | All of these |
| E. | None of these |
| Answer» C. Client | |
| 1833. |
Charts tips can : |
| A. | Show the formatting of a data label |
| B. | Show the name of a data series |
| C. | Show the value of data point |
| D. | Both (b) and (c) |
| E. | None of these |
| Answer» B. Show the name of a data series | |
| 1834. |
The Name box : |
| A. | Shows the location of the previously active cell |
| B. | Appears the left of the formula bar |
| C. | Appears below the status bar |
| D. | Appears below the menu bar |
| E. | None of these |
| Answer» B. Appears the left of the formula bar | |
| 1835. |
How do you change column width to fit the contents? |
| A. | Single-click the boundary to the left to the column heading |
| B. | Double click the boundary to the right of the column heading |
| C. | Press Alt and single click anywhere in the column |
| D. | All of these |
| E. | None of these |
| Answer» B. Double click the boundary to the right of the column heading | |
| 1836. |
Hyperlinks cannot be : |
| A. | Special shapes like stars and banners |
| B. | Drawing objects like rectangles ovals |
| C. | Pictures |
| D. | All can be hyperlinks |
| E. | None of these |
| Answer» D. All can be hyperlinks | |
| 1837. |
You can use the horizontal and vertical scroll bars to : |
| A. | Split a worksheet into two panes |
| B. | View different rows and columns |
| C. | Edit the contents of a cell |
| D. | View different worksheets |
| E. | None of these |
| Answer» B. View different rows and columns | |
| 1838. |
What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer. |
| A. | Spreadsheet program |
| B. | Database program |
| C. | Word processor program |
| D. | Desktop publisher program |
| E. | None of these |
| Answer» A. Spreadsheet program | |
| 1839. |
Which operation is not performed by computer |
| A. | Inputting |
| B. | Processing |
| C. | Controlling |
| D. | Understanding |
| E. | Thinking |
| Answer» D. Understanding | |
| 1840. |
The computer that process both analog and digital is called |
| A. | Analog computer |
| B. | Digital computer |
| C. | Hybrid computer |
| D. | Mainframe computer |
| E. | Super computer |
| Answer» C. Hybrid computer | |
| 1841. |
A rig t click on the desktop itself will …………….. |
| A. | open the Display Properties dialog box |
| B. | show a context-sensitive menu |
| C. | open the Control Panel |
| D. | minimize all open applications |
| E. | None of these |
| Answer» A. open the Display Properties dialog box | |
| 1842. |
The window which shows icons for things like the mouse, sound, and display is……. |
| A. | My Computer or computer |
| B. | Explorer |
| C. | Control Panel |
| D. | Taskbar |
| E. | programs |
| Answer» C. Control Panel | |
| 1843. |
……….refers to a computer’s ability to configure and use a device without human interaction. |
| A. | CPU |
| B. | Plug and Play |
| C. | Cache |
| D. | ALU |
| E. | Format |
| Answer» B. Plug and Play | |
| 1844. |
When was the first windows operating system launched? |
| A. | 1984 |
| B. | 1985 |
| C. | 1988 |
| D. | 1989 |
| E. | 1990 |
| Answer» B. 1985 | |
| 1845. |
Today’s computer giant IBM was earlier known by different name which was changes in 1924. What was that name? |
| A. | Tabulator Machine Co. |
| B. | Computing Tabulating Recording Co. |
| C. | The Tabulator Ltd. |
| D. | International Computer Ltd. |
| E. | None of these |
| Answer» B. Computing Tabulating Recording Co. | |
| 1846. |
The process of starting a or restarting a computer system by loading instructions from a secondary storage device into the computer memory is called |
| A. | Duping |
| B. | Booting |
| C. | Padding |
| D. | CPS |
| E. | None of these |
| Answer» B. Booting | |
| 1847. |
What does the disk drive of a computer do? |
| A. | Rotate the disk |
| B. | Read the disk |
| C. | Load a program from the disk into the memory |
| D. | Both (b) and (c) |
| E. | All (a), (b) & (c) |
| Answer» D. Both (b) and (c) | |
| 1848. |
IMB launched its first personal computer called IBM-PC in 1981. It had chips from Intel, disk drives from Tandon, operating system from Microsoft, the printer from Epson and the application software from everywhere. Can you name the country which contributed the video display? |
| A. | India |
| B. | China |
| C. | Germany |
| D. | Taiwan |
| E. | Japan |
| Answer» D. Taiwan | |
| 1849. |
In H2O the figure 2 is appeared lowered. Which effect has been applied? |
| A. | Superscript |
| B. | Lowered |
| C. | Subscript |
| D. | Laid down |
| E. | None |
| Answer» C. Subscript | |
| 1850. |
A Laptop or Notebook marked 802.11n in its feature, it means device support |
| A. | Bluetooth |
| B. | WiMAX |
| C. | USB |
| D. | Wi-Fi LAN |
| E. | 3G |
| Answer» D. Wi-Fi LAN | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.