Excel Flashcards
The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.
a. database
c. expression
b. spreadsheet
d. formula
spreadsheet
Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.
a. KeyTips
c. ShortTips
b. ScreenTips
d. shortcuts
shortcuts
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.
a. Touch Mode
c. Tap Mode
b. Click Mode
d. Normal Mode
touch mode
“AZ” is an example of a ____.
a. column heading
c. cell reference
b. row heading
d. Name box
column heading
To go to column A of the current row, press ____.
a. Ctrl + Home
c. Shift + Tab
b. Home
d. Tab + Enter
home
An Excel worksheet can have a maximum of ____ columns in a worksheet.
a. 156
c. 16,384
b. 256
d. 17 million
16384
To make A1 the active cell, you should press which of the following keys?
a. Page Up
c. Home
b. Page Down
d. Ctrl + Home
ctrl + home
You can move to the previous or next sheet by pressing the ____ keys.
a. Alt + Page Up or Alt + Page Down
c. Tab + Page Up or Tab + Page Down
b. Ctrl + Page Up or Ctrl + Page Down
d. F4 + Page Up or F4 + Page Down
Ctrl + Page Up or Ctrl + Page Down
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 ____.
a. semi-colon
c. colon
b. period
d. comma
colon
The characters +, -, *, and / are examples of ____.
a. formulas
c. arithmetic operators
b. values
d. calculations
arithmetic operators
An Excel formula always begins with a(n) ____.
a. parentheses
c. plus sign
b. equals sign
d. colon
equal sign
The formula used to multiply cell A1 by cell C1 is ____.
a. =A1C1
c. =A1/C1
b. C1A1
d. A1*C1
=A1*C1
A(n) ____ is a group of cells in a rectangular block.
a. cluster
c. selection
b. adjunct
d. range
range
In the figure above, Box 1 points to the formula =F13*G13 in the ____.
a. address box
c. formula box
b. address bar
d. formula bar
formula bar
In the figure above Box 3, points to color coded ____ references.
a. cell
c. row
b. formula
d. function
cell
In the figure above, Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.
a. cell F13
c. cell G13
b. cell H13
d. cell H13
cell H13
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
a. right
c. down
b. up
d. left
right
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.
a. Ctrl + Enter
c. Alt + E
b. Alt + Enter
d. Ctrl + E
Alt + Enter
What is the result of the expression =50+20/10*5?
a. 60
c. 25
b. 1
d. 50
60
To change the order of operations, enclose part of the formula in ____.
a. brackets
c. parentheses
b. italics
d. quotation marks
parentheses
Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.
a. color coding
c. highlighting
b. bolding
d. italicizing
color coding
To switch to ____ mode, you double-click the cell.
a. Insert
c. Edit
b. Copy
d. Paste
edit
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.
a. QuickFit
c. Full Column
b. AutoFit
d. Longest
autofit
____ makes it easier to enter repetitive text in cells.
a. Editing mode
c. AutoComplete
b. AutoFit
d. AutoFill
auto complete
Which of the following takes precedence over multiplication?
a. division
c. addition
b. exponentiation
d. subtraction
exponentiation
____ enters text based on patterns it finds in the data.
a. AutoComplete
c. AutoFit
b. Flash Fill
d. Fill
flash fill
In ____ orientation, a page is taller than it is wide.
a. natural
c. portrait
b. landscape
d. basic
portrait
____ displays the location of the different page breaks within the worksheet.
a. Normal
c. Page Break Preview
b. Page Preview
d. Page Break Layout
page break preview
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.
a. shrink
c. scale
b. size
d. scroll
scale
according to the order of operation in Excel:
a. Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
b. Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction.
c. Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition.
d. Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.
Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
To move the active cell up one row, press ____.
a. Shift + Enter
c. Shift + Tab
b. Ctrl + Tab
d. Ctrl + Enter
shift enter
Which of the following will not change the location of the active cell?
a. drag and drop
c. clicking another cell
b. scrolling
d. clicking a column heading
scrolling