Excel Lesson 2-creating A Workbook
This quiz concerns Excel Lesson 2-Creating a workbook.
- 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
Correct Answer(s)
A. Enter
B. Tab
C. Shift+tab
D. An arrow key
E. Another cellExplanation
To complete a cell entry in a spreadsheet, you can use the following methods: pressing the enter key, pressing the tab key, pressing shift+tab to move to the previous cell, using an arrow key to navigate to another cell, or simply selecting another cell. Each of these actions allows you to finalize the input in the current cell and move on to the next one or perform a different action.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.
Correct Answer
trueExplanation
When you choose a larger font size, the height of the row is automatically adjusted to accommodate the larger text. This is because the height of a row is determined by the tallest element within it, which in this case would be the larger text. Therefore, selecting a larger font size will result in a taller row to ensure that the text is fully visible and properly displayed.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 feature is useful when you want to apply the same formatting, such as font style, color, and borders, to multiple cells without manually adjusting each one. By selecting the format painter button and then clicking on the cell or range of cells you want to apply the formatting to, you can quickly and easily copy the formatting from one cell to another.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 include multiple rows and columns, and is often used to perform calculations or apply formatting to a specific set of cells.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
- D.
I'm psychic & I just Know!!
Correct Answer
A. It is highlighted on the screen.Explanation
The correct answer is "It is highlighted on the screen." When a range is active, it is visually distinguished from other ranges on the screen by being highlighted. This visual cue helps the user identify which range they are currently working with and prevents confusion when navigating through different ranges in a document or spreadsheet.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 a computer program or spreadsheet refers to a group of cells. Each range has a specific address called a range address, which is used to identify and refer to that particular range of cells. Therefore, the statement 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 letter "A" refers to the column and the number "1" refers to the row of the first cell in the range. The colon ":" is used to indicate a range. The letter "B" refers to the column and the number "3" refers to the row of the last cell in the range. Therefore, A1:B3 represents a range of cells from A1 to B3.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 selecter
- B.
Cell cross
- C.
Selection pointer
- D.
Range selecter
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 the range of cells you are selecting and indicates the starting point of your selection.Rate this question:
-
- 11.
If labels spill onto the column to it's right & the column on the right is not empty you need to ________________.
- A.
Resize the column
- B.
Complete your calculations by hand, excel is too hard to learn.
- C.
Select the column to delete it, you didn't need it anyway.
- D.
Leave it the way it is.
- E.
Widen it so the label is not cut off.
Correct Answer(s)
A. Resize the column
E. Widen it so the label is not cut off.Explanation
If labels spill onto the column to its right and the column on the right is not empty, you need to resize the column or widen it so that the label is not cut off.Rate this question:
-
- 12.
A__________ is a single point of color on the screen.
- A.
Pixel
- B.
Cell
- C.
Border
- D.
Margin
Correct Answer
A. PixelExplanation
A pixel is a single point of color on the screen. It is the smallest unit of measurement in a digital image or display. Pixels combine together to form images and are responsible for creating the visuals we see on screens. Each pixel represents a specific color and when millions of pixels are combined, they create a complete image. Therefore, a pixel is the correct answer as it accurately describes a single point of color on the screen.Rate this question:
-
- 13.
A value is always _____________ aligned in the cells & is included in calculations.
- A.
Left
- B.
Centered
- C.
Justified
- D.
Right
Correct Answer
D. RightExplanation
Values in cells are typically aligned to the right. When a value is aligned to the right, it means that it is positioned towards the right side of the cell. This alignment is commonly used for numerical data, as it allows for easier reading and comparison of values. Additionally, when values are aligned to the right, they are included in calculations such as summing or averaging the values in a range of cells.Rate this question:
-
- 14.
This button allows you to incorporate the currency format to data.
- A.
.
- B.
%
- C.
=
- D.
-
- E.
$
Correct Answer
E. $Explanation
This answer suggests that the button mentioned in the question allows the user to incorporate the currency format to data. The symbol "$" is commonly used to represent currency, so selecting this button would likely apply the dollar currency format to the data.Rate this question:
-
- 15.
When you key the date, excel applies a standard format that shows:
- A.
2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year.
- B.
Excel leaves it exactly the way I type it!
- C.
The formula to change the date.
Correct Answer
A. 2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year.Explanation
When you key the date in Excel, it applies a standard format that shows 2 digits for the month, 2 digits for the day, and either 2 or 4 digits for the year. This means that if you type a date like "01/05/2022", Excel will display it as "01/05/22" or "01/05/2022" depending on the format applied. Excel does not automatically change the date or apply any formula to it, it simply displays it according to the standard format.Rate this question:
-
- 16.
What does the function Sum do?
- A.
Adds the values in the range & then divides by the number of cells in the range.
- B.
Determines the largest value in a range.
- C.
Multiplies the values in a range.
- D.
Adds the values in the cell
Correct Answer
D. Adds the values in the cellExplanation
Sum-Adds the values in the cell
Average-adds the values in the range & then divides by the number of cells in the range
Max-Determins the largest value in a range.Rate this question:
-
- 17.
You can check results of your calculations by using:
- A.
Auto fit
- B.
Auto replace
- C.
Auto correct
- D.
Auto calculate
Correct Answer
D. Auto calculateExplanation
The given correct answer is "Auto calculate" because it suggests that you can verify the accuracy of your calculations by using an automatic calculation feature. This feature allows you to perform calculations in a spreadsheet or software program, ensuring that the results are correct without manual calculation.Rate this question:
-
- 18.
A_________ is a built in mathematical formula included in excel.
- A.
Cell
- B.
Formula
- C.
Range
- D.
Range address
- E.
Function
Correct Answer
E. FunctionExplanation
A function is a built-in mathematical formula included in Excel that allows users to perform calculations, manipulate data, and automate tasks. Functions can be used to perform a wide range of operations, such as summing numbers, finding averages, counting cells, and more. They are predefined formulas that can be easily applied to cells or ranges in Excel to perform specific calculations or operations.Rate this question:
-
- 19.
A________ is a series of instructions that performs a calculation & displays an answer.
- A.
Function
- B.
Formula
- C.
Range
- D.
Cell
Correct Answer
B. FormulaExplanation
A formula is a series of instructions that performs a calculation and displays an answer. It is used in spreadsheets or programming to automate calculations and generate results based on given inputs. Formulas can include mathematical operators, functions, and references to cells or ranges of data. When a formula is executed, it performs the specified calculations and displays the resulting value.Rate this question:
-
- 20.
Formula's always start with:
- A.
=
- B.
-
- C.
*
- D.
+
- E.
/
Correct Answer
A. =Explanation
The correct answer is =. This is because in most mathematical equations or formulas, the equal sign (=) is used to indicate that the expression on the left side is equal to the expression on the right side. It is the symbol that represents equality in mathematics.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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 30, 2009Quiz Created by
Nmays
Back to top