Excel 2016 Expert Lesson 1

Excel 2016 Expert Lesson 1

11th Grade

10 Qs

quiz-placeholder

Similar activities

Production Possibility Frontier

Production Possibility Frontier

10th - 12th Grade

11 Qs

US PKK XI 1 TBSM

US PKK XI 1 TBSM

11th Grade

15 Qs

Management Theory - F. Taylor

Management Theory - F. Taylor

9th - 11th Grade

10 Qs

5 x 5 Rule

5 x 5 Rule

9th - 12th Grade

10 Qs

MANAGEMENT FUNCTIONS & ROLES

MANAGEMENT FUNCTIONS & ROLES

11th Grade

10 Qs

What do you know about Credit?

What do you know about Credit?

9th - 12th Grade

10 Qs

Entrepreneurship Unit 1

Entrepreneurship Unit 1

11th - 12th Grade

10 Qs

U3 QUIZ - COURT SYSTEMS

U3 QUIZ - COURT SYSTEMS

10th - 12th Grade

15 Qs

Excel 2016 Expert Lesson 1

Excel 2016 Expert Lesson 1

Assessment

Quiz

Business

11th Grade

Medium

Created by

Anonymous Anonymous

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

1 min • 1 pt

Which of the following is the file extension used for Excel Template files?

.xlsm

.xltx

.xlsx

.xlam

2.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following demonstrates the general format of a formula that references a cell in a different worksheet?

CellAddress!SheetName

SheetName#CellAddress

CellAddress#SheetName

SheetName!CellAddress

3.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following statements best describes how to copy macros from one workbook to another?

Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor

Use the Record Macro button on the Developer tab

Use the Add-Ins button on the Developer tab

Open the Visual Basic Editor and type RUN COPYMACROS in the Project Explorer window

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following represents the syntax for a structured reference to a field in an Excel table?

FieldName[TableName]

TableName[FieldName]

[FieldName]TableName

[TableName]FieldName

5.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Your co-worker sent you a workbook to update. You have entered new numbers in your worksheet, but the totals are not updating. Which of the following statements best describes how to remedy the problem?

Click the Share Workbook button on the Review tab

Go to the cells with the totals that are not updating, press the F2 key and then press Enter to re-enter the formulas

Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.

Send the workbook back to your co-worker and have them fix it

6.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Which of the following methods is used to display a hidden tab on the ribbon?

On the View tab, in the Show group, click the Tabs button and select the tab you want to display.

Right-click any tab on the ribbon and select Display Hidden Tabs

On the Home tab, in the Cells group, click Insert and then select Show Hidden Tabs

Display the Excel Options dialog box, select Customize Ribbon, and then select the check box next to the name of the tab you want to add.

7.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Which of the following statements best describes how to create a custom template of your own?

Click the File tab, select Save As, click Browse, and change the file type to .xltx.

Click the File tab, select Save As, click Browse, and change the file type to .xlsm.

Click the File tab, select Save As, click Browse, and change the file type to .xlam

Click the File tab, select Options, click Save, select the Save as Template check box, and save the file as usual.

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?