Answers110 CCHS Business Computer Applications - Office 2019Performing Calculations

Performing Calculations Answers

15 verified answers4 views
1
Free Preview

What are the components that could be used in a mathematical formula? Check all that apply.variableexpressionvalueoperatorresult

A
variable
B
expression
C
value
D
operator
E
result
2
Free Preview

A2:D19 .

A
range
B
value
C
formula
3

E55 .

A
value
B
formula
C
range
4

(A2:A19,C13,E55,19) .

A
syntax
B
function name
C
argument
5

Which symbol does a formula start with?

A
=
B
%
C
+
D
^
6

Where can you locate the Function Library group?

A
View tab of the ribbon
B
Formulas tab of the ribbon
C
File tab of the ribbon
D
Insert tab of the ribbon
7

Which part of the formula references the worksheet?

A
Sheet3!
B
SUM
C
A12
D
A6:A19
8

What is the difference between a displayed result and a formula?

A
The displayed result is always the same number, but the formula changes.
B
The formula is always the same as the displayed result; it will always be a simple value.
C
The displayed result changes as the formula dictates it; it may not be a simple value.
D
The displayed result and the formula are unrelated.
9

How do you activate the Formula AutoComplete function of Excel 2019?

A
Go to the File tab on the ribbon.
B
Type in AutoComplete in the Tell Me bar.
C
Click the cell, type =, and begin the formula.
D
Use the drop-down menu under the Formula tab.
10

Samuel wanted to paste the value and the formula attached from cell B6 to cell F16. Which methods will work? Check all that apply.Select cell B6, copy, and the drag cursor from B6 to F16.Select cell B6, copy, and paste special into F16.Select cell B6, Ctrl+C, and Ctrl+V into F16.Select cell B6, Ctrl+F, Ctrl+C, and Ctrl+V into F16.Select cell B6, copy, and paste into F16.

A
Select cell B6, copy, and the drag cursor from B6 to F16.
B
Select cell B6, copy, and paste special into F16.
C
Select cell B6, Ctrl+C, and Ctrl+V into F16.
D
Select cell B6, Ctrl+F, Ctrl+C, and Ctrl+V into F16.
E
Select cell B6, copy, and paste into F16.
11

Which symbol is used to indicate that a formula may contain an error?

A
green triangle in upper-left corner of cell
B
an orange circle below the formula result
C
green triangle with question mark inside
D
a wavy purple arrow above the formula result
12

What is an example of an absolute cell reference?

A
52%
B
D2
C
$B$5
D
!90!
13

What are ways to enter a formula in Excel? Check all that apply.Click on the Function Library group and select a function from the drop-down menu.Click on the Function Library group and Insert Function.Click on the File tab in the ribbon.Click on the Insert tab in the ribbon and then Equation.Type = into any cell.Click on the formula bar above the cells.

A
Click on the Function Library group and select a function from the drop-down menu.
B
Click on the Function Library group and Insert Function.
C
Click on the File tab in the ribbon.
D
Click on the Insert tab in the ribbon and then Equation.
E
Type = into any cell.
F
Click on the formula bar above the cells.
14

Sonora wants to extend the cells to be added in her formula. What is the quickest way to add more cells?

A
Go to the Function Library group and click Insert Function.
B
Click the Insert tab in the ribbon and then Equation.
C
Type the ranges in the parentheses in the formula bar.
D
Left-click on a cell that is included and drag the cursor.
15

SUM .

A
syntax
B
function name
C
argument

Did you find these answers helpful?

More from this Course

Assignment
12 verified answers

Performing Calculations

Assignment
6 verified answers

Performing Calculations

Instruction
1 verified answers

Native American Art in North America