Excel Expert 2 KA

Excel Expert 2 KA

10th - 12th Grade

10 Qs

quiz-placeholder

Similar activities

Chapter 14: Impairment Loss

Chapter 14: Impairment Loss

10th Grade

14 Qs

Marketing Campaign

Marketing Campaign

9th - 12th Grade

10 Qs

Break-even and contribution

Break-even and contribution

11th Grade - University

11 Qs

IBDP Organisational Structure

IBDP Organisational Structure

11th - 12th Grade

14 Qs

Marketing Philosophies Review

Marketing Philosophies Review

KG - 11th Grade

9 Qs

The Mailroom & Postal services

The Mailroom & Postal services

10th Grade

10 Qs

Mengelola Transaksi Pembayaran - Receptionist

Mengelola Transaksi Pembayaran - Receptionist

12th Grade

10 Qs

Product Design

Product Design

10th Grade

10 Qs

Excel Expert 2 KA

Excel Expert 2 KA

Assessment

Quiz

Business

10th - 12th Grade

Medium

Created by

Cherie Young

Used 33+ 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

20 sec • 1 pt

Which number format is used to display the month as a single text character (such as N for November)?

mm

m

mmmmm

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to display the two numbers 1,540,257.14 and 2,250,444.18 as 1.54 M and 2.25 M, respectively. Which number format must be applied to the first two numbers?

0,000.00 “M”

#,##0.00,, “M”

#,##0.* “M”

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which number format is used to format a list of credit card numbers so they appear as typically displayed on a credit card?

####.####.####.####

0000E+4

0000 0000 0000 0000

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following methods is used to display the Series dialog box that is used to fill data in a range?

On the Data tab, in the Forecast group, select What-If Analysis and then click Series.

On the Home tab, in the Editing group, select Fill and then click Series.

On the Insert tab, in the Text group, click Series.

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which tab in the Data Validation dialog box is used to specify the validation criteria?

Settings

Number

Input Message

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which option on the Conditional Formatting menu is used to display colored bars that represent the values in cells, with the highest values displaying the longest bars?

Highlight Cells Rules

Color Scales

Data Bars

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is the name of the default document theme in Excel 2016?

General

Office

Standard

Create a free account and access millions of resources

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

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

Already have an account?