Class VI : Editing Cell Contents In MS Excel
Quiz 2
Lesson 4
Questions and Answers
- 1.
From which bar , you can edit cell contents ?
- A.
Menu Bar
- B.
Formula Bar
- C.
Status Bar
- D.
Office button
Correct Answer
B. Formula BarExplanation
The Formula Bar is the correct answer because it is the specific bar in which you can edit cell contents in a spreadsheet program. The Formula Bar allows users to directly input or modify the contents of a selected cell, including formulas, text, or numbers. It is located at the top of the program window and displays the contents of the currently selected cell, making it easy to edit and update cell data.Rate this question:
-
- 2.
The default row height is 8.43 characters.
- A.
False
- B.
True
Correct Answer
A. FalseExplanation
The given statement is false. The default row height in most spreadsheet applications, including Microsoft Excel, is not measured in characters but in points. The default row height is typically set to a specific point value, such as 15 points, rather than being based on the number of characters that can fit in a row. Therefore, the correct answer is false.Rate this question:
-
- 3.
There are 2 pre-defined series in autofill.
- A.
Names of any class
- B.
Father names
- C.
Student roll no
- D.
Months of the year and days of the week
Correct Answer
D. Months of the year and days of the weekExplanation
The correct answer is "Months of the year and days of the week." This means that when using autofill, the system suggests options from these two series specifically. It is likely that when filling out a form or document, if the user starts typing a month or a day of the week, the autofill feature will provide suggestions based on these series.Rate this question:
-
- 4.
A grid of rectangular cells is called
Correct Answer
Worksheet
worksheetExplanation
A grid of rectangular cells is commonly referred to as a worksheet. It is a common term used in spreadsheet software such as Microsoft Excel or Google Sheets. A worksheet allows users to organize and manipulate data in a tabular format, with each cell containing a specific value or formula. The term "worksheet" can be capitalized or written in lowercase, depending on the context or personal preference.Rate this question:
- 5.
Ctrl+Z is the shortcut key for
Correct Answer
Undo
undoExplanation
Ctrl+Z is the keyboard shortcut for the "Undo" function. This function allows the user to reverse the previous action or restore the document to its previous state. By pressing Ctrl+Z, the user can quickly undo their last action, whether it is deleting text, formatting changes, or any other modification made in the document. The "undo" option is commonly used in various software applications, including word processors, image editors, and even web browsers, to provide users with a convenient way to revert changes and correct mistakes.Rate this question:
- 6.
How many sheets are present on the Sheet Tab?
- A.
3
- B.
4
- C.
1
- D.
2
Correct Answer
A. 3Explanation
There are three sheets present on the Sheet Tab.Rate this question:
-
- 7.
The selected cell , which is identified by a thick black border.
- A.
Cell
- B.
Cell addredd
- C.
None of above
- D.
Active cell
Correct Answer
D. Active cellExplanation
The selected cell is referred to as the active cell because it is currently being used or manipulated. It is distinguished by a thick black border to indicate that it is the currently selected cell in a spreadsheet or table. The active cell is where any data input or editing will take place, and any formulas or functions will be applied to this cell.Rate this question:
-
- 8.
The Undo and Redo commands are present Quick ___________ toolbar
Correct Answer
Access
accessExplanation
The Undo and Redo commands are present in the Quick Access toolbar. This toolbar is a customizable toolbar that allows users to add frequently used commands for easy access. By having the Undo and Redo commands in this toolbar, users can quickly undo or redo their actions without having to navigate through multiple menus or options. This improves efficiency and productivity by providing a convenient and easily accessible way to perform these actions.Rate this question:
- 9.
You can create your own list in the Custom Lists dialog box.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true because in most software applications, including Microsoft Excel, users have the ability to create their own custom lists. This allows users to define their own specific lists of data that can be used for various purposes, such as in data validation or sorting. By accessing the Custom Lists dialog box, users can easily create and manage these custom lists according to their needs and preferences.Rate this question:
-
- 10.
The black square that appears in the botton-right corner of the selected cell range
Correct Answer
Autofill handle
fill handle
autofill handleExplanation
The correct answer for this question is Autofill handle, fill handle, and autofill handle. The autofill handle is a small square that appears in the bottom-right corner of a selected cell range in Microsoft Excel. It allows users to quickly fill adjacent cells with a series of values or patterns, such as numbers, dates, or formulas. The fill handle is another term used to refer to the same feature in Excel. It is a convenient tool for copying and extending data across multiple cells in a worksheet.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 21, 2023Quiz Edited by
ProProfs Editorial Team -
Aug 23, 2015Quiz Created by
SabeenHHS
Back to top