WorksheetsDIT Excel 2016 Review
Total questions: 15
Worksheet time: 8mins
What is a workbook?
Excel file
Excel spreadsheet page.
A number, text, formula or function
What can a cell contain?
A column
A number, text, formula or function
A row
The cell address
Which keyboard shortcut bolds text in a cell?
“Ctrl+B”
“Ctrl+I”
“Ctrl+U”
“Ctrl+X”
Which keyboard shortcut would you press to cancel a command?
“Backspace”
“Tab”
“Delete”
“Escape”
Which of the following statements is TRUE?
The content and format of a cell are independent.
Changing the format of a cell also affects its content.
The content and format of a cell are the same.
What are the pieces of information that describe the appearance of a cell's content?
Active attributes
Paste attributes
Format attributes
Edit attributes
Which of the following is NOT a way to change the column width in Excel?
Right-click the column header and then click Column Width.
Click and drag the column's boundary line to the desired width.
Double-click the column header and then click Delete.
All of the above
Double-click the column's boundary line.
What are the three parts of a formula?
Equal sign, Operand, Operator
Formula Bar, Cell Reference, Color
Complex, Simple, Order of Operations
Define Function.
Must be the first character in the cell. It tells the spreadsheet a calculation is to be performed
A predefined formula that performs a calculation based on values that are entered in the function.
Indicates the operation to be performed, such as a sum
Contains the information you want to use in the function’s calculation.
The following function calculates the average of the values in a range of cells by summing the cells and dividing by the number of cells used to find the sum.
COUNT
MAX
AVERAGE
MIN
Using the correct order of operations, what does this formula equal? =(4-2)*6/2
8
6
2
4
A cell has a very long formula that you must edit. What would be the best way to edit the formula.
Double-click on the cell and edit the formula in the cell.
Select the cell and edit the formula in the Formula Bar.
How are a cell's content and format related?
The content and format are the same.
They are independent and not related.
Changing the format affects the content.
Using the correct order of operations, what does this formula equal? =16/4*2
4
8
2
16
In the formula "=F3+5", what part of the formula is the "+"?
An operator
An operand
