A ________ is a prewritten formula that is built into Excel.
A. function
B.feature
C. task
D. calculation
answer
function
question
To start a new line in a cell, press the ____ keys
A. CTRL+ENTER
B. TAB+ENTER
C. ALT+ENTER
D. SHIFT + ENTER
answer
ALT+ENTER
question
When you enter a two digit year that is less than 30, Excel changes the year to______
A. 20xx
B. 30xx
C. 18xx
D. 19xx
answer
20xx
question
All of the following are valid Excel arithmetic operators except______
A. ^
B. *
C. %
D. >
answer
>
question
Which of the following calculations multiplies 23 by 0.01?
=23% =23 =23+.01 =24-.01
answer
=23%
question
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _______ that you use in algebra.
placement
positioning
operations
selections
answer
operations
question
When excel follows the order of operations the formul, 8*3+2 equals_______
40
26
48
13
answer
26
question
Which of the following happens when you enter the formula =G15 into a cell?
Excel recalculates all formuals in the worksheet
Excel assigns the sum of the values in the previous 15 cells to the active cell
Excel assigns the value in cell G15 to the active cell
Nothing, =G15 is an invalid formula
answer
Excel assigns the value in cell G15 to the active cell
question
Point mode allows you to _____
select cells for use in a formula using the keyboard
select a function from the Sum button list
select cells for use in a formula using the mouse pointeredit cell contents directly in the cell
answer
select cells for use in a formula using the mouse pointer
question
The adjusted cell references in a copid and pasted formula are called _____ references.
related
relative
pasted
alternative
answer
relative
question
Which of the following is the path to the Copy and Paste buttons?
(home tab/ Copy group)
(home tab/ paste group)
(home tab/ Clipboard group)
(home tab/Formulas group)
answer
(home tab/ Clipboard group)
question
You can click the ______ button to undo an automatic correction.
auto Fill options
autocorrect options
Paste options
Trace err0r
answer
autocorrect options
question
Which of the following Option buttons fives options for filling cells following a fill operation?
Autofill options
Auto Correct options
Insert Options
Paste Options
answer
Auto Fill Options
question
The ______ options button lists error checkingoptions following the assignment of an invalid formula to a cell.
find error
explain error
fix error
trace error
answer
trace error
question
You can select a range using the keyboard by pressing the ____ key and the and ARROW key
F2
f4
F6
F8
answer
F8
question
The ____ option button lists formatting options following an insertion of cells, row, or columns
autocorrect
insert
auto fill
paste
answer
insert
question
A ____ cell in Excel has numerical value of zero.
blank
formatted
copied
filled
answer
blank
question
The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
MIN
SUM
AVERAGE
MAX
answer
AVERAGE
question
The _______ Autocomplete list contains those functions that alphabetically match the letter you type following the equal sign.
function
formula
equal
calculate
answer
formula
question
Excel automatically appends the _______ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
left parentesis
right bracket
right parenthesis
left bracket
answer
right parenthesis
question
Which of the following is the path to the Sum button?
editing tab/home group
home tab/Editing group
Hometab/ Clipboard group
Calculation tab/ editing group
answer
hometab/editing group
question
You should _____ a function name in the Formula AutoComplete list to select the function.
doubleclick
click
right click
none of the above
answer
double click
question
The ______ function displays the highest value in a range.
MIN
SUM
MAX
AVERAGE
answer
MAX
question
clicking the _____ opends the Insert Function dialog box shown int eh accompanying figure.
Insert function box on the formula bar
function dialog box launcher
Function button
Functions and formulas button on the status bar
answer
insert function box on the formula bar
question
The ______ function determines the lowest number in a range
MAX
AVERAGE
SUM
MIN
answer
MIN
question
To copy cell contents you can select teh cell and then press the _____ keys.
CTRL+V
CTRL+X
CTRL+B
CTRL+C
answer
CTRL+C
question
To paste copied cell contents you can press the _____ keys.
CTRL+C
CTRL+P
CTRL+V
CTRL+X
answer
CTRL+V
question
you can use the ____ to check which cells are referenced int he formula assigned to the active cell.
formula finder
range finder
calculation finder
function finder
answer
Range finder
question
A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
scheme
gallery
theme
style
answer
theme
question
You can open the Format Cells dialog box by pressing the ______ keys.
SHIFT+TAB
CTRL+1
ALT+1
SHIFT+F1
answer
CTRL+1
question
The most popular background color is_____
blue
white
red
yellow
answer
blue
question
The ________ displays numbers with a fixed dollar sing to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
comma style
accounting number
percent style
currnecy style
answer
accounting
question
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign.
fixed
formatted
floating
none of the above
answer
fixed
question
Which of the following is the path to the Comma style button?
Hometab/ Alignment tab
Hometab/ Fontgroup
Hometab/ Cells group
Hometab/ number group
answer
hometab/ number group
question
Which of the following is the path to the Conditional Formatting button?
Hometab/Editinggroup
Stylestab/Formattinggroup
Formatting group/ Styles group
Hometab/ styles group
answer
hometab/ styles group
question
If you do not assign a format to a cell or cells in a column, the column width will remain ______ characters.
8.43
7.52
11.65
9.43
answer
8.43
question
Which of the following is the path to the Spelling button?
Hometab/ Progging group
Proofing tab/ spelling group
Review tab/ Proofing group
Reiveiw tab/ checking group
answer
review tab/ proofing group
question
_____ allows you to create or modigy a worksheet while viewing how it will look in printed format.
normal
page layout
page break preview
full screen
answer
page layout
question
To pring a range of cells in teh actinve worksheet, click _______ in the Settings area in the Print gallery, as shown in the accompanying figure.
print active sheets
print selection
print entire workbook
none of the above
answer
print selection
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy