Day 2 Excel Quiz

Day 2 Excel Quiz

Professional Development

10 Qs

quiz-placeholder

Similar activities

Evaluacion de Diagnostico 2024

Evaluacion de Diagnostico 2024

Professional Development

15 Qs

MS WORD

MS WORD

Professional Development

11 Qs

Power Point Basicos

Power Point Basicos

Professional Development

13 Qs

CONG NGHE THONG TIN

CONG NGHE THONG TIN

Professional Development

15 Qs

COMPUTER SHORTCUT KEYS

COMPUTER SHORTCUT KEYS

6th Grade - Professional Development

10 Qs

แบบทดสอบ การใช้งานโปรแกรม Microsoft Word

แบบทดสอบ การใช้งานโปรแกรม Microsoft Word

Professional Development

10 Qs

Introduction to Excel

Introduction to Excel

KG - Professional Development

10 Qs

Day 2 Excel Quiz

Day 2 Excel Quiz

Assessment

Quiz

Computers

Professional Development

Practice Problem

Hard

Created by

Eduardo Edralin

Used 7+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. What is the keyboard shortcut key to lock cell references in a formula?

CTRL

ALT

F2

F4

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the shortcut keys for AutoSum?

ALT and S

CTRL and S

ALT and =

CTRL and =

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which of the following is the correct formula to calculate the weighted average score in cell C8 as shown below?

=SUMPRODUCT(C2:C5,B2:B5)

=SUMPRODUCT(C2:C4,B2:B4)

=AVERAGE(B2:B4)

=AVERAGE(C2:C4)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below?

=IF(B2>=E2,"Accept","Reject")

=IF(B2>=$E2,"Accept","Reject")

=IF(B2>=$E$2,"Accept","Reject")

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?

=MROUND(A1,100)

=MROUND(A1,10)

=ROUND(A1,0)

=ROUND(A1,1)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the keyboard shortcut keys to edit formula in a cell?

F2

F4

CTRL + 1

CTRL + F

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The shortcut keys to increase the number of decimal places is

ALT + H + 9

ALT + H + P

ALT + H + D

ALT + H + 0

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?