AnswersTX-Business Information Management BIM IIntroduction to Functions

Introduction to Functions Answers

8 verified answers1 views
1
Free Preview

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
2
Free Preview

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

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

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
4

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.
5

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
6

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
7

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
8

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.

Did you find these answers helpful?

More from this Course

Instruction
15 verified answers

Instruction

Assignment
13 verified answers

Introduction to Functions

Assignment
13 verified answers

Introduction to Functions

Introduction to Functions Answers — TX-Business…