Table of Contents
- 1 What is the default option that Excel uses to fill an area?
- 2 What button allows you to choose whether you want to copy the values from the source area to the?
- 3 Which of the following keys moves the insertion point to the end of data in a cell?
- 4 How do you AutoFill horizontally?
- 5 What is a series of adjacent cells called?
- 6 How can you remove borders applied in cells?
- 7 Can you select nonadjacent ranges using Shift key?
- 8 What is the shortcut key to insert current date in a cell?
- 9 Where to find Chapter 3 flashcards in Excel?
- 10 Which is the auto fill option in Excel?
What is the default option that Excel uses to fill an area?
Excel Module 3
| Question | Answer |
|---|---|
| ___________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu. | Fill Series |
| When the Paste Options button is visible, you can use _________________________ to access the paste commands available in the Paste Options gallery. | Keyboard Shortcuts |
Excel Exam Review
| Question | Answer |
|---|---|
| The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. | Autofill Options |
| The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. | Autocorrect |
What effect does the comma style format have on the selected cells?
Cards
| Term _ are a collection of worksheets. | Definition Workbooks |
|---|---|
| Term What effect does the Comma Style Format have on the selected cells? | Definition Causes the cells to display with two decimal places and commas as thousands seperators |
Which of the following keys moves the insertion point to the end of data in a cell?
Excel Module 1 & 2
| Question | Answer |
|---|---|
| Which of the following keys moves the insertion point to the end of the data in the cell? | END |
| The _______ button allows you to erase recent cell entries. | undo |
| Excel remembers the last _______ actions you have completed. | 100 |
| Press _____ to select the entire worksheet. | CTRL+A |
How do you AutoFill horizontally?
As well as working down a column, the Autofill feature also works horizontally, across rows. Simply drag the fill handle across the cells that you want to populate.
What is it called when the text is automatically moves around the graphic?
What is it called when the text is automatically moved around a graphic? rotation handle.
What is a series of adjacent cells called?
Range. Series of two or more adjacent cells in a column or row or a rectangular group of cells.
How can you remove borders applied in cells?
On the Home tab, in the Font group, do one of the following:
- To apply a new or different border style, click the arrow next to Borders. , and then click a border style.
- To remove cell borders, click the arrow next to Borders , and then click No Border .
What is a pie chart with one or more slices offset called?
Cards
| Term If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series. | Definition C. decrement, increment |
|---|---|
| Term A Pie chart with one or more slices offset is called a(n) ____. | Definition B. exploded pie chart |
Can you select nonadjacent ranges using Shift key?
You can select nonadjacent ranges using the SHIFT key.
What is the shortcut key to insert current date in a cell?
To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon).
How do you AutoFill in Excel without dragging?
Simply do the following:
- Select the cell with the formula and the adjacent cells you want to fill.
- Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Where to find Chapter 3 flashcards in Excel?
THIS SET IS OFTEN IN FOLDERS WITH… YOU MIGHT ALSO LIKE… Excel Chapter 03: Working with Large Worksheets, C…
Which is the auto fill option in Excel?
The __ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. Which of following Auto Fill Options menu options is the same as the Fill Series Option? Which of the following cell contents is extended to Qtr 3, Qtr 4, and Qtr 1 by dragging the fill handle?
Which is an extension of the fill pattern Sunday, Tuesday?
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle? Which of the following is an extension of the fill pattern Sunday, Tuesday? The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.