Microsoft Excel - Quiz 1 Com254
Quiz 1 for the Microsoft Excel Go! Series
Questions and Answers
- 1.
A new ______________ opens when you start the Excel program.
- A.
Workbook
- B.
Document
- C.
Database
- D.
Presentation
Correct Answer
A. WorkbookExplanation
When you start the Excel program, a new workbook opens. A workbook in Excel is a file that contains one or more worksheets where you can enter, calculate, and analyze data. It is the primary document in Excel where you can organize and manipulate your data. Therefore, the correct answer is "workbook".Rate this question:
-
- 2.
A worksheet is also called a ___________________________.
- A.
Document
- B.
Spreadsheet
- C.
Database
- D.
Form
Correct Answer
B. SpreadsheetExplanation
A worksheet is also called a spreadsheet because it is a type of document that is used for organizing and analyzing data in a tabular format. Spreadsheets are commonly used in various fields such as finance, accounting, and data management, allowing users to perform calculations, create charts, and manipulate data easily.Rate this question:
-
- 3.
A pattern of uniformly spaced horizontal and vertical lines that are present when you open an Excel file are called _________________.
- A.
Cells
- B.
Ranges
- C.
Gridlines
- D.
Rows
Correct Answer
C. GridlinesExplanation
When you open an Excel file, you can see a pattern of uniformly spaced horizontal and vertical lines that form a grid-like structure. These lines are called gridlines. They help in visually organizing and aligning the data in the cells of the spreadsheet, making it easier to read and work with the information.Rate this question:
-
- 4.
The intersection of a column and a row is called a(n) ______________.
- A.
Cell
- B.
Range
- C.
Address
- D.
Value
Correct Answer
A. CellExplanation
A cell is the intersection of a column and a row in a spreadsheet or table. It is where data can be entered, edited, or displayed. Cells are the basic units of a spreadsheet and are used to organize and store information. They can contain text, numbers, formulas, or functions.Rate this question:
-
- 5.
The cell that is ready to accept data or be affected by the next Excel command is called the _____________ cell.
- A.
Open
- B.
Active
- C.
Empty
- D.
Available
Correct Answer
B. ActiveExplanation
The cell that is ready to accept data or be affected by the next Excel command is called the "active" cell. This means that it is currently selected and any input or action will be applied to this cell.Rate this question:
-
- 6.
_____________________ consist of numbers, text, dates, or times of the day.
- A.
Cells
- B.
Formulas
- C.
Data
- D.
Functions
Correct Answer
C. DataExplanation
Data refers to the information that is stored in a spreadsheet. It can include numbers, text, dates, or times of the day. In a spreadsheet, data is typically organized into cells, which are the basic units of a spreadsheet. Cells can contain different types of data, such as numerical values, text strings, or dates. Data is essential for performing calculations, creating formulas, and analyzing information in a spreadsheet. Therefore, the correct answer is "Data."Rate this question:
-
- 7.
A(n) _____________ cell is a single cell created by combining two or more selected cells.
- A.
Combined
- B.
Merged
- C.
Active
- D.
Aligned
Correct Answer
B. MergedExplanation
A merged cell is a single cell created by combining two or more selected cells. When cells are merged, their contents are combined into one cell, and the resulting cell takes up the space of all the merged cells. This is useful for creating a larger cell that spans multiple columns or rows, allowing for better organization and presentation of data.Rate this question:
-
- 8.
_____________________ are text, page numbers, and graphics that display and print at the bottom of every page.
- A.
Footers
- B.
Titles
- C.
Headers
- D.
Elements
Correct Answer
A. FootersExplanation
Footers are the elements that display and print at the bottom of every page. They typically contain text, page numbers, and graphics that provide additional information or navigation options. Unlike headers, which appear at the top of each page, footers are located at the bottom. They are commonly used in documents, presentations, and websites to provide consistency and enhance the overall design and usability.Rate this question:
-
- 9.
Use the _________ Text command to display long cell entries on more than one line within a cell.
- A.
Format
- B.
Wrap
- C.
Justify
- D.
Align
Correct Answer
B. WrapExplanation
The Wrap Text command is used to display long cell entries on more than one line within a cell. This command automatically adjusts the height of the cell to accommodate the text, allowing it to be displayed in a more readable format. By selecting the Wrap Text option, the text will wrap within the cell, preventing it from overflowing into adjacent cells. This is particularly useful when dealing with lengthy text entries or when formatting cells for reports or presentations.Rate this question:
-
- 10.
Reverse an action or a series of actions by using the _________ command.
- A.
Undo
- B.
Redo
- C.
Overtype
- D.
Reverse
Correct Answer
A. UndoExplanation
The correct answer is "undo". The undo command is used to reverse an action or a series of actions. It allows the user to revert back to a previous state before the action was performed, effectively undoing any changes made. This command is commonly found in software applications and is a useful tool for correcting mistakes or trying different options without permanently affecting the data.Rate this question:
-
- 11.
Sheet tabs identify each __________ in a workbook.
- A.
Worksheet
- B.
File
- C.
Document
- D.
Location
Correct Answer
A. WorksheetExplanation
Sheet tabs are used to identify each worksheet in a workbook. A workbook is a collection of multiple worksheets, and each worksheet represents a separate page or tab within the workbook. Therefore, the correct answer is worksheet.Rate this question:
-
- 12.
When more than one worksheet of a workbook is selected they are:
- A.
Combined
- B.
Grouped
- C.
Totaled
- D.
Fixed
Correct Answer
B. GroupedExplanation
When more than one worksheet of a workbook is selected, they are grouped. Grouping worksheets allows for easier management and manipulation of data across multiple sheets. It allows users to perform actions such as formatting, inserting or deleting rows/columns, and applying formulas to multiple sheets at once. Grouping also enables users to view and navigate through the selected sheets simultaneously, making it convenient for data analysis and comparison.Rate this question:
-
- 13.
The __________ worksheet is where text and data will be entered.
- A.
Live
- B.
Open
- C.
Active
- D.
First
Correct Answer
C. ActiveExplanation
The active worksheet is where text and data will be entered. This means that the user can input information directly into this worksheet. The other options, such as live, open, and first, do not specifically indicate that text and data can be entered into them. Therefore, the active worksheet is the correct choice.Rate this question:
-
- 14.
__________ enables you to extend a series of values into adjacent cells based on the value of other cells.
- A.
Auto Type
- B.
Auto Fill
- C.
Copying
- D.
Formatting
Correct Answer
B. Auto FillExplanation
Auto Fill enables you to extend a series of values into adjacent cells based on the value of other cells. It automatically detects the pattern in the selected cells and fills the adjacent cells with the corresponding values. This feature is useful when you have a series of data that follows a specific pattern and you want to quickly populate the remaining cells without manually typing each value.Rate this question:
-
- 15.
What is a temporary area maintained by the Windows operating system that stores data?
- A.
Recycle Bin
- B.
Clipboard
- C.
Storage
- D.
Drive
Correct Answer
B. ClipboardExplanation
The clipboard is a temporary area maintained by the Windows operating system that stores data. It allows users to cut, copy, and paste text, images, and other types of data between different applications or within the same application. The data stored in the clipboard remains there until it is replaced by new data or until the computer is restarted. This feature provides a convenient way for users to transfer information and enhances productivity by allowing the reuse of data across different tasks and applications.Rate this question:
-
- 16.
The __________ command inserts the most recent data stored in the Clipboard to a new cell or range of cells.
- A.
Move
- B.
Copy
- C.
Paste
- D.
Insert
Correct Answer
C. PasteExplanation
The "paste" command is used to insert the most recent data stored in the Clipboard to a new cell or range of cells. It allows you to transfer data from one location to another within a spreadsheet or document. This command is commonly used when you want to duplicate or move data without retyping it.Rate this question:
-
- 17.
The __________ range is the range of cells into which copied data is placed.
- A.
Destination
- B.
Source
- C.
Data
- D.
Adjacent
Correct Answer
A. DestinationExplanation
The destination range refers to the range of cells where the copied data is placed. It is the location or target where the data is being copied to.Rate this question:
-
- 18.
Grouped __________ enable you to format the same range of cells in all worksheets of the group simultaneously.
- A.
Ranges
- B.
Workbooks
- C.
Cells
- D.
Worksheets
Correct Answer
D. WorksheetsExplanation
Grouped worksheets enable you to format the same range of cells in all worksheets of the group simultaneously. By grouping the worksheets, any changes made to the formatting of a specific range of cells will be applied to all the worksheets within the group. This saves time and effort as you don't have to manually format each worksheet individually.Rate this question:
-
- 19.
__________ cell references refer to their fixed position in the worksheet and do not change when the formula is copied.
- A.
Relative
- B.
Absolute
- C.
Workbook
- D.
Worksheet
Correct Answer
B. AbsoluteExplanation
Absolute cell references refer to their fixed position in the worksheet and do not change when the formula is copied. Unlike relative cell references, which adjust their position based on the location of the formula, absolute cell references remain constant. This is useful when you want to refer to a specific cell or range of cells in a formula and ensure that it does not change when the formula is copied to other cells.Rate this question:
-
- 20.
The Find and Replace feature searches the __________ in a worksheet – or in a selected range – for matches and then replaces each match with a replacement of your choice.
- A.
Columns
- B.
Rows
- C.
Cells
- D.
Selections
Correct Answer
C. CellsExplanation
The Find and Replace feature in a worksheet allows users to search for matches and replace them with a chosen replacement. In this context, the feature searches for matches within the cells of the worksheet or a selected range. It does not search within columns, rows, or selections specifically, but rather within the individual cells of the worksheet.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 24, 2009Quiz Created by
Tfishermba