OAD 232, EXCEL, CHAPTER 2, FORMULAS, FUNCTIONS, AND FORMATTING – Flashcards
Unlock all answers in this set
Unlock answersquestion
A __ IS A PREWRITTEN FORMULA THAT IS BUILT INTO EXCEL
answer
FUNCTION
question
TO START A NEW LINE IN A CELL, PRESS THE __ KEYS
answer
ALT + ENTER
question
WHEN YOU ENTER A TWO-DIGIT YEAR THAT IS LESS THAN 30, EXCEL CHANGES THE YEAR TO __
answer
20XX
question
ALL OF THE FOLLOWING ARE VALID EXCEL ARITHMETIC OPERATORS
answer
^ * %
question
WHICH OF THE FOLLOWING CALCUATIONS MULTIPLIES 23 BY 0.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
answer
OPERATIONS
question
WHEN EXCEL FOLLOWS THE ORDER OF OPERATIONS, THE FORMULA, 8*3+2, EQUALS __
answer
26
question
THE FOLLOWING HAPPENS WHEN YOU ENTER THE FORMULA =G15 INTO A CELL
answer
EXCEL ASSIGNS THE VALUE IN CELL G15 TO THE ACTIVE CELL
question
THE ADJUSTED CELL REFERENCES IN A COPIED AND PASTED FORMLA ARE CALLED __ REFERENCES
answer
RELATIVE CELL
question
THE FOLLOWING IS THE PATH TO THE COPY AND PAST BUTTONS
answer
(HOME TAB/CLIPBOARD GROUP)
question
YOU CAN CLICK THE __ BUTTON TO UNDO AN AUTOMATIC CORRECTION
answer
AUTOCORRECT OPTIONS
question
THE FOLLOWING OPTION BUTTONS GIVE OPTIONS FOR FILLING CELLS FOLLOWING A FILL OPERATION
answer
AUTO FILL OPTIONS
question
THE __ OPTIONS BUTTON LISTS ERROR-CHECKING OPTIONS FOLLOWING THE ASSIGNMENT OF AN INVALID FORMULA TO A CELL.
answer
TRACE ERROR
question
YOU CAN SELECT A RANGE USING THE KEYBOARD BY PRESSING THE __ KEY AND THEN AN ARROW KEY.
answer
F8
question
THE __ OPTION BUTTON LISTS FORMATTING OPTIONS FOLLOWING AN INSERTION OF CELLS, ROWS, OR COLUMNS
answer
INSERT
question
A __ CELL IN EXCEL HAS A NUMERICAL VALUE OF ZERO.
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.
answer
AVERAGE
question
THE __ AUTOCOMPLETE LIST CONTAINS THOSE FUNCTIONS THAT ALPHABETICALLY MATCH THE LETTERS YOU TYPE FOLLOWING THE EQUAL SIGN.
answer
FORMULA
question
EXCEL AUTOMATICALLY APPENDS THE __ TO COMPLETE THE AVERAGE FUNCTION WHEN YOU CLICK THE ENTER BOX OR PRESS THE ENTER KEY.
answer
RIGHT PARENTHESIS
question
THE FOLLOWING IS THE PATH TO THE SUM BUTTON
answer
(HOME TAB/EDITING GROUP)
question
YOU SHOULD __ A FUNCTION NAME IN THE FORMULA AUTOCOMPLETE LIST TO SELECT THE FUNCTION
answer
DOUBLE-CLICK
question
THE __ FUNCTION DISPLAYS THE HIGHEST VALUE IN A RANGE
answer
MAX
question
THE __ FUNCTION DETERMINES THE LOWERST NUMBER IN A RANGE
answer
MIN
question
TO COPY CELL CONTENTS, YOU CAN SELECT THE CELL AND THEN PRESS THE __ KEYS
answer
CTRL + C
question
TO PASTE COPIED CELL CONTENTS, YOU CAN PRESS THE __ KEYS.
answer
CTRL + V
question
YOU CAN USE THE __ TO CHECK WHICH CELLS ARE REFERENCED IN THE FORMLA ASSIGNED TO THE ACTIVE CELL
answer
RANGE FINDER
question
A __ IS A PREDEFINED SET OF COLORS, FONTS, CHART SYTLES, CELL STYLES, AND FILL EFFECTS.
answer
THEME
question
YOU CAN OPEN THE FORMAT CELLS DIALOG BOX BY PRESSING THE __ KEYS
answer
CTRL + 1
question
THE MOST POPULAR BACKGROUND COLOR IS __
answer
BLUE
question
THE __ DISPLAYS NUMBERS WITH A FIXED DOLLAR SIGN 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.
answer
ACCOUNTING NUMBER FORMAT
question
THE RANGES E4:I4 AND F13:I13 ARE FORMATTED WITH A __ DOLLAR SIGN
answer
FIXED
question
THE FOLLOWING IS THE PATH TO THE COMMA STYLE BUTTON
answer
(HOME TAB/NUMBER GROUP)
question
THE FOLLOWING IS THE PATH TO THE CONDITIONAL FORMATTING BUTTON
answer
(HOME TAB/STYLES GROUP)
question
IF YOU DO NOT ASSIGN A FORMAT TO A CELL OR CELLS IN A COLUMN, THE COLUMN WIDTH WILL REMAIN __ CHARACTERS
answer
8.43
question
THE FOLLOWING IS THE PATH TO THE SPELLING BUTTON
answer
(REVIEW TAB/PROOFING GROUP)
question
__ VIEW ALLOWS YOU TO CREATE OR MODIFY A WORKSHEET WHILE VIEWING HOW IT WILL LOOK IN PRINTED FORMAT.
answer
PAGE LAYOUT
