Excel 1 Final
Intro to Excel, concepts and terms
- 1.
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
- A.
B1-G10
- B.
B1.G10
- C.
B1;G10
- D.
B1:G10
Correct Answer
D. B1:G10Explanation
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is B1:G10. This is because the colon (:) is used to indicate a range of cells, and B1:G10 represents all the cells from B1 to G10 in a rectangular shape.Rate this question:
-
- 2.
If you make a mistake when you create a chart using the wizard, you will have to start again by selecting the range and proceeding through the chart wizard.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
If you make a mistake when creating a chart using the wizard, you do not have to start again by selecting the range and proceeding through the chart wizard. The chart can be edited or modified after it has been created, allowing you to fix any mistakes without having to start from scratch.Rate this question:
-
- 3.
On an Excel sheet the active cell is indicated by ____.
- A.
A darker wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
A. A darker wide borderExplanation
The active cell on an Excel sheet is indicated by a darker wide border. This border helps to identify which cell is currently selected and ready to receive input or perform actions. It stands out from the other cells, making it easier for users to navigate and work with the spreadsheet. The darker wide border serves as a visual cue to indicate the active cell's location and status.Rate this question:
-
- 4.
A 3D refernce means
- A.
Adding a graphic to the spreadsheet
- B.
Reference in a formula to cels on other worksheets
- C.
A special kind of function that uses 3 numbers
- D.
Formatting with 3 colors.
Correct Answer
B. Reference in a formula to cels on other worksheetsExplanation
A 3D reference in a spreadsheet refers to a formula that includes cells from multiple worksheets. This means that the formula is not limited to just one worksheet, but can access and calculate data from different sheets within the same spreadsheet. This can be useful when you need to perform calculations or analysis that involve data from different sources or categories within your spreadsheet.Rate this question:
-
- 5.
If you press _____, the cell accepts your typing as its contents but the focus stays in the cell
- A.
Enter
- B.
CTRL + Enter
- C.
Tab
- D.
Insert
Correct Answer
B. CTRL + EnterExplanation
Pressing CTRL + Enter allows the user to input their typing into the cell as its contents, but the focus remains in the cell. This means that after entering the text, the user can continue editing or performing other actions within the same cell without having to click on another cell. This shortcut is commonly used in spreadsheet applications like Microsoft Excel to quickly input data and move to the next line within the same cell.Rate this question:
-
- 6.
The view that puts a blue line around each page that would be printed is the _____.
- A.
Print Preview
- B.
Normal
- C.
Page Break Preview
- D.
Split View
Correct Answer
C. Page Break PreviewExplanation
The view that puts a blue line around each page that would be printed is the Page Break Preview. In this view, users can see how the content of their document will be divided and displayed on each printed page. The blue line represents the page breaks, allowing users to adjust and modify the layout accordingly. This view is particularly useful for ensuring that the document is properly formatted and that no important content is split between different pages when printed.Rate this question:
-
- 7.
Using the AutoSum button will place in the selected cell _____.
- A.
The sum of values in the cell's column
- B.
Nothing until you select a range of cells
- C.
The sum of the cell's row unless you change the range
- D.
A formula which will add values in the range Excel guesses you want to add
Correct Answer
B. Nothing until you select a range of cellsExplanation
When using the AutoSum button, it will not place anything in the selected cell until you select a range of cells. This means that the AutoSum button will not automatically calculate the sum of values in the cell's column or the sum of the cell's row. It also does not automatically create a formula that adds values in a range guessed by Excel. The AutoSum button simply waits for the user to select a range of cells before performing the desired calculation.Rate this question:
-
- 8.
All text that appears on a chart must be formatted in the same font so that it will have a unified appearance.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because it is not necessary for all text on a chart to be formatted in the same font. Different fonts can be used to highlight different sections or emphasize certain information on the chart. This can help to improve readability and draw attention to important details. Therefore, the text on a chart can be formatted in different fonts to achieve a desired visual effect.Rate this question:
-
- 9.
AutoCalculate will quickly add selected cells if you _____ .
- A.
Right-click on the status bar and select SUM
- B.
Click the AutoCalculate button on the toolbar
- C.
Use the key combo CTRL + $
- D.
Double-click the selection
Correct Answer
A. Right-click on the status bar and select SUMExplanation
To quickly add selected cells in Excel, you can right-click on the status bar and select SUM. This action will instantly display the sum of the selected cells in the status bar at the bottom of the Excel window.Rate this question:
-
- 10.
Once you go to print preview mode, you either have to print or cancel because there is no way to go back and edit your spreadsheet after you have gone that far.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
In print preview mode, you can still go back and edit your spreadsheet. This means that you have the option to make changes to your spreadsheet even after entering print preview mode. Therefore, the statement "Once you go to print preview mode, you either have to print or cancel because there is no way to go back and edit your spreadsheet after you have gone that far" is false.Rate this question:
-
- 11.
To select several cells or ranges that are not touching each other, you would _____ while selecting.
- A.
Hold down the CTRL key
- B.
hold down the SHIFT key
- C.
Hold down the ALT key
- D.
Hold down CTRL + SHIFT
Correct Answer
A. Hold down the CTRL keyExplanation
To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. Holding down the CTRL key allows you to select multiple non-contiguous cells or ranges by clicking on each of them individually. This key modifier is commonly used in spreadsheet software to make non-sequential selections.Rate this question:
-
- 12.
A certain spreadsheet shows in Page Break Preview that cells in Rows 1 - 25 have white background. The cells in Row 26 that contain data have a dark gray background. When you click the Print button, _____.
- A.
Nothing will print because some cells with data have been omitted
- B.
Only the cells with gray background will print
- C.
The whole sheet will print
- D.
Only the cells with white background will print.
Correct Answer
D. Only the cells with white background will print.Explanation
When you click the Print button, only the cells with a white background will print. This is because the Page Break Preview shows that cells in Rows 1-25 have a white background, indicating that they are set to be printed. On the other hand, the cells in Row 26 with a dark gray background are not set to be printed. Therefore, when you click the Print button, only the cells with a white background will be included in the printout.Rate this question:
-
- 13.
A cell is ___?
- A.
A portion of the spreadsheet where you type your formula.
- B.
The intersection of the row and column
- C.
The upper corner that is to the left of the column indicator and above the row indicator.
- D.
Any place on the spreadsheet where you can type.
Correct Answer
B. The intersection of the row and columnExplanation
A cell is the intersection of the row and column in a spreadsheet. This is where data can be entered and calculations can be performed using formulas. Each cell is identified by a unique reference, such as A1 or B5, which indicates its position in the spreadsheet grid.Rate this question:
-
- 14.
When you enter data into a cell and press the Enter key on the keyboard, the cursor will move to ___?
- A.
The cell below the cell where you entered the data
- B.
The cell to the right of where you entered the data.
- C.
it will not move.
- D.
The formula bar so you can double-check your data.
Correct Answer
A. The cell below the cell where you entered the dataExplanation
When you enter data into a cell and press the Enter key on the keyboard, the cursor will move to the cell below the cell where you entered the data. This is the default behavior in most spreadsheet software, including Microsoft Excel. Moving to the cell below allows the user to easily continue entering data in a columnar fashion.Rate this question:
-
- 15.
It is possible in Excel to insert a new row in a range of cells without affecting the entire row on the worksheet.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
In Excel, it is possible to insert a new row within a specific range of cells without affecting the entire row on the worksheet. This can be done by selecting the range of cells where the new row needs to be inserted, right-clicking on the selection, and choosing the "Insert" option. This will shift the existing cells down and create a new row within the selected range, without affecting the rest of the worksheet.Rate this question:
-
- 16.
To select a column the easiest method is to _____.
- A.
Double-click any cell in the column
- B.
Drag from the top cell in the column to the last cell in the column
- C.
Click the column heading
- D.
Click the column label
Correct Answer
C. Click the column headingExplanation
To select a column, the easiest method is to click the column heading. This is because the column heading represents the entire column and clicking on it will automatically select the entire column. This method is quick and efficient as it allows the user to easily select the desired column without the need for any additional steps or actions.Rate this question:
-
- 17.
Which statement regarding formatting is true?
- A.
You can only change the font type and size for text data.
- B.
If you want to add decimal points to a number, your only choice is to use the format menu and then choose cells.
- C.
You can use the autoformat command to create a certain look and then customize it to your individual requirements.
- D.
When you use a “$”, it always appears left justified in the cell.
Correct Answer
C. You can use the autoformat command to create a certain look and then customize it to your individual requirements. -
- 18.
Which of the following is not an example of an Excel function (formula)?
- A.
=SUM(A4:A10)
- B.
=A4:A10
- C.
=AVERAGE(A4:A10)
- D.
=MIN(A4:A10)
Correct Answer
B. =A4:A10Explanation
The correct answer is =A4:A10. This is not an example of an Excel function because it is not a formula that performs a calculation or manipulation of data. It is simply a range of cells (A4 to A10) without any operation or function applied to it.Rate this question:
-
- 19.
Which of the following is a description of the pie chart?
- A.
Display the importance of values over time emphasizing the amount of change
- B.
Display the individual values for comparison.
- C.
Display one data series as a whole. Each of its parts represents a percentage of the whole.
- D.
Show trends over time emphasizing time flow and rate of change.
Correct Answer
C. Display one data series as a whole. Each of its parts represents a percentage of the whole.Explanation
The correct answer describes a pie chart as displaying one data series as a whole, with each part representing a percentage of the whole. This means that a pie chart is used to show the composition or distribution of a single data set. It is commonly used to represent proportions or percentages in a visually appealing way, where the size of each slice of the pie corresponds to the relative magnitude of the data it represents.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 -
Jun 02, 2010Quiz Created by
Frespana
Back to top