Advanced Excel Quiz Questions And Answers
(235).jpg "Advanced Excel Quiz Questions And Answers - Quiz")
Otherwise known as excel spreadsheets, this is a one of the complex computer packages to learn and master, especially the advanced part of it. The ability to do math and calculations using excel makes it confusing. Test your knowledge below.
Questions and Answers
- 1.
_______ tab, in the Editing group, click Find & Select, and then click Go To.
- A.
Data
- B.
Home
Correct Answer
B. HomeExplanation
In order to access the Go To feature, you need to go to the Home tab. Within the Home tab, you will find the Editing group, where the Find & Select option is located. By clicking on Find & Select, a drop-down menu will appear, and from there you can select Go To. Therefore, the correct answer is Home.Rate this question:
-
- 2.
On the _____tab, in the Font group,
- A.
Home
- B.
Data
Correct Answer
A. HomeExplanation
The correct answer is "Home" because the question is asking about the tab where the Font group is located. The Font group contains options for formatting text, such as changing the font type, size, and style. The Home tab is typically where you can find basic formatting options for text in programs like Microsoft Word and Excel.Rate this question:
-
- 3.
On the ----------tab, in the Page Setup group, click Background.
- A.
Page layout
- B.
Home
Correct Answer
A. Page layoutExplanation
In the given question, the correct answer is "Page layout". This answer is based on the information provided in the question, which states that on the "----------tab, in the Page Setup group, click Background". Therefore, the answer "Page layout" is the appropriate option in this context.Rate this question:
-
- 4.
On the ----------tab, in the Page Setup group, click Background.
- A.
1.      Customize Ribbon
- B.
2.      Page layout
Correct Answer
B. 2.      Page layoutExplanation
In order to access the Background option in the Page Setup group, the user needs to be on the Page layout tab. This tab contains various options related to the layout and formatting of the page, including the Background option. Therefore, the correct answer is Page layout.Rate this question:
-
- 5.
Open a new, blank workbook
- A.
CTRL+N.
- B.
CTRL+s.
Correct Answer
A. CTRL+N.Explanation
Pressing CTRL+N opens a new, blank workbook in most spreadsheet software programs. CTRL+s is the shortcut for saving the current file, not for opening a new workbook. Therefore, the correct answer is pressing CTRL+N.Rate this question:
-
- 6.
On the ------------tab, in the Sparklines group, click the type of sparkline that you want to create
- A.
Insert
- B.
Data
Correct Answer
A. InsertExplanation
The correct answer is "insert". In Microsoft Excel, to create a sparkline, you need to go to the "Insert" tab. Within the "Insert" tab, there is a group called "Sparklines" where you can find different types of sparklines that you can choose from. By clicking on the desired type of sparkline, you can create it in your worksheet.Rate this question:
-
- 7.
On the------------ tab, in the Clipboard group, click Copy
- A.
Customize Ribbon
- B.
Home
Correct Answer
B. HomeExplanation
The correct answer is "Home" because the question is asking where to find the "Copy" function in the Clipboard group. The Clipboard group is located on the "Home" tab, so clicking on "Home" will allow you to access the Copy function.Rate this question:
-
- 8.
Under SmartArt Tools, on the Format tab, in the _____ group, click the arrow next to Shape Outline.
- A.
1.    Shape Styles group,
- B.
2.      Data
Correct Answer
A. 1.    Shape Styles group,Explanation
Under SmartArt Tools, on the Format tab, in the Shape Styles group, you can find various options to customize the appearance of the shape outline. By clicking the arrow next to Shape Outline, you can access additional settings such as changing the color, weight, and style of the outline. This allows you to enhance the visual appeal of your SmartArt graphic and make it more visually appealing and professional-looking.Rate this question:
-
- 9.
If the Developer tab is not available, do the following to display it: File tab, - Options- ____________- Developer -OK.
- A.
Customize Ribbon
- B.
 Data
Correct Answer
A. Customize RibbonExplanation
To display the Developer tab, you need to go to the File tab, then select Options. In the Options menu, you will find the Customize Ribbon option. By selecting Customize Ribbon and clicking OK, the Developer tab will be displayed.Rate this question:
-
- 10.
On the ________tab, in the Styles group,
- A.
home
- B.
 Data
