The MS Excel Basics Quiz! Trivia Test
-
Labels are aligned at the ________ edge of the cell.
-
Left
-
Right
-
Top
-
Bottom
-
Are you confident enough to think that you can pass this MS Excel basics quiz? A lot of people have a hard time when it comes to using Microsoft Excel, and this is because of the complexity of how data is input. In this quiz, you will get to see just how much you know about the tool and some See moreof the shortcuts one uses to perfect their data entry. Do take up the quiz and get to see just how well you understand it.
(109).jpg "The MS Excel Basics Quiz! Trivia Test - Quiz")
Quiz Preview
- 2.
You can complete a cell entry by pressing
-
Enter
-
Tab
-
Shift+tab
-
An arrow key
-
Another cell
Correct Answer(s)
A. Enter
A. Tab
A. Shift+tab
A. An arrow key
A. Another cellExplanation
You can complete a cell entry in a spreadsheet by pressing the enter key, which moves the cursor to the cell below. Alternatively, you can press the tab key, which moves the cursor to the cell on the right. Shift+tab can be used to move the cursor to the cell on the left. An arrow key can also be used to move the cursor in any direction. Finally, you can also complete a cell entry by selecting another cell, which automatically saves the current entry.Rate this question:
-
- 3.
The default font keyed in a new workbook is
-
12 pt. Times New Romans
-
10 pt. Arial
-
12 pt. Bradley Hand ITC
-
10 pt. Times New Roman
Correct Answer
A. 10 pt. ArialExplanation
The default font in a new workbook is 10 pt. Arial.Rate this question:
-
- 4.
If you choose a larger font size, the height of the row is automatically made taller.
-
True
-
False
Correct Answer
A. TrueExplanation
When selecting a larger font size, the height of the row is automatically adjusted to accommodate the larger text. This means that if you choose a larger font size, the row will become taller in order to properly display the larger text. Therefore, the statement "If you choose a larger font size, the height of the row is automatically made taller" is true.Rate this question:
-
- 5.
Which button allows you to copy cell formats from one cell to another?
-
Enter
-
Autofit
-
Format painter
-
Esc
Correct Answer
A. Format painterExplanation
The format painter button allows you to copy cell formats from one cell to another. This feature is useful when you want to quickly apply the same formatting, such as font style, color, and borders, to multiple cells without manually adjusting each one. By selecting the cell with the desired format and clicking on the format painter button, you can easily apply the same format to other cells by clicking on them.Rate this question:
-
- 6.
A_______ is a group of cells that form a rectangle on the screen.
-
Label
-
Workbook
-
Worksheet
-
Column
-
Range
Correct Answer
A. RangeExplanation
A range is a group of cells that form a rectangle on the screen. It can include multiple rows and columns, allowing for the selection and manipulation of a specific area of a spreadsheet. Ranges are commonly used in spreadsheet applications to perform calculations, apply formatting, or manipulate data within a specific area of a worksheet.Rate this question:
-
- 7.
How do you know a range is active?
-
It is highlighted on the screen.
-
It has a marquee around it.
-
The data changes to Bold to let me know it's active
-
I'm psychic & I just Know!!
Correct Answer
A. It is highlighted on the screen.Explanation
The correct answer is that a range is active when it is highlighted on the screen. This means that the range is currently selected or being used for a specific operation. This visual indicator helps the user identify which range is currently active and allows them to perform actions or make changes within that range.Rate this question:
-
- 8.
A range has an address called a range address.
-
True
-
False
Correct Answer
A. TrueExplanation
A range in this context refers to a group of cells in a spreadsheet or a specific section of data. Each range is identified by its address, which is known as a range address. This address helps to locate and reference the range when performing operations or calculations. Therefore, the statement that a range has an address called a range address is true.Rate this question:
-
- 9.
An example of a range address.
-
A1:B3
-
A1;B3
-
A1-B3
-
A1=B3
-
A1*B3
Correct Answer
A. A1:B3Explanation
The correct answer is A1:B3 because it represents a range of cells in a spreadsheet. The format A1:B3 indicates that the range starts from cell A1 and ends at cell B3, including all the cells in between. This range can be used to perform calculations or apply formatting to multiple cells at once.Rate this question:
-
- 10.
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________.
-
Cell selector
-
Cell cross
-
Selection pointer
-
Range selector
Correct Answer
A. Selection pointerExplanation
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a selection pointer. This pointer helps to indicate that you are in the process of selecting cells and allows you to easily drag and highlight the desired range.Rate this question:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
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 -
Jan 07, 2013Quiz Created by
Amethbc
Back to top