Excel Functions and Shortcuts (P3 FINAL)

Excel Functions and Shortcuts (P3 FINAL)

Assessment

Flashcard

Computers

11th Grade

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

Student preview

quiz-placeholder

25 questions

Show all answers

1.

FLASHCARD QUESTION

Front

What is the shortcut key to save an Excel workbook?

Back

Ctrl + S

2.

FLASHCARD QUESTION

Front

Which function is used to sum a range of cells in Excel?

Back

=SUM()

3.

FLASHCARD QUESTION

Front

What does VLOOKUP function do in Excel?

Back

Searches for a value in the first column of a table and returns a value in the same row from another column

4.

FLASHCARD QUESTION

Front

Which Excel feature allows you to visually represent data using bars, lines, or pie slices?

Back

Charts

5.

FLASHCARD QUESTION

Front

Which keyboard shortcut is used to insert a new worksheet in Excel?

Back

Shift + F11

6.

FLASHCARD QUESTION

Front

What does the function CONCATENATE in Excel do?

Back

Combines text from multiple cells into one cell

7.

FLASHCARD QUESTION

Front

Which function would you use to round a number up to the nearest whole number in Excel?

Back

=ROUNDUP()

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

Already have an account?