Microsoft Excel Quiz: Can You Answer?

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Lshipley
L
Lshipley
Community Contributor
Quizzes Created: 3 | Total Attempts: 11,417
Questions: 30 | Attempts: 326

Settings

.

• 1.

When you open up Microsoft Excel, you open it up to a _______________.

• A.

• B.

Worksheet

• C.

Sheet

B. Worksheet
Explanation
When you open up Microsoft Excel, you open it up to a worksheet. A worksheet is a single page or tab within a spreadsheet where you can enter and manipulate data. It is the primary working area in Excel where you can perform calculations, organize data, and create charts or graphs. A spreadsheet, on the other hand, refers to the entire file or document that contains multiple worksheets. A sheet is a general term that can refer to either a worksheet or a chart sheet within an Excel file.

Rate this question:

• 2.

A row is __________.

• A.

Horizontal

• B.

Vertical

A. Horizontal
Explanation
A row is a horizontal arrangement of objects or elements. It is a line or series of things placed side by side in a straight line from left to right. In contrast, a vertical arrangement would be a column, where objects or elements are placed one above the other. Therefore, the correct answer is horizontal.

Rate this question:

• 3.

A column is ____________.

• A.

Horizontal

• B.

Vertical

B. Vertical
Explanation
A column is a vertical structure or element that is used to support or bear weight in a building or structure. It is typically tall and slender in shape, standing upright to provide stability and structural integrity. Columns are commonly found in architecture and are used to distribute the weight of the structure evenly, allowing for the construction of larger and more complex buildings.

Rate this question:

• 4.

To merge two are more cells together use the ________________.

• A.

Tab key

• B.

Insert

• C.

Merge & center

• D.

Copy & paste

C. Merge & center
Explanation
To merge two or more cells together, the correct option is "merge & center". This option combines the selected cells into a single cell and centers the content within the merged cell. This is useful when you want to create a header or title that spans across multiple columns or rows in a spreadsheet or table.

Rate this question:

• 5.

What command do you use if you want to save your excel assignment under a different name?

• A.

Save

• B.

Save as

• C.

Options

• D.

Save up

B. Save as
Explanation
The "save as" command is used when you want to save your excel assignment under a different name. This command allows you to create a copy of the file with a new name, while keeping the original file intact. It is useful when you want to make a duplicate of the assignment or save it with a different name for organizational purposes.

Rate this question:

• 6.

When putting a formula in, what symbol must you put in first?

• A.

+

• B.

#

• C.

>

• D.

=

D. =
Explanation
When putting a formula in, the symbol that must be put in first is the equals sign (=). The equals sign is used to indicate that the following characters are part of a formula and not a regular text entry. It is essential to include the equals sign at the beginning of a formula to ensure that the spreadsheet software recognizes it as a formula and performs the necessary calculations accordingly.

Rate this question:

• 7.

If subtracting two items from each other, what word command must you place after the symbol.

• A.

SUM

• B.

SUB

• C.

MIN

• D.

A. SUM
Explanation
The word command that must be placed after the symbol when subtracting two items from each other is "SUB". This is because "SUB" is the abbreviation for "subtract", which indicates the operation of subtraction. The other options, "SUM", "MIN", and "ADD", are not appropriate word commands for subtraction.

Rate this question:

• 8.

What is the name of the bar where you put in a formula?

• A.

• B.

Formula bar

• C.

Ribbon bar

• D.

Symbol bar

B. Formula bar
Explanation
The formula bar is the correct answer because it is the specific name given to the bar where you input formulas in software applications such as Microsoft Excel. It allows users to enter and edit formulas, which are used to perform calculations and manipulate data within the program. The other options (address bar, ribbon bar, symbol bar) are not associated with inputting formulas and do not serve the same purpose as the formula bar.

Rate this question:

• 9.

When the formula contains the address of a cell, it is called a(n):

• A.

• B.

Group

• C.

Cell reference

• D.

Order of operations

C. Cell reference
Explanation
A cell reference refers to the address of a specific cell in a spreadsheet. It is used in formulas to perform calculations or retrieve data from that particular cell. The formula can include the cell reference to indicate which cell's value should be used in the calculation. Therefore, the correct answer is "cell reference".

