Excel Basics Quiz 1
Answer the following.
Questions and Answers
- 1.
A workbook is also called a __________________ .
- A.
Template
- B.
Spreadsheet
- C.
Document
Correct Answer
B. SpreadsheetExplanation
A workbook is also called a spreadsheet because it is a file that contains multiple sheets or tabs, each of which can be used to organize and analyze data in a grid-like format. Spreadsheets are commonly used for tasks such as calculations, data analysis, and creating charts or graphs. The term "spreadsheet" is often used interchangeably with "workbook" to refer to the file that contains the spreadsheet data and formulas.Rate this question:
-
- 2.
The________ bar displays both the name of the application and the name of the spreadsheet.
- A.
Title
- B.
Menu
- C.
Formula
Correct Answer
A. TitleExplanation
The correct answer is "title". The title bar is the horizontal bar at the top of the application window that displays the name of the application and the name of the currently opened spreadsheet. It provides important information about the current document or application and allows users to easily identify and switch between different files or applications.Rate this question:
-
- 3.
Example of:
- A.
Titles
- B.
Row headings
- C.
Column headings
Correct Answer
C. Column headingsExplanation
The correct answer is "column headings" because in the given example, the question is asking for an explanation of the correct answer. The answer itself is "column headings" which suggests that the question is asking for an explanation of the titles, row headings, and column headings.Rate this question:
-
- 4.
Example of:
- A.
Name box
- B.
Title box
- C.
Pointer box
Correct Answer
A. Name boxExplanation
The given answer "name box" is correct because it accurately identifies one of the examples mentioned in the question. The question asks for examples, and "name box" is a valid example of a type of box.Rate this question:
-
- 5.
Example of:
- A.
Title bar
- B.
Name bar
- C.
Formula bar
Correct Answer
C. Formula barExplanation
The formula bar is a feature in computer software, specifically in spreadsheet programs like Microsoft Excel. It is a toolbar located at the top of the program window where users can enter or edit formulas or data. The formula bar displays the contents of the currently selected cell and allows users to input or modify data directly. It is an essential tool for working with formulas and performing calculations in spreadsheets.Rate this question:
-
- 6.
A ________ is an intersection of a column and row.
- A.
Cell
- B.
Name box
- C.
Title box
Correct Answer
A. CellExplanation
A cell is an intersection of a column and row. In a spreadsheet or table, data is organized in rows and columns, and each individual square where a row and column intersect is called a cell. Cells are used to input and display data, perform calculations, and apply formatting. They are the basic building blocks of a spreadsheet or table, allowing for the organization and manipulation of data in a structured manner.Rate this question:
-
- 7.
A Workbook defaults to __________ worksheets. A Workbook must contain at least one worksheet.
- A.
One
- B.
Three
- C.
Two
Correct Answer
B. ThreeExplanation
A Workbook defaults to three worksheets. A Workbook is a file that contains multiple worksheets, and by default, it is created with three worksheets. However, it is possible to add or remove worksheets as needed. It is important for a Workbook to have at least one worksheet, as it is the primary component where data can be entered, edited, and organized.Rate this question:
-
- 8.
Identify the cell address.
- A.
3C
- B.
C3
- C.
C
Correct Answer
B. C3Explanation
The correct answer is C3. This is the correct cell address because it follows the standard format for cell addresses in spreadsheets, where the letter represents the column and the number represents the row. In this case, "C" represents the third column and "3" represents the third row, so the cell address is C3.Rate this question:
-
- 9.
- The __________ cell is the cell that receives the data or command you give it.
- A.
Active
- B.
Live
- C.
Working
- 10.
The ____________________located along the right edge of the screen is used to move up or down the spreadsheet.
- A.
Page up
- B.
Horizontal scroll bar
- C.
Vertical scroll bar
Correct Answer
C. Vertical scroll barExplanation
The vertical scroll bar, located along the right edge of the screen, is used to move up or down the spreadsheet. It allows users to navigate through the rows of data in a spreadsheet, making it easier to view and access information that is not visible on the current screen. The page up key is typically used to move up a page at a time, while the horizontal scroll bar is used to move left or right along the spreadsheet.Rate this question:
-
- 11.
You can enter three types of data in a cell:
- A.
Text and numbers
- B.
Text, numbers, and formulas
- C.
Formulas and numbers
Correct Answer
B. Text, numbers, and formulasExplanation
In a cell, you can enter text, numbers, and formulas. Text can be used to input any kind of textual information, such as names or descriptions. Numbers can be used for calculations or to represent quantities. Formulas allow you to perform calculations using cell references and mathematical operators. By combining these three types of data, you can create dynamic and informative spreadsheets.Rate this question:
-
- 12.
Enter
- A.
Enter
- B.
Cancel
- C.
Formula
Correct Answer
A. EnterExplanation
The given correct answer is "enter" because it is the only option that is correctly spelled and makes sense in the context of the question. The other options, such as "cancel" and "formula," do not fit with the word "enter" and are unlikely to be the correct answer.Rate this question:
-
- 13.
Feature keeps track of previously-entered text.
- A.
Autoenter
- B.
Autocheck
- C.
AutoComplete
Correct Answer
C. AutoCompleteExplanation
The feature that keeps track of previously-entered text is called AutoComplete. This feature predicts and suggests previously entered words or phrases as the user types, making it easier and quicker to enter repetitive or commonly used text. It saves time and reduces typing effort by offering suggestions based on the user's input history.Rate this question:
-
Correct Answer
A. Active
A. Active
Explanation
The active cell is the cell that receives the data or command you give it. It is the cell that is currently selected or highlighted in a spreadsheet or worksheet. When you input data or a command, it is applied to the active cell.
The active cell is the cell that receives the data or command you give it. It is the cell that is currently selected or highlighted in a spreadsheet or worksheet. When you input data or a command, it is applied to the active cell.
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 20, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 28, 2011Quiz Created by
Daisyjones
Back to top