# Intro to Excel / spreadsheets

## Quiz by Si Eian Lim

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Measure skills

from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can

- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet

13 questions

Show answers

- Q1What software program is commonly used to create spreadsheets?PhotoshopExcelWordPowerPoint30s
- Q2What do we call the intersection of a row and a column in a spreadsheet?SectionCellSquareBlock30s
- Q3What do we call the vertical arrangement of cells in a spreadsheet?CellRowBlockColumn30s
- Q4What do we call the horizontal arrangement of cells in a spreadsheet?BlockColumnCellRow30s
- Q5What is the function of a spreadsheet in organizing and analyzing data?To write essaysTo edit photosTo organize and analyze dataTo create presentations30s
- Q6What is the formula for calculating the total in Excel?SUMCOUNTAVERAGEADD30s
- Q7What is the function of a formula in a spreadsheet?To add imagesTo create shapesTo play musicTo perform calculations30s
- Q8In Excel formulas, what does the equal sign (=) usually signify?The start of a formulaMultiplicationSubtractionDivision30s
- Q9If you have the numbers 2, 4, and 6 in cells A1, A2, and A3 in Excel, what formula would you use to find their average?=SUM(A1;A3)=SUM(A1:A3)=AVERAGE(A1;A3)=AVERAGE(A1:A3)30s
- Q10Which Excel formula will add up the numbers in cells B1, B2, and B3?=SUM(B1:B3)=SUM(B1;B3)=TOTAL(B1:B3)=ADD(B1:B3)30s
- Q11Sara has scores of 70, 85, and 95 in her exams recorded in cells C1, C2, and C3. What formula should she use to calculate her average score?=AVERAGE(C1:C3)=AVERAGE(C1;C3)=MEDIAN(C1:C3)=SUM(C1:C3)/330s
- Q12In Excel, what does the symbol 'A1' represent?An Excel shortcut keyA specific cell's referenceThe total number of cells in a worksheetA function in Excel30s
- Q13What is the purpose of using a cell reference in Excel?To print a spreadsheetTo refer to a specific cell for calculations or data entryTo change the color of a cellTo insert a new row in a worksheet30s