Take This Interesting Microsoft Excel Quiz
Excel Test
Questions and Answers
- 1.
Microsoft Excel is what type of program?
- A.
A.Database
- B.
B.Email
- C.
C.Spreadsheet
- D.
D.Word processor
Correct Answer
C. C.SpreadsheetExplanation
Microsoft Excel is a spreadsheet program. It is designed to create, manipulate, and analyze data in a tabular format. Excel allows users to perform calculations, create charts and graphs, and organize data efficiently. It is widely used in various industries for tasks such as financial analysis, data management, and budgeting. Therefore, the correct answer is C - Spreadsheet.Rate this question:
-
- 2.
A cell:
- A.
A.is an intersection of a colunand a row
- B.
B.has a unique cell address
- C.
C.Neither A or B
- D.
D.Both A and B
Correct Answer
D. D.Both A and BExplanation
A cell in a spreadsheet is both an intersection of a column and a row, as well as having a unique cell address. This means that each cell can be identified by its column and row coordinates. Therefore, option D is the correct answer as it includes both statements A and B.Rate this question:
-
- 3.
A document was saved to your disk and you want to open it for editing, Which menu do you select?
- A.
A.Edit
- B.
B.File
- C.
C.Open
- D.
D.View
Correct Answer
B. B.FileExplanation
To open a document for editing that has been saved to your disk, you would select the "File" menu. The "File" menu typically contains options related to managing and manipulating files, such as opening, saving, and closing them. Therefore, choosing the "File" menu would provide you with the necessary options to open the document and begin editing it.Rate this question:
-
- 4.
All formulas in Excel begin with the following symbol:
- A.
A.=
- B.
B.+
- C.
C.%
- D.
D.#
Correct Answer
A. A.=Explanation
In Excel, all formulas begin with the symbol "=", which indicates that the following characters are part of a formula rather than regular text. This symbol is used to tell Excel to perform a calculation or function using the specified values or cell references. Therefore, the correct answer is A.= because it is the symbol that signifies the start of a formula in Excel.Rate this question:
-
- 5.
Which formula below will add the value of B2 to the value of C3?
- A.
A.=B2+C3
- B.
B.=C3+B2
- C.
C.=SUM(B2+C3)
- D.
D.All of the above
Correct Answer
D. D.All of the aboveExplanation
The correct answer is D. All of the above. This is because all three options A, B, and C will add the value of B2 to the value of C3. Option A directly adds the two cells, option B switches the order of the cells but still adds them, and option C uses the SUM function to add the two cells. Therefore, all three options will give the same result.Rate this question:
-
- 6.
The Auto Sum function is used to create a formula that includes a range of cells.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The Auto Sum function is indeed used to create a formula that includes a range of cells. This function automatically adds up the values in a selected range of cells and displays the result in the cell where the function is applied. It is a quick and convenient way to calculate the sum of a range of numbers without manually typing out the formula. Therefore, the statement "True" accurately reflects the purpose and functionality of the Auto Sum function.Rate this question:
-
- 7.
A dialog box will appear before you delete a workdheet even if the worksheet does not contain data.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because a dialog box will not appear before deleting a worksheet if the worksheet does not contain any data. The purpose of the dialog box is to confirm the deletion of data, so if there is no data present, there is no need for the dialog box to appear.Rate this question:
-
- 8.
A workbook defaults to three worksheets. Additional worksheets can be created
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A workbook in Microsoft Excel typically starts with three default worksheets. However, users have the option to create additional worksheets as needed. This allows for organizing data and calculations into separate sheets within the same workbook, providing better organization and clarity for complex projects.Rate this question:
-
- 9.
Grouping worksheets allows you to:
- A.
A.apply identical formulas across all the worksheets in a group
- B.
B.apply identical formulas across all the worksheets in a group
- C.
C.make changes to all the worksheets in a group bychanging only one of the worksheets
- D.
D.All of the above
Correct Answer
D. D.All of the aboveExplanation
Grouping worksheets allows you to apply identical formulas across all the worksheets in a group, making it easier to perform calculations and maintain consistency. Additionally, it allows you to make changes to all the worksheets in a group by changing only one of the worksheets, saving time and effort. Therefore, the correct answer is D. All of the above.Rate this question:
-
- 10.
You want to inset a column between column A and column B. Which of the following needs to be done?
- A.
A.All the information in the worksheet needs to be retype
- B.
B.Insert a column by selecting the Columns selection on the Edit menu
- C.
C.Insert a cplumn by selecting the Columns selection on the Insert menu
- D.
D.It cannot be done. A new worksheet needs to be created
Correct Answer
C. C.Insert a cplumn by selecting the Columns selection on the Insert menuExplanation
To insert a column between column A and column B, you need to select the "Columns" option from the "Insert" menu. This will shift all the existing columns to the right, making space for the new column. Option C correctly suggests this method of inserting a column. Option A is incorrect as it states that all the information in the worksheet needs to be retyped, which is unnecessary. Option B is incorrect as it mentions selecting the "Columns" option from the "Edit" menu, which is not the correct menu. Option D is incorrect as it suggests creating a new worksheet, which is not needed in this case.Rate this question:
-
- 11.
The eadiest way to select an entire row is to ______.
- A.
A.Choose the Select option in the Edit menu
- B.
B.Click both the first entry and last entry in the row
- C.
C.Click the row heading
- D.
D.Double-click any cell in the row
Correct Answer
C. C.Click the row headingExplanation
To select an entire row, one can click on the row heading. The row heading is the number or letter label on the left side of the spreadsheet that identifies the row. By clicking on the row heading, the entire row will be selected, allowing for easy manipulation or formatting of the data in that row.Rate this question:
-
- 12.
If a cell shows #####, it means you mush insert a column
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
If a cell shows "#####", it means that the data in the cell is too long to be displayed fully. This is a common occurrence when the cell contains a number or date that is wider than the column width. To fix this, the column width needs to be adjusted to accommodate the data. Therefore, the correct answer is False, as "#####" does not indicate the need to insert a column.Rate this question:
-
- 13.
The merge and center button:
- A.
A.is only available when worksheets are grouped
- B.
B.is used to center vertically only
- C.
C.allows you select one or more cells and merge them into a larger cell
- D.
D.is a button on the Drawing Toolbar
Correct Answer
C. C.allows you select one or more cells and merge them into a larger cellExplanation
The merge and center button allows you to select one or more cells and merge them into a larger cell. This can be useful when you want to combine the contents of multiple cells into one cell or create a header that spans across multiple columns. It is not necessary to have worksheets grouped or to center vertically only in order to use this button. Additionally, it is not located on the Drawing Toolbar, but rather on the main Excel toolbar.Rate this question:
-
- 14.
Which of the following operations cannot be performed in the Alignment tab of the Format Cells dialog box?
- A.
A.Change text orientation
- B.
B,Color a cell background
- C.
C.Merge cells
- D.
D.Wrap text
Correct Answer
B. B,Color a cell backgroundExplanation
In the Alignment tab of the Format Cells dialog box, you can perform operations such as changing text orientation, merging cells, and wrapping text. However, coloring a cell background is not an option in this tab. To change the background color of a cell, you would need to go to the Fill tab in the Format Cells dialog box or use other formatting options available in the spreadsheet software.Rate this question:
-
- 15.
The Source Data is:
- A.
A.the range of cells that make up a chart
- B.
B.the same thing as an axis
- C.
C.Both A and B
- D.
D. Neither A and B
Correct Answer
A. A.the range of cells that make up a chartExplanation
The correct answer is A. The source data refers to the range of cells that are used to create a chart. These cells contain the data that will be plotted on the chart. The source data can include multiple columns and rows, and it is used to determine the values and labels that will be displayed on the chart. The source data is essential for creating an accurate and meaningful chart.Rate this question:
-
- 16.
The quickest way to create and edit your charts is to use:
- A.
A.the Tools Menu
- B.
B.the Chart Toolbar
- C.
C,the View function
- D.
D.the Format Dialog box
Correct Answer
B. B.the Chart ToolbarExplanation
The Chart Toolbar is the quickest way to create and edit charts because it provides easy access to various charting tools and options. It allows users to quickly select chart types, add or remove chart elements, adjust formatting, and customize the appearance of the chart. By having all the necessary charting functions in one toolbar, users can save time and efficiently create and modify their charts without the need to navigate through multiple menus or dialog boxes.Rate this question:
-
- 17.
Which of the following is not a chart type in Excel?
- A.
A.Bar Chart
- B.
B.Pie Chart
- C.
C.Pin Chart
- D.
D.Line Chart
Correct Answer
C. C.Pin Chart -
- 18.
A chart created on the same worksheet as the soure data is called a chart sheet.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A chart created on the same worksheet as the source data is not called a chart sheet. A chart sheet is a separate sheet in the workbook that is dedicated solely to displaying a chart. Therefore, the correct answer is False.Rate this question:
-
- 19.
To resize a chart:
- A.
A.use the arrow keys on your keyboard
- B.
B.use the mouse to drah the sizing handles until the chart is the desired size
- C.
C.use the nouse to drah the blinking cursor through the choices smal(50%), medium (75%), and large (100%)
- D.
D.delete the original chart and insert a new chart with the correct measurements
Correct Answer
C. C.use the nouse to drah the blinking cursor through the choices smal(50%), medium (75%), and large (100%)Explanation
To resize a chart, you can use the mouse to drag the blinking cursor through the choices small (50%), medium (75%), and large (100%). This means that you can select the desired size for the chart by simply dragging the cursor over the options provided. This method allows for easy and precise resizing without the need to delete the original chart and insert a new one. Using the arrow keys on the keyboard or dragging the sizing handles are not mentioned as options for resizing the chart in this explanation.Rate this question:
-
- 20.
Which dialog box allows you to add headers and footers to a documents.
- A.
A.Save As
- B.
B.Page Setup
- C.
C.View Options
- D.
D.Filter Data
Correct Answer
B. B.Page SetupExplanation
The Page Setup dialog box allows you to add headers and footers to a document. This dialog box provides options for customizing the layout and formatting of the page, including the ability to add headers and footers that appear at the top and bottom of each page. This feature is commonly used in documents such as reports or formal letters, where you may want to include information such as the document title, page numbers, or the date.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 19, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 18, 2011Quiz Created by
Jrgbcrl
Back to top