Terms
Short cuts
Functions
Tools
Test your knowledge
100

How do we represent columns in Excel?

Using letters


100

What keyboard shortcut is commonly used to copy selected content in Excel?

Ctrl + C 


100

What function in Excel adds up a range of numbers?

SUM 


100

What feature in Excel combines multiple adjacent cells into one larger cell?

Merge&Center

100

What is the process called when a liquid turns into a gas?

Evaporation

200

How are rows represented in excel?

Using numbers


200

How do you quickly paste copied content in Excel?

Ctrl + V.

200

 What Excel function that finds the middle value of a set of numbers  

Average

200


When you need text to stay contained within a cell rather than overflowing into neighboring cells, what setting would you adjust in Excel?

Wrap text

200

Which river is the longest in the world?

The Nile River

300

What term is used to describe a group of cells in Excel? 

Range


300

What keyboard shortcut is used to undo the last action in Excel?

Ctrl + Z 


300

Which function in Excel counts the number of cells that contain numerical values in a range?

COUNT 


300

Which tools allow you to add a row or column to a range?

Insert 

300

Who is credited with inventing the light bulb?

Thomas Edison

400

How is a range in excel represented?

(CLRN:CLRN) Example:(A1:A12)


400

How can you quickly select the entire column in Excel?

Ctrl + Spacebar. 


400

What Excel function returns the smallest value in a range of cells?

MIN


400

If you want to display numerical values with a dollar symbol in Excel, what formatting option would you apply?

Number formatting , currency

400

What is the result of dividing 48 by 6?

8

500

 How can you make your data look like it's in a box in Excel?

Using all border 

500

What keyboard shortcut allows you to save your Excel file?

Ctrl + S

500

What Excel function returns the largest value in a range of cells?

MAX

500

Which ribbon contains the command to change the orientation from right-to-left to left-to-right or vice versa? 

Page Layout

500

What is the largest country in the world?


Russia

M
e
n
u