Search Header Logo

Data Analysis Using Excel Test

Authored by Divakar Bangaru

Computers

Professional Development

Used 2+ times

Data Analysis Using Excel Test
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which formula will you use to calculate the Number of people who were absent?

=COUNTBLANK(Attendance)

=SUM(Attendance)

=COUNTA(Attendance)

=COUNT("Attendance")

2.

MULTIPLE CHOICE QUESTION

15 mins • 1 pt

What is the default justification for cells formatted as labels?

right aligned
left aligned
center
1 inch

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Columns in a spreadsheet are:

Vertical
Horizontal
Upside down
right side

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the term used where a column and row intersect?

Toolbar
Cell
Name Box
Formula Bar

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

The feature to center text across several cells is called:

Wrap Text
Merge and Center
Shrink to Fit
Number Formatting

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Microsoft Excel is what type of software?

Word Processing
Spreadsheet
Presentation
Drawing

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

When entering numbers in  Excel, they are automatically (by default):

Left Justified
Right Justified
Center Justified
Full Justified

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

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?