MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 615 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 201. |
In Excel worksheet can have a maximum of…. Number of rows |
| A. | 256 |
| B. | 1024 |
| C. | 32,000 |
| D. | 65,535 |
| Answer» E. | |
| 202. |
In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? |
| A. | Use Ctrl to select all three cells, then click the paste button on the standard toolbar |
| B. | Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify |
| C. | Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to |
| D. | All of above |
| Answer» D. All of above | |
| 203. |
What is an expression that tells how the numbers in a determined set of cells are to be calculated? |
| A. | Formula |
| B. | Field |
| C. | Data |
| D. | Query Correct Answer: |
| Answer» B. Field | |
| 204. |
In Excel you can create hyperlinks from the Excel workbook to |
| A. | A webpage on company internet |
| B. | A web page on the internet |
| C. | Other Office application documents |
| D. | All |
| Answer» E. | |
| 205. |
In Excel to delete an embedded objects, first |
| A. | Double click the object |
| B. | Select the object by clicking it |
| C. | Press the Shift + Delete keys |
| D. | Select it and then press the delete key |
| Answer» E. | |
| 206. |
In Excel the auto fill feature |
| A. | Extends a sequential series of data |
| B. | Automatically adds a range of cell values |
| C. | Applies a boarder around selected cells |
| D. | None of above |
| Answer» E. | |
| 207. |
In Excel Tab scrolling buttons |
| A. | Allow you to view a different worksheet |
| B. | Allow you to view additional worksheet row down |
| C. | Allow you to view additional worksheet columns to the right |
| D. | Allow you to view additional sheet tabs |
| Answer» E. | |
| 208. |
In Excel accounting style shows negative numbers in |
| A. | Bold |
| B. | Brackets |
| C. | Parentheses |
| D. | Quotes |
| Answer» D. Quotes | |
| 209. |
In Excel you can use the horizontal and vertical scroll bars to |
| A. | Split a worksheet into two panes |
| B. | View different rows and columns edit the contents of a cell |
| C. | Edit the contents of a cell |
| D. | View different worksheets |
| Answer» C. Edit the contents of a cell | |
| 210. |
What does the NOW() function return? |
| A. | It returns the serial number of the current date and time |
| B. | It returns the serial number of the current date |
| C. | It returns the serial number of the current time |
| D. | None of the above |
| Answer» E. | |
| 211. |
In Excel circular reference is |
| A. | Geometric modeling tool |
| B. | A cell that points to a drawing object |
| C. | A formula that either directly or indirectly depends on itself |
| D. | Always erroneous |
| Answer» D. Always erroneous | |
| 212. |
In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a |
| A. | calendar |
| B. | photograph of rainfall |
| C. | chart showing rainfall amounts |
| D. | database of rainfall |
| Answer» D. database of rainfall | |
| 213. |
In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells |
| A. | F3 |
| B. | F5 |
| C. | F7 |
| D. | F11 |
| Answer» E. | |
| 214. |
In Excel you can open the scenario Manager dialog box by choosing scenarios from the….. menu. |
| A. | View |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» E. | |
| 215. |
In Excel which of the following formulas will Excel not be able to calculate? |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | 0 |
| Answer» B. 0 | |
| 216. |
In Excel when working in the page break preview, you can |
| A. | View exactly where each page break occurs |
| B. | Add or remove page breaks |
| C. | Change the print area |
| D. | All of above |
| Answer» E. | |
| 217. |
In Excel which symbol must all formula beginwith? |
| A. | 0 |
| B. | + |
| C. | ( |
| D. | @ |
| Answer» B. + | |
| 218. |
In Excel typical worksheet has …. Number of columns |
| A. | 128 |
| B. | 256 |
| C. | 512 |
| D. | 1024 |
| Answer» C. 512 | |
| 219. |
In Excel to hold row and column titles inplaces so that they do not scroll when you scroll a worksheet, click the |
| A. | Unfreeze panes command on the window menu |
| B. | Freeze panes command on the window menu |
| C. | Hold titles command on the edit menu |
| D. | Split command on the window menu |
| Answer» C. Hold titles command on the edit menu | |
| 220. |
In Excel you can use the format painter multiple times before you turn it off by |
| A. | You can use the format painter button only one time when you click it |
| B. | Double clicking the format painter button |
| C. | Pressing the Ctrl key and clicking the format painter button |
| D. | Pressing Alt key and clicking the format painter button |
| Answer» C. Pressing the Ctrl key and clicking the format painter button | |
| 221. |
What is the shortcut key to insert new sheet in current workbook? |
| A. | F11 |
| B. | Alt + F11 |
| C. | Ctrl + F11 |
| D. | Shift + F11 |
| Answer» E. | |
| 222. |
In Excel how do you delete a column? |
| A. | Select the column heading you want to delete and select the Delete Row button on the standard toolbar |
| B. | Select the column heading you want to delete and select Insert Delete from the menu |
| C. | Select the row heading you want to delete and select Edit>Delete from the menu |
| D. | Right click the column heading you want to delet and select delete from the shortcut menu |
| Answer» E. | |
| 223. |
In Excel chart wizard term data series refers to |
| A. | A chart legend |
| B. | A collection of chart data markers |
| C. | A set of values you plot in a chart |
| D. | A data label |
| Answer» C. A set of values you plot in a chart | |
| 224. |
To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu |
| A. | Edit |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» D. Data | |
| 225. |
In Excel All macro keyboard shortcuts include the ….. key |
| A. | Alt |
| B. | Ctrl |
| C. | F11 |
| D. | Shift |
| Answer» B. Ctrl | |
| 226. |
In Excel you cannot link excel worksheet data to a word document |
| A. | With the right drag method |
| B. | With a hyperlink |
| C. | With the copy and paste special commands |
| D. | With the copy and paste buttons on the standard toolbar |
| Answer» E. | |
| 227. |
To edit data in an embedded Excel worksheet object in a Word document |
| A. | Use the Excel menu bar and toolbars inside the word application |
| B. | Edit the hyperlink |
| C. | Edit the data in a Excel source application |
| D. | Use the Word menu bar and toolbars |
| Answer» B. Edit the hyperlink | |
| 228. |
The cell reference for cell range of G2 to M12 is _______ |
| A. | G2.M12 |
| B. | G2;M12 |
| C. | G2:M12 |
| D. | G2-M12 |
| Answer» D. G2-M12 | |
| 229. |
In Excel the Name box |
| A. | Shows the location of the previously active cell |
| B. | Appears t the left of the formula bar |
| C. | Appears below the status bar |
| D. | Appears below the menu bar |
| Answer» C. Appears below the status bar | |
| 230. |
In Excel when creating a vertical page break |
| A. | The active cell must be A1 |
| B. | The active cell can be anywhere in the worksheet |
| C. | The active cell must be in row 1 |
| D. | The active cell must be in column A |
| Answer» D. The active cell must be in column A | |
| 231. |
Which of the following is not a valid Zoom percentage in Excel? |
| A. | 10 |
| B. | 100 |
| C. | 300 |
| D. | 500 |
| Answer» E. | |
| 232. |
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called |
| A. | HTML |
| B. | Pivot Table Field List |
| C. | Pivot Table List |
| D. | Pivot Table Report |
| Answer» E. | |
| 233. |
In Excel one can copy data or formulas |
| A. | With the copy, paste and cut commands on the edit menu |
| B. | With commands on ta shortcut menu |
| C. | With buttons on the standard toolbars |
| D. | All of the above |
| Answer» E. | |
| 234. |
Merge cells option can be applied from |
| A. | Format Cells dialog box Alignment Tab |
| B. | Formatting toolbar |
| C. | Both of above |
| D. | None of above |
| Answer» B. Formatting toolbar | |
| 235. |
Which of the following describes how to select all the cells in a single column? |
| A. | Right click on column and select Pick from list |
| B. | Use data – text to columns menu item |
| C. | Left click on the gray column title button |
| D. | Pressing Ctrl + A on the keyboard |
| Answer» D. Pressing Ctrl + A on the keyboard | |
| 236. |
You can not link Excel worksheet data to a Word document |
| A. | With the right drag method |
| B. | With a hyperlink |
| C. | With the copy and paste special commands |
| D. | With the copy and paste buttons on the standard toolbar |
| Answer» E. | |
| 237. |
In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu |
| A. | Edit |
| B. | View |
| C. | Format |
| D. | Tools |
| Answer» D. Tools | |
| 238. |
In Excel which formula can add the all thenumeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell |
| A. | Count |
| B. | Average |
| C. | Sum |
| D. | None of above |
| Answer» D. None of above | |
| 239. |
Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros? |
| 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 above |
| Answer» C. Apply a selected background color | |
| 240. |
In Excel which of these will not select all thecells in a document? |
| A. | Clicking three times with the right mouse button in the spreadsheet |
| B. | Using the Edit – Select All menu |
| C. | Pressing Ctrl + A on the keyboard |
| D. | Pressing Ctrl + A on the keyboard |
| Answer» B. Using the Edit – Select All menu | |
| 241. |
In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the |
| A. | Unfreeze panes command on the window menu |
| B. | Freeze panes command on the window menu |
| C. | Hold titles command on the edit menu |
| D. | Split command on the window menu |
| Answer» C. Hold titles command on the edit menu | |
| 242. |
You can open the consolidate dialog box byt choosing Consolidate from the ….. menu. |
| A. | Insert |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» E. | |
| 243. |
In Excel you can use the drag and drop method to |
| A. | Copy cell contents |
| B. | Delete cells contents |
| C. | Add cell contents |
| D. | All of above |
| Answer» B. Delete cells contents | |
| 244. |
The Software which contains rows and columns is called ______ |
| A. | Database |
| B. | Drawing |
| C. | Spreadsheet |
| D. | Word processing |
| Answer» D. Word processing | |
| 245. |
You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use? |
| A. | New |
| B. | Save As |
| C. | Edit |
| D. | Save |
| Answer» C. Edit | |
| 246. |
How to fit long texts in a single cell with multiple lines? |
| A. | Start typing in the cell and press the Enter key to start another line |
| B. | Use the Wrap Text option in the Format -> Alignment menu |
| C. | Use the Shrink to Fit option in the Format -> Cells -> Alignment menu |
| D. | All of above |
| Answer» C. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu | |
| 247. |
In Excel how do you insert a row? |
| A. | Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu |
| B. | Select the row heading where you want to insert the new row and select Edit>Row from the menu |
| C. | Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar |
| D. | All of the above |
| Answer» B. Select the row heading where you want to insert the new row and select Edit>Row from the menu | |
| 248. |
Right clicking something in Excel |
| A. | Deletes the object |
| B. | Nothing the right mouse button is there for left handed people |
| C. | Opens a shortcut menu listing everything you can do to the object |
| D. | Selects the object |
| Answer» D. Selects the object | |
| 249. |
In Excel say that you want to paste a formularesult – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next? |
| A. | Click the Paste button on the standard toolbar |
| B. | Click the arrow on the paste button on the standard toolbar, then click formulas |
| C. | Click the arrow on the paste button on the standard toolbar, then click values. |
| D. | All of above |
| Answer» D. All of above | |
| 250. |
This type of software contains rows and columns. |
| A. | Drawing |
| B. | Spreadsheet |
| C. | Database |
| D. | Word processing |
| Answer» C. Database | |