Question 1

When adding graphs,hyperlinks,or images to a Microsoft Excel worksheet,you use the ________ tab.
A) Data
B) Format
C) View
D) Insert

Accepted Answer

The Insert tab in Microsoft Excel is used to insert objects such as graphs, hyperlinks, or images into a worksheet. The Data tab is used to manage and analyze data, the Format tab is used to format cells and charts, and the View tab is used to change the view of the worksheet.

Question 2

In Excel,the term "________" refers to a single spreadsheet.
A) workbook
B) library
C) worksheet
D) gridline

Accepted Answer

A single spreadsheet in Excel is referred to as a worksheet. A workbook is a collection of multiple worksheets or spreadsheets. A library is not a term commonly used in Excel, and gridlines refer to the lines on the worksheet that separate cells from each other.

Question 3

Which of the following can be used to move the focus to a different cell in the Excel worksheet?
A) arrow keys
B) office button
C) shift key
D) data tab

Accepted Answer

B

Question 4

To save a worksheet in Microsoft Excel,you use the Save option in the Edit menu.

Accepted Answer

In Microsoft Excel, to save a worksheet, you would typically use the Save option found in the File menu, not Edit menu. However, in more recent versions of Excel, there is a 'Save' button located on the Quick Access Toolbar.

Question 5

In Microsoft Excel,which of the following tabs can be used for filtering and sorting the information in your spreadsheet?
A) Data
B) Add-ins
C) Formula
D) Home

Accepted Answer

The Data tab in Microsoft Excel includes various options for filtering and sorting data in the spreadsheet. This includes options such as filter, sort, remove duplicates, text to columns, and more. The other tabs listed (Add-ins, Formula, and Home) do not have as many options for filtering and sorting data.

Question 6

You have entered a formula in the cell G9.Which of the following would occur if you press F2 function key after selecting the cell G9?
A) The formula in G9 can be edited without retyping.
B) The formula will be copied to the clipboard.
C) A graph that explains the formula would appear.
D) The formula in the cell will be locked.

Accepted Answer

Pressing the F2 function key after selecting a cell that contains a formula allows you to enter edit mode directly in the cell instead of having to double-click on the cell. This will enable you to edit the formula without retyping it.

Question 7

Which of the following is the correct method for accessing Microsoft Help?
A) It can be accessed by clicking the question mark in the office button that appears at the upper left-corner of the Excel window.
B) It can be accessed by clicking the question mark in the upper right-hand corner of the ribbon on the Excel window.
C) It can be accessed by clicking the question mark in the status bar that appears at the very bottom of the Excel window.
D) It can be accessed by clicking the question mark present on the title bar of the Excel window.

Accepted Answer

The correct method for accessing Microsoft Help in Excel is by clicking the question mark in the upper right-hand corner of the ribbon on the Excel window.

Question 8

In Excel,a ________ is a combination of one or more worksheets.
A) dashboard
B) workbook
C) batch
D) datasheet

Accepted Answer

A workbook is a combination of one or more worksheets in Excel. It is the main file type used in Excel and contains all the data, charts, and macros for a particular project or analysis.

Question 9

A ________ is a table of data which has rows and columns.
A) spreadsheet
B) cell
C) broadsheet
D) library

Accepted Answer

A spreadsheet is a program used to organize and analyze data in a table format with rows and columns.

Question 10

The intersection of a row and a column on a spreadsheet is called a data point.

Accepted Answer

The answer of The intersection of a row and a...

Question 11

In Microsoft Excel,most frequently used tools and selections appear under the ________ tab.
A) Data
B) Home
C) View
D) Add-ins

Accepted Answer

The Home tab is where the most frequently used tools and selections are placed in Microsoft Excel. This includes options for cell formatting, font style and size, alignment, and basic formulas.

Question 12

In Microsoft Excel,the columns are identified by ________.
A) capital letters
B) numbers
C) Roman numerals
D) lowercase letters

Accepted Answer

In Microsoft Excel, the columns are identified and labeled with capital letters from A to Z and then continuing with AA, AB, AC, and so on.

Question 13

In Microsoft Excel,the wide bar of tools and selections that appears just under the tabs is termed the ________.
A) menu tab
B) task pane
C) office button
D) ribbon.

