Search Header Logo

BA 250 Midterm Review

Authored by Abby Pilgrim

Business

University

Used 9+ times

BA 250 Midterm Review
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

FILL IN THE BLANKS QUESTION

1 min • 1 pt

The (a)   is the term for a selected rectangular cell within an excel spreadsheet.

2.

FILL IN THE BLANKS QUESTION

1 min • 1 pt

A (a)   cell reference is one that changes relatively with location of the formula.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A _______________ is an excel spreadsheet made up of more than one ____________________.

worksheet; workbook

workbook; worksheet

spreadsheet; workbook

file; spreadsheet

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If the information in a cell represents a quantity, it is defined as a ______.

category

label

value

tab

5.

FILL IN THE BLANKS QUESTION

1 min • 1 pt

A (a)   (aka formula) is an arithmetical expression used to calculate values in Excel.

6.

FILL IN THE BLANKS QUESTION

1 min • 1 pt

What character must be included in a cell reference to make it "absolute" or in other terms "not changing"?

(a)  

7.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which is an example of a simple formula? (Select all that apply)

=C4*E4

=C4/E4

=VLOOKUP(D4>=H4,(H4-D4)*C2,0)

=C4+E4-F4

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?