Excel Chapter 5 Questions

Excel Chapter 5 Questions

9th - 12th Grade

15 Qs

quiz-placeholder

Similar activities

資訊科技九下第四、五章

資訊科技九下第四、五章

9th Grade

20 Qs

تكنولوجيا المعلومات - صف تاسع

تكنولوجيا المعلومات - صف تاسع

9th Grade

12 Qs

PASSIVE VOICE EXERCISE

PASSIVE VOICE EXERCISE

11th Grade

15 Qs

EVALUASI METODE FIFO,LIFO, DAN AVERAGE

EVALUASI METODE FIFO,LIFO, DAN AVERAGE

12th Grade

10 Qs

English Vocabulary

English Vocabulary

10th - 12th Grade

10 Qs

Quiz on G20

Quiz on G20

9th - 12th Grade

20 Qs

Statistics

Statistics

10th - 12th Grade

20 Qs

SEMINAR BAHASA MELAYU | KERTAS 2

SEMINAR BAHASA MELAYU | KERTAS 2

9th - 12th Grade

10 Qs

Excel Chapter 5 Questions

Excel Chapter 5 Questions

Assessment

Quiz

Education

9th - 12th Grade

Practice Problem

Medium

Created by

Cheryl Albright

Used 12+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?

=$B$1+25

=B1+25

=SUM(B1:B39)

=B1:B39

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is a prewritten formula that is built into Microsoft Excel?

Utility

Procedure

Function

Statement

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?

AVERAGE

MAX

MIN

SUM

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?

AVERAGE

MAX

MIN

SUM

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which are valid Microsoft Excel functions?

AVERAGE, MAX, and NUM

MAX, MIN, and WEEK

AVERAGE, MAX, and MIN

WEEKDAY, MAX, and CLOSE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which group on the Formulas Ribbon enables a user to specify when a formula is computed?

Function Library

Defined Names

Formula Auditing

Calculation

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Where is the Insert Function button found in Microsoft Excel?

Quick Access Toolbar

Formula bar

Status bar

Shortcut menu

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?