Data analysis quiz

What is a Spreadsheet?

• A drawing tool

• A word processor

• A software to organise and calculate data

• A file viewer

What is a Cell in a Spreadsheet?

• A page in the document

• A box formed by the intersection of a row and a column

• A type of formula

• A folder inside the spreadsheet

What is the function of Ctrl + V in a spreadsheet?

• Cut a text

• Copy a text

• View a text

• Paste a text

How can you change the font type in a spreadsheet?

• Use the File menu

• Use the Font dropdown menu in the toolbar

• Use the Insert menu

• Right-click on the sheet tab

What is the shortcut key for Bold text in a spreadsheet?

• Ctrl + B

• Ctrl + V

• Ctrl + X

• Ctrl + C

What is the name given to a cell at column A and row 1

• Column A1

• 1A

• A1

• Cell A,1

What does Ctrl + X do in a spreadsheet?

• Undo

• Cut

• Close

• Exit

What is the default font and size in Microsoft Excel?

• Calibri, 11

• Times new roman, 11

• Calibri, 12

• Times new roman, 12

Which of the following is NOT a use of a spreadsheet?

• Calculating and analyzing data

• Creating charts and graphs

• Sorting data

• Writing notes

• Managing budgets

Short cut key for underlining a text