With which of the following do all formulas in Excel start? A. / B. = C. + D. & Explanation: Every formula in Excel must begin with the equals sign (=).
Which of the following Excel features allows users to evaluate values and return a result? A. Formulas B. Formatting C. Filters D. Insertions Explanation: Formulas and functions evaluate data and return results.
The function is ____ which can calculate the value given in a specific order. A. Program B. Predefined formula C. Software D. None of these Explanation: Functions are built-in, predefined formulas in Excel.
What are the items inside the parentheses in an MS Excel formula called? A. Variables B. Parameters C. Arguments D. Conditions Explanation: Values or references inside parentheses are called arguments.
Cell entry “July 16, 2016” will be considered a ____ by Excel sheet. A. Number B. Formula C. Value D. Label Explanation: Excel automatically recognizes and stores dates as numeric values.
Which of the following is not the correct method of editing the cell content? A. F2 B. Double-press the cell C. Click the formula bar D. Pressing the Alt key Explanation: Alt does not activate edit mode for cell content.
Which of the following methods cannot be used to enter data in an MS Excel cell? A. Pressing the Esc key B. Clicking the formula bar C. Pressing an arrow key D. Pressing the Tab key Explanation: Esc cancels editing; the other keys confirm or move after entry.
To edit an embedded Excel worksheet object in a Word document, ____. A. Use the Excel menu bar and toolbars inside the Word application B. Edit the data in an Excel source application C. Use the word menu bar and toolbar D. None Explanation: Double-clicking an embedded object activates Excel’s menus inside Word.
When you link data maintained in an Excel workbook to a Word document, ____. A. The Word document cannot be edited B. The Word document contains a reference to the source document C. The Word document must contain a hyperlink D. The Word document contains a copy of the actual data Explanation: Linking creates a reference to the source Excel file.
You cannot link excel worksheet data to a word document ____. A. With the copy and paste special commands B. With a hyperlink C. With the copy and paste commands on the standard toolbar D. None of these Explanation: All listed methods can be used to link or embed Excel data into Word.