How To Make Excel Sheet?
(67).webp "How To Make Excel Sheet? - Quiz")
Do you know how to make excel sheet? Let's prove yourself now by taking this quiz!
- 1.
What is a worksheet tab in Excel 2007?
- A.
A worksheet tab is used to access tools associated with the worksheet
- B.
A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
- C.
A worksheet tab is used to get help when working with Microsoft Excel 2007
- D.
A worksheet tab is used to move from one cell to the next cell in a worksheet
Correct Answer
B. A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheetExplanation
A worksheet tab in Excel 2007 is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet. This means that when you click on a specific worksheet tab, that particular worksheet becomes active and you can start working on it. The sheet tabs make it easy to navigate between different worksheets within the Excel workbook.Rate this question:
-
- 2.
True or False: Tables created through Excel's table feature allow users to filter columns by different values.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Tables created through Excel's table feature allow users to filter columns by different values. This feature enables users to easily sort and filter data within a table based on specific criteria. By applying filters to columns, users can quickly analyze and display only the data they need, making it easier to identify trends, patterns, or specific information within the table. This functionality enhances data analysis and simplifies data management tasks in Excel.Rate this question:
-
- 3.
True or False: Pivot tables allow filtering of table information by different values in column and row headers.
- A.
True
- B.
False
- C.
Only when using Excel 2003 or earlier versions
Correct Answer
A. TrueExplanation
Pivot tables indeed allow filtering of table information by different values in column and row headers. This feature enables users to easily analyze and summarize large amounts of data by selecting specific criteria to display. By filtering the headers, users can focus on specific subsets of data and gain insights into trends, patterns, and relationships within the dataset.Rate this question:
-
- 4.
Creating tables is as easy as highlighting cells that have already been filled in appropiately, followed by clicking on the insert tab and then clicking on the table button.
- A.
No, highlighting cells disables the ability to create tables
- B.
Yes, it is that simple, but the highlighted cells must have numerical data
- C.
No, you go to the home tab and then click on the table button
- D.
Yes, it is that simple, but the highlighted selection should not contain any blank cells
Correct Answer
D. Yes, it is that simple, but the highlighted selection should not contain any blank cellsExplanation
The correct answer is "Yes, it is that simple, but the highlighted selection should not contain any blank cells." This is because the statement mentions that creating tables is easy by highlighting cells that have already been filled appropriately. However, the highlighted selection should not contain any blank cells, indicating that all cells should have data in them.Rate this question:
-
- 5.
Once data in a table gets filtered, you can neither unfilter the table nor get the table back to the original settings.
- A.
False, you may change filters up to three times
- B.
True
- C.
False, you may change filters as many times as you please without limits
- D.
False, tables cannot be filtered
Correct Answer
C. False, you may change filters as many times as you please without limits -
- 6.
Which pivot table layout allows the dragging of fields to the grid in a spreadsheet?
- A.
Default Pivot Table Layout
- B.
Classic Pivot Table Layout
- C.
Master Pivot Table Layout
- D.
Operation Geronimo Layout
Correct Answer
B. Classic Pivot Table LayoutExplanation
The Classic Pivot Table Layout allows the dragging of fields to the grid in a spreadsheet. This layout is a traditional and widely used format for organizing and analyzing data in a pivot table. It provides a user-friendly interface that allows users to easily drag and drop fields into rows, columns, and values sections of the pivot table grid to customize the layout and view of the data. This enables users to quickly and efficiently summarize and analyze large datasets in a spreadsheet format.Rate this question:
-
- 7.
True or False: For a table to work properly, the top row should have column headings.
- A.
True
- B.
False, only rows may have headings
- C.
False
Correct Answer
A. TrueExplanation
In a table, the top row is typically used to provide column headings, which label the data in each column. Without column headings, it would be difficult to understand the meaning or context of the data in the table. Therefore, for a table to work properly and be easily interpreted, it is important for the top row to have column headings.Rate this question:
-
- 8.
True or False: Pivot tables that have been created can easily be turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart that you want to create.
- A.
True
- B.
False, pivot tables do not contain enough information for graphs or charts
- C.
False, only regular tables may be used to create graphs or charts
Correct Answer
A. TrueExplanation
Pivot tables can indeed be easily turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart to create. This is because pivot tables summarize and organize data in a way that is ideal for visual representation. By converting a pivot table into a graph or chart, it becomes easier to analyze and interpret the data visually, allowing for better insights and understanding.Rate this question:
-
- 9.
What is the function of the Formulas tab in Microsoft Excel 2007?
- A.
The Formulas tab provides links to instructions on how to write your own formulas, but will not input any formulas automatically
- B.
The Formulas tab contain only the most common formulas supported by Excel
- C.
The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab
- D.
The Formulas tab is used for automatic creation of a complete formula without any user interaction at all
Correct Answer
C. The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tabExplanation
The Formulas tab in Microsoft Excel 2007 contains various formula-related functions such as the function library, formula auditing, defining names, and calculations. These functions can be easily inserted into a cell from the Formulas tab. This tab does not automatically input any formulas but provides links to instructions on how to write your own formulas.Rate this question:
-
- 10.
Which of the following Excel features allows you to summarize the data in a large table?
- A.
Data Validation
- B.
Conditional Formatting
- C.
Pivot Table
- D.
Hyperlink
Correct Answer
C. Pivot TableExplanation
A Pivot Table is an Excel feature that allows you to summarize and analyze large amounts of data in a table. It enables you to group and summarize data based on different criteria, such as summing up values, counting occurrences, or finding averages. This feature is particularly useful when dealing with large datasets and allows you to quickly and easily create meaningful summaries and visualizations of the data.Rate this question:
-
- 11.
When number signs (#####) are displayed in the cell, it means:
- A.
There are too many characters in the cell to be displayed with the current cell width
- B.
The formula in the cell is wrong
- C.
The decimal point placement in the cell is wrong
- D.
All of the above
Correct Answer
A. There are too many characters in the cell to be displayed with the current cell widthExplanation
When number signs (#####) are displayed in a cell, it means that there are too many characters in the cell to be displayed with the current cell width. This occurs when the content of the cell is wider than the column width, causing the content to be truncated and replaced with number signs.Rate this question:
-
- 12.
What does the Format Painter button do?
- A.
Only changes the color of each cell
- B.
Only changes the color of a group of cells that you choose
- C.
Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.
- D.
Only copies formulas from one cell or group of cells to another.
Correct Answer
C. Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.Explanation
The Format Painter button allows you to copy the formatting of a cell, including its formulas, and apply it to another cell or group of cells. This can be done quickly and easily, saving time and effort in formatting multiple cells with the same style and formula.Rate this question:
-
- 13.
By default, each workbook automatically has 3 sheets labeled on the bottom tabs: Sheet 1, Sheet 2, Sheet 3. To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, what has to be done?
- A.
Right click on sheet 2 and select insert
- B.
Right click on sheet 1 and select insert
- C.
Right click on sheet 3 and select insert
- D.
None of the above
Correct Answer
A. Right click on sheet 2 and select insertExplanation
To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, you need to right click on sheet 2 and select insert. This will create a new sheet between the existing Sheet 1 and Sheet 2.Rate this question:
-
- 14.
When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?
- A.
Seperate the page into two for easier printing
- B.
Use the Fit to Page option
- C.
Highlight all cells to print and print selection
- D.
None of the above
Correct Answer
B. Use the Fit to Page optionExplanation
If changing the margins on the spreadsheet does not solve the problem with the printout width, using the Fit to Page option can help. This option automatically adjusts the size of the spreadsheet to fit within the printable area of the page, ensuring that all content is visible when printed. This can be useful when the spreadsheet is too wide or too long to fit on a single page. By selecting the Fit to Page option, the spreadsheet will be scaled down to fit within the available space, allowing for a proper printout.Rate this question:
-
- 15.
Once data is entered into a cell, can it be edited?
- A.
Yes, but the file must be saved with a different file name
- B.
No, once a file is saved, cell data cannot be changed
- C.
Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
- D.
No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
Correct Answer
C. Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editingExplanation
The correct answer states that data can be edited even after saving a file by double-clicking on a cell. This is a common feature in spreadsheet software like Microsoft Excel. Double-clicking on a cell allows the user to enter edit mode, where they can modify the data. Saving the file with a different name is not necessary to edit the data in a cell.Rate this question:
-
- 16.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
- A.
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
Correct Answer
B. Right click on the spreadsheet tab and select DELETEExplanation
To remove a spreadsheet from a workbook, the correct sequence of events is to right-click on the spreadsheet tab and select DELETE. This action will delete the specific spreadsheet from the workbook, effectively removing it from the file.Rate this question:
-
- 17.
What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?
- A.
F3
- B.
F5
- C.
F7
- D.
F9
- E.
F11
- F.
F13
Correct Answer
E. F11Explanation
Pressing the F11 key on the keyboard creates a chart from the selected cells in Microsoft Excel. This shortcut allows users to quickly generate a chart without needing to navigate through the menu options.Rate this question:
-
- 18.
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
C. SumExplanation
The Sum formula can add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range.Rate this question:
-
- 19.
Which of these will NOT select all the cells in a document?
- A.
Clicking three times with the right mouse button in the spreadsheet
- B.
Using the Edit - Select All menu item
- C.
Pressing CTRL + A on the keyboard
Correct Answer
A. Clicking three times with the right mouse button in the spreadsheetExplanation
Clicking three times with the right mouse button in the spreadsheet does not select all the cells in a document. This action typically opens a context menu with options specific to the spreadsheet program, rather than selecting cells.Rate this question:
-
- 20.
When you see a cell with a red triangle in the top right corner, what does this signify?
- A.
There is an error in the cell
- B.
There is a comment associated with the cell
- C.
The font color for text in the cell is red
- D.
A formula cannot be entered into the cell
Correct Answer
B. There is a comment associated with the cellExplanation
When a cell has a red triangle in the top right corner, it signifies that there is a comment associated with the cell. This comment can be viewed by hovering over the cell or by opening the comment feature in the spreadsheet program. The red triangle serves as a visual indicator that additional information or notes are available for that specific cell.Rate this question:
-
- 21.
Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
- A.
![How To Make Excel Sheet? - Quiz]()
- B.
![How To Make Excel Sheet? - Quiz]()
- C.
![How To Make Excel Sheet? - Quiz]()
Correct Answer
A.Explanation
The correct answer is the "Number Format" button. This button allows users to format selected cells as currency values by applying the currency format to the cell contents.Rate this question:
-
- 22.
Which of the following will NOT set text in selected cells to ITALICS?
- A.
Pressing CTRL + I on the keyboard
- B.
Using the Tools - Wizard - Web Form menu item
- C.
Using the Format - Cells - Font menu item
Correct Answer
B. Using the Tools - Wizard - Web Form menu itemExplanation
Using the Tools - Wizard - Web Form menu item will not set text in selected cells to ITALICS. This menu item is used for creating web forms and does not have an option to change the font style to italics. Therefore, selecting this menu item will not affect the text formatting in the selected cells.Rate this question:
-
- 23.
Is it possible to insert an image from a file into an Excel spreadsheet?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
It is possible to insert an image from a file into an Excel spreadsheet. This can be done by selecting the "Insert" tab, clicking on the "Pictures" option, and then choosing the desired image file from the file explorer. The image will then be inserted into the Excel spreadsheet, allowing users to incorporate visual elements into their data or presentations.Rate this question:
-
- 24.
How do you turn off automatic calculation for a spreadsheet ?
- A.
You cannot turn off automatic calculation - its built into the spreadsheet / workbook.
- B.
Right click on the spreadsheet tab and select MANUAL CALCULATION.
- C.
Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.
Correct Answer
C. Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.Explanation
To turn off automatic calculation for a spreadsheet in Excel, you need to go to the Office Button, then select Excel Options. From there, navigate to the Formulas section and choose Manual in the Workbook Calculation option. This will disable automatic calculation and allow you to manually recalculate the spreadsheet when needed.Rate this question:
-
- 25.
What is the keyboard shortcut (button or buttons to be pressed) to Complete a cell entry and move up in the selection ?
- A.
CTRL+TAB
- B.
SHIFT+TAB
- C.
ALT+TAB
- D.
SHIFT+ENTER
- E.
CTRL+ENTER
- F.
ALT+ENTER
Correct Answer
D. SHIFT+ENTERExplanation
Pressing SHIFT+ENTER is the keyboard shortcut to complete a cell entry and move up in the selection.Rate this question:
-
- 26.
When working with a chart, which of the following will allow you to change the spacing of tick marks and labels on the category axis ? Click on the desired axis and go to:
- A.
FORMAT - SELECTED AXIS - SCALE - Select options required
- B.
FORMAT - CHART - AXIS - SCALE - Select options required
- C.
Format Tab - Format Selection - Axis Options - Select options required
Correct Answer
C. Format Tab - Format Selection - Axis Options - Select options requiredExplanation
The correct answer is "Format Tab - Format Selection - Axis Options - Select options required". This option allows you to access the formatting options for the selected axis in the chart. Within the Axis Options, you can adjust the spacing of tick marks and labels on the category axis by selecting the desired options.Rate this question:
-
- 27.
What does the following error mean - #REF! ?
- A.
The #REF! error value occurs when a cell reference is not valid.
- B.
The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.
- C.
The #REF! error value occurs when a cell has been formatted as a currency but contains text.
Correct Answer
A. The #REF! error value occurs when a cell reference is not valid.Explanation
The #REF! error value occurs when a cell reference is not valid. This means that the formula in a cell is referencing a cell that does not exist or has been deleted. It could also occur if the formula is referencing a different sheet or workbook that is not open or accessible. This error can be fixed by correcting the cell reference in the formula to point to a valid cell.Rate this question:
-
- 28.
Which feature in Excel allows you to view two spreadsheets in one window?
- A.
Freeze panes
- B.
Split
- C.
View side by side
Correct Answer
B. SplitExplanation
The Split feature in Excel allows you to view two spreadsheets in one window. This feature is useful when you want to compare or work on two different parts of a spreadsheet simultaneously. By splitting the window, you can scroll through one part of the spreadsheet while keeping the other part stationary, making it easier to analyze and make changes to your data.Rate this question:
-
- 29.
What must first be created before copying the results of an advanced filter to another location?
- A.
Criteria range
- B.
Output range
- C.
Setup range
- D.
Filter range
Correct Answer
A. Criteria rangeExplanation
Before copying the results of an advanced filter to another location, the criteria range must first be created. The criteria range is used to specify the conditions that the data must meet in order to be included in the filtered results. This range typically includes the headers and the criteria for each column. Once the criteria range is set up, the advanced filter can be applied to the data, and the filtered results can be copied to another location.Rate this question:
-
- 30.
Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?
- A.
ROUND
- B.
ROUNDUP
- C.
ROUNDDOWN
- D.
RAND
Correct Answer
A. ROUNDExplanation
The ROUND formula is used to automatically change a decimal value of .5 or greater up to the next highest whole number value. This means that if the decimal value is .5 or greater, it will be rounded up to the next whole number.Rate this question:
-
.gif)
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Aug 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 12, 2012Quiz Created by
Steph123
Back to top