VOL 1 Lesson # 2 - Creating Worksheet - Quiz
Excel uses different types of references to refer to cells and ranges either absolutely, or relatively, in terms of their ______.
location
Which sign is typed first to enter a formula into a cell?
=
What formula will you use to calculate the total expenses of Year 1? Figure A: The worksheet
=SUM(B8:B15)
Which type of reference is best for referring to a multiplier value that is in one cell on a worksheet for all formulas, no matter where the formulas are?
Absolute
Which of the following is the name for the values on which a function takes action or performs calculations?
Arguments
Which of the following features allows you to enter functions like AVERAGE() in a single click?
AutoSum
Which of the following can be accomplished by dragging?
Both moving and copying
How do you define a range?
By clicking and highlighting the cells you want to be in the range, entering the name in the name box, and then pressing Enter
How will you specify an absolute reference?
By placing a dollar sign in front of column letters and row numbers
Which function is performed by the pointer shown in the following figure? Figure A: The pointer
Changes the column width
Which key do you hold down while copying data by dragging?
Ctrl
Which shortcut key is used to undo the most recent action?
Ctrl+Z
Which of the following sets of commands is used to move the data?
Cut and Paste
Which character do you use to specify absolute references?
Dollar sign ($)
Which of the following keys is used to toggle through reference types while you enter a formula?
F4
An absolute reference in Excel is a pointer to a cell or range of cells and will change when copied to another location in the worksheet.
False
Using the Format Painter option will also copy data.
False
You can only insert a function from the Formulas tab.
False
______ are named formulas built into Excel to help you perform all sorts of calculations.
Functions
Which of the following options guides you through the process of entering functions?
Insert Function
How does Excel handle the left-aligned text that is too wide for the column in which it appears?
It depends on what is in the next cell to the right.
By default, which alignment is followed when the text is entered in the cell?
Left
Which of the following is not one of the possible combinations of reference types?
Mixed: A1$
______ enclose the values on which a function acts.
Parentheses ()
Which of the following is not a way to edit a formula in Excel?
Press Esc.
Which of the following is a way in which Excel handles numbers that are too wide for a cell?
Scientific notation
Which of the following is evaluated last in the Excel order of operations?
Subtraction
Formulas in Excel will perform the mathematical calculations for you.
True
The AutoSum function will automatically add all the numbers in a range of cells.
True
When entering a formula in Excel, you need to start with an equal sign.
True
Which of the following statements is true about moving and copying the data?
When you move a formula, Excel updates any references they contain relative to the new location of the formula.
