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 , Microsoft Office .
| 151. |
In Excel all worksheet formula |
| A. | Manipulate values |
| B. | Manipulate labels |
| C. | Return a formula result |
| D. | Use the addition operator |
| Answer» C. Return a formula result | |
| 152. |
In Excel which of the following is a correct order of precedence in formula calculation? |
| A. | Multiplication and division exponentia- tion positive and negative values |
| B. | Multiplication and division, positive and negative values, addition and subtraction |
| C. | Addition and subtraction, positive and negative values, exponentiation |
| D. | All of above |
| Answer» D. All of above | |
| 153. |
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» D. The resulting values of a formula instead of the actual formula | |
| 154. |
In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this? |
| A. | None of these |
| B. | Select Format > Money from the menu |
| C. | Click the Currency Style button on the formatting toolbar |
| D. | You have to retype everything and manually add the dollar signs, commas, and decimals. |
| Answer» C. Click the Currency Style button on the formatting toolbar | |
| 155. |
In Excel which of the following is not a valid data type in excel |
| A. | Number |
| B. | Character |
| C. | Label |
| D. | Date/time |
| Answer» B. Character | |
| 156. |
Excel worksheet cells work very similarly to what common element of the windows graphical user interface |
| A. | Option button |
| B. | List boxes |
| C. | Text boxes |
| D. | Combo boxes |
| Answer» C. Text boxes | |
| 157. |
In Excel which of the following options is not located in the Page Setup dialog box? |
| A. | Page Break Preview. |
| B. | Page Orientation |
| C. | Margins |
| D. | Headers and Footers |
| Answer» A. Page Break Preview. | |
| 158. |
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» C. Line chart | |
| 159. |
In Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? |
| A. | Press Ctrl +Home |
| B. | Press Home |
| C. | Press Shift + Home |
| D. | Press Alt + Home |
| Answer» A. Press Ctrl +Home | |
| 160. |
Which of the following methods cannot be used to edit the contents of a cell In Excel? |
| A. | Press the Alt key |
| B. | Clicking the formula bar |
| C. | Pressing the F2 key |
| D. | Double clicking the cell |
| Answer» A. Press the Alt key | |
| 161. |
In Excel if you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you |
| A. | Press the Erase key |
| B. | Press Esc |
| C. | Press the Enter button |
| D. | Press the Edit Formula button |
| Answer» B. Press Esc | |
| 162. |
In Excel default style for new data keyed in a new workbook is |
| A. | Comma |
| B. | Currency |
| C. | Normal |
| D. | Per cent |
| Answer» C. Normal | |
| 163. |
In Excel LEN function does what? |
| A. | Compares the content in two cells |
| B. | Counts the numbers of characters in a cell |
| C. | Deletes extra space in text |
| D. | All of above |
| Answer» A. Compares the content in two cells | |
| 164. |
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» A. Convert | |
| 165. |
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» A. Copy cell contents | |
| 166. |
In Excel to balance your checkbook, your best method is |
| A. | Copy your check amounts into Excel so that you’ll have a neat printout to work on |
| B. | Use Excel to check your arithmetic |
| C. | Download the Checkbook register templates from Templates on Microsoft Office Online |
| D. | All of above |
| Answer» C. Download the Checkbook register templates from Templates on Microsoft Office Online | |
| 167. |
In Excel which formula can add the all the numeric 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» C. Sum | |
| 168. |
In Excel to name a constant, you use the …… dialog box |
| A. | Create name |
| B. | Define name |
| C. | Paste name |
| D. | Format cells |
| Answer» B. Define name | |
| 169. |
In Excel to cancel the marquee, press |
| A. | Ctrl + End |
| B. | End |
| C. | Esc |
| D. | Shift + Esc |
| Answer» C. Esc | |
| 170. |
In Excel the function calculates depreciation at the same amount each year over an asset’s useful life |
| A. | DB (fixed-declining balance) |
| B. | SLN (straight line) |
| C. | DDB (double-declining) |
| D. | All of above |
| Answer» B. SLN (straight line) | |
| 171. |
In Excel the following is not an underline option in the format cells dialog box |
| A. | Double |
| B. | Single Engineering |
| C. | Single Accounting |
| D. | Double Accounting |
| Answer» B. Single Engineering | |
| 172. |
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» A. Select the cells containing the title text and use the fill handle to center the text across a range of cells | |
| 173. |
In Excel when integrating Ms-Word and Excel, Word is usually the |
| A. | Server |
| B. | Source |
| C. | Client |
| D. | None |
| Answer» C. Client | |
| 174. |
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» D. Both (B) and (C) | |
| 175. |
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» B. Appears t the left of the formula bar | |
| 176. |
In Excel 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 above |
| Answer» B. Double click the boundary to the right of the column heading | |
| 177. |
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» D. All of above | |
| 178. |
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 |
| C. | Edit the contents of a cell |
| D. | View different worksheets |
| Answer» B. View different rows and columns | |
| 179. |
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 |
| Answer» A. Spreadsheet program | |
| 180. |
In Excel you can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar. |
| A. | Standard |
| B. | Formatting |
| C. | Drawing |
| D. | Picture |
| Answer» D. Picture | |
| 181. |
In Excel to drag a selected range of data to another worksheet in the same workbook, use the |
| A. | Tab key |
| B. | Alt key |
| C. | Shift key |
| D. | Ctrl key |
| Answer» D. Ctrl key | |
| 182. |
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» C. The active cell must be in row 1 | |
| 183. |
In Excel to activate the previous cell in a pre- selected range, press |
| A. | The Alt key |
| B. | The Tab key |
| C. | The Enter key |
| D. | None of above |
| Answer» D. None of above | |
| 184. |
In Excel when the formula bar is activated, you can see |
| A. | The Edit Formula button |
| B. | The Cancel button |
| C. | The Enter button |
| D. | All of above |
| Answer» D. All of above | |
| 185. |
In a worksheet you can select |
| A. | Etire worksheet |
| B. | Rows |
| C. | Columns |
| D. | All of the above |
| Answer» D. All of the above | |
| 186. |
When you print preview a worksheet |
| A. | the entire worksheet is displayed |
| B. | the selected range is displayed |
| C. | the active portion of the worksheet is displayed |
| D. | All of the above |
| Answer» D. All of the above | |
| 187. |
In Excel to access the Go To Special feature, you can press |
| A. | Ctrl + G |
| B. | Ctrl + O |
| C. | Ctrl + Shift + G |
| D. | Ctrl + 1 |
| Answer» A. Ctrl + G | |
| 188. |
In Excel which do you press to enter the current date in a cell? |
| A. | Ctrl + Shift + : |
| B. | Ctrl + ; |
| C. | Ctrl + F10 |
| D. | All of above |
| Answer» B. Ctrl + ; | |
| 189. |
In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when |
| A. | Data will be entered in the adjacent cells |
| B. | No data will be entered in the adjacent cells |
| C. | There is no suitable abbreviation for the text |
| D. | There is not time to format the text |
| Answer» B. No data will be entered in the adjacent cells | |
| 190. |
In Excel you can group noncontiguous worksheets with |
| A. | The group button on the standard toolbar |
| B. | The shift key and the mouse |
| C. | The ctrl key and mouse |
| D. | The alt+enter key |
| Answer» C. The ctrl key and mouse | |
| 191. |
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» A. The print density of characters | |
| 192. |
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 refe- rence 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» B. The Word document contains a refe- rence to the original source application | |
| 193. |
In Excel 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» B. There is a comment associated with the cell | |
| 194. |
In Excel to hold row and column titles in places 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» B. Freeze panes command on the window menu | |
| 195. |
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» C. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to | |
| 196. |
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» A. Use the Excel menu bar and toolbars inside the word application | |
| 197. |
In Excel Status indicators are located on the |
| A. | Vertical scroll bar |
| B. | Horizontal scroll bar |
| C. | Formula bar |
| D. | Standard toolbar |
| Answer» C. Formula bar | |
| 198. |
In Excel Rounding errors can occur |
| A. | When you use multiplication, division, or exponentiation in a formula |
| B. | When you use addition and subtraction in a formula |
| C. | Because excel uses hidden decimal places in computation |
| D. | When you show the results of formulas with different decimal places that the calculated results |
| Answer» A. When you use multiplication, division, or exponentiation in a formula | |
| 199. |
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» D. All of the above | |
| 200. |
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» D. With the copy and paste buttons on the standard toolbar | |
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.