MS Excel Fundamentals Quiz! Trivia
(123).jpg "MS Excel Fundamentals Quiz! Trivia - Quiz")
M. S. Excel is an essential application by Microsoft that enables one to present different data types with ease. Do you know how to enter formulas into the system or use the various tools? Can you change cells into rows? This quiz is an excellent place to test out your skills, do give it a shot and see how well you will do!
Questions and Answers
- 1.
These are rows and columns of data.
- A.
Cells
- B.
Microsoft Excel
- C.
Spreadsheet
- D.
Workbook
Correct Answer
C. SpreadsheetExplanation
The given answer "Spreadsheet" is correct because a spreadsheet is a file made up of rows and columns that can be used to organize and analyze data. It is a common feature in programs like Microsoft Excel, where users can input data into individual cells and perform calculations and data manipulation using formulas and functions. A spreadsheet can be considered as a digital grid that allows for easy organization, manipulation, and analysis of data.Rate this question:
-
- 2.
These are documents or files created from Microsoft Excel.
- A.
Data
- B.
Spreadsheets
- C.
Workbooks
- D.
Worksheets
Correct Answer
C. WorkbooksExplanation
Workbooks are the correct answer because they are documents or files created from Microsoft Excel. A workbook in Excel is a file that contains multiple worksheets, where each worksheet is a separate tab within the workbook. Workbooks are used to organize and store data in a structured manner, allowing users to perform calculations, create charts, and analyze data.Rate this question:
-
- 3.
It is the cell reference that displays the address of an active cell.
- A.
Formula bar
- B.
Name box
- C.
Range
- D.
Worksheet tab
Correct Answer
B. Name boxExplanation
The name box in a spreadsheet displays the address of the active cell. It is located next to the formula bar and allows users to quickly see the current cell reference. This feature is useful when working with large spreadsheets or when navigating between different cells in a worksheet. By displaying the address of the active cell, the name box helps users keep track of their location and easily edit or manipulate data in the spreadsheet.Rate this question:
-
- 4.
It is a part of the MS Excel environment that is used to displays the content of the selected cell and it is located to the area near the top of the worksheet.
- A.
Formula bar
- B.
Name box
- C.
Status bar
- D.
Worksheet tab
Correct Answer
A. Formula barExplanation
The formula bar in MS Excel is used to display the content of the selected cell. It is located near the top of the worksheet and allows users to view and edit the formulas or data in the selected cell. This feature is especially useful when working with complex formulas or large amounts of data, as it provides a clear and organized view of the cell's content.Rate this question:
-
- 5.
The command that you should use if you want to duplicate your worksheet data to other parts of the worksheet area.
- A.
Move and paste
- B.
Copy and paste
- C.
Cut and paste
- D.
Cut and copy
Correct Answer
B. Copy and pasteExplanation
To duplicate worksheet data to other parts of the worksheet area, you should use the "copy and paste" command. This command allows you to make an exact copy of the selected data and then paste it in another location within the worksheet. This is useful when you want to replicate data or create backups of important information without having to manually re-enter it.Rate this question:
-
- 6.
The intersection of rows and columns of spreadsheet.
- A.
Range of cells
- B.
Cell
- C.
Cell address
- D.
Merge cells
Correct Answer
B. CellExplanation
A cell is the intersection of rows and columns in a spreadsheet. It is the basic unit of a spreadsheet where data can be entered, edited, and stored. Each cell has a unique cell address, which is a combination of the column letter and row number. Cells can also be merged together to create a larger cell that spans multiple columns or rows.Rate this question:
-
- 7.
The spreadsheet command that you should use to add one or more blank rows or columns in an already constructed worksheet.
- A.
Copy
- B.
Delete
- C.
Insert
- D.
Move
Correct Answer
C. InsertExplanation
To add one or more blank rows or columns in an already constructed worksheet, the appropriate spreadsheet command to use is "Insert." This command allows the user to insert new rows or columns at a specific location within the worksheet, pushing the existing content down or to the right. By selecting the desired location and using the "Insert" command, the user can create empty spaces for additional data or formatting purposes without deleting any existing information.Rate this question:
-
- 8.
The symbol that you need to use before you type the formula in a cell.
- A.
+ (plus sign)
- B.
= (equal sign)
- C.
– (minus sign)
- D.
/ (slash)
Correct Answer
B. = (equal sign)Explanation
Before typing a formula in a cell, you need to use the equal sign (=) symbol. This is because the equal sign is the operator that tells the spreadsheet software that you are entering a formula and not just a regular text or number. By using the equal sign, you are instructing the software to calculate the result based on the formula you provide.Rate this question:
-
- 9.
####### in the cell it means that
- A.
Your formula has a syntax error
- B.
The column is too narrow to show all the digits of the number
- C.
The row is too short to show the number at the current font size
- D.
Either b or c
Correct Answer
B. The column is too narrow to show all the digits of the numberExplanation
The correct answer is that the column is too narrow to show all the digits of the number. This is indicated by the "#" symbol in the cell. It means that the cell is not wide enough to display the entire number, so it is showing a shortened version with the "#" symbol at the end.Rate this question:
-
- 10.
The part of MS Excel environment that is used to display the name of the program and the name of the workbook you are currently working on.
- A.
Name box
- B.
Ribbon
- C.
Status bar
- D.
Title bar
Correct Answer
D. Title barExplanation
The title bar in MS Excel displays the name of the program and the name of the workbook you are currently working on. It is located at the top of the Excel window. The title bar helps you easily identify the program you are using and the specific workbook you are working on, especially when you have multiple workbooks open at the same time.Rate this question:
-
- 11.
Keystroke is used in saving a worksheet.
- A.
ALT + S
- B.
CTRL + S
- C.
Shift + A
- D.
Shift + S
Correct Answer
B. CTRL + SExplanation
The correct answer is CTRL + S. This key combination is commonly used to save a worksheet in various software applications, including spreadsheet programs like Microsoft Excel. Pressing CTRL + S simultaneously triggers the "Save" command, allowing users to save their work and prevent any potential loss of data.Rate this question:
-
- 12.
Data type which contains any combination of letters, numbers, and special characters that are not used in the calculation.
- A.
Date/Time
- B.
Formula
- C.
Label
- D.
Values
Correct Answer
C. LabelExplanation
A label is a data type that contains any combination of letters, numbers, and special characters that are not used in the calculation. Unlike other data types such as date/time or formula which have specific formats and functions, a label is simply used to provide descriptive text or identifiers for data. It is commonly used to categorize or name data in a way that is easily understandable to users.Rate this question:
-
- 13.
These data entries are numbers that are can be used in calculation.
- A.
Date/Time
- B.
Formula
- C.
Label
- D.
Values
Correct Answer
D. Values -
- 14.
Which of the following buttons are you going to select to stretch Cell C1 so it covers 10 cells?
- A.
![MS Excel Fundamentals Quiz! Trivia - Quiz]()
- B.
![MS Excel Fundamentals Quiz! Trivia - Quiz]()
- C.
![MS Excel Fundamentals Quiz! Trivia - Quiz]()
- D.
![MS Excel Fundamentals Quiz! Trivia - Quiz]()
Correct Answer
D.Explanation
To stretch Cell C1 to cover 10 cells, you would select the merge and center button. This button combines selected cells into a single cell and centers the content horizontally. By selecting the merge and center button, Cell C1 will expand to cover the desired 10 cells.Rate this question:
-
- 15.
Text controls that are used to format the horizontal and vertical alignments of data within a cell.
- A.
Merge Cells
- B.
Text Alignment
- C.
Shrink to Fit
- D.
Wrap Text
Correct Answer
B. Text AlignmentExplanation
Text alignment refers to the positioning of text within a cell. This can be adjusted to align the text horizontally (left, center, right) or vertically (top, middle, bottom) within the cell. By using text alignment controls, users can ensure that the data within a cell is displayed in a visually appealing and organized manner.Rate this question:
-
- 16.
These are spreadsheet pages with in a workbook.
- A.
Cells
- B.
Tables
- C.
Tabs
- D.
Worksheets
Correct Answer
D. WorksheetsExplanation
Worksheets are spreadsheet pages within a workbook. They allow users to organize and analyze data in separate pages. Each worksheet can contain cells, tables, and tabs to further structure and manipulate data. Therefore, worksheets are the correct answer as they best describe the spreadsheet pages within a workbook.Rate this question:
-
- 17.
It is a small black square in the lower-right corner of the cell that you need to drag across in order to automatically copy the cell content in adjacent rows or columns.
- A.
Auto-fill Options
- B.
Border
- C.
Cursor
- D.
Fill handle
Correct Answer
D. Fill handleExplanation
The fill handle is a small black square in the lower-right corner of a cell that allows you to automatically copy the cell content in adjacent rows or columns. By dragging the fill handle, you can quickly populate a series or copy the content of a cell to multiple cells.Rate this question:
-
- 18.
Column Headers is to letters as Row Headers is to:
- A.
Formulas
- B.
Numbers
- C.
Cell adresses
- D.
Symbols
Correct Answer
B. NumbersExplanation
In a spreadsheet, column headers are used to label each column with letters (such as A, B, C), while row headers label each row with numbers (such as 1, 2, 3). Therefore, the correct answer is "numbers".Rate this question:
-
- 19.
button represents
- A.
Auto-fill button
- B.
Alphanumeric button
- C.
Sort ascending button
- D.
Sort descending button
Correct Answer
D. Sort descending buttonExplanation
The given correct answer, "Sort descending button," suggests that the button represents a function to arrange data or elements in a descending order. This button is likely to be used in applications or software where users need to organize or sort information in a specific manner. By clicking this button, the data will be rearranged in a descending order, with the highest values or most recent items appearing first.Rate this question:
-
- 20.
It is a part of the MS Excel environment that shows the number of worksheets in a workbook.
- A.
Formula bar
- B.
Name box
- C.
Status bar
- D.
Worksheet tab
Correct Answer
D. Worksheet tabExplanation
The worksheet tab is a part of the MS Excel environment that shows the number of worksheets in a workbook. It is located at the bottom of the Excel window and displays the names of each worksheet. By clicking on the worksheet tab, users can navigate between different worksheets within the workbook. This feature helps in organizing and managing data across multiple sheets within a single Excel file.Rate this question:
-
- 21.
It is the process of placing and organizing records or data in a specified order.
- A.
Auto-fill
- B.
Creating Chart
- C.
Formatting
- D.
Sorting
Correct Answer
D. SortingExplanation
Sorting is the correct answer because it involves arranging records or data in a specific order. This process helps in organizing information in a structured manner, making it easier to search, analyze, and retrieve data. Sorting can be done in ascending or descending order based on certain criteria, such as alphabetical order, numerical value, or date. By arranging data systematically, sorting enhances efficiency and accessibility in data management and analysis.Rate this question:
-
- 22.
It is the most appropriate formula you can put in the B2 cell to calculate a 7% tax
- A.
=A2*0.07
- B.
=A2*0.7%
- C.
=A2*0.7
- D.
=A2+(A2*0.07)
Correct Answer
A. =A2*0.07Explanation
The correct answer is =A2*0.07. This formula multiplies the value in cell A2 by 0.07, which represents a 7% tax rate. Multiplying by 0.07 calculates the tax amount as a percentage of the value in cell A2.Rate this question:
-
- 23.
button means:
- A.
Align the text on the borders of the page.
- B.
Extend the content on the entire length of the cell.
- C.
Group together the selected cells and align center the content.
- D.
None of the above
Correct Answer
C. Group together the selected cells and align center the content.Explanation
The correct answer is "Group together the selected cells and align center the content." This means that when you click the button, it will combine or group the selected cells together and align the content in the center of those cells. This can be useful for organizing and visually grouping related information within a table or spreadsheet.Rate this question:
-
- 24.
Keys that are used to select multiple ranges of adjacent cells.
- A.
ALT
- B.
CTRL
- C.
SHIFT
- D.
TAB
Correct Answer
C. SHIFTExplanation
SHIFT is the correct answer because it is a key that is commonly used in combination with other keys to select multiple ranges of adjacent cells. When SHIFT is held down and combined with arrow keys or the mouse, it allows for the selection of a range of cells. This is a useful feature when working with large amounts of data or when needing to perform actions on multiple cells simultaneously.Rate this question:
-
- 25.
What will happen to the value of a cell that contains a number if you drag its fill-handle downward and you select the fill-series option of auto-fill?
- A.
Nothing will happen
- B.
The value will decline into cells that are dragged across.
- C.
The value will be copied into cells that are dragged across.
- D.
The value will increment into cells that are dragged across.
Correct Answer
D. The value will increment into cells that are dragged across.Explanation
When you drag the fill-handle downward and select the fill-series option of auto-fill, the value of the cell that contains a number will increment into the cells that are dragged across. This means that the value will increase by a fixed amount in each subsequent cell as you drag it down.Rate this question:
-
.png)
.png)
.png)
.png)
.png "button represents")
.png "It is the most appropriate formula you can put in the B2 cell to calculate a 7% tax")
.png "button means:")
Back to top