Rate this question:

• 10.

Worksheets can be:

• A.

Named

• B.

• C.

Duplicated

• D.

All of the above

A. Named
Explanation
Worksheets can be named in order to provide a clear and specific label for each sheet. This helps users easily identify and navigate between different sheets within a workbook. By naming worksheets, users can also organize and categorize their data more effectively. Additionally, naming worksheets can make it easier to reference specific sheets in formulas or macros. Therefore, the correct answer is "named".

Rate this question:

• 11.

If you are printing paper the long way, you the orientation is:

• A.

Regular

• B.

Vertical

• C.

Portrait

• D.

Landscape

D. Landscape
Explanation
When printing paper in landscape orientation, the paper is positioned horizontally, with the longer side of the paper running from left to right. This allows for a wider printout, making it suitable for documents that have a wider layout, such as spreadsheets or wide tables. In contrast, portrait orientation is when the paper is positioned vertically, with the longer side running from top to bottom.

Rate this question:

• 12.

When copying information from one cell to another, and the cell information stays the same, that is called:

• A.

Copy cells

• B.

Fill formatting

• C.

Fill without formatting

• D.

Copy and paste

A. Copy cells
Explanation
When copying information from one cell to another, if the cell information remains unchanged, it is referred to as "copy cells". This means that the exact content of the cell is replicated in another cell without any alterations.

Rate this question:

• 13.

To create a chart or graph you must use the tab marked:

• A.

Home

• B.

View

• C.

Formula

• D.

Insert

D. Insert
Explanation
To create a chart or graph, you need to use the "insert" tab. This tab contains various options and tools for inserting different elements into your document, including charts and graphs. By selecting the "insert" tab, you can access the necessary features and functions to create and customize your desired chart or graph. The "home" tab is generally used for basic formatting and editing tasks, while the "view" tab is used for changing the display settings. The "formula" tab is used for working with mathematical and logical formulas.

Rate this question:

• 14.

To sort in descending order means to sort:

• A.

A - z

• B.

Z - a

B. Z - a
Explanation
To sort in descending order means to arrange the items in reverse alphabetical order, starting from the highest value or letter and ending with the lowest. In this case, "z - a" represents sorting in descending order as it starts with the letter "z" and ends with the letter "a".

Rate this question:

• 15.

A pie chart is used to:

• A.

Show information and date over a period of time

• B.

Create a pretty graph with different types of colors

• C.

Show information in relationship to each other

C. Show information in relationship to each other
Explanation
A pie chart is used to show information in relationship to each other. It represents the proportion of different categories or components within a whole. Each slice of the pie represents a specific category, and the size of each slice corresponds to the proportion or percentage it represents in relation to the whole. This allows for easy visualization and comparison of the different categories and their relative importance or contribution.

Rate this question:

• 16.

A column chart :

• A.

Goes up and down

• B.

Goes side to side

• C.

Goes in circles

• D.

Goes in a line

A. Goes up and down
Explanation
A column chart is a type of graphical representation that uses vertical bars to display data. These bars go up and down along the y-axis, representing different categories or variables on the x-axis. Each bar's height corresponds to the value it represents, allowing for easy comparison between different data points. Therefore, the correct answer is "goes up and down."

Rate this question:

• 17.

A cell is identified by two characters, often referred to as:

• A.

Numericalpha

• B.

Lettersnumbers

• C.

Numbersletters

• D.

Alphanumeric

D. Alphanumeric
Explanation
A cell is identified by two characters, often referred to as alphanumeric because it can contain both letters and numbers. This means that the characters used to identify a cell can be a combination of both alphabets and numerals, allowing for a wider range of possibilities in cell identification.

Rate this question:

• 18.

When heading information is placed in cell 1 (one) of each column, what is it called?

• A.

• B.

• C.

• D.

Explanation
When heading information is placed in cell 1 of each column, it is called a header row. The header row typically contains labels or titles that describe the data in each column. It is used to identify and categorize the data in the columns below, making it easier to understand and organize the information in the table or spreadsheet.

Rate this question:

• 19.

What can excel be used for?

• A.

• B.

Create phone book

• C.

