MS Office Computer Awareness Questions Quiz
.
Questions and Answers
- 1.
What is used to apply several formats in one step?
- A.
Cell styles
- B.
Date
- C.
Cell reference
Correct Answer
A. Cell stylesExplanation
Cell styles are used to apply several formats in one step. Instead of manually applying different formatting options such as font, color, borders, and alignment to each cell individually, cell styles allow users to create a predefined set of formatting options that can be applied to multiple cells at once. This saves time and ensures consistency in the formatting of cells throughout a spreadsheet.Rate this question:
-
- 2.
What is a row of numbers and column letters?
- A.
Gridlines
- B.
Headlines
- C.
HTML
Correct Answer
B. HeadlinesExplanation
A row of numbers and column letters is commonly referred to as "headlines" in the context of a grid or table. This term is used to describe the labels or headings that are typically displayed at the top and left side of a grid, indicating the column names and row numbers respectively. These headlines help to organize and identify the data within the grid, making it easier to navigate and interpret.Rate this question:
-
- 3.
Cancel restores the original contents of the active cell?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When the statement says "Cancel restores the original contents of the active cell", it means that if any changes have been made to the content of the active cell, clicking on the "Cancel" button will revert those changes and restore the cell to its original content. This implies that the "Cancel" function has the ability to undo any modifications made to the active cell, making the statement true.Rate this question:
-
- 4.
__________ is a numeric data that can be used in calculations.
Correct Answer
ValueExplanation
Value is a numeric data that can be used in calculations. It represents a numerical quantity or measurement and can be manipulated mathematically. This can include integers, decimals, or fractions that can be added, subtracted, multiplied, or divided to perform various calculations.Rate this question:
- 5.
What is a spreadsheet?
- 6.
What creates a duplicate of the selected cell(s) contents for pasting
- A.
Center
- B.
Paste
- C.
Copy
Correct Answer
C. CopyExplanation
Copying creates a duplicate of the selected cell(s) contents for pasting. When you copy a cell, the content of the cell is stored in the clipboard, allowing you to paste it into another location. This is useful when you want to replicate the same data in multiple cells or transfer data to another part of the spreadsheet. The copied content remains in the clipboard until it is overwritten by another copy action or cleared manually.Rate this question:
-
- 7.
Cut removes the selcted cell(s) contents.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true. The "Cut" function is used to remove the selected cell(s) contents in various applications or software. When you cut a cell, the contents are removed from the original location and can be pasted into a different location. This is different from copying, where the contents are duplicated and remain in the original location.Rate this question:
-
- 8.
Bold formats the active cell as bold
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because in Microsoft Excel, the bold formatting option can be used to make the text in the active cell appear bold. This can be done by selecting the cell and then clicking on the "Bold" button in the formatting toolbar or by using the keyboard shortcut Ctrl+B.Rate this question:
-
- 9.
_________ is data displayed as a calendar date
Correct Answer
dateExplanation
The term "date" refers to data that is displayed as a calendar date. This can include the day, month, and year in a specific format. It is commonly used to represent specific points in time or to organize events and appointments.Rate this question:
- 10.
What is a descriptive word used to search for clip art.
- A.
Keyword
- B.
Label
- C.
Pointing
Correct Answer
A. KeywordExplanation
A descriptive word is used to search for clip art because it helps to narrow down the search and find specific images that match the desired theme or subject. By using keywords, users can enter specific terms related to the type of clip art they are looking for, such as "animals," "nature," or "sports," which will then generate relevant results. This allows for a more efficient and targeted search process, saving time and helping users find the clip art they need.Rate this question:
-
- 11.
HTML is the file format for documents viewed using a browser.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
HTML (Hypertext Markup Language) is indeed the file format used for creating and structuring documents that can be viewed on a web browser. It is the standard markup language for creating web pages and is responsible for defining the structure and layout of the content within a web page. By using HTML tags, developers can format text, insert images, create links, and add various other elements to enhance the user experience. Therefore, the statement "HTML is the file format for documents viewed using a browser" is correct.Rate this question:
-
- 12.
What is able to add a tousands seprator to a value?
- 13.
------------------- is an excel file
Correct Answer
workbookExplanation
The term "workbook" is commonly used to refer to an excel file. It is a collection of worksheets that allows users to organize and analyze data. Workbooks can contain multiple sheets, charts, formulas, and other data manipulation tools. Therefore, "workbook" is the correct answer to the question.Rate this question:
- 14.
What is a view that displays the worksheet as a printed page?
- A.
Page Layout view
- B.
Name box
- C.
Keyword
Correct Answer
A. Page Layout viewExplanation
Page Layout view is a view in which the worksheet is displayed as it would appear when printed. It shows the page breaks, margins, and other elements of the printed page. This view allows the user to see how the worksheet will look when printed, making it easier to adjust the layout and ensure that everything fits properly on the page.Rate this question:
-
- 15.
active cell is the intersection of a row and column?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The active cell is not necessarily the intersection of a row and column. It refers to the currently selected cell in a spreadsheet or table, which could be anywhere within the grid. Therefore, the given statement is false.Rate this question:
-
- 16.
What creates a new workbook?
- A.
New
- B.
Allign text right
- C.
Copy
Correct Answer
A. NewExplanation
The correct answer is "new". This option refers to the action of creating a new workbook. When selecting this option, a new workbook is generated, providing a blank canvas for the user to input and organize data.Rate this question:
-
- 17.
Italic formats the active cell as italic.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
This statement is true. In Microsoft Excel, the "Italic" formatting option is used to apply italic font style to the active cell. Italic font style is commonly used to emphasize or highlight certain text in a spreadsheet. By selecting the active cell and applying the italic formatting, the text within that cell will be displayed in an italicized font.Rate this question:
-
- 18.
What displays a dialog box with options for tracking changes?
- A.
Header and footer
- B.
Highlight changes
- C.
Hyperlink
Correct Answer
C. Hyperlink -
- 19.
What displays a list of fonts to choose from?
- A.
Bold
- B.
Font
- C.
Cancel
Correct Answer
B. FontExplanation
The term "font" refers to a specific style and design of text. In this context, the answer suggests that a list of fonts would be displayed in order to choose from. This implies that the question is asking about a feature or tool that allows users to select different font options for their text.Rate this question:
-
- 20.
Sheet tab is used to display a worksheet
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because a sheet tab is indeed used to display a worksheet. In spreadsheet software like Microsoft Excel or Google Sheets, each worksheet is represented by a tab at the bottom of the screen. Clicking on a sheet tab allows you to view and work on that particular worksheet. Therefore, the given answer "True" is correct.Rate this question:
-
Back to top