N5 AIT - Spreadsheets Quiz

An individual box within a worksheet is known as?

• square
• range
• reference

• cell

What is normally used to perform calculations in a spreadsheet?

• Variable
• Formula
• Conditional formating
• Macro

In Excel, what do all formula begin with?

• !
• -
• +
• =

What must bar charts have? Tick all that apply!

• Heading (in caps)

• Pie chart

• Axis Labels

• Heading (in lower case)

We can use this function to count the number of cells containing words/letters

• =COUNTA

• =COUNTW

• =COUNT

• =COUNTN

We can use this function to perform a 'logical test' where the answer is a TRUE or FALSE outcome

• =MAYBE

• =WHEN

• =LOGIC

• =IF

We can use this function to add more than 2 cells together

• =ADD

• =SUM

• =ANSWER

• =COUNT

We can use this function to find the highest number in a range of cells

• =MAX

• =MIN

• =HIGHEST

• =LARGEST

When printing in value view we must show

• Row and column headings only

• Grid lines and row and column headings

• Grid lines only

• A blank background

When printing in formula view we must show

• Row and column headings only

• Grid lines and row and column headings

• Grid lines only

• A blank background