|
Spreadsheet |
The advantage of an electronic ___ is that the content can be easily edited and updated to reflect changing financial conditions. |
|
Shortcuts |
Keyboard ___ can help you work faster and more efficiently because you can keep your hands on the keyboard. |
|
Touch Mode |
In ___, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need. |
|
Column Heading |
"AZ" is an example of a ___. |
|
Home |
To go to Column A of the current row, press ___. |
|
16,384 |
An Excel worksheet can have a maximum of ___ columns in a worksheet. |
|
Ctrl + Home |
To make A1 the active cell, you should press which of the following keys? |
|
Ctrl + Page Up or Ctrl + Page Down |
You can move to the previous or next sheet by pressing the ___ keys. |
|
Colon |
Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ___. |
|
Arithmetic Operators |
The characters +,-,*, and / are examples of ___. |
|
Equals Sign |
An Excel formula always begins with an ___. |
|
=A1*C1 |
The formula used to multiply cell A1 by cell C1 is ___. |
|
Range |
A ___ is a group of cells in a rectangular block. |
|
Left |
When you insert a new column, the existing columns are shifted to the ___ and the new column has the same width as the column directly to its left |
|
Alt + Enter |
If you want to create a new line within a cell, press the ___ keys to move the insertion point to the next line within the cell. |
|
60 |
What is the result of the expression =50+20/10*5? |
|
Parentheses |
To change the order of operations, enclose part of the formula in ___. |
|
Color coding |
Excel makes reading formulas simpler by ___ each cell reference in the formula and its corresponding cell in the worksheet. |
|
Edit |
To switch to ___ mode, you double-click the cell. |
|
AutoFit |
To change a column width, you can click ___ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column. |
|
AutoComplete |
___ makes it easier to enter repetitive text in cells. |
|
Exponentiation |
Which of the following takes precedence over multiplication? |
|
Flash fill |
___ enters text based on patterns it finds in the data. |
|
Portrait |
In ___ orientation, a page is taller than it is wide. |
|
Page Break Preview |
___ displays the location of the different page breaks within the worksheet. |
|
Scale |
You can ___ the width or the height of the printout so that all of the columns or all of the rows fit on a single page. |
|
Excel performs to exponentiation, then multiplication and division, then addition, and subtraction. |
According to the order of operation in Excel: |
|
Shift + Enter |
To move the active cell up one row, press ___. |
|
Scrolling |
Which of the following will not change the location of the active cell? |
|
An outline of the new location of the selected range |
When you copy a selection of cells using drag and drop, which appears before you release the mouse button? |
|
=SUM(F6:F9) |
What is the syntax for a SUM formula adding the values of cell F6 to F9? |
|
Go to a location in the worksheet command |
Ctrl + G is used to access the ___. |
|
A date format |
mm/dd/yyyy is known as ___. |
|
Ctrl + S |
Whenever you click the Save button on the Quick Access Toolbar or press the ___ keys, the workbook file is updated to reflect the latest content. |
|
2,1,3 |
To move or copy a range of cells, select the correct order. |
Share This
Flashcard
