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 .
351. |
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» B. Click the insert menu and then click function |
352. |
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» C. Left click on the gray column title button |
353. |
when you use the fill effects in the format data series dialog box, you can not |
A. | rotate text on the chart |
B. | select a fore ground color |
C. | select a pattern |
D. | select a background color |
Answer» A. rotate text on the chart |
354. |
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? |
A. | Rows and columns |
B. | Headings |
C. | Speed |
D. | None |
Answer» C. Speed |
355. |
Which of the following is not a basic step in creating a worksheet? |
A. | Save the workbook |
B. | Modify the worksheet |
C. | Enter text and data |
D. | Copy the worksheet |
Answer» D. Copy the worksheet |
356. |
What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20? |
A. | Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows |
B. | Select the range you want, include both cells, point to fill on the Edit menu, and then click down. |
C. | Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special |
D. | All of above |
Answer» A. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows |
357. |
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. |
Answer» C. Select columns E, F and G |
358. |
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» C. Select the cells containing the title text and use the fill handle to center the text across a range of cells |
359. |
When integrating Ms-Word and Excel, Word is usually the |
A. | Server |
B. | Source |
C. | Client |
D. | None |
Answer» C. Client |
360. |
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» D. b and c |
361. |
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 |
362. |
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 |
363. |
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 |
364. |
Hyperlinks cannot be |
A. | Special shapes like stars and banners |
B. | Drawing objects like rectangles ovals |
C. | Pictures |
D. | All can be hyperlinks |
Answer» D. All can be hyperlinks |
365. |
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 |
366. |
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 |
367. |
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 |
368. |
What function displays row data in a column or column data in a row? |
A. | Hyperlink |
B. | Index |
C. | Transpose |
D. | Rows |
Answer» C. Transpose |
369. |
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 |
Answer» B. Placed in a word table |
370. |
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 |
Answer» A. IF |
371. |
Macros are “run” or executed from the ….. menu. |
A. | Insert |
B. | Frmat |
C. | Tools |
D. | Data |
Answer» C. Tools |
372. |
You can open the consolidate dialog box byt choosing Consolidate from the ….. menu. |
A. | Insert |
B. | Format |
C. | Tools |
D. | Data |
Answer» D. Data |
373. |
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 |
Answer» C. Bar charts, line graphs and pie charts |
374. |
How are data organized in a spreadsheet? |
A. | Lines and spaces |
B. | Layers and planes |
C. | Rows and columns |
D. | Height and width |
Answer» C. Rows and columns |
375. |
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 above |
Answer» C. Finds related records |
376. |
Gridlines |
A. | May be turned off for display but turned on for printing |
B. | May be turned on or off for printing |
C. | The be turned off for display and printing |
D. | a, b and c |
Answer» D. a, b and c |
377. |
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. | a and c |
Answer» D. a and c |
378. |
Which of the following is a correct order of precedence in a formula calculation? |
A. | Multiplication and division, exponential positive and negative value |
B. | Multiplication and division, positive and negative values, addition and subtraction |
C. | Addition and subtraction, positive and negative values, exponentiation |
D. | None of above |
Answer» D. None of above |
379. |
A function inside another function is called a ….. function. |
A. | Nested |
B. | Round |
C. | Sum |
D. | Text |
Answer» A. Nested |
380. |
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 above |
Answer» B. On the file menu, click print, and then click selection under print what |
381. |
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» B. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box |
382. |
Which function calculates your monthly mortage payment? |
A. | PMT (payments) |
B. | NPER (number of periods) |
C. | PV (present value) |
D. | All of above |
Answer» A. PMT (payments) |
383. |
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 above |
Answer» A. Point to speech on the tools menu, and then click show text to speech toolbar. |
384. |
Which of the following methods can not 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 |
Answer» C. Pressing the Esc key |
385. |
Which of the following will not set text in selected cells to italics? |
A. | Pressing Ctrl + I on the keyboard |
B. | Using the Tools – Wizard – Web Form menu item |
C. | Using the Format – Cells – Font menu item |
D. | None of the above |
Answer» B. Using the Tools – Wizard – Web Form menu item |
386. |
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 |
Answer» A. Pressing the Alt key |
387. |
Which of the following is not an option in the spelling dialog box? |
A. | Edit |
B. | Ignore |
C. | Ignore all |
D. | Change |
Answer» A. Edit |
388. |
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» C. Format |
389. |
To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu |
A. | Edit |
B. | Format |
C. | Tools |
D. | Data |
Answer» C. Tools |
390. |
You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu. |
A. | Edit |
B. | Insert |
C. | Format |
D. | Tools |
Answer» D. Tools |
391. |
Which of the following is not a worksheet design criterion? |
A. | Efficiency |
B. | Auditability |
C. | Description |
D. | Clarity |
Answer» C. Description |
392. |
To copy cell contents using drag and drop, press the |
A. | End key |
B. | Shift key |
C. | Esc key |
D. | None of above |
Answer» D. None of above |
393. |
If you press …., the cell accepts your typing as its contents. |
A. | Enter |
B. | Ctrl + Enter |
C. | TAB |
D. | Insert |
Answer» A. Enter |
394. |
The autofill 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» A. Extends a sequential series of data |
395. |
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells? |
A. | F3 |
B. | F5 |
C. | F7 |
D. | F11 |
Answer» D. F11 |
396. |
you can use the formula palette to |
A. | format cells containing numbers |
B. | create and edit formulas containing functions |
C. | entered assumptions data |
D. | copy a range of cells |
Answer» B. create and edit formulas containing functions |
397. |
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed |
A. | Format Report |
B. | Pivot Table |
C. | Refresh Data |
D. | Show Detail |
Answer» C. Refresh Data |
398. |
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» A. Formula |
399. |
“Qtr 1, Qtr 2, Qtr 3” is an example of a |
A. | Formula |
B. | Function |
C. | Series |
D. | Syntax |
Answer» C. Series |
400. |
You can edit existing Excel data by pressing the |
A. | F1 key |
B. | F2 key |
C. | F3 key |
D. | F4 key |
Answer» B. F2 key |
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.