Excel worksheet cells work very similarly to what common element of the windows graphical user interface
✅ Correct Answer:Text boxes
Explanation: A cell in Excel functions much like a standard 'Text Box' in Windows. You can click into it, type alphanumeric text, edit the content, and format it. Unlike option buttons or list boxes which restrict input to specific choices, a cell (like a text box) allows free-form entry.
102
Which of the following is not a valid data type in Excel?
✅ Correct Answer:Character
Explanation: Excel's core data types include 'Numbers' (values), 'Labels' (text strings), and 'Date/Time' (serial numbers). 'Character' is not a distinct data type in Excel; it is simply considered part of the 'Label' or Text type. This distinction is important in programming languages but less so in spreadsheets.
103
The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?
✅ Correct Answer:Click the Currency Style button on the formatting toolbar
Explanation: Excel makes it easy to format numbers without retyping them. By selecting the cell and clicking the 'Currency Style' button ($) on the toolbar (or Ribbon), Excel automatically adds the currency symbol ($), a thousands separator (comma), and two decimal places to the existing number.
104
The Paste Special command lets you copy and paste:
✅ Correct Answer:The resulting values of a formula instead of the actual formula
Explanation: Paste Special is a powerful feature. Its most common use (Option D) is to copy a formula (e.g., =A1+B1) but paste only the calculated 'Value' (e.g., 100), removing the underlying formula. It can also be used to paste formats, comments, or even perform math like multiplying the pasted data.
105
Which of the following is a correct order of precedence in formula calculation?
✅ Correct Answer:All of above
Explanation: Note: This question contains a discrepancy in the provided options. The standard correct order of operations in Excel is: Parentheses, Reference operators, Negation, Percent, Exponentiation, Multiplication/Division, and finally Addition/Subtraction. None of the options A, B, or C perfectly list this full sequence correctly, but 'All of above' is often marked in legacy answer keys to imply the question is asking about the *existence* of precedence rules.
106
All worksheet formula
✅ Correct Answer:Return a formula result
Explanation: The primary purpose of any formula in Excel (whether it is simple arithmetic like =2+2 or a complex function like =VLOOKUP) is to perform a calculation and 'Return a result'. While they manipulate values, the defining characteristic is that they produce a new output based on inputs.
107
You can enter which types of data into worksheet cells?
✅ Correct Answer:Labels, values, and formulas
Explanation: Excel cells can hold three fundamental types of data: Labels (Text/Strings for headings), Values (Numbers/Dates for calculation), and Formulas (Equations starting with '=' to process those values). These three components make up the core of any spreadsheet.
108
Excel probably considers the cell entry January 1, 2000 to be a
✅ Correct Answer:Value
Explanation: In Excel, Dates and Times are stored as sequential serial numbers, which means they are considered numeric 'Values'. This allows you to perform math on them (like subtracting one date from another). 'January 1, 2000' is recognized as a date value, not a text label.
109
Each excel file is called a workbook because
✅ Correct Answer:It can contain many sheets including worksheets and chart sheets
Explanation: The term 'Workbook' is used because, like a physical book with pages, a single Excel file can hold multiple pages called 'Worksheets' (for data) and 'Chart Sheets' (for graphs). This organization allows related data to be kept together in one file.
110
Which of the following is not information you can specify using the solver?
✅ Correct Answer:Input cells
Explanation: Solver uses three specific parameters: The 'Target Cell' (Objective), 'Changing Cells' (Variables to adjust), and 'Constraints' (Rules to follow). 'Input cells' is not a formal Solver term; the correct term for the cells being modified is 'Changing Variable Cells'.
111
When you insert an excel file into a word document. The data are
✅ Correct Answer:Linked
Explanation: When inserting an Excel file into Word, you typically have the choice to Link or Embed. If the question implies a connection where data updates, 'Linked' is the correct answer. Linking maintains a connection to the source file, whereas Embedding saves a copy inside the Word doc.
112
Which of following is Not one of Excel's what-if function?
✅ Correct Answer:Auto Outline
Explanation: Excel's primary 'What-If Analysis' tools are Goal Seek, Scenario Manager, and Data Tables (plus the Solver add-in). 'Auto Outline' is a formatting tool that groups rows and columns to hide/show detail data; it does not perform calculations or predictive analysis.
113
A circular reference is
✅ Correct Answer:A formula that either directly or indirectly depends on itself
Explanation: A circular reference occurs when a formula refers to its own cell (e.g., cell A1 containing '=A1+10'). This creates an infinite loop where Excel keeps trying to calculate the value forever. Excel usually warns you about this immediately.
114
You can convert existing excel worksheet data an charts to an HTML document by using
✅ Correct Answer:Internet assistant wizard
Explanation: In the mid-90s (Excel 95/97), Microsoft provided an add-in called the 'Internet Assistant Wizard'. It allowed users to convert their spreadsheet data directly into HTML code for publishing on the web. Modern Excel has this built-in via 'Save As > Web Page'.
115
You can use the formula palette to
✅ Correct Answer:Create and edit formulas containing functions
Explanation: The Formula Palette (now called the 'Insert Function' dialog) acts as a wizard. It helps you build formulas by providing boxes for each argument (input) required by the function, ensuring you don't make syntax errors like missing commas or parentheses.
116
Which menu option can be used to split windows into two
✅ Correct Answer:Window > split
Explanation: In older Excel versions, the command to divide your screen into two scrollable panes was found under the 'Window' menu ('Window > Split'). In modern Excel (2007+), this command is located on the 'View' tab of the Ribbon, under the Window group.
117
The autofill feature
✅ Correct Answer:Extends a sequential series of data
Explanation: AutoFill is used to generate sequences. If you type 'Jan' and drag the fill handle, Excel extends it to 'Feb, Mar, Apr...'. It works for days, dates, numbers, and custom lists. It does not sum numbers (that's AutoSum) or apply borders.
118
When you copy a formula
✅ Correct Answer:Excel edits cell references in the newly copied formula
Explanation: This is the magic of 'Relative Referencing'. When you copy a formula like '=A1+B1' one row down, Excel automatically edits the references to become '=A2+B2'. It adjusts the relative positions so the calculation remains logically correct for the new row.
119
Which of the following is the latest version of Excel?
✅ Correct Answer:Excel 2002
Explanation: (Note: This question is from an older bank. Based on the original options provided in such tests, Excel 2002 (XP) was the latest). Today, however, we have Excel 2019, 2021, and Excel 365. Excel 2002 introduced features like the Task Pane and XML support.
120
To copy cell contents using drag and drop press the
✅ Correct Answer:Ctrl key
Explanation: By default, dragging a cell's border moves the data. However, if you hold down the 'Ctrl' key while dragging, the mouse cursor changes to show a small plus (+) sign, indicating that you are 'Copying' the data to the new location instead of moving it.