Upgrade to remove ads
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?
What are the pieces of information that describe the appearance of a cell's content?
You accidentally delete a large portion of you spreadsheet. How do you get the information back?
Which keyboard shortcut underlines text in a cell?
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.
A formula that contains a cell reference
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.
What is the argument in this function? =COUNT(B11:H14)
Using the correct order of operations, what is the does this formula equal? =16/4*2.
In the formula "=D10+15", what part of the formula is the "15"?
In the formula "=F3+5", what part of the formula is the "+"?
This formula is a complex formula.
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?
Which key should you press
if you wanted to select cells
that are noncontiguous or not beside one another?
What Clear command would you use to make cell A2 look like cell B3?
Which function would you enter to return the number 45.1?
What number would the function "=COUNT(A2:A7)" return?
Cell C2 contains the
formula "=10+D3". If you
copied C2 to A1, what would
be the formula in A1?
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?
What tab group would you use to change the format of cell A2 to match cell A3?
This set is often in folders with...
Microsoft Excel Fundamentals and Skills Project (B…
You might also like...
Excel Study Guide 11/12/18
excel test 1
review question chapter 5
Computer Science Excel Exam
Other sets by this creator
Other Quizlet sets
2000 Core Urdu/Hindi Words 126-150
Masterclass - Communication B1
ADMIN 211 ProProfs 1-20