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.
| 151. |
You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu. |
| A. | Edit |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» E. | |
| 152. |
In Excel to center worksheet titles 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 |
| Answer» B. Widen the columns | |
| 153. |
In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use? |
| A. | Pie chart |
| B. | Row chart |
| C. | Line chart |
| D. | Column chart |
| Answer» D. Column chart | |
| 154. |
You can zoom a worksheet |
| A. | With the mouse pointer in Print Preview |
| B. | With the zoom button on the Print Preview toolbar |
| C. | With the Zoom command on the view menu |
| D. | All of the above |
| Answer» E. | |
| 155. |
In Excel the view that puts a blue a blue line around each page that would be printed is the |
| A. | Print Preview |
| B. | Normal View |
| C. | Page Break Preview |
| D. | Split View |
| Answer» D. Split View | |
| 156. |
In Excel using the AutoSum button will replace in the selected cell |
| A. | the sum of values in the cell’s column |
| B. | nothing until you select a range of cells |
| C. | the sum of the cell’s row unless you change the range |
| D. | a formula which will add values in the range Excel guesses you want to add |
| Answer» E. | |
| 157. |
In Excel which of the following special function keys allow the content in cell |
| A. | Esc |
| B. | Shift |
| C. | Return |
| D. | Tab |
| Answer» D. Tab | |
| 158. |
When you link data maintained in Excel workbook to a Word document |
| A. | The Word document cannot be edited |
| B. | The Word document contains a reference to the original source application |
| C. | The word document must contain a hyperlink |
| D. | The word document contains a copy of the actual data |
| Answer» C. The word document must contain a hyperlink | |
| 159. |
A data map is helpful |
| A. | When you have too much data to chart |
| B. | To show a geographic distribution of data |
| C. | To compare data points |
| D. | To show changes in data over time |
| Answer» C. To compare data points | |
| 160. |
In Excel which elements of worksheet can be protected from accidental modification ? |
| A. | Contents |
| B. | Objects |
| C. | Scenarios |
| D. | All of above |
| Answer» E. | |
| 161. |
In Excel how can you print three copies of a workbook? |
| A. | Select File>Properties form the menu and type 3 in the Copies to print text box. |
| B. | Select File >Print from the menu and type 3 in the Number of copies text box. |
| C. | Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made |
| D. | Press Ctrl+P+3 |
| Answer» C. Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made | |
| 162. |
Which area in an excel window allows entering values and formulas ? |
| A. | Title bar |
| B. | Menu bar |
| C. | Formula bar |
| D. | Standard toolbar |
| Answer» D. Standard toolbar | |
| 163. |
In Excel Tab scrolling button |
| A. | Allow you to view a different worksheet |
| B. | Allow you to view additional worksheet rows down |
| C. | Allow you to view additional worksheet columns to the right |
| D. | Allow you to view additional sheets tabs |
| Answer» E. | |
| 164. |
To center worksheet titles 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 |
| Answer» D. Widen the column | |
| 165. |
In Excel what does SUMIF function do? |
| A. | Adds up cell values based on a condition |
| B. | Adds all the numbers in a range of cells |
| C. | Returns a subtotal in a list or database |
| D. | All of above |
| Answer» B. Adds all the numbers in a range of cells | |
| 166. |
Got functions? No? You need the insert function dialog box. How do you get it? |
| A. | Right click a cell and then click insert |
| B. | Click the insert menu and then click function |
| C. | Type = in a cell |
| D. | All of the above |
| Answer» C. Type = in a cell | |
| 167. |
In Excel you can copy cell formats from one cell to another by using the |
| A. | Backspace key |
| B. | Default font |
| C. | Format painter |
| D. | Formatting toolbar |
| Answer» D. Formatting toolbar | |
| 168. |
In Excel you can use the formula palette to |
| A. | Format cells containing numbers |
| B. | Create and edit formulas containing functions |
| C. | Enter assumptions data |
| D. | Copy a range of cells |
| Answer» C. Enter assumptions data | |
| 169. |
Which of the following is correct syntax in Excel? |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | 0 |
| Answer» B. 0 | |
| 170. |
What is the symbol for multiplying? |
| A. | > |
| B. | / |
| C. | ! |
| D. | * |
| Answer» E. | |
| 171. |
In Excel when you are typing an equation into a cell the first thing that must be entered is |
| A. | the first cell referenced |
| B. | parenthesis |
| C. | quotation marks |
| D. | an equal sign |
| Answer» E. | |
| 172. |
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 | |
| 173. |
Microsoft Excel is a powerful……….. |
| A. | Word processing package |
| B. | Spreadsheet package |
| C. | Communication S/W Package |
| D. | DBMS package |
| Answer» C. Communication S/W Package | |
| 174. |
In Excel the Paste Special command lets you copy and paste |
| A. | Multiply the selection by a copied value |
| B. | Cell comments |
| C. | Formatting options |
| D. | The resulting values of a formula instead of the actual formula |
| Answer» E. | |
| 175. |
In Excel this function converts miles to kilometers, kilograms to pounds, and so on |
| A. | Convert |
| B. | Product |
| C. | Change |
| D. | All of above |
| Answer» B. Product | |
| 176. |
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. | b and c |
| Answer» E. | |
| 177. |
In Excel to view a cell comment |
| A. | Click the edit comment command on the insert menu |
| B. | Click the display comment command on the window menu |
| C. | Position the mouse pointer over the cell |
| D. | Click the comment command on the view menu |
| Answer» D. Click the comment command on the view menu | |
| 178. |
In Excel the following is not a basic step in creating a worksheet |
| A. | Save workbook |
| B. | Modifiy the worksheet |
| C. | Enter text and data |
| D. | Copy the worksheet |
| Answer» E. | |
| 179. |
In Excel term refers to a specific set of values saved with the workbook |
| A. | Range |
| B. | Scenario |
| C. | Trend line |
| D. | What-if analysis |
| Answer» C. Trend line | |
| 180. |
You can edit existing Excel data by pressing the |
| A. | F1 key |
| B. | F2 key |
| C. | F3 key |
| D. | F4 key |
| Answer» C. F3 key | |
| 181. |
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in …………… |
| A. | ascending order |
| B. | descending order |
| C. | alphabetical order |
| D. | random order |
| Answer» C. alphabetical order | |
| 182. |
In Excel when the formula bar is active, you can see |
| A. | The edit formula button |
| B. | The cancel button |
| C. | The enter button |
| D. | All of the above |
| Answer» E. | |
| 183. |
A __________ is a grid with labeled columns and rows. |
| A. | Dialog box |
| B. | Worksheet |
| C. | Clipboard |
| D. | Toolbar |
| Answer» C. Clipboard | |
| 184. |
When you see a cell with a red triangle in the top right corner, what does this signify? |
| A. | There is an error in the cell |
| B. | There is a comment associated with the cell |
| C. | The font color for text in the cell is red |
| D. | A formula cannot be entered into the cell |
| Answer» C. The font color for text in the cell is red | |
| 185. |
Which of the following options is appropriate to show the numbers 9779851089510 in a cell? |
| A. | Enclose the number is brackets |
| B. | Place the character T before the number |
| C. | Place the character TX before the number |
| D. | Apply the Text format in the cell and type the numbers |
| Answer» E. | |
| 186. |
In Excel Weight refers to |
| A. | The print density of characters |
| B. | The height of the printed character |
| C. | Upright or slanted shape |
| D. | The design and appearance of characters |
| Answer» B. The height of the printed character | |
| 187. |
In Excel when you work with large worksheets, you may need to |
| A. | Size the worksheet to fit on the specific number of pages |
| B. | Add and remove page breaks |
| C. | Specify only certain print areas |
| D. | All of above |
| Answer» E. | |
| 188. |
You accidentally erased a record in the sheet. What command can be used to restore it immediately? |
| A. | Insert |
| B. | Copy |
| C. | Undo |
| D. | Replace |
| Answer» D. Replace | |
| 189. |
In Excel which of the following is not an option in the spelling dialog box |
| A. | Edit |
| B. | Ignore |
| C. | Ignore all |
| D. | Change |
| Answer» B. Ignore | |
| 190. |
Worksheet can be renamed by |
| A. | Adding ? symbol at the end of filename while saving workbook |
| B. | Click on Worksheet tab by Holding CTRL Key and type new name |
| C. | Double Click on the Worksheet tab and type new name |
| D. | Worksheet cannot renamed |
| Answer» D. Worksheet cannot renamed | |
| 191. |
In Excel when you insert an excel file into a word document. The data are |
| A. | Hyperlinked placed in a word table |
| B. | Linked |
| C. | Embedded |
| D. | Use the word menu bar and toolbars |
| Answer» C. Embedded | |
| 192. |
In Excel what symbol is used before a number to make it a label? |
| A. | “ (quote) |
| B. | 0 |
| C. | _ (underscore) |
| D. | ‘ (apostrophe) |
| Answer» C. _ (underscore) | |
| 193. |
In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page? |
| A. | Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles. |
| B. | Click page setup on the file menu, click the page tab, click the options button, then enter your choices. |
| C. | Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading. |
| D. | All of above |
| Answer» B. Click page setup on the file menu, click the page tab, click the options button, then enter your choices. | |
| 194. |
In Excel default style for new data keyed in a new workbook is |
| A. | Comma |
| B. | Currency |
| C. | Normal |
| D. | Per cent |
| Answer» D. Per cent | |
| 195. |
Which button do yu click to add up a series of numbers? |
| A. | The autosum button |
| B. | The Formula button |
| C. | The quicktotal button |
| D. | The total button |
| Answer» B. The Formula button | |
| 196. |
Getting data from a cell located in a different sheet is called…. |
| A. | Accessing |
| B. | Referencing |
| C. | Updating |
| D. | Functioning |
| Answer» C. Updating | |
| 197. |
All formula in Excel start with |
| A. | &percent; |
| B. | + |
| C. | 0 |
| D. | - |
| Answer» E. | |
| 198. |
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “[email protected]” in cell C1? |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | 0 |
| Answer» D. 0 | |
| 199. |
In Excel 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) |
| Answer» E. | |
| 200. |
What is the shortcut key to insert current date in a cell? |
| A. | CTRL + D |
| B. | CTRL + T |
| C. | CTRL + ; |
| D. | CTRL + / |
| Answer» D. CTRL + / | |