stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
BTA3O - Excel - Chapter 2 Flashcards | StudBud
Explore
/
BTA3O - Excel - Chapter 2
BTA3O - Excel - Chapter 2
12 terms
·
StudBud Administration
·
32 plays
Imported from external platform
Flashcards
12 cards
F
Practice quiz
P
Host live
L
Questions
12
Answers
1
If you hide rows 3–5 in your worksheet, row 4 will not print.
True
False
2
What mathematical operation does the asterisk (*) perform in Excel?
Subtraction
Division
Addition
Multiplication
3
Why is the order of operations important when creating formulas?
Only accountants use parentheses in their formulas.
It significantly changes the results of a formula.
It looks more professional.
It’s not important because the result is always the same.
4
Cell references in a formula can be typed, using upper- or lowercase letters, or selected with the mouse.
True
False
5
To rename a worksheet, you can double-click the sheet tab and type the new name without pressing [Delete] or [Backspace]
True
False
6
After sorting the Quiz 1 grades in column D from highest to lowest, what would be the correct order of the students?
Sarah, John, Jessica, Austin, Crystal
Sarah, Crystal, Austin, John, Jessica
Sarah, John, Crystal, Jessica, Austin
Jessica, John, Sarah, Austin, Crystal
7
Which image displays the correct sheet tabs after you have copied the Q1 Revenue sheet?
A
B
C
D
8
To insert a new column between Last and Student ID#, you would select column B.
False
True
9
PEMDAS stands for Parentheses, Equations, Division, Multiplication, Addition, Subtraction.
True
False
10
When multiple sheets are selected, you can modify all of them simultaneously.
True
False
11
What cell reference should you enter if you want to create a formula that refers to cell A3 on the Expenses worksheet?
Expenses!A3
Exp!A3
ExpensesA3
Expenses!A3!
12
A formula always begins with the equals (=) sign in the cell.
True
False
