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
- 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
- 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
- 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.
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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.
- 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.
- 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.
- 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
- 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
- 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.
- 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)
- 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.
Questions: 22 | Attempts: 5458 | Last updated: Dec 16, 2020
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Questions: 29 | Attempts: 3197 | Last updated: May 4, 2016
-
Sample QuestionFrom the following list, select the choice that is a 3D formula in Excel.
Questions: 8 | Attempts: 3133 | Last updated: Jun 7, 2019
-
Sample QuestionThe advantage of using a spreadsheet is:
Back to top