Which of the following methods cannot be used to edit the content of cell?
✅ Correct Answer:Pressing the Alt key
Explanation: There are three main ways to enter 'Edit Mode' in Excel: Double-clicking the cell, clicking inside the Formula Bar, or pressing the F2 key. Pressing the 'Alt' key simply activates the menu bar shortcuts (Key Tips) and does not allow you to edit the cell's content.
202
Which of the following will not set text in selected cells to italics?
✅ Correct Answer:Using the Tools - Wizard - Web Form menu item
Explanation: To make text Italic, you can use the keyboard shortcut 'Ctrl + I', use the Italic button on the toolbar, or go to Format > Cells > Font tab. The 'Tools - Wizard - Web Form' menu is used for creating web forms and has absolutely nothing to do with formatting text style like Italics.
203
Which of the following methods cannot be used to enter data in a cell?
✅ Correct Answer:Pressing the Esc key
Explanation: When you are typing data into a cell: Pressing Enter, Tab, or any Arrow key will 'commit' (save) the data and move the selection to the next cell. However, pressing the 'Esc' (Escape) key cancels the entry. It deletes what you were typing and reverts the cell to its previous state, so no data is entered.
204
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?
✅ Correct Answer:Point to speech on the tools menu, and then click show text to speech toolbar.
Explanation: Excel has a 'Text to Speech' feature (Speak Cells) that reads aloud the content of cells. In older versions (like Excel 2002/2003), this was accessed via Tools > Speech > Show Text to Speech Toolbar. This is very useful for verifying data entry without looking back and forth at the screen.
205
Which function calculates your monthly mortgage payment?
✅ Correct Answer:PMT (payments)
Explanation: The PMT function calculates the payment for a loan based on constant payments and a constant interest rate. It is commonly used for mortgages and car loans. It requires the interest rate, the number of periods (NPER), and the present value (PV/Loan Amount) to give you the monthly installment.
206
Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
✅ Correct Answer:On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
Explanation: This is a classic feature from the time of the Euro currency transition. Excel provided a specific Add-In called 'Euro Currency Tools'. Activating this add-in gave users a toolbar and functions to accurately convert legacy European currencies (like German Marks or French Francs) into Euros based on fixed conversion rates.
207
How should you print a selected area of a worksheet, if you'll want to print a different area next time?
✅ Correct Answer:On the file menu, click print, and then click selection under print what
Explanation: If your printing need is temporary (just for this time), you should choose 'Print Selection' in the print dialog. If you use 'Set Print Area' (Option A), Excel saves that area as the default print zone for the future, which you would have to manually clear later. 'Print Selection' is best for one-time specific prints.
208
A function inside another function is called a ______ function.
✅ Correct Answer:Nested
Explanation: When you use a function as an argument within another function, it is called a 'Nested' function. For example, =IF(A1>50, 'Pass', IF(A1>40, 'Retest', 'Fail')). Here, the second IF is nested inside the first IF. Excel allows multiple levels of nesting to create complex logic.
209
Which of the following is a correct order of precedence in a formula calculation?
✅ Correct Answer:None of these
Explanation: Excel follows a standard mathematical order of operations (PEMDAS). The correct order is: Parentheses (), Reference operators, Negation (-), Percent (%), Exponentiation (^), Multiplication and Division (* /), and finally Addition and Subtraction (+ -). None of the provided options list the hierarchy correctly (e.g., Exponentiation comes before Multiplication).
210
You can print only an embedded chart by
✅ Correct Answer:Selecting the chart before you print
Explanation: If you have a chart embedded inside a worksheet along with data, but you only want to print the chart itself, simply click on the chart to select it first. When a chart is selected, Excel's print command automatically isolates the chart and prints it on a full page, ignoring the surrounding cells.
211
Gridlines
✅ Correct Answer:a, b and c
Explanation: Excel gives you full control over Gridlines (the faint lines that separate cells). You can configure them independently for viewing and printing. For example, you can keep them visible on your screen while working (View tab) but turn them off for the printed paper (Page Layout tab), or vice versa. Therefore, all options describe valid settings.
212
What does the VLOOKUP function do?
✅ Correct Answer:Finds related records
Explanation: VLOOKUP stands for 'Vertical Lookup'. It searches for a specific value in the first column of a table array and returns a value in the same row from a specified column. It is primarily used to find related records, such as looking up a Student ID to find their Name or Marks.
213
How are data organized in a spreadsheet?
✅ Correct Answer:Rows and columns
Explanation: The fundamental structure of any spreadsheet (including Excel) is a grid system. Data is organized into horizontal 'Rows' (identified by numbers 1, 2, 3...) and vertical 'Columns' (identified by letters A, B, C...). The intersection of a row and a column creates a 'Cell', which holds the data.
214
Which types of charts can excel produce?
✅ Correct Answer:Bar charts, line graphs and pie charts
Explanation: Excel is a powerful visualization tool capable of producing a wide variety of charts. While options A, B, and D restrict the list to just one or two types, option C is the most inclusive correct answer. Excel supports Column, Bar, Line, Pie, Area, Scatter, and many other chart types.
215
Each excel file is called a workbook because
✅ Correct Answer:It can contain many sheets including worksheets and chart sheets
Explanation: An Excel file is technically referred to as a 'Workbook'. The analogy is that just as a physical book contains many pages, an Excel Workbook can contain multiple 'sheets'. These sheets can be standard Worksheets (grids for data) or Chart Sheets (dedicated full-page charts), keeping related work together in one file.
216
You can open the consolidate dialog box by choosing Consolidate from the ______ menu.
✅ Correct Answer:Data
Explanation: The 'Consolidate' feature combines values from multiple ranges into one new range. This command is categorized as a data management tool. Therefore, in both old and new versions of Excel, you will find the 'Consolidate' button under the 'Data' menu (or Data tab on the Ribbon).
217
Macros are 'run' or executed from the ______ menu.
✅ Correct Answer:Tools
Explanation: In older versions of Excel (like Excel 2003), the option to record, run, or edit Macros was located under the 'Tools' menu (Tools > Macro > Macros). In modern versions of Excel (2007 and later), this functionality has been moved to the 'View' tab (Macros button) and the dedicated 'Developer' tab.
218
Except for the ______ function, a formula with a logical function shows the word 'TRUE' or 'FALSE' as a result
✅ Correct Answer:IF
Explanation: Standard logical functions like AND, OR, and NOT purely evaluate conditions and return a boolean result: either TRUE or FALSE. The IF function is unique because it allows you to specify exactly what to display (e.g., 'Pass', 'Fail', numbers, or other text) instead of just the standard Boolean True/False.
219
When you insert an Excel file into a Word document, the data are
✅ Correct Answer:Linked
Explanation: When you insert an Excel file into Word (using Insert Object), you often have the choice to 'Link' to the file. If the data is 'Linked', any changes made to the original Excel file will automatically update in the Word document. If it were merely 'Embedded', the Word doc would store a static copy that doesn't update with the original file.
220
What function displays row data in a column or column data in a row?
✅ Correct Answer:Transpose
Explanation: The TRANSPOSE function is used to rotate the orientation of a data range or array. It converts a vertical range of cells (column) to a horizontal range (row), or vice versa. For example, if you copy a column of names and use 'Paste Special > Transpose', they will be pasted across a row.