AnswersTX-Business Information Management BIM IIntroduction to Functions

Introduction to Functions Answers

8 verified answers2 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

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
3

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
4

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
5

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
6

How can you get to the Excel Function Reference information? Check all that apply.Help tabEscF1searching in the Tell Me barCtrl + R

A
Help tab
B
Esc
C
F1
D
searching in the Tell Me bar
E
Ctrl + R
7

What is unique about the date calculations from other formulas?

A
Some do not require any arguments.
B
It uses absolute numbers.
C
It uses / for division.
D
It uses parentheses for arguments.
8

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

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

Did you find these answers helpful?

More from this Course

Instruction
15 verified answers

Instruction

Instruction
8 verified answers

Instruction

Assignment
13 verified answers

Introduction to Functions

Introduction to Functions Answers — TX-Business…