Search Header Logo

BA 250 Midterm Review

Authored by Abby Pilgrim

Business

University

Used 10+ times

BA 250 Midterm Review
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?