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.
| 101. |
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» C. Single Accounting | |
| 102. |
What should be add before a fraction to avoid entering it as a date? |
| A. | // |
| B. | FR |
| C. | Zero |
| D. | Zero Space |
| Answer» E. | |
| 103. |
Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from |
| A. | from Fromat >> Cells |
| B. | from Format >> Autoformat |
| C. | from Table >> Autoformat |
| D. | All of above |
| Answer» C. from Table >> Autoformat | |
| 104. |
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» D. None | |
| 105. |
Excel displays the current cell address in the ………. |
| A. | Formula bar |
| B. | Status Bar |
| C. | Name Box |
| D. | Title Bar |
| Answer» D. Title Bar | |
| 106. |
In Excel Book1 is an example of how … are numbered and named during each work session |
| A. | Active cell |
| B. | Formula bar |
| C. | Menu bar |
| D. | Name box |
| Answer» E. | |
| 107. |
In Excel which of the following is an absolute cell reference? |
| A. | !A!1 |
| B. | $A$1 |
| C. | #a#1 |
| D. | A1 |
| Answer» C. #a#1 | |
| 108. |
In Excel following term describes explanatory text attached to a cell |
| A. | Callout |
| B. | Comment |
| C. | Dialog |
| D. | Extension |
| Answer» C. Dialog | |
| 109. |
In Excel using the F11 shortcut key to create a chart on chart sheet creates |
| A. | A default chart |
| B. | A 2-dimensional column chart |
| C. | A 2-dimensional bar chart |
| D. | A 3-dimensional line chart |
| Answer» C. A 2-dimensional bar chart | |
| 110. |
In Excel 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 |
| Answer» D. You have to work hard to create it | |
| 111. |
In Excel concatenation of text can be done using |
| A. | Apostrophe (‘) |
| B. | Exclamation (!) |
| C. | Hash (#) |
| D. | Ampersand (&) |
| Answer» E. | |
| 112. |
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» E. | |
| 113. |
In Excel you can create only a horizontal page break by first selecting |
| A. | A row below the row where you want the page break to occure |
| B. | A cell in row 1 |
| C. | A cell in column A |
| D. | (A) and (C) |
| Answer» E. | |
| 114. |
In Excel which menu option can be sued to split windows into two |
| A. | Format > window |
| B. | View > window > split |
| C. | Window > split |
| D. | View > split |
| Answer» D. View > split | |
| 115. |
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» C. Press the Enter button | |
| 116. |
An Excel Workbook is a collection of ……. |
| A. | Workbooks |
| B. | Worksheets |
| C. | Charts |
| D. | Worksheets and Charts |
| Answer» E. | |
| 117. |
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. | |
| 118. |
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» D. Select columns D, E, and F. | |
| 119. |
To copy cell contents using drag and drop, press the |
| A. | End key |
| B. | Shift key |
| C. | Esc key |
| D. | None of above |
| Answer» E. | |
| 120. |
In Excel how do you select an entire column? |
| A. | Select Edit > Select > Column from the menu |
| B. | Click the column heading letter |
| C. | Hold down the shift key as you click anywhere in the column. |
| D. | Hold down the Ctrl key as you click anywhere in the column |
| Answer» B. Click the column heading letter | |
| 121. |
Which one is the last column header in Excel 2007? |
| A. | XFD |
| B. | XFX |
| C. | XFL |
| D. | XFT |
| Answer» B. XFX | |
| 122. |
A function inside another function is called _______ |
| A. | Nested function |
| B. | Round function |
| C. | Sum function |
| D. | Text function |
| Answer» B. Round function | |
| 123. |
In Excel what chart object is horizontal orvertical line that extends across the plot area to make it easier to read and follow the values? |
| A. | Category axis |
| B. | Data marker |
| C. | Data point |
| D. | Gridline |
| Answer» E. | |
| 124. |
What excel feature can you use if you want to work with one record at a time? |
| A. | Auto Complete |
| B. | Auto Filter |
| C. | Data Form |
| D. | Sub Totals |
| Answer» D. Sub Totals | |
| 125. |
How do you tell one cell from another? |
| A. | By numbers |
| B. | By letters |
| C. | By its address |
| D. | by color |
| Answer» D. by color | |
| 126. |
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» C. There is no suitable abbreviation for the text | |
| 127. |
Multiple calculations can be made in a single formula using….. |
| A. | Standard Formulas |
| B. | Array Formula |
| C. | Complex Formulas |
| D. | Smart Formula |
| Answer» C. Complex Formulas | |
| 128. |
How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell. |
| A. | The Settings tab under the menu Format -> Cells |
| B. | The Settings tab under the menu Data -> Validation |
| C. | The Settings tab under the menu Data -> Filter -> Advanced Filter |
| D. | the Settings tab under the menu Format -> Conditional Formatting |
| Answer» C. The Settings tab under the menu Data -> Filter -> Advanced Filter | |
| 129. |
In Excel 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. | |
| 130. |
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» D. Clicking the enter button to the formula bar | |
| 131. |
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» D. All of above | |
| 132. |
In Excel when integrating Ms-Word and Excel,Word is usually the |
| A. | Server |
| B. | Source |
| C. | Client |
| D. | None |
| Answer» D. None | |
| 133. |
What is the shortcut key to insert a new comment in a cell? |
| A. | F2 |
| B. | Alt + F2 |
| C. | Ctrl + F2 |
| D. | Shift + F2 |
| Answer» E. | |
| 134. |
In Excel A data map is helpful |
| A. | When you have too much data to chart |
| B. | To show a geographic distribution of data8 |
| C. | To compare data points |
| D. | To show changes in data over time |
| Answer» C. To compare data points | |
| 135. |
In Excel to open an existing workbook, you can click the Open button on the …… toolbar. |
| A. | Drawing |
| B. | Formatting |
| C. | Forms |
| D. | Standard |
| Answer» E. | |
| 136. |
How to specify cell range from A9 to A99 in Excel? |
| A. | (A9, A99) |
| B. | (A9 to A99) |
| C. | (A9 : A99) |
| D. | (A9 – A99) |
| Answer» D. (A9 – A99) | |
| 137. |
In Excel to cancel the marquee, press |
| A. | Ctrl + End |
| B. | End |
| C. | Esc |
| D. | Shift + Esc |
| Answer» D. Shift + Esc | |
| 138. |
In Excel _______ may not contain in Formula |
| A. | Text Constant |
| B. | Number Constant |
| C. | Circular Reference |
| D. | All of them |
| Answer» D. All of them | |
| 139. |
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» B. select a fore ground color | |
| 140. |
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do? |
| A. | Re-format the spreadsheet |
| B. | Insert a row |
| C. | Increase the column width |
| D. | Use the spacebar |
| Answer» C. Increase the column width | |
| 141. |
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is …. |
| A. | G1-G10 |
| B. | B1.G10 |
| C. | B1;G10 |
| D. | B1:G10 |
| Answer» E. | |
| 142. |
If the cell B1 contains the formula = $A$1, which of the following statements is true |
| A. | There is a relative reference to cell A1 |
| B. | There is an absolute reference to cell A1 |
| C. | Further changes in value of A1 will not affect the value of B1 |
| D. | Further changes in value of B1 will affect the value of A1 |
| Answer» C. Further changes in value of A1 will not affect the value of B1 | |
| 143. |
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» E. | |
| 144. |
Special category of Number tab in Format Cells dialog box can be used to apply formats like |
| A. | Zip Code |
| B. | Phone Number |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 145. |
Which option allows you to Bold all the negative values within the selected cell range: |
| A. | Zero Formatting |
| B. | Conditional Formatting |
| C. | Compare Formatting |
| D. | Negative Formatting |
| Answer» C. Compare Formatting | |
| 146. |
Which of the following is not an underline option in the format cells dialog box? |
| A. | Double |
| B. | Single Accounting |
| C. | Double Accounting |
| D. | Single Engineering |
| Answer» E. | |
| 147. |
In Excel autofill feature |
| A. | Extends a sequential series of data |
| B. | Automatically adds range of cell values |
| C. | Applies a boarder around the selected cells |
| D. | None of the above |
| Answer» C. Applies a boarder around the selected cells | |
| 148. |
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» E. | |
| 149. |
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» E. | |
| 150. |
Macros are “run” or executed from the ….. menu. |
| A. | Insert |
| B. | Frmat |
| C. | Tools |
| D. | Data |
| Answer» D. Data | |