Year 8 Excel Assessment

What is a spreadsheet?

• an electronic document that is used to write letters

• an electronic document that can be used to present text and images

• an electronic document arranged in the rows and columns of a grid used to manipulate values and make calculations. 

• an electronic document store data

What is the cell reference for the price of item C?

• B4

• B3

• A4

• C4

What is the cell reference for the Quantity of item E?

• C7

• C6

• D6

• B6

What is the difference between a row and a column?

• Rows are a group of cells arranged horizontally /side by side 

  Columns are a group of cells aligned vertically / from top to bottom 

• Rows are a group of cells aligned vertically / from top to bottom 

  Columns are a group of cells arranged horizontally /side by side

Using the table above, write the formula that is used to calculate the total for D2.

• =B2-C2

• =B2+C2

• =B2*C2

• =B2/C2

What is the name of the feature that allows you to quickly enter formula?

• MAX

• SUM

• Average

• Autofill

What is conditional formatting and why is it used?

• Conditional formatting gets rid of any background colour used

• Conditional formatting makes it easy to highlight certain values, making particular cells easy to identify 

• Conditional formatting makes it harder to see certain values 

• Conditional formatting formats the cells black and white only

Select two advantages of using formulas when using data in excel.

• Faster

• You have to type out the formula every time

• Easily copied to different cells or worksheets (AutoFill)

• Can cause errors for you to fix

What formula would you use for the following. Assume the cell reference is A1 and B1

• = A1 * B1

• Subtraction

• = A1 + B1

• Multiplication

• = A1 - B1

• Division

• = A1 / B1

• Addition

Select an advantage of using charts.

• Shows the data in a visual form 

• Shows complicated data in text form only

• It doesn't show the trends of the data

• It is not organised