Excel Proficiency Quiz AFS
This is to Enhance your Excel Skills
Questions and Answers
- 1.
Labels are aligned at the ________ edge of the cell.
- A.
Left
- B.
Right
- C.
Top
- D.
Bottom
Correct Answer
A. LeftExplanation
Labels are aligned at the left edge of the cell.Rate this question:
-
- 2.
You can complete a cell entry by pressing
- A.
Enter
- B.
Tab
- C.
Shift+tab
- D.
An arrow key
- E.
Another cell
- F.
All of the Above
Correct Answer
F. All of the AboveExplanation
Pressing "enter", "tab", "shift+tab", an arrow key, or moving to another cell are all ways to complete a cell entry in a spreadsheet. Therefore, the correct answer is "All of the Above" as all of these options can be used to finalize a cell entry.Rate this question:
-
- 3.
The default font keyed in a new work book is.
- A.
12 pt. Times New Romans
- B.
10 pt. Arial
- C.
12 pt. Bradley Hand ITC
- D.
10 pt. Times New Roman
Correct Answer
B. 10 pt. ArialExplanation
The default font in a new workbook is 10 pt. Arial.Rate this question:
-
- 4.
True or False. If you choose a larger font size, the height of the row is automatically made taller.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
If you choose a larger font size, the height of the row is automatically made taller. This is because the font size determines the amount of vertical space that each character occupies. When the font size is increased, the characters become larger and require more vertical space, thus causing the row height to increase.Rate this question:
-
- 5.
Which button allows you to copy cell formats from one cell to another?
- A.
Enter
- B.
Autofit
- C.
Format painter
- D.
Esc
Correct Answer
C. Format painterExplanation
The format painter button allows you to copy cell formats from one cell to another. This tool is useful when you want to apply the same formatting, such as font style, font size, and cell 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 then apply the formatting to other cells by clicking on them.Rate this question:
-
- 6.
A_______ is a group of cells that form a retangle on the screen.
- A.
Label
- B.
Workbook
- C.
Worksheet
- D.
Column
- E.
Range
Correct Answer
E. RangeExplanation
A range is a group of cells that form a rectangle on the screen. It can be a selection of cells, a specific row or column, or even multiple rows and columns. Ranges are commonly used in spreadsheet programs 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?
- A.
It is highlighted on the screen.
- B.
It has a marquee around it.
- C.
The data changes to Bold to let me know it's active
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 worked on. This visual indicator helps the user identify which range they are currently working with and ensures that any actions or changes made will apply to that specific range. The other options, having a marquee around it or the data changing to bold, are not mentioned as indicators of an active range, making them incorrect choices.Rate this question:
-
- 8.
True or False. A range has an address called an range address.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A range in computer programming refers to a group of cells or values within a spreadsheet or document. Each range has an address called a range address, which helps identify and locate the specific range within the document. 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.
- A.
A1:B3
- B.
A1;B3
- C.
A1-B3
- D.
A1=B3
- E.
A1*B3
Correct Answer
A. A1:B3Explanation
The correct answer is A1:B3 because it represents a range of cells in a spreadsheet. The "A1" refers to the top-left cell of the range, and the "B3" refers to the bottom-right cell of the range. This notation is commonly used in spreadsheet programs to specify a group of cells that are adjacent to each other and need to be selected or manipulated together.Rate this question:
-
- 10.
When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________.
- A.
Cell selector
- B.
Cell cross
- C.
Selection pointer
- D.
Range selector
Correct Answer
C. 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 you visually identify and indicate the cells that you are selecting. It allows you to easily choose multiple cells or a range of cells in a spreadsheet or document.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
-
Sep 04, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 01, 2012Quiz Created by
AmericanFleet
Back to top