Correct Answer
A. homeExplanation
The correct answer is "home". This suggests that the Styles group can be found on the Home tab.Rate this question:
-
- 11.
thesaurus in _______ menu
- A.
Data
- B.
Review
Correct Answer
B. ReviewExplanation
The correct answer is "Review" because a thesaurus is a tool used to find synonyms and antonyms for words, and the "Review" menu often includes options for checking and editing the content of a document, which would include the use of a thesaurus.Rate this question:
-
- 12.
Sub total _______menu
- A.
 Data
- B.
Review
Correct Answer
A. Â Data -
- 13.
Data validation from __________ menu
- A.
Data
- B.
Review
Correct Answer
A. Data -
- 14.
New coment from ______________ menu
- A.
Insert
- B.
Data
Correct Answer
A. InsertExplanation
The correct answer is "Insert" because the given comment suggests that there is a new comment and the user wants to insert or add some data related to that comment. The "Insert" option is likely to allow the user to input or append the desired data into the comment section.Rate this question:
-
- 15.
New coment from ______________ menu
- A.
Insert
- B.
Data
Correct Answer
A. InsertExplanation
The given correct answer is "Insert". It is likely that the question is asking about a feature or option in a menu, and the correct answer is the action of inserting something. This could refer to inserting new comments or data into a system or document. Without more context, it is difficult to provide a more specific explanation.Rate this question:
-
- 16.
What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
- A.
Elect both cells, and then drag the fill handle Fill handle over the range you want, for instance 18 more rows.
- B.
Select the range you want, including both cells, point to Fill on the Edit menu, and then click down.
Correct Answer
A. Elect both cells, and then drag the fill handle Fill handle over the range you want, for instance 18 more rows.Explanation
To extend the numbers to a longer sequence, you can select both cells and drag the fill handle over the range you want. In this case, you would drag it for 18 more rows to include the numbers 1 through 20.Rate this question:
-
- 17.
Which symbol must all formula begin with?
- A.
=
- B.
+
Correct Answer
A. =Explanation
All formulas must begin with the "=" symbol. This symbol is used to indicate that the following characters are part of a formula and not just regular text. It is a convention in spreadsheet programs like Microsoft Excel and Google Sheets to use the "=" symbol at the start of a formula to differentiate it from other text entries. This allows the program to recognize and evaluate the formula correctly.Rate this question:
-
- 18.
A typical worksheet has …. Number of columns
- A.
128
- B.
256
Correct Answer
B. 256Explanation
A typical worksheet has 256 number of columns. This means that the worksheet can accommodate data in 256 different columns. The number of columns in a worksheet determines the horizontal space available for organizing and analyzing data. With 256 columns, users can input and manipulate a large amount of information in a structured manner.Rate this question:
-
- 19.
The Chart wizard term data categories refers to;
- A.
A chart plot area
- B.
A horizontal axis
Correct Answer
B. A horizontal axisExplanation
The term "data categories" in the context of the Chart wizard refers to a horizontal axis. In a chart, the horizontal axis represents the categories or groups that the data is being plotted against. It is used to display and label the different categories or groups of data in the chart, allowing for easy comparison and analysis.Rate this question:
-
- 20.
A worksheet range is a
- A.
A group of cells
- B.
A group of worksheets
Correct Answer
A. A group of cellsExplanation
A worksheet range refers to a group of cells within a worksheet. It allows for the selection and manipulation of multiple cells simultaneously, making it easier to perform calculations or formatting changes across a specific set of cells. By selecting a range of cells, you can apply functions, formulas, or formatting options to all the cells within that range, saving time and effort.Rate this question:
-
- 21.
The auto calculate feature
- A.
Can only add values in a range of cells
- B.
Provides a quick way to view the result of an arithmetic operation on a range of cells
- C.
Option 3
- D.
Option 4
Correct Answer
B. Provides a quick way to view the result of an arithmetic operation on a range of cellsExplanation
The auto calculate feature in Excel allows users to quickly view the result of an arithmetic operation on a range of cells. This means that users do not have to manually input formulas or functions to perform calculations, as the auto calculate feature automatically updates and displays the result. This feature is particularly useful when working with large sets of data, as it provides a convenient and efficient way to obtain instant calculations without the need for complex formulas or manual input.Rate this question:
-
- 22.
You can edit a cell by
- A.
Clicking the formula button
- B.
Double clicking the cell to edit it in-place
- C.
Option 3
- D.
Option 4
Correct Answer
B. Double clicking the cell to edit it in-placeExplanation
Double clicking a cell allows you to directly edit its contents without the need to go to the formula bar or any other location. This feature is convenient and time-saving as it provides a quick way to make changes to the data within a cell. By double clicking, the cell becomes active for editing, and you can easily modify its content.Rate this question:
-
- 23.
Which elements of worksheet can be protected from accidental modification
- A.
Scenarios
- B.
All of above
Correct Answer
B. All of aboveExplanation
All of the elements of a worksheet can be protected from accidental modification. This includes cells, formulas, charts, graphics, and any other content present on the worksheet. By protecting these elements, users can prevent any unintentional changes or deletions, ensuring the integrity and accuracy of the data and calculations in the worksheet.Rate this question:
-
- 24.
Files created with Lotus 1-2-3 have an extension
- A.
123
- B.
WK1
Correct Answer
A. 123Explanation
Files created with Lotus 1-2-3 have the extension "123". This means that when a file is saved or created using Lotus 1-2-3, it will have the file name followed by the extension ".123". This extension helps to identify and distinguish Lotus 1-2-3 files from other file types.Rate this question:
-
- 25.
Comments can be added to cells using
- A.
Edit > Comments
- B.
Insert > Comments
Correct Answer
B. Insert > CommentsExplanation
The correct answer is "Insert > Comments" because this option allows users to add comments to cells in a spreadsheet. By selecting this option, users can easily provide additional information or explanations about specific data or calculations in the spreadsheet. This feature is useful for collaboration and communication purposes, as it allows multiple users to leave comments and discuss the content of the spreadsheet.Rate this question:
-
- 26.
Which of the following is not a worksheet design criterion?
- A.
Description
- B.
Clarity
Correct Answer
A. DescriptionExplanation
A worksheet design criterion refers to the factors that are considered when creating a worksheet. These criteria help ensure that the worksheet is effective and user-friendly. In this case, "Description" is not a worksheet design criterion because it does not typically play a role in determining the layout, formatting, or organization of a worksheet. Description may be important for providing context or instructions within a worksheet, but it is not a fundamental design criterion like clarity, which focuses on ensuring that the information presented on the worksheet is clear and easy to understand.Rate this question:
-
- 27.
Which of the following is the latest version of Excel
- A.
Excel ME
- B.
Excel XP
Correct Answer
B. Excel XPExplanation
Excel XP is the latest version of Excel. It was released in 2001 as part of the Microsoft Office XP suite. This version introduced several new features and improvements compared to the previous versions. It included enhanced formatting options, improved data analysis tools, and better collaboration capabilities. Excel XP also had a more user-friendly interface and improved stability and performance. Overall, Excel XP was a significant upgrade from its predecessors and remained the latest version until the release of Excel 2003.Rate this question:
-
- 28.
To copy cell contents using drag and drop press the
- A.
Ctrl key
- B.
Esc key
Correct Answer
A. Ctrl keyExplanation
When you want to copy cell contents in Excel using drag and drop, you press and hold the Ctrl key while dragging the cell's fill handle. This action duplicates the contents to the new location. Without pressing the Ctrl key, the default action is to move (cut and paste) the contents, not copy them.Rate this question:
-
- 29.
Which menu option can be sued to split windows into two
- A.
Window > split
- B.
View > split
Correct Answer
A. Window > splitExplanation
The correct answer is "Window > split". This menu option allows users to split windows into two, enabling them to view multiple documents or applications side by side. By selecting this option, users can easily organize their workspace and increase productivity by easily referencing information from different sources simultaneously.Rate this question:
-
- 30.
Which of the following is not information you can specify using the solver?
- A.
Input cells
- B.
Constraints
Correct Answer
A. Input cellsExplanation
The solver in question refers to a tool used to solve optimization problems. In this context, the input cells are the variables or parameters that are used as inputs to the solver. These input cells can be specified and manipulated to find the optimal solution. Therefore, the correct answer is "Input cells" because they are indeed information that can be specified using the solver.Rate this question:
-
- 31.
Excel probably considers the cell entry January 1, 2000 to be a
- A.
Label
- B.
Value
Correct Answer
B. ValueExplanation
Excel probably considers the cell entry January 1, 2000 to be a value because it is a specific date that can be used in calculations and formulas. In Excel, dates are stored as numeric values, with January 1, 1900 being represented by the value 1. Therefore, January 1, 2000 would have a numeric value greater than 1, making it a value rather than a label.Rate this question:
-
- 32.
All worksheet formula
- A.
Return a formula result
- B.
Use the addition operator
Correct Answer
A. Return a formula resultExplanation
The answer "Return a formula result" is correct because when using a worksheet formula, the purpose is to calculate and return a result based on the given inputs and formula logic. The formula is used to perform calculations, manipulate data, or generate specific results within a worksheet. Therefore, the main objective of using a worksheet formula is to obtain a result based on the formula's calculations.Rate this question:
-
- 33.
Which of the following is not a valid data type in excel
- A.
Number
- B.
Character
Correct Answer
B. CharacterExplanation
The correct answer is "Character" because in Excel, the data types are typically categorized as numbers, dates, text, and Boolean values. "Character" is not a specific data type in Excel, as it falls under the broader category of "text".Rate this question:
-
- 34.
Which area in an excel window allows entering values and formulas
- A.
Formula bar
- B.
Standard toolbar
Correct Answer
A. Formula barExplanation
The formula bar in an Excel window is the area where users can enter both values and formulas. It is located just below the ribbon and displays the content of the active cell. This is where users can input data or write formulas to perform calculations in Excel. The formula bar is a crucial tool for data entry and formula creation in Excel.Rate this question:
-
- 35.
Which of the following is a popular DOS based spreadsheet package?
- A.
Excel
- B.
Lotus 1-2-3
Correct Answer
B. Lotus 1-2-3Explanation
Lotus 1-2-3 is a popular DOS based spreadsheet package. It was one of the first spreadsheet software programs to gain widespread popularity in the 1980s. It offered features such as advanced calculations, graphing capabilities, and database management. Lotus 1-2-3 was widely used in business and finance sectors for data analysis and financial modeling. Although it has been largely replaced by modern spreadsheet software like Microsoft Excel, Lotus 1-2-3 played a significant role in the development of spreadsheet technology.Rate this question:
-
- 36.
Which of the following is not a worksheet design criterion?
- A.
Description
- B.
Clarity   Â
Correct Answer
A. DescriptionExplanation
The given answer, "Description," is not a worksheet design criterion. Worksheet design criteria typically include factors such as clarity, organization, readability, and ease of use. Description, on the other hand, refers to providing information or details about something, which may not be directly related to the design of a worksheet. Therefore, it can be concluded that description is not a criterion for designing a worksheet.Rate this question:
-
- 37.
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
- A.
 Formula
