Trivia 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 Trivia flashcards as text
Click the worksheet tab of the sheet you wish to copy, hold down SHIFT, and then drag the chosen sheet along the row of sheet tabs to copy the complete worksheet and all of its data.
Answer: FALSE
The statement is false because holding down SHIFT while dragging a worksheet tab allows you to select multiple adjacent worksheets, not copy a single one. To copy a worksheet in Excel, you must hold down the CTRL key while dragging the sheet tab. This creates a duplicate of the entire worksheet.
A _______ is the term for the point where a row and a column intersect.
Answer: cell
In Microsoft Excel, a cell is the fundamental building block of a worksheet. It is defined as the unique intersection point where a row and a column meet. Each cell has a unique address, such as A1 or B5, and can contain data, formulas, or functions.
A cell cluster is referred to as a ___.
Answer: cell range
A cell range refers to a group or cluster of contiguous cells in an Excel worksheet. It is typically identified by the addresses of the top-left and bottom-right cells, separated by a colon (e.g., A1:C5). Cell ranges are frequently used when applying formatting, performing calculations, or defining data sets for functions.
What location does the fill handle have?
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 the selected cell or range. It is a powerful tool used to quickly copy data, formulas, or extend a series of data (like numbers or dates) into adjacent cells. When you hover over it, your cursor changes to a thin black cross.
Why does the value in cell G1 in this image appear to be somewhat different from the value in the formula bar?
Answer: It’s using the Currency number format.
The difference between the value displayed in cell G1 and the formula bar indicates that the cell's value is being presented with a specific number format. In this case, the Currency number format is applied, which typically adds a currency symbol (like '$') and formats the number to two decimal places. This makes it appear slightly different from the raw numerical value or formula shown in the formula bar.
To switch between Workbooks, click the tabs at the bottom of a workbook.
Answer: worksheets
To switch between different sheets within the same Excel workbook, you click on the worksheet tabs located at the bottom of the workbook window. Each tab represents a separate worksheet, allowing users to organize and access different sets of data or calculations within a single file. This provides an easy way to navigate through complex workbooks.
Say you are looking for your average grade. What's wrong with the image's formula, exactly?
Answer: It should have an equals sign (=) at the beginning.
In Excel, every formula or function must begin with an equals sign (=). This tells Excel that the cell contains a calculation rather than just text or a number. Without the leading equals sign, Excel would treat the input as a text string instead of executing the function to calculate the average grade.
True or False: By double-clicking the cell that the formula is located in, you can view the formula.
Answer: TRUE
True. Double-clicking on a cell that contains a formula is a quick and common way to view and edit the formula directly within the cell. This action puts the cell into edit mode, displaying the formula rather than its calculated result. It allows users to easily inspect the components and references used in the calculation.
Which of the following is a reference to an absolute cell?
Answer: $A$2
An absolute cell reference in Excel is denoted by dollar signs ($) before both the column letter and the row number, such as $A$2. This type of reference ensures that when a formula is copied or filled to other cells, the reference to cell A2 remains fixed and does not change. This is crucial when you want a formula to always refer back to a specific cell, regardless of its new location.
Which of the following formulas is true? Please check all that apply.
Answer: =R2*D2
A valid Excel formula must begin with an equals sign (=) and correctly reference cells or values using appropriate operators. Option D, `=R2*D2`, is a valid formula because it starts with an equals sign and uses standard cell references (R2 and D2) with a multiplication operator (*). The other options are incorrect because they either lack the initial equals sign or use invalid cell reference formats.
What result would this formula in Excel produce? =(82-32)/5+8*2
Answer: 26
Excel follows the standard order of operations (PEMDAS/BODMAS) to evaluate formulas. First, the operation inside the parentheses (82-32) is calculated, resulting in 50. Next, division (50/5) and multiplication (8*2) are performed, yielding 10 and 16 respectively. Finally, the addition (10+16) is completed, resulting in the final answer of 26.
What tool did we employ in order to swiftly apply the formatting displayed in this picture?
Answer: Conditional formatting
The formatting displayed in the picture, which often involves visual cues like color scales, data bars, or icon sets based on cell values, is achieved using Conditional Formatting. This Excel feature allows you to automatically apply specific formatting to cells that meet certain criteria or conditions. It helps to visually highlight important data, trends, or outliers within a dataset.
What is the primary benefit of choosing Mark as Final?
Answer: It discourages other users from editing the workbook.
Choosing 'Mark as Final' in Excel sets a read-only recommended flag on the workbook, signaling that the author considers it complete and final. While it doesn't strictly prevent editing, it discourages other users from making changes by displaying a warning message upon opening. This feature is primarily a communication tool to indicate the document's intended status.
In this illustration, a _______ is made using the four areas.
Answer: PivotTable
The illustration shows the four distinct areas (Filters, Columns, Rows, and Values) used to organize and summarize data in Excel. These areas are fundamental components of a PivotTable, which is a powerful tool for analyzing and presenting large datasets. By dragging fields into these areas, users can dynamically create customized reports and insights from their data.
Which feature determines the input value that will provide a desired outcome after starting with a desired result?
Answer: Goal seek
Goal Seek is an Excel feature that determines the input value required to achieve a specific desired result (outcome) from a formula. Instead of manually adjusting input values, you tell Excel the target value you want for a formula and which input cell to change. Excel then iteratively calculates the necessary input to reach that goal.
What does an Excel workbook mean?
Answer: a file that stores one or more worksheets
An Excel workbook is the primary file type in Microsoft Excel, serving as a container for your data. It is a single file that can store one or more individual worksheets (also known as spreadsheets). Worksheets are where you input, organize, and analyze your data using cells, rows, and columns.