General Knowledge Flashcards
16 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 16 General Knowledge flashcards as text
A ________ is the point where two rows and columns meet.
Answer: cell
In spreadsheet programs like Excel, a cell is the fundamental unit where data is stored. It is precisely defined as the intersection point where a row and a column meet. Each cell has a unique address, such as A1 or B5, derived from its column letter and row number.
The ________refers to a group of cells.
Answer: cell range
In Excel, a cell range refers to a collection of two or more cells. These cells can be adjacent or non-adjacent, and a contiguous range is typically denoted by the addresses of its top-left and bottom-right cells separated by a colon (e.g., A1:B5). This grouping allows for operations, formatting, or formulas to be applied to multiple cells simultaneously.
What is the location of the filling handle?
Answer: In the bottom-right corner of the selected cell
The fill handle in Excel is a small square located in the bottom-right corner of a selected cell or range. It is a powerful tool used to quickly copy data, formulas, or extend a series of data (like numbers, dates, or custom lists) to adjacent cells. Dragging this handle allows for efficient data entry and formula replication.
True or False: An Excel file is called a workbook?
Answer: True
True. In Microsoft Excel, a file is indeed referred to as a workbook. A workbook acts as a container for one or more individual worksheets, which are the grids where data is entered and manipulated. This structure helps organize related data and calculations within a single file.
What is the best way to remove of cell boarders?
Answer: Both of Both A and B
Both methods are effective for removing cell borders in Excel. You can access the Border tool directly from the Home tab's Font group on the Ribbon and select 'No Border' from the dropdown list. Alternatively, you can open the 'Format Cells' dialog box, navigate to the 'Border' tab, and then choose 'None' for the border style, which achieves the same result.
In Excel, where can you change the shading color for a group of cells?
Answer: All of the above
Excel provides multiple ways to change the shading or fill color for a group of cells. The 'Fill Color' tool is readily available on the Home tab (often referred to as the Formatting toolbar). Additionally, the 'Format Cells' dialog box, under the 'Fill' or 'Patterns' tab, offers extensive options for fill effects, including colors and patterns. All these options allow you to customize cell shading.
When all of the numbers in a range between 0 and 100 should be displayed in red, what command would you use?
Answer: Apply Conditional Formatting command on Format menu
Conditional Formatting is the most appropriate and efficient command for automatically applying formatting, such as changing text color to red, based on specific criteria. It allows you to set rules (e.g., 'cell value is between 0 and 100') and define the formatting to apply when those rules are met. This ensures dynamic formatting that updates automatically if cell values change, without manual intervention.
In Excel, you may set the page border.
Answer: You can not set page border in Excel
Unlike word processing software, Excel does not have a direct feature to apply a 'page border' to the entire worksheet or printed page. Borders in Excel are applied to individual cells or ranges of cells. While you can create a visual effect resembling a page border by applying borders to a large range of cells, there isn't a dedicated 'page border' command.
Which of the following statements about Conditional Formatting is not true?
Answer: You can set condition to look for Bold and apply Italics on them
Conditional Formatting in Excel allows you to apply formatting *based on* cell values, formulas, or other logical conditions, not based on existing manual formatting like 'Bold.' You can set conditions to *apply* bold or italics, but you cannot create a rule that *detects* if a cell is already bold and then applies italics. Conditional Formatting rules evaluate content or properties, not manual formatting styles.
Which of the statements below is false?
Answer: The width of a row and be specified manually or fir automatically.
The statement 'The width of a row and be specified manually or fir automatically' is false because rows have a height, not a width. Columns have width, which can be adjusted manually or automatically to fit content. Row height can be adjusted manually or automatically to fit content, but referring to the 'width of a row' is incorrect terminology in Excel.
The formula palette can be used to
Answer: Create and edit formula containing functions
The Formula Palette (or Function Arguments dialog box in modern Excel versions, accessed via the 'Insert Function' button next to the formula bar) is a helpful tool designed to assist users in creating and editing formulas, especially those involving functions. It provides a guided interface to input arguments for functions, making complex formulas easier to construct and debug by showing argument descriptions and results.
How do you activate the previous cell when a range is selected?
Answer: None of the above
When a range of cells is selected, pressing `Tab` moves to the next cell in the selection, and `Shift + Tab` moves to the previous cell in the selection. Pressing `Enter` typically moves to the next cell down in the selection, and `Shift + Enter` moves to the previous cell up. Therefore, none of the provided options (Tab, Enter, Alt Key) alone activate the 'previous cell' in a general sense within a selected range.
Which tool will you use to combine certain cells and position the content in the middle?
Answer: From Format Cell dialog box click on Merge Cell check box
The 'Merge cells' checkbox, located within the 'Alignment' tab of the 'Format Cells' dialog box, is the specific control used to combine multiple selected cells into a single larger cell. This action is the core step for merging. To then position the content in the middle, you would separately apply the 'Center' alignment, which can also be done from the 'Format Cells' dialog or the Home tab.
On the Excel screen, there are tab scroll buttons.
Answer: Towards the button left corner
The tab scroll buttons in Excel are located in the bottom-left corner of the worksheet window, next to the sheet tabs themselves. These small arrow buttons allow users to navigate through multiple sheet tabs when there are too many to fit horizontally across the screen. They are essential for accessing hidden or distant worksheets within a workbook.
On the left of the formula bar, there is a Name box.
Answer: Shows the name of cell or range currently working on
The Name Box, situated to the left of the formula bar in Excel, displays the address of the currently selected cell (e.g., A1). When a range of cells is selected or a named range is active, it shows the address of the first cell in the range or the name of the defined range. It also allows users to quickly navigate to specific cells or ranges by typing their names.
Each Excel file is a workbook with a variety of sheets. Which of the following can't be a workbook sheet?
Answer: Data sheet
An Excel workbook can contain various types of sheets, including 'Worksheets' (for data entry and calculations), 'Chart Sheets' (dedicated sheets for displaying charts), and 'Macro Sheets' (for VBA code, though less common in modern Excel). 'Data sheet' is not a standard, distinct type of sheet within an Excel workbook; data is typically stored within a regular 'Worksheet'.