How Well Do You Know Microsoft Excel Quiz?
This quiz is designed to test the knowledge and skills of students enrolled in Office Skills
Questions and Answers
- 1.
When opening Microsoft Excel 2003, the workbook opens with three blank worksheets, but, if necessary, additional worksheets can be added to a maximum of 255.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Microsoft Excel 2003 opens with three blank worksheets by default. However, if needed, additional worksheets can be added up to a maximum of 255. Therefore, the statement "True" is correct.Rate this question:
-
- 2.
A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true. A cell in a spreadsheet is identified by its unique address, which is the intersection of a specific column and row. This address, also known as a cell reference, helps to locate and access specific data within the spreadsheet.Rate this question:
-
- 3.
When the text entered is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the left as long as the adjacent cells contain data.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When the text entered is longer than the width of a column, Excel does not display the overflow characters in adjacent cells to the left. Instead, it displays the overflow characters as "#####" to indicate that the cell is not wide enough to display the entire text. Therefore, the statement is false.Rate this question:
-
- 4.
_______________________, a primary part of Excel, pictorially (or visually) represent(s) data.
- A.
Worksheets
- B.
Charts
- C.
Databases
- D.
Web-support
Correct Answer
B. ChartsExplanation
Charts are a primary part of Excel that visually represent data. They provide a graphical representation of the data, making it easier to analyze and understand patterns, trends, and relationships. Charts can be used to present data in various formats such as bar graphs, line graphs, pie charts, and scatter plots, among others. By visually representing data, charts help users make informed decisions and communicate information effectively.Rate this question:
-
- 5.
A __________________, which is the intersection of a column and row, is the basic unit of a worksheet into which data is entered.
- A.
Cell
- B.
Workbook
- C.
Fill Tool
- D.
Range
Correct Answer
A. CellExplanation
A cell is the basic unit of a worksheet where data is entered. It is the intersection of a column and row, allowing for organized data entry and manipulation. Cells can contain various types of data such as numbers, text, formulas, and functions. They can also be formatted and styled to enhance the visual presentation of the data. Overall, cells play a crucial role in organizing and analyzing data in a worksheet.Rate this question:
-
- 6.
Excel's ______________ provides a convenient means to add the numbers in a range of cells.
- A.
MAX function
- B.
MIN function
- C.
SUM function
- D.
AVERAGE function
- E.
COUNT function
Correct Answer
C. SUM functionExplanation
The correct answer is the SUM function. The SUM function in Excel allows users to easily add up the numbers in a range of cells. By selecting the desired range of cells and using the SUM function, Excel will automatically calculate the total sum of the numbers in that range. This provides a convenient and efficient way to perform addition operations in Excel.Rate this question:
-
- 7.
To select any cell (in the entire worksheet), click in the _____________ located on the left side of the formula bar and enter the cell reference of the desired cell. (This can help you to quickly jump directly to any cell on the entire worksheet!)
- A.
AutoSum Area
- B.
Name Box
- C.
AutoScroll Area
- D.
Formula Bar
- E.
AutoCalculate Area
Correct Answer
B. Name BoxExplanation
The correct answer is Name Box. The Name Box is located on the left side of the formula bar in Microsoft Excel. By clicking in the Name Box and entering the cell reference of the desired cell, you can quickly jump directly to that cell on the entire worksheet. This is a handy feature that allows for easy navigation within a large worksheet.Rate this question:
-
- 8.
As shown in the accompanying figure, when Excel starts it creates a new empty ____________________, called Book1, which is like a notebook.
Correct Answer
workbook
work book
Work Book
WorkbookExplanation
When Excel starts, it creates a new empty workbook, which is like a notebook. A workbook in Excel is a file that contains multiple worksheets where data can be organized and analyzed. The term "workbook" refers to this specific file format and is commonly used to describe the main document in Excel. The variations in capitalization ("work book," "Work Book," "Workbook") are incorrect and do not accurately represent the standard naming convention for a workbook in Excel.Rate this question:
- 9.
Mr. Connors refers to Microsoft Excel as a “super _____________,” because of all the data it can hold.
Correct Answer
calculator
calculater
calculatarExplanation
Mr. Connors refers to Microsoft Excel as a "super calculator" because of all the data it can hold.Rate this question:
- 10.
Each cell has a unique address or name called the "cell ____________________."
Correct Answer
reference
refrence
Reference
RefrenceExplanation
Each cell in a spreadsheet has a unique address or name called the "cell reference." This reference is used to identify and locate a specific cell within the spreadsheet. It allows users to easily navigate and manipulate data by referring to specific cells in formulas, functions, or data analysis. The reference can be written in different formats, such as a combination of column and row labels (e.g., A1) or a named range.Rate this question:
Back to top