AnswersComputer Applications I-Sem A -CA- 39901AIntroduction to Functions

Introduction to Functions Answers

7 verified answers3 views
1
Free Preview

What is a benefit of naming cells and ranges?

A
Using names in ranges is the only way to use formulas.
B
Using names in formulas changes the color and font quickly with named cells.
C
Using names in formulas makes it clearer to see what the function is.
D
Using names in ranges hides the function from the worksheet.
2
Free Preview

Which areas can be used to create names in the Create from Selection feature in the Formula tab? Check all that apply.top rowheaderleft columnfooterright columnbottom row

A
top row
B
header
C
left column
D
footer
E
right column
F
bottom row
3

What is the quick key to highlighting a column?

A
Ctrl + down arrow
B
Ctrl + Shift + down arrow
C
Right-click + down arrow
D
Ctrl + Windows + down arrow
4

Where in the Formula tab on the ribbon would you find the Use in Formula function?

A
Function Library
B
Formula Auditing
C
Calculation
D
Defined Names
5

What is the purpose of the Excel Function Reference?

A
to look up functions and their purposes
B
to add customized functions to the list
C
to delete functions from the list
D
to sort and organize functions in the list
6

Where should a range name be entered?

A
in the Home tab on the ribbon
B
in the title box in the status bar
C
in the title bar
D
in the name box in the formula bar
7

What function text would you use to put today’s date in a cell?

A
=NOW()
B
=TODAY()
C
NOW()
D
TODAY()

Did you find these answers helpful?

More from this Course

Assignment
25 verified answers

Topic Test

Assignment
13 verified answers

Introduction to Functions

Assignment
19 verified answers

Introduction to Functions

Introduction to Functions Answers — Computer…