Home
Subjects
Create
Search
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Other
Computer Skills
Excel
Excel Essentials
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (29)
They are independent and not related.
How are a cell's content and format related?
Ctrl+X then Ctrl+V
What sequence of keyboard shortcuts would you use to MOVE information from one cell to another?
Click and drag the column's boundary line to the desired width.
Double-click the column's boundary line.
Right-click the column header and then click Column Width.
Which are ways to change the column width in Excel?
Format attributes
What are the pieces of information that describe the appearance of a cell's content?
Press Ctrl+Z
You accidentally delete a large portion of you spreadsheet. How do you get the information back?
Ctrl+U
Which keyboard shortcut underlines text in a cell?
Ctrl+C
Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?
By using parentheses
How can you force a certain order of operations in a formula?
You can enter a cell references in a formula by typing in the reference.
You can enter a cell reference in a formula by clicking the cell location on the spreadsheet.
Cell references make it easy to use values from other cells in a formula.
Statements that ARE true about cell references.
=F6/3
A formula that contains a cell reference
=6
Using the correct order of operations, what does this formula equal? =(4-2)*6/2.
Select the cell and edit the formula in the Formula Bar.
A cell has a very long formula that you must edit. What would be the best way to edit the formula.
B11:H14
What is the argument in this function? =COUNT(B11:H14)
=8
Using the correct order of operations, what is the does this formula equal? =16/4*2.
An operand
In the formula "=D10+15", what part of the formula is the "15"?
An operator
In the formula "=F3+5", what part of the formula is the "+"?
=5+A1*B1
This formula is a complex formula.
Division
Define the following operator: /
Insert copied cells
Which command would
you use, if you wanted to move
row 6 in between row 3 and 4,
without overwriting any data.
Each rectangle in a spreadsheet.
What is a cell?
Cells that are aligned vertically
What is a column?
Ctrl
Which key should you press
if you wanted to select cells
that are noncontiguous or not beside one another?
Clear All
What Clear command would you use to make cell A2 look like cell B3?
=MAX(A2:B5)
Which function would you enter to return the number 45.1?
4
What number would the function "=COUNT(A2:A7)" return?
=10+B2
Cell C2 contains the
formula "=10+D3". If you
copied C2 to A1, what would
be the formula in A1?
=SUM(B2:B5)
What is the best formula
for finding the total value for
cells B2 through B5?
Above the worksheet, the third cell and the longest. (Letter C)
Where is the Formula Bar?
Number
What tab group would you use to change the format of cell A2 to match cell A3?
This set is often in folders with...
Excel Fundamentals
27 terms
EXCEL SKILLS
33 terms
Microsoft Excel Fundamentals and Skills Project (B…
73 terms
Microsoft Excel
46 terms
You might also like...
Excel Study Guide 11/12/18
25 terms
excel test 1
36 terms
review question chapter 5
40 terms
Computer Science Excel Exam
60 terms
Other sets by this creator
Adolescence
49 terms
Middle Childhood
39 terms
Theorists
51 terms
Professionalism
30 terms
Other Quizlet sets
2000 Core Urdu/Hindi Words 126-150
30 terms
Masterclass - Communication B1
16 terms
JP 9
43 terms
ADMIN 211 ProProfs 1-20
20 terms