Formulas
Page Layout
Review
File
Insert
100

What is the formula to add a column of numbers together? 

What is =SUM(cell:cell). 

100

What does the view grid lines button do? 

What is shows the lines dividing each cell. 

100

What does the spell check do?

What is corrects any spelling or points out words that aren't spelled right or sentences that aren't grammatically correct. 

100

What does save do?

What is allows you to save the spreadsheet to your device and allows you to access the spreadsheet later.
100

What does insert image do?

What is puts a picture of your choice into thje spreadsheet.

200

What is the formula of count cells equal to?

What is COUNTIF

200

What does the group button do?

What is change the way the cells are categorized and put together.

200

What does translate do?

What is changes the language to make it easier for the reader. 

200

What does new do?

What is allows you to create/open a new excel spreadsheet.

200

What does insert charts do?

What is allows you to insert a chart of your choice to neatly fit data.

300

What is the formula to count cells not equal to x or y?

What is SUMPRODUCT

300

What does theme do?

What is changes the color scheme of your spreadsheet and changes fonts to match the colors. 

300

What does new comment do?

What is allows you to attach a comment to a certain cell.  

300

What does info do?

What is in the info tab you can change document properties.

300

What does hyperlink do?

What is inserts a link to a email or website.

400

Name the formula to count blank cells

What is COUNTA

400

What does orientation do? 

What is changes the way your spreadsheet is shown, either horizontal or vertical. 
400

What does protect do?

What is allows you to encrypt the document with a password.
400

What does export do?

What is change the document to a pdf/xps.

400

What does insert table do?

What is puts a table of your choice with themes.

500

What is the formula to sum by month?

What is EOMONTH

500

What does the print area button do?

What is allows you to print a certain area of the spreadsheet without printing the entire thing. 

500

What does allow edit ranges do?

What is allows you to change who has edit access to your spreadsheet.

500

What does publish do?

What is publish's to power BI.

500

What does the insert symbol button do?

What is allows you to put a symbol where it is needed such as copyright.

M
e
n
u