Question 1

What feature in Excel 2016 helps you organize and analyze your data using rows and columns?

Accepted Answer

Spreadsheet

Answer

Document

Answer

Slide

Answer

Graph

Question 2

What tool in Excel 2016 can you use to quickly find the total of a group of numbers?

Accepted Answer

Sum function

Answer

Multiply function

Answer

Average function

Answer

Divide function

Question 3

In Excel 2016, what do you call the individual boxes that make up a worksheet?

Accepted Answer

Cells

Answer

Columns

Answer

Rows

Answer

Tables

Question 4

What feature in Excel 2016 allows you to combine multiple cells into one larger cell?

Accepted Answer

Merge Cells

Answer

Align Cells

Answer

Shift Cells

Answer

Split Cells

Question 5

In Excel 2016, which symbol is used to start a formula?

Accepted Answer

Equals sign (=)

Answer

Plus sign (+)

Answer

Minus sign (-)

Answer

Asterisk (*)

Question 6

What is the main purpose of Microsoft Excel 2016?

Accepted Answer

To create and manage spreadsheets

Answer

To watch movies

Answer

To play video games

Answer

To browse the internet

Question 7

What does a cell in Excel 2016 represent?

Accepted Answer

A single box for data entry

Answer

A formula only

Answer

A full page of text

Answer

An image

Question 8

What happens when you click on a cell in Excel 2016?

Accepted Answer

You can enter or edit data in that cell

Answer

The program shuts down

Answer

You cannot do anything

Answer

The cell turns into a picture

Question 9

What do you click to save your work in Excel 2016?

Accepted Answer

Save button

Answer

Print button

Answer

Close button

Answer

Open button

Question 10

What keyboard shortcut is commonly used to save your work in Excel 2016?

Accepted Answer

Ctrl + S

Answer

Shift + S

Answer

Alt + F4

Answer

Ctrl + P

Question 11

What do you call the horizontal lines in a spreadsheet?

Accepted Answer

Rows

Answer

Columns

Answer

Grids

Answer

Cells

Question 12

Which feature in Excel 2016 allows you to sort and organize your data?

Accepted Answer

Sort & Filter

Answer

Insert

Answer

Review

Answer

Format

Question 13

What do you use to create a visual representation of data in Excel 2016?

Accepted Answer

Charts

Answer

Cells

Answer

Tables

Answer

Rows

Question 14

What do you use to create a new Excel file?

Accepted Answer

File menu

Answer

View menu

Answer

Help menu

Answer

Edit menu

Question 15

Which cell reference means the first column and the first row in Excel?

Accepted Answer

A1

Answer

A2

Answer

C2

Answer

B1

Question 16

What do you call the horizontal spaces in Excel where data is entered?

Accepted Answer

Rows

Answer

Tables

Answer

Cells

Answer

Columns

Question 17

Which function would you use to add up a group of numbers in Excel?

Accepted Answer

SUM

Answer

MAX

Answer

COUNT

Answer

AVERAGE

Question 18

What do you call the vertical spaces in Excel where data is entered?

Accepted Answer

Columns

Answer

Cells

Answer

Rows

Answer

Fields

Question 19

What is the purpose of the 'Undo' button in Excel?

Accepted Answer

To reverse the last action

Answer

To print the document

Answer

To close Excel

Answer

To save the file

Question 20

What tool can you use in Excel to sort data in a list?

Accepted Answer

Sort feature

Answer

Filter feature

Answer

Draw feature

Answer

Split feature

Related quizzes

Related quizzes