OCP A - Computer Applications 1 - Excel 2007

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Sloanca
S
Sloanca
Community Contributor
Quizzes Created: 18 | Total Attempts: 11,018
| Attempts: 82
SettingsSettings
Please wait...
  • 1/49 Questions

    Bold, italic, and underlining can add emphasis to the contents of a cell. These features are referred to as font _______.

    • Orientation
    • Operands
    • Styles
    • Fill
Please wait...
About This Quiz


Directions: Please read and answer each question. This 49-question test is timed, allowing you a total of 55 minutes to complete this portion of the test. When done, print your certificate, give it to your instructor, and request the project(s) portion of this test (if not already completed). Good luck!

OCP A - Computer Applications 1 - Excel 2007 - Quiz

Quiz Preview

  • 2. 

    At times, you might need to remove, or clear, all formatting applied to a cell or range of cells.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    At times, it may be necessary to remove or clear all formatting applied to a cell or range of cells. This could be because the formatting is no longer needed or because it is interfering with the desired presentation of the data. By selecting the cell or range of cells and choosing to clear formatting, all formatting such as font styles, colors, borders, and number formats will be removed, leaving the cell or range with the default formatting. Therefore, the statement "True" is correct.

    Rate this question:

  • 3. 

    You can magnify or reduce the view of a worksheet with the _______ controls on the status bar.

    • Fill

    • Manual

    • Zoom

    • Splitting

    Correct Answer
    A. Zoom
    Explanation
    The correct answer is "zoom." On the status bar of a worksheet, there are controls that allow you to magnify or reduce the view of the worksheet. These controls are called "zoom" controls. By using the zoom controls, you can adjust the size of the worksheet to make it easier to read or fit more information on the screen.

    Rate this question:

  • 4. 

    A ____ is text that prints in the bottom margin of each page.

    • Header

    • Footer

    • Margin

    • Marker

    Correct Answer
    A. Footer
    Explanation
    A footer is text that prints in the bottom margin of each page. It typically contains information such as page numbers, copyright notices, and other relevant details that are consistent throughout the document. The footer is positioned at the bottom of the page and is repeated on every page to provide continuity and reference for the reader.

    Rate this question:

  • 5. 

    Numbers that extend beyond a cell's width appear as ____ in a cell.

    • &&&&

    • ????

    • ####

    • ++++

    Correct Answer
    A. ####
    Explanation
    When numbers extend beyond a cell's width in a spreadsheet, they appear as a series of hash symbols (####). This is because the cell's width is not wide enough to display the entire number, so the spreadsheet software replaces it with hash symbols to indicate that the number is too long to fit in the cell.

    Rate this question:

  • 6. 

    To save space in the worksheet, you can change each cell's text _______ to rotate its data to any angle.

    • Zoom

    • Orientation

    • Relative

    • Manual

    Correct Answer
    A. Orientation
    Explanation
    To save space in the worksheet, you can change each cell's text orientation to rotate its data to any angle. This means that instead of having the text in the cell displayed horizontally, it can be rotated vertically or diagonally, allowing for more efficient use of space in the worksheet. By changing the orientation of the text, the data can still be easily read and understood, while maximizing the available space.

    Rate this question:

  • 7. 

    The default _________ (or background) color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals.

    • Fill

    • Orientation

    • Relative

    • Zoom

    Correct Answer
    A. Fill
    Explanation
    The correct answer is "fill". In Excel, the default background color of cells is white, but you can change this background color using the fill feature. This allows you to highlight or accentuate certain cells, such as descriptive labels or totals, by applying a different background color to them.

    Rate this question:

  • 8. 

    You can close a workbook by clicking the Office Button to display the Office menu and clicking ____.

    • Open

    • Close

    • Exit

    • End

    Correct Answer
    A. Close
    Explanation
    To close a workbook, you can click the Office Button to display the Office menu and then click "Close". This option will close the workbook and remove it from the screen, allowing you to exit the program or open another workbook. The other options listed, such as "Open", "Exit", and "End", are not relevant to the task of closing the workbook.

    Rate this question:

  • 9. 

    The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Office button, the Ribbon, and the status bar.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the Excel program window indeed has the same basic parts as all Office programs. These parts include the title bar, which displays the name of the document; the Quick Access Toolbar, which provides easy access to frequently used commands; the Office button, which is used to access file-related commands; the Ribbon, which contains tabs with various commands and options; and the status bar, which displays information about the current worksheet. Therefore, the statement "The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Office button, the Ribbon, and the status bar" is true.

    Rate this question:

  • 10. 

    To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because there are multiple ways to clear the active cell in Excel. It can be done using the Ribbon, which provides various options to manipulate cells and their contents. Alternatively, the keyboard can be used by pressing the delete key or using specific shortcuts. Lastly, the mouse can also be used by right-clicking on the cell and selecting the "Clear" option. Therefore, the statement is correct.

    Rate this question:

  • 11. 

    The default number format is General, which displays numbers the way you type them.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The default number format in most software applications is General, which means that numbers are displayed exactly as they are typed. This format does not apply any specific formatting rules or styles to the numbers. Therefore, the statement "The default number format is General, which displays numbers the way you type them" is true.

    Rate this question:

  • 12. 

    When you need to edit a worksheet with many formulas, you can specify _____ calculation, which lets you determine when Excel calculates the formulas.

    • Zoom

    • Styles

    • Fill

    • Manual

    Correct Answer
    A. Manual
    Explanation
    When you need to edit a worksheet with many formulas, you can specify manual calculation, which lets you determine when Excel calculates the formulas. This means that Excel will not automatically recalculate the formulas when you make changes to the worksheet. Instead, you have control over when the calculations are performed, allowing you to make multiple edits without waiting for Excel to recalculate after each change. This can be useful when working with large datasets or complex formulas, as it saves time and improves efficiency.

    Rate this question:

  • 13. 

    Each formula begins with a quotation (") mark.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The explanation for the given correct answer is that the statement "Each formula begins with a quotation (") mark" is false. The use of a quotation mark at the beginning of each formula is not a requirement or a standard practice. Formulas can begin with various characters or symbols depending on the programming language or formula syntax being used.

    Rate this question:

  • 14. 

    Formulas can include more than one operator.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because formulas in mathematics or any other field can indeed include more than one operator. Operators such as addition (+), subtraction (-), multiplication (*), and division (/) can be combined within a formula to perform multiple operations in a sequence. For example, the formula "3 + 4 * 2" includes both the addition and multiplication operators.

    Rate this question:

  • 15. 

    Identifies the cell, and is formed by combining the cell's column letter and row number.

    • Workbook

    • Active worksheet

    • Cell reference

    • Worksheet

    • Spreadsheet

    Correct Answer
    A. Cell reference
    Explanation
    A cell reference is a way to identify and locate a specific cell within a worksheet or spreadsheet. It is formed by combining the column letter and row number of the cell. This allows users to easily refer to and manipulate data within a specific cell, making it a useful tool for organizing and analyzing information.

    Rate this question:

  • 16. 

    Worksheet formulas consist of two components: _______ and operators.

    • Relative

    • Styles

    • Operands

    • Fill

    Correct Answer
    A. Operands
    Explanation
    Worksheet formulas consist of two components: operands and operators. The operands are the values or cell references on which the operators perform the calculation. In other words, operands are the numbers, cell references, or functions that are used in a formula to produce a result. The operators, on the other hand, are the symbols or functions that perform the mathematical or logical operations on the operands. Therefore, in order to create a formula in a worksheet, both operands and operators are required.

    Rate this question:

  • 17. 

    The file used to store worksheets.

    • Workbook

    • Active worksheet

    • Cell reference

    • Worksheet

    • Spreadsheet

    Correct Answer
    A. Workbook
    Explanation
    A workbook is the correct answer because it is a file used to store worksheets. In Microsoft Excel, a workbook is a file that contains multiple worksheets, which are used to organize and manipulate data. Each worksheet within the workbook is a separate tab where you can enter and analyze data. Therefore, a workbook is the appropriate term for the file used to store worksheets.

    Rate this question:

  • 18. 

    Excel ______ all numbers.

    • Right-aligns

    • Left-aligns

    • Top-aligns

    • Bottom-aligns

    Correct Answer
    A. Right-aligns
    Explanation
    Excel right-aligns all numbers by default. This means that when you enter a number in a cell, it will be aligned to the right side of the cell. This is the most common and intuitive way to display numbers, as it allows for easy comparison and calculation. Other types of data, such as text or dates, may be left-aligned or centered by default in Excel.

    Rate this question:

  • 19. 

    ________ divides the worksheet window into two or four panes that you can scroll independently.

    • Zoom

    • Splitting

    • Manual

    • Operands

    Correct Answer
    A. Splitting
    Explanation
    Splitting is the correct answer because it refers to the action of dividing the worksheet window into two or four panes. This allows the user to scroll through each pane independently, making it easier to view and work with different sections of the worksheet simultaneously. The other options, such as zoom, manual, and operands, do not pertain to dividing the worksheet window into panes.

    Rate this question:

  • 20. 

    Data can be indented (or ___) within cells to help distinguish categories or set data apart.

    • Shifted to the right

    • Shifted to the left

    • Shifted up

    • Shifted down

    Correct Answer
    A. Shifted to the right
    Explanation
    Indenting data within cells is a common practice to visually separate or categorize information. By shifting the data to the right, it creates a clear distinction between different categories or sets of data within the cell. This indentation helps improve readability and organization, making it easier for the reader to understand and analyze the information presented in the table or spreadsheet.

    Rate this question:

  • 21. 

    You can select a different theme for your workbook. Click the ___ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

    • Page Layout

    • Layout

    • Format

    • Page Format

    Correct Answer
    A. Page Layout
    Explanation
    The correct answer is "Page Layout" because it is the tab on the Ribbon where you can select a different theme for your workbook. The Themes group within the Page Layout tab contains the Themes button, which when clicked, displays a gallery of themes to choose from.

    Rate this question:

  • 22. 

    Unless you specify otherwise, text you enter in a cell is lined up along the upper-right side of the cell.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The given statement is false. By default, when you enter text in a cell, it is lined up along the bottom-left side of the cell. If you want to change the alignment, you can use the alignment options in the formatting toolbar or the cell formatting menu.

    Rate this question:

  • 23. 

    Excel Case 2-2Josh wants to apply a cell style to certain cells in his worksheet. Please answer the question below.Josh wants to get to the Cell Style gallery. How does he navigate to the Cell Style gallery?

    • In the Styles group on the Home tab of the Ribbon, click the Cell styles button.

    • In the Editing group on the Themes tab of the Ribbon, click the Cell Styles button.

    • In the Editing group on the Home tab of the Ribbon, click the Cell Styles button.

    • None of the above

    Correct Answer
    A. In the Styles group on the Home tab of the Ribbon, click the Cell styles button.
    Explanation
    To navigate to the Cell Style gallery in Excel, Josh needs to go to the Home tab of the Ribbon and locate the Styles group. Within the Styles group, he should click on the Cell styles button. This will open the Cell Style gallery where he can choose the desired cell style to apply to certain cells in his worksheet. The other options mentioned in the question are incorrect as they do not accurately describe the correct steps to navigate to the Cell Style gallery.

    Rate this question:

  • 24. 

    The ______ calculation lists how many of the selected cells contain numbers.

    • Operands

    • Numerical count

    • Relative

    • Styles

    Correct Answer
    A. Numerical count
    Explanation
    The term "numerical count" accurately describes the calculation that lists how many of the selected cells contain numbers. This calculation counts the cells that have numerical values and provides a count of those cells. The other options, such as operands, relative, and styles, do not accurately describe this specific calculation.

    Rate this question:

  • 25. 

    The Save As command saves an existing workbook on a disk, using its current name and save location.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The Save As command allows the user to save an existing workbook with a new name or in a different location on the disk. It does not save the workbook with its current name and save location. Therefore, the statement "The Save As command saves an existing workbook on a disk, using its current name and save location" is false.

    Rate this question:

  • 26. 

    To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ___ group, click the arrow next to the Font box to display a gallery of available fonts.

    • Font

    • Edit

    • Styles

    • Data

    Correct Answer
    A. Font
    Explanation
    To change fonts and sizes in a spreadsheet, the cells that need to be modified must be selected. After selecting the desired cells, the Font box can be found in the Font group on the Home tab of the Ribbon. Clicking the arrow next to the Font box will display a gallery of available fonts to choose from.

    Rate this question:

  • 27. 

    To switch to manual calculation, click the ____ button in the Calculation group on the Formula tab, and then click Manual.

    • Calculation Options

    • Calculation Manual

    • Automatic Calculation

    • Formulas

    Correct Answer
    A. Calculation Options
    Explanation
    To switch to manual calculation, the user needs to click on the "Calculation Options" button in the Calculation group on the Formula tab, and then select the "Manual" option. This option allows the user to manually calculate the formulas in the spreadsheet instead of automatically recalculating them whenever changes are made.

    Rate this question:

  • 28. 

    A ______ cell reference adjusts to its new location when copied or moved.

    • Relative

    • Manual

    • Fill

    • Numerical count

    Correct Answer
    A. Relative
    Explanation
    A relative cell reference adjusts to its new location when copied or moved. This means that if a formula or function contains a relative cell reference, the reference will change based on its new position. For example, if a formula in cell B2 references cell A1 (=A1), when the formula is copied to cell B3, the reference will automatically adjust to cell A2 (=A2). This allows for easy replication of formulas across multiple cells without having to manually update each reference.

    Rate this question:

  • 29. 

    A relative cell reference adjusts to its new location when copied or moved. For example, when the formula =A3+A4 is copied from cell A5 to cell B5, the formula changes to ____.

    • =B3+B4

    • =B4+B5

    • =$B3+$B4

    • =B$4+B$5

    Correct Answer
    A. =B3+B4
    Explanation
    A relative cell reference adjusts to its new location when copied or moved. In this case, the formula =A3+A4 is initially in cell A5. When it is copied to cell B5, the formula adjusts to match the new location. Therefore, the correct answer is =B3+B4.

    Rate this question:

  • 30. 

    The worksheet that is displayed in the work area.

    • Workbook

    • Active worksheet

    • Cell reference

    • Worksheet

    • Spreadsheet

    Correct Answer
    A. Active worksheet
    Explanation
    The active worksheet refers to the worksheet that is currently being displayed in the work area. It is the sheet where you can enter and manipulate data. The other options, such as workbook, cell reference, and spreadsheet, are related to different aspects of Excel but do not specifically refer to the currently displayed worksheet. Therefore, the correct answer is the active worksheet.

    Rate this question:

  • 31. 

    In Excel, a computerized spreadsheet is called a ____.

    • Worksheet

    • Table

    • Workbook

    • File

    Correct Answer
    A. Worksheet
    Explanation
    A computerized spreadsheet in Excel is referred to as a worksheet. It is a grid of cells organized in rows and columns where data can be entered, calculated, and analyzed. Worksheets are used to perform various tasks such as data organization, calculations, and creating charts or graphs. They are an essential component of Excel and allow users to manipulate and analyze data efficiently.

    Rate this question:

  • 32. 

    To check the spelling in a worksheet, click the Review tab on the Ribbon, and then, in the ___ group, click the Spelling button.

    • Editing

    • Proofing

    • Checking

    • Searching

    Correct Answer
    A. Proofing
    Explanation
    To check the spelling in a worksheet, you need to click on the Review tab on the Ribbon. Once there, you should look for the group that is related to proofreading, as it is the process of checking for errors and mistakes. In this case, the correct group to click on is the "Proofing" group. By clicking on the Spelling button within this group, you will be able to check the spelling in the worksheet.

    Rate this question:

  • 33. 

    A grid of rows and columns in which you enter text, numbers, and the results of calculations.

    • Workbook

    • Active worksheet

    • Cell reference

    • Worksheet

    • Spreadsheet

    Correct Answer
    A. Spreadsheet
    Explanation
    A spreadsheet is a grid of rows and columns where you can input text, numbers, and perform calculations. It is a tool commonly used for organizing and analyzing data.

    Rate this question:

  • 34. 

    To replace cell contents, select the cell, type the new data, and then enter the data by clicking the Enter button on the Forumla Bar or by pressing the ___.

    • Enter key

    • Tab key

    • Either a. or b.

    • Neither a. nor b.

    Correct Answer
    A. Either a. or b.
    Explanation
    To replace cell contents, you can either type the new data and press the Enter key on the keyboard or type the new data and click the Enter button on the Formula Bar. Both options allow you to enter the new data and replace the existing cell contents.

    Rate this question:

  • 35. 

    Click the Ctrl+V keys to ____ the selected cells.

    • Copy

    • Cut

    • Paste

    • Move

    Correct Answer
    A. Paste
    Explanation
    The correct answer is "paste" because when you click the Ctrl+V keys, it is the keyboard shortcut for pasting the content that has been copied or cut from one location to another.

    Rate this question:

  • 36. 

    To use the drag-and-drop method, select the cell or range you want to move or copy. Then, position the pointer on the top border of the selected cells. the pointer changes from a white cross to a ____ arrow. to move the selected cells, drag them to a new location.

    • One-headed

    • Two-headed

    • Three-headed

    • Four-headed

    Correct Answer
    A. Four-headed
    Explanation
    When using the drag-and-drop method to move or copy a selected cell or range, the pointer changes to a four-headed arrow when positioned on the top border of the selected cells. This four-headed arrow indicates that the cells can be moved to a new location by dragging them.

    Rate this question:

  • 37. 
    FIGURE 4-1 Excel Case 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers.  Please refer to the figure above while answering the questions below.Kayden wants to customize which calculations appear on the status bar. What should she do next? - ProProfs

    FIGURE 4-1 Excel Case 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers.  Please refer to the figure above while answering the questions below.Kayden wants to customize which calculations appear on the status bar. What should she do next?

    • Right-click the status bar to open the Customize Status Bar menu

    • Left-click the status bar to open the Customize Calculations menu

    • Click the status bar multiple times to cycle through the different calculations

    • None of the above

    Correct Answer
    A. Right-click the status bar to open the Customize Status Bar menu
    Explanation
    To customize which calculations appear on the status bar, Kayden should right-click the status bar. This action will open the Customize Status Bar menu, where she can select and customize the calculations that she wants to see in the status bar.

    Rate this question:

  • 38. 

    Design view is helpful when you prepare a worksheet for printing.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Design view is not helpful when preparing a worksheet for printing. Design view is primarily used for designing and formatting the layout of a worksheet, such as adjusting column widths, adding headers and footers, and applying formatting styles. However, when it comes to printing, it is more appropriate to use the Print Preview or Page Layout view, which allow you to see exactly how the worksheet will appear when printed, including page breaks, margins, and scaling options. Therefore, the statement that Design view is helpful when preparing a worksheet for printing is false.

    Rate this question:

  • 39. 

    You can change the width of several columns at one time. Select the columns you want to resize. Then use the pointer to click and drag the ___ edge of one of the selected column headings.

    • Top

    • Left

    • Right

    • Bottom

    Correct Answer
    A. Right
    Explanation
    To change the width of several columns at once, you need to select the columns you want to resize. Then, you can use the pointer to click and drag the right edge of one of the selected column headings. By doing this, you can adjust the width of all the selected columns simultaneously.

    Rate this question:

  • 40. 

    The name of each worksheet appears in the ____ at the bottom of the worksheet window.

    • Sheet box

    • Sheet task bar

    • Sheet dialog box

    • Sheet tab

    Correct Answer
    A. Sheet tab
    Explanation
    The name of each worksheet appears in the sheet tab at the bottom of the worksheet window.

    Rate this question:

  • 41. 
    FIGURE 3-1Excel Case 3-1Vanessa is learning how to split a worksheet window. Please answer the question below while referring to the figure above.To resize the panes, what should Vanessa do? - ProProfs

    FIGURE 3-1Excel Case 3-1Vanessa is learning how to split a worksheet window. Please answer the question below while referring to the figure above.To resize the panes, what should Vanessa do?

    • Start over and zoom in prior to splitting the windows

    • Drag the split bar

    • Either a. or b.

    • Neither a. nor b.

    Correct Answer
    A. Drag the split bar
    Explanation
    Vanessa should drag the split bar to resize the panes. This allows her to adjust the size of the panes according to her preference. Starting over and zooming in prior to splitting the windows is not necessary, as resizing the panes can be done directly by dragging the split bar. Therefore, the correct answer is to drag the split bar.

    Rate this question:

  • 42. 

    Three types of cell references are used in formulas that do NOT include ____.

    • Relative

    • Absolute

    • Mixed

    • Relational

    Correct Answer
    A. Relational
  • 43. 

    To change the margins of a worksheet, click the Page Layout tab on the Ribbon, and then, in the ____ group, click the Margins button.

    • Page Layout

    • Layout

    • Format

    • Page Setup

    Correct Answer
    A. Page Setup
    Explanation
    To change the margins of a worksheet, you need to go to the Page Layout tab on the Ribbon. From there, you will find the Margins button in the Page Setup group. Clicking on this button will allow you to adjust the margins of your worksheet.

    Rate this question:

  • 44. 

    A computerized spreadsheet.

    • Workbook

    • Active worksheet

    • Cell reference

    • Worksheet

    • Spreadsheet

    Correct Answer
    A. Worksheet
    Explanation
    A worksheet is a single page or sheet within a computerized spreadsheet that is used for organizing and analyzing data. It is a space where users can input and manipulate data, perform calculations, and create charts or graphs. Worksheets are typically organized into columns and rows, with each intersection of a column and row forming a cell. Users can enter data into these cells and use formulas or functions to perform calculations. Overall, a worksheet is an essential component of a computerized spreadsheet that allows users to organize and analyze data efficiently.

    Rate this question:

  • 45. 

    A ____ border indicates that you can replace the current reference in the formula by clicking another cell or selecting a range.

    • Flashing

    • Colored

    • Flashing colored

    • Double-arrow

    Correct Answer
    A. Flashing colored
    Explanation
    A flashing colored border indicates that you can replace the current reference in the formula by clicking another cell or selecting a range. This border is a visual cue that allows the user to easily identify and change the reference in the formula.

    Rate this question:

  • 46. 

    When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.

    • =$A$3+$A$4

    • =$B$5+$B$6

    • =A3+A4

    • =$B$3+$B$4

    Correct Answer
    A. =$A$3+$A$4
    Explanation
    When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula remains the same as =$A$3+$A$4. The dollar signs in front of the column and row references indicate absolute references, meaning that the formula will always refer to cell A3 and A4 regardless of where it is copied to. Therefore, when the formula is copied to cell B7, it will still refer to cell A3 and A4.

    Rate this question:

  • 47. 

    A format is the design of text.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement "A format is the design of text" is false. A format refers to the arrangement, organization, or structure of text, images, or other elements in a document or file. It includes aspects such as font style, size, color, alignment, spacing, and other visual attributes. While the design of text can be a part of formatting, it does not encompass the entire concept. Formatting involves various elements and attributes that contribute to the overall presentation and appearance of a document or file.

    Rate this question:

  • 48. 
    Figure 1-1Excel Case 1-1Dori is working in a large worksheet and plans to use the Expanded Find and Replace dialog box shown in Figure 1-1 to help her find and replace some updated information. Please refer to the figure above asyou answer the question below.Dori knows that she has entered an incorrect value of 4,231 in one of the cells and wants to find it. She would choose

    Figure 1-1Excel Case 1-1Dori is working in a large worksheet and plans to use the Expanded Find and Replace dialog box shown in Figure 1-1 to help her find and replace some updated information. Please refer to the figure above asyou answer the question below.Dori knows that she has entered an incorrect value of 4,231 in one of the cells and wants to find it. She would choose "cell contents" as her place to search in the ___ search option section.

    • Look in

    • Search

    • Within

    • None of the above

    Correct Answer
    A. Within
    Explanation
    In the Expanded Find and Replace dialog box, Dori wants to find the incorrect value of 4,231 in one of the cells. To do this, she would choose "Within" as her search option in the search option section. This option allows her to search for the incorrect value within the contents of the cells in the worksheet.

    Rate this question:

  • 49. 

    You can change which cells are included in a reference by dragging any corner of the ___ to resize the selected range.

    • Column border

    • Formula bar

    • Colored outline

    • Row border

    Correct Answer
    A. Colored outline
    Explanation
    When you drag any corner of the colored outline, it allows you to resize the selected range in Excel. The colored outline refers to the border that appears around a selected range of cells. By dragging the corner of this outline, you can expand or contract the range of cells included in a reference. This is a common technique used to adjust the range of cells used in formulas or data analysis in Excel.

    Rate this question:

Quiz Review Timeline (Updated): Oct 27, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Oct 27, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 05, 2009
    Quiz Created by
    Sloanca
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.