- B.
Field
Correct Answer
A. Â FormulaExplanation
An expression that tells how the numbers in a determined set of cells are to be calculated is called a formula. A formula is a mathematical equation or operation that is used to perform calculations in a spreadsheet or any other system that uses cells to store data. It can include mathematical operators, functions, and cell references to perform complex calculations and generate results based on the values in the specified set of cells.Rate this question:
-
- 38.
Excel is a
- A.
 Word processor
- B.
A spreadsheet
Correct Answer
B. A spreadsheetExplanation
Excel is a spreadsheet software that allows users to create, organize, and analyze data in a tabular format. It provides various features such as mathematical functions, charts, and graphs, which are specifically designed for data analysis and manipulation. Unlike a word processor, which is used for creating and editing text documents, Excel focuses on numerical data and calculations. Therefore, the correct answer is "A spreadsheet".Rate this question:
-
- 39.
When you insert an Excel file into a Word document, the data are
- A.
Hyperlinked
- B.
 Placed in a word table
Correct Answer
B. Â Placed in a word tableExplanation
When you insert an Excel file into a Word document, the data is placed in a Word table. This means that the content of the Excel file is organized and displayed in a structured manner within a table in the Word document. This allows for easier viewing and manipulation of the data within the Word document itself.Rate this question:
-
- 40.
How are data organized in a spreadsheet?
- A.
 Rows and columns
- B.
 Height and width
Correct Answer
A. Â Rows and columnsExplanation
Data in a spreadsheet are organized in rows and columns. Rows are horizontal lines that contain data, while columns are vertical lines that hold specific types of information. This arrangement allows for a systematic organization and easy retrieval of data. Rows are typically used to represent individual records or entries, while columns represent different attributes or variables associated with those records. By organizing data in this way, it becomes easier to analyze and manipulate information in a spreadsheet.Rate this question:
-
- 41.
When you use the fill effects in the format data series dialog box, you can not
- A.
 rotate text on the chart
- B.
 select a fore ground color
Correct Answer
A. Â rotate text on the chartExplanation
When using the fill effects in the format data series dialog box, you are unable to rotate text on the chart. This means that you cannot change the orientation or angle of the text within the chart. The fill effects options in the dialog box only allow for modifications to the background color, patterns, and gradients of the chart elements.Rate this question:
-
- 42.
Which of the following is not a basic step in creating a worksheet?
- A.
Enter text and data
- B.
 Copy the worksheet
Correct Answer
B. Â Copy the worksheetExplanation
Copying the worksheet is not a basic step in creating a worksheet. The basic steps in creating a worksheet include entering text and data, formatting the worksheet, and creating formulas or functions. Copying the worksheet is typically done after the worksheet has been created and is used when you need to duplicate the worksheet for a similar purpose or to make changes without affecting the original worksheet.Rate this question:
-
- 43.
Hyperlinks cannot be
- A.
 Pictures
- B.
All can be hyperlinks
Correct Answer
B. All can be hyperlinksExplanation
This answer suggests that all types of content, including pictures, can be used as hyperlinks. In other words, hyperlinks are not limited to just text or specific types of content. This means that when creating a hyperlink, any type of content can be linked to another webpage or resource, allowing users to navigate through different types of content by clicking on them.Rate this question:
-
- 44.
To drag a selected range of data to another worksheet in the same workbook, use the
- A.
 Shift key
- B.
 Ctrl key
Correct Answer
B. Â Ctrl keyExplanation
To drag a selected range of data to another worksheet in the same workbook, you need to use the Ctrl key. Pressing the Ctrl key while dragging the selected range allows you to create a copy of the data in the destination worksheet without removing it from the original worksheet. This is useful when you want to duplicate or move data between worksheets without losing the original information. The Shift key, on the other hand, is not used for this specific action.Rate this question:
-
- 45.
In a worksheet you can select
- A.
 Columns
- B.
ROW
- C.
SHEET
- D.
 a, b, and c
Correct Answer
B. ROWExplanation
In a worksheet, you can select rows. This means that you can highlight or choose specific rows in order to perform certain actions such as formatting, deleting, or inserting data. Selecting rows allows you to manipulate data in a more organized and efficient manner.Rate this question:
-
- 46.
What term refers to a specific set of values saved with the workbook?
- A.
Range
- B.
 Scenario
Correct Answer
B. Â ScenarioExplanation
A scenario in Excel refers to a specific set of values that are saved with the workbook. It allows users to create different versions of the same data by changing the values in the scenario. This feature is useful when analyzing different possibilities or what-if scenarios without altering the original data.Rate this question:
-
- 47.
You can activate a cell by
- A.
A FINCTION IN OTHER
- B.
NESTED
- C.
SINGLE
Correct Answer
B. NESTED -
- 48.
Macros are “run” or executed from the ….. menu.
- A.
 Tools
- B.
 Data
Correct Answer
A. Â ToolsExplanation
Macros are executed from the "Tools" menu.Rate this question:
-
- 49.
What term describes a background that appears as a grainy, non smooth surface
- A.
gradient
- B.
pattern
Correct Answer
B. patternExplanation
A "pattern" in the context of graphic design or digital imagery often refers to a repetitive or distinct arrangement that can include textures such as grainy surfaces. A "gradient," on the other hand, refers to a smooth transition between colors and does not imply a textured or grainy appearance.Rate this question:
-
- 50.
You can edit existing Excel data by pressing the
- A.
 F1 key
- B.
 F2 key
Correct Answer
B. Â F2 keyExplanation
Pressing the F2 key allows you to edit existing Excel data. This key activates the cell's editing mode, allowing you to modify the contents of the cell directly.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
-
Aug 28, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Mar 22, 2012Quiz Created by
SPACECOMPUTER