Accepted Answer

The wide bar of tools and selections in Microsoft Excel that appears just under the tabs is called the ribbon. This ribbon contains various tabs with different groups of commands to format cells, insert charts, tables, or pictures, and more.

Question 14

In Excel,every formula must begin with a(n)________ sign.
A) plus
B) minus
C) dollar
D) equality

Accepted Answer

Every formula in Excel must begin with an equality sign (=) to indicate that it is a formula and needs to be calculated.

Question 15

In Microsoft Excel,the intersection of a row and column is called a(n)________.
A) junction
B) content point
C) cell
D) data point

Accepted Answer

The intersection of a row and column in Microsoft Excel is referred to as a cell. It is the smallest unit on a worksheet and can contain data, formulas, text, or other elements. A junction, content point, or data point are not commonly used terms in Excel to refer to the intersection of a row and column.

Question 16

What is the meaning of the formula SUM (C3:C8)?
A) Add all the values starting from the third cell to eighth cell in the third column.
B) Add the all the values starting from the third cell to eighth cell in the third row.
C) Add the values of third cell in the third column and eighth cell in the third column.
D) Add the values of third cell in the third row and eighth cell in the third row.

Accepted Answer

The formula SUM (C3:C8) means add all the values starting from the third cell to eighth cell in the third column.

Question 17

In Excel,the option to change the page orientation is located on the ________ tab.
A) Page Layout
B) View
C) Review
D) Add-ins

Accepted Answer

The Page Layout tab is where options related to formatting and printing of the worksheet are located, including changing the page orientation from portrait to landscape or vice versa. The View tab is focused on changing the view settings such as zoom level or gridlines. The Review tab is used for reviewing and commenting on changes made to the worksheet, while the Add-ins tab contains options for managing add-ins that have been installed in Excel.

Question 18

A Microsoft Excel workbook is a collection of one or more spreadsheets.

Accepted Answer

A Microsoft Excel workbook typically contains multiple spreadsheets or worksheets, arranged in tabs at the bottom of the window.

Question 19

In Excel,the Review tab can be used for ________.
A) creating more complex formulas
B) filtering and sorting data in the spreadsheet
C) tracking changes and making comments
D) formatting the page, often for printing

Accepted Answer

The Review tab in Excel is mainly used for tracking changes made to the spreadsheet and making comments on those changes. This is especially useful when multiple people are working on the same spreadsheet and need to communicate with each other about edits or suggestions. The Review tab includes features such as track changes, comments, and compare that are focused on reviewing and editing the content of the spreadsheet, rather than formatting or creating formulas.

Question 20

The rows in Excel spreadsheet are identified by letters,and the columns are identified by numbers.

Accepted Answer

In Excel, rows are identified by numbers, and columns are identified by letters.

Quiz 17: Introduction to Microsoft Excel

When adding graphs,hyperlinks,or images to a Microsoft Excel worksheet,you use the ________ tab.

In Excel,the term "________" refers to a single spreadsheet.

Which of the following can be used to move the focus to a different cell in the Excel worksheet?

To save a worksheet in Microsoft Excel,you use the Save option in the Edit menu.

In Microsoft Excel,which of the following tabs can be used for filtering and sorting the information in your spreadsheet?

You have entered a formula in the cell G9.Which of the following would occur if you press F2 function key after selecting the cell G9?

Which of the following is the correct method for accessing Microsoft Help?

In Excel,a ________ is a combination of one or more worksheets.

A ________ is a table of data which has rows and columns.

The intersection of a row and a column on a spreadsheet is called a data point.

In Microsoft Excel,most frequently used tools and selections appear under the ________ tab.

In Microsoft Excel,the columns are identified by ________.

In Microsoft Excel,the wide bar of tools and selections that appears just under the tabs is termed the ________.

In Excel,every formula must begin with a(n) ________ sign.

In Microsoft Excel,the intersection of a row and column is called a(n) ________.

What is the meaning of the formula SUM (C3:C8) ?

In Excel,the option to change the page orientation is located on the ________ tab.

A Microsoft Excel workbook is a collection of one or more spreadsheets.

In Excel,the Review tab can be used for ________.

The rows in Excel spreadsheet are identified by letters,and the columns are identified by numbers.