Cost of vacation

• D.

Create labels

• E.

Some of the above

• F.

All of the above

E. Some of the above
Explanation
Excel can be used for multiple purposes, including monitoring grades, creating a phone book, calculating the cost of a vacation, and creating labels. Therefore, the answer "some of the above" is correct as it encompasses the various uses of Excel mentioned in the options.

Rate this question:

• 20.

If you were to add two numbers and multiply them by 15, what would the equation look like in excel?

• A.

=a1 + b1 x 15

• B.

=sum(a1 + b1)x15

• C.

=sum(a1 + b1)*15

• D.

Sum(a1 + b1) /15

C. =sum(a1 + b1)*15
Explanation
The correct answer is "=sum(a1 + b1)*15". In Excel, the SUM function is used to add the values in cells A1 and B1, and then the result is multiplied by 15 using the asterisk symbol (*).

Rate this question:

• 21.

• A.

True

• B.

False

A. True
Explanation
You can add additional worksheets to Excel by clicking on the "+" button located at the bottom of the worksheet tabs. This allows you to create new worksheets within the same Excel file, which can be useful for organizing and managing different sets of data or performing different calculations.

Rate this question:

• 22.

Excel is a program.

• A.

True

• B.

False

B. False
Explanation
Excel is not a program, it is a spreadsheet software developed by Microsoft. It is used for creating, organizing, and analyzing data in a tabular format. Therefore, the correct answer is False.

Rate this question:

• 23.

Excel can be used to create a database.

• A.

True

• B.

False

B. False
Explanation
Excel is a spreadsheet software that is primarily used for creating and managing numerical data, performing calculations, and creating charts and graphs. While Excel does have some basic database functionalities, such as sorting and filtering data, it is not designed to be a full-fledged database management system. It lacks advanced features like data validation, data relationships, and security measures that are essential for a robust database. Therefore, the statement that Excel can be used to create a database is false.

Rate this question:

• 24.

At Central High School we use MS Excel 10.

• A.

True

• B.

False

A. True
Explanation
The given statement states that Central High School uses MS Excel 10. This implies that the statement is true.

Rate this question:

• 25.

When making a graph, you have to highlight everything.

• A.

True

• B.

False

B. False
Explanation
When making a graph, you do not have to highlight everything. Highlighting everything would make the graph cluttered and difficult to read. Instead, it is important to selectively highlight the relevant data or key points to effectively communicate the information in the graph.

Rate this question:

• 26.

The symbol for division is "/".

• A.

True

• B.

False

A. True
Explanation
The symbol "/" is commonly used to represent division in mathematical operations. It is widely recognized and accepted as the division symbol in various mathematical notations and programming languages. Therefore, the statement that the symbol for division is "/" is true.

Rate this question:

• 27.

You have to write a formula in each cell in order for it to be effective.

• A.

True

• B.

False

B. False
Explanation
The statement implies that in order for a formula to be effective, it must be written in each cell. However, this is not true. Formulas in spreadsheets can be written in a single cell and then copied or dragged to other cells to apply the formula to multiple cells. This saves time and effort in entering the same formula repeatedly. Therefore, the correct answer is false.

Rate this question:

• 28.

You can copy and paste a chart into a document.

• A.

True

• B.

False

A. True
Explanation
You can copy and paste a chart into a document. This is a common feature in many document editing software, where you can select a chart, copy it, and then paste it into a document. This allows you to easily insert charts from other sources into your document without having to recreate them manually.

Rate this question:

• 29.

Ctrl c and ctrl x is copy and paste.

• A.

True

• B.

False

B. False
Explanation
The statement is incorrect. The correct keyboard shortcuts for copy and paste are Ctrl+C and Ctrl+V, not Ctrl+C and Ctrl+X. Ctrl+X is the shortcut for cut, not copy. Therefore, the given answer is false.

Rate this question:

• 30.

In order to print a document, the shortcut is cntr p.

• A.

True

• B.

False

A. True
Explanation
The statement is true because the shortcut to print a document is indeed "cntr p".

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 18, 2023
Quiz Edited by
ProProfs Editorial Team
• Dec 01, 2011
Quiz Created by
Lshipley

Related Topics