Bcms Class Mid-term Exam Review Part I

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 Teacherv
T
Teacherv
Community Contributor
Quizzes Created: 5 | Total Attempts: 514
| Attempts: 81
SettingsSettings
Please wait...
  • 1/10 Questions

    In MS Excel, each formula starts with

    • @
    • #
    • =
    • +
Please wait...
About This Quiz

This BCMS Class Mid-Term Exam Review Part I assesses essential skills in MS Word and Excel. It covers functionalities like spell check, row adjustments, money formatting, and inserting visual elements, equipping students with practical office software competencies.

Bcms Class Mid-term Exam Review Part I - Quiz

Quiz Preview

  • 2. 

    In MS Word, which menu is used to start spell check?

    • File

    • View

    • Tools

    • File

    Correct Answer
    A. Tools
    Explanation
    In MS Word, the Tools menu is used to start the spell check. This menu contains various options and features related to editing and proofreading, including the spell check functionality. By selecting the Tools menu, users can access the spell check tool and review and correct any spelling errors in their document.

    Rate this question:

  • 3. 

    In MS Excel, to multiply a number in cell A7 by a number in C7 we use a formula

    • B7=A7*C7

    • A7*C7

    • =A7*C7

    • A7=C7

    Correct Answer
    A. =A7*C7
    Explanation
    To multiply a number in cell A7 by a number in C7 in MS Excel, we use the formula "=A7*C7". This formula multiplies the value in cell A7 with the value in cell C7 and displays the result in cell B7.

    Rate this question:

  • 4. 

    In MS Word, to insert WordArt we go to

    • Vew - Zoom...

    • Tools - Macro...

    • Format - Font...

    • Insert - Picture...

    Correct Answer
    A. Insert - Picture...
    Explanation
    To insert WordArt in MS Word, we need to go to the "Insert" tab and select "Picture". This option allows us to insert various types of images, including WordArt, into our document.

    Rate this question:

  • 5. 

    What is a single field on an MS Excel spreadsheet called?

    • A space

    • A cell

    • A column

    • A number

    Correct Answer
    A. A cell
    Explanation
    A single field on an MS Excel spreadsheet is called a cell. In Excel, a cell is the smallest unit of data storage and can contain various types of information such as text, numbers, formulas, or functions. Cells are organized in rows and columns, allowing users to input and manipulate data efficiently. Cells can be formatted, merged, or referenced in formulas to perform calculations or create relationships between different cells. Overall, a cell is a fundamental component of an Excel spreadsheet that enables users to organize and analyze data effectively.

    Rate this question:

  • 6. 

    In MS Excel, which number format would be used to format money?

    • Percentages

    • General

    • Commas

    • Currency

    Correct Answer
    A. Currency
    Explanation
    The currency number format would be used in MS Excel to format money. This format is specifically designed for displaying monetary values and includes symbols such as the dollar sign ($) or the euro sign (€) depending on the currency being used. It also adds appropriate decimal places and thousand separators to make the values more readable and consistent.

    Rate this question:

  • 7. 

    To change the height of a row in MS Excel, we first

    • Type some text

    • Type some numbers

    • Right click a cell

    • Highlight the row

    Correct Answer
    A. Highlight the row
    Explanation
    To change the height of a row in MS Excel, we need to highlight the row first. This can be done by clicking on any cell within the row and then dragging the cursor to select the entire row. Once the row is highlighted, we can right-click on the selected row and choose the "Row Height" option to change the height of the row.

    Rate this question:

  • 8. 

    In MS Word, to view the document's header we go to

    • Format - Paragraph

    • File - Print Preview

    • Insert - Hyperlink

    • Tools - Option

    Correct Answer
    A. File - Print Preview
    Explanation
    To view the document's header in MS Word, we need to go to "File - Print Preview". This option allows us to see a preview of how the document will look when printed, including the header section. This is useful for checking the placement and formatting of the header before printing the document.

    Rate this question:

  • 9. 

    In MS Excel, to spread a formula along a column, we use

    • AutoSum

    • AutoFill

    • AutoFix

    • AutoSpread

    Correct Answer
    A. AutoFill
    Explanation
    To spread a formula along a column in MS Excel, we use AutoFill. AutoFill allows us to quickly fill a series or pattern of data, including formulas, by dragging the fill handle. This feature is useful when we want to apply the same formula to multiple cells in a column without manually entering it in each cell. AutoSum, AutoFix, and AutoSpread are not relevant options for this action in MS Excel.

    Rate this question:

  • 10. 

    To insert a footer in an MS Word document, got to

    • View

    • File

    • Format

    • Edit

    Correct Answer
    A. View
    Explanation
    To insert a footer in an MS Word document, you need to go to the "View" tab. This tab contains various options for viewing and editing the document, including the option to insert headers and footers. By selecting the "View" tab, you can access the necessary tools to insert a footer into your document.

    Rate this question:

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

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

  • Current Version
  • Oct 13, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 06, 2010
    Quiz Created by
    Teacherv
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.