5. Final Excel Quiz

Keilan is working on a project in Excel and needs to select a range of cells from B1 through E5. Which option below denotes this selected range?

• B1:E5

• B1 - E5

• B1$E5

• B1 to E5

Luca and Sebastian are comparing the sales performance of two different products they are selling. What type of chart will they use to effectively compare the sales of these two products?

• Column Chart

• Pie Chart

• Line Chart

• Both A and B

Valentina is organizing her school project data and needs to save it in a file. What is an Excel file generally called?

• Workbook

• E-Spreadsheet

• Woorksheet

• Sheet

Lexi is learning how to use Excel for her school project. She wants to know what the basic area of a worksheet is called where she can enter data. What is it?

• cell

• box

• table

• column

Ava is working on a large spreadsheet for her class project and needs to quickly sum up a range of data. Which tool should she use?

• Autofill

• Autosum

• Auto format

• Auto correct

If Sebastian and Amelia have not entered any values in their respective cells A1 and A2, what will be the value of the formula: =A1*A2

• 0

• Error

• 1

Ava and Billy are learning about functions in MS Excel. Which of the following is not a valid function they can use?

• SUBTRACT

• SUM

• COUNT

• COUNTA

Luca is working on a school project and needs to save his data in a Microsoft Excel file. What is the extension of the file he should use?

• xlsx

• msxcl

• xcl

• xlsm

Fraser is working on a large data analysis project in Excel. He needs to know the total number of rows available in a worksheet to ensure his data fits. What is the total number of rows in an Excel worksheet?

• 1,048,576

• Unlimited

• 65,535

• 1,068,576

Finn and Valentina are working on a project in Excel. They are curious to know the total number of columns available in a worksheet. Can you help them find out?

• 16,384

• 26

• 256

• 12,834