Bcms Class Mid-term Exam Review Part I
-
In MS Excel, each formula starts with
-
@
-
#
-
=
-
+
-
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.
(104).webp "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. ToolsExplanation
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*C7Explanation
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 cellExplanation
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. CurrencyExplanation
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 rowExplanation
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 PreviewExplanation
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. AutoFillExplanation
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. ViewExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 06, 2010Quiz Created by
Teacherv